Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 MSDE (2000)
 Change SQL Service Instance name?

Author  Topic 

James_Coulter
Starting Member

3 Posts

Posted - 2003-06-19 : 00:17:38
I installed MSDE from the VS.NET installation (2002) and the instance name shows up as server/VSdotNet but I need server/NetSDK to work with the Quickstart samples. Is there an easy way to change the instance name? I'm pretty novice with SQL/MSDE.


-- James --
_______________________________
http://www.jamescoulter.com
http://www.digitaldimension.com

Doug G
Constraint Violating Yak Guru

331 Posts

Posted - 2003-06-19 : 14:48:34
I don't know about changing an existing instance name, but it's easy enough to install and specify the instance name. The basics are to run setup.exe from the command line similar to this:

setup.exe INSTANCENAME="testmsde"



======
Doug G
======
Go to Top of Page

James_Coulter
Starting Member

3 Posts

Posted - 2003-06-19 : 15:24:29
Thanks Doug.

Turns out there are TWO versions of MSDE that ship with .NET and I installed the wrong one.

http://support.microsoft.com/?kbid=813850

What's more, if you installed .NET 2002, and then update the Framework to 1.1, it doesn't include the correct MSDE for working with the Quickstart samples; you must download it from MS here...

http://msdn.microsoft.com/netframework/downloads/sdkmsde/default.aspx

...and follow the installation instructions to override the security paranoia. What's more, if there are leftover copies of the sample databases from previous botched installations, the ConfigSamples utility won't be able to register them properly. Afeter about a full day of troubleshooting, I think I have it working.

The minor problem I have now is that the Service Manager doesn't automatically attach to the NetSDK instance at startup. Anyone know how to make it do that?

-- James --
_______________________________
http://www.jamescoulter.com
http://www.digitaldimension.com
Go to Top of Page

Chouf
Starting Member

1 Post

Posted - 2003-06-23 : 02:28:02
Hi James,
I'm nearly at the same stage that you are. After battling with the installations (.Net, MSDE, Starter Kits)for the last 10 days and nearly quitting (I'm doing this in spare time at night) i've finally managed to get the IbuySpy Portal and Store apps running. I've still to get the sdk samples going.

My sql service manager is in the same state as yours. I've noticed that if you type the server name i.e <machine\NETSDK> in the drop down and refresh services, it does recognise the instance and works.

I also have the following link for you, not an encouraging one i'm afraid:

[url][/http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B814132]

This relates to the sp3a installation disabling network connections by default.

Hope it's helpful

Chouf
Go to Top of Page
   

- Advertisement -