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)
 MSDE multiple instance

Author  Topic 

Sitka
Aged Yak Warrior

571 Posts

Posted - 2003-08-22 : 16:18:45
Had a crazy day yestersday with MSDE.
Windows 2003 Server with Windows Sharepoint Services.
WSS can run on MSDE or SQL. This latest version is
real sweet. I don't know what it costs but it is definitely
cool but the guys in the newsgroups recomment using a full install
of SQL over MSDE but whatever. A neat concept of this whole package was it's well defined boundries.
Well I wanted to get a few more instances of MSDE running on this machine alongside the default \SHAREPOINT one.
I found startup binding order was important. I couldn't bind the network libraries to the new instance until I shut the first instance down then enabled the library on the second instance,restarted then refired up the first instance.
According to the docs I believe the first instance in this case is considered a non default instance because it isn't named for the server it resides on. If that makes any difference. But all is good just a heads up and one for the search pages

DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
SVRNETCN.exe



Voted best SQL forum nickname...."Tutorial-D"
   

- Advertisement -