Showing posts with label instance. Show all posts
Showing posts with label instance. Show all posts

Wednesday, March 28, 2012

Problem with SQL Server 2000 developer

I'm also having the same problem with MSDE. I really just want a local SQL Server instance on my machine for developer purposes. I'm running Win XP Pro sp2. When I attempt to install either SQL Server OR the analysis services, the install sheild logo appears for a moment, then nothing. There is no setup, no error, no nothing. The sqlsetup says it's running, but after almost 10 minutes, nothing happens.

What can I do to get some kind of SQL running on my computer? The same thing happens when I try to install the analysis tools, too!

Thanks!

Have you tried 're-booting' your computer and then running the installer?

I highly recommend using SQL Express instead of MSDE. You can download a copy here.

|||Just as an update, I have attempted to reboot my computer a half dozen times. I actually require the 2000 framework because my company is currently using SQL Server 2000 ENT.|||As an update, I have attempted to reboot my computer several times when installing either SQL Server or the analysis tools. I need 2000 on my machine because our company is still using SQL Server 2000 ENT.|||

what version and edition of sql server is this ? If it is Enterprise Edition , then it need Server Version of OS like Windows 2000 server,2003 Server etc... What you can do is Download SQL Server Express downloadble version of SQL Server 2005 and install

Madhu

|||I have attempted to reboot and reinstall the software at least a half dozen times. I'm only trying to install the developer version of SQL 2000 and/or the analysis tools.|||I've even tried closing my anti-virus software. It still doesn't load. The CD spins for a few moments, then stops. I can live without the SQL Server on my machine, but I really need the tools.sql

Wednesday, March 7, 2012

Problem with registering a new server?

Hi all,
I have installed SQL Server 2k personal ed on Win xp and now I want to add another instance other than that one I added when installation.But I do not know how? I used EM and its wizard but it says could not find server or access is denied...
-any quick help is appreciatedYou need to re-run the setup and specify named instance name. Then you can register it as <COMPUTER_NAME>\<NAMED_INSTANCE_NAME>.

Problem with regional settings I think

I have a developer server (which we run ASP.NEt solutions against) it's an
MSDE instance and then we have another "LIVE" server which also has an MSDE
instance.
We are using Crystal Reports to get Reports out of the Databases and the
reports look different when we run them against the servers.
A Total ( in the report) on our Develooper Server shows as 2,00 in the
report but on out LIVE one.. it shows as 200,00 ... so I'm thinking it has
something to do with how the MSDE is returning numbers (floats) and Thousand
Separators...
Where do I start to check for these things?
Best regards/
Lars NetzelIt's not the thousands separator. It's the decimal point. In Europe,
you'll see the comma used to mark the decimal point. I'd check the regional
settings on both those boxes.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Lars Netzel" <nospam@.doamin.com> wrote in message
news:eW7o2AGBFHA.2428@.TK2MSFTNGP14.phx.gbl...
I have a developer server (which we run ASP.NEt solutions against) it's an
MSDE instance and then we have another "LIVE" server which also has an MSDE
instance.
We are using Crystal Reports to get Reports out of the Databases and the
reports look different when we run them against the servers.
A Total ( in the report) on our Develooper Server shows as 2,00 in the
report but on out LIVE one.. it shows as 200,00 ... so I'm thinking it has
something to do with how the MSDE is returning numbers (floats) and Thousand
Separators...
Where do I start to check for these things?
Best regards/
Lars Netzel|||I have checked the regional settings in the Windows OS on both Servers..
they are identical (Swedish Settings) I'm wondering if there are any
regional settings in teh SQL server itself... and if so where do I find
that?
/Lars
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23qxBgiGBFHA.2540@.TK2MSFTNGP09.phx.gbl...
> It's not the thousands separator. It's the decimal point. In Europe,
> you'll see the comma used to mark the decimal point. I'd check the
> regional
> settings on both those boxes.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Lars Netzel" <nospam@.doamin.com> wrote in message
> news:eW7o2AGBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> I have a developer server (which we run ASP.NEt solutions against) it's an
> MSDE instance and then we have another "LIVE" server which also has an
> MSDE
> instance.
> We are using Crystal Reports to get Reports out of the Databases and the
> reports look different when we run them against the servers.
> A Total ( in the report) on our Develooper Server shows as 2,00 in the
> report but on out LIVE one.. it shows as 200,00 ... so I'm thinking it has
> something to do with how the MSDE is returning numbers (floats) and
> Thousand
> Separators...
> Where do I start to check for these things?
> Best regards/
> Lars Netzel
>
>|||Did you try changing to, say, US? Also, if the SQL Server service is
running on a domain account, log on with that account and check its
settings.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Lars Netzel" <nospam@.doamin.com> wrote in message
news:%23ABo9rGBFHA.3512@.TK2MSFTNGP10.phx.gbl...
I have checked the regional settings in the Windows OS on both Servers..
they are identical (Swedish Settings) I'm wondering if there are any
regional settings in teh SQL server itself... and if so where do I find
that?
/Lars
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23qxBgiGBFHA.2540@.TK2MSFTNGP09.phx.gbl...
> It's not the thousands separator. It's the decimal point. In Europe,
> you'll see the comma used to mark the decimal point. I'd check the
> regional
> settings on both those boxes.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Lars Netzel" <nospam@.doamin.com> wrote in message
> news:eW7o2AGBFHA.2428@.TK2MSFTNGP14.phx.gbl...
> I have a developer server (which we run ASP.NEt solutions against) it's an
> MSDE instance and then we have another "LIVE" server which also has an
> MSDE
> instance.
> We are using Crystal Reports to get Reports out of the Databases and the
> reports look different when we run them against the servers.
> A Total ( in the report) on our Develooper Server shows as 2,00 in the
> report but on out LIVE one.. it shows as 200,00 ... so I'm thinking it has
> something to do with how the MSDE is returning numbers (floats) and
> Thousand
> Separators...
> Where do I start to check for these things?
> Best regards/
> Lars Netzel
>
>