|
|
You're in the
sql server msde
group:MSDE Instances
sql server msde:
Hello everyone. After finally getting MSDE installed, I
am having trouble with instances. At bootup the instance that is loading is the wrong one, and is not working. The instance that is loading is just "computername," and I need "computername\instance" to load. I have checked the registry for the other instance and it is not there. The only place I can find this instance is when I open the SQL Server Service Manager and click the drop down menu for server. When I select the "computername\instance" from the drop down menu everything works fine, it is just initially it loads a defective instance. Anyone have any ideas?? Thanks,
Hi, and thank you for the reply. Sorry that I did not
make this more clear to begin with. No, I do not have two instances installed, and I don't want two instances installed. I guess somewhere in the middle of all the trouble I had installing MSDE it created some kind of bogus instance. All the readings I have read say that a default instance in the registry will be located under MSSQL Server and a named instance will be under Microsoft SQL Server. I have deleted the MSSQL Server key and then everything works fine until I reboot, then the key is re- created. I can log off and back on after the key is deleted and it works like it is supposed to. When I open SVRNETCN.exe it says that I have two instances installed: 1.) computername 2.) computername\instancename I cannot find a way to get rid of "computername" and that is the way that it is loading by default. Let me know if you need more info and I hope I made it a little more clear. Thanks, Chris [quoted text, click to view] >-----Original Message-----
>hi Chris, >"Chris" <ckujawa@kcpag.com> ha scritto nel messaggio >news:010701c4ac9d$fa3d49a0$a501280a@phx.gbl >> Hello everyone. After finally getting MSDE installed, I >> am having trouble with instances. At bootup the instance >> that is loading is the wrong one, and is not working. The >> instance that is loading is just "computername," and I >> need "computername\instance" to load. I have checked the >> registry for the other instance and it is not there. The >> only place I can find this instance is when I open the SQL >> Server Service Manager and click the drop down menu for >> server. When I select the "computername\instance" from >> the drop down menu everything works fine, it is just >> initially it loads a defective instance. Anyone have any >> ideas?? > >Just a question.... to understand... >you do have 2 MSDE instances installed.... >a default instance and a named instance... please verify that both (or the >instance you are interestd in) services are set to start at bootstrap, >inspecting the Windows services manager (control panel- >administrative >tools->services).. startup has to be "Automatic"... > >why the default instance is not working? >-- >Andrea Montanari (Microsoft MVP - SQL Server) >http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org >DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 >(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual >interface) >--------- remove DMO to reply > >.
When you start the SQL server manager for the particularInstance,Is the AUTO-START SERVICE when OS Starts checked. -ZS [quoted text, click to view] >-----Original Message-----
>Hello everyone. After finally getting MSDE installed, I >am having trouble with instances. At bootup the instance >that is loading is the wrong one, and is not working. The >instance that is loading is just "computername," and I >need "computername\instance" to load. I have checked the >registry for the other instance and it is not there. The >only place I can find this instance is when I open the SQL >Server Service Manager and click the drop down menu for >server. When I select the "computername\instance" from >the drop down menu everything works fine, it is just >initially it loads a defective instance. Anyone have any >ideas?? > >Thanks, > >Chris >.
hi Chris,
"Chris" <ckujawa@kcpag.com> ha scritto nel messaggio news:010701c4ac9d$fa3d49a0$a501280a@phx.gbl [quoted text, click to view] > Hello everyone. After finally getting MSDE installed, I > am having trouble with instances. At bootup the instance > that is loading is the wrong one, and is not working. The > instance that is loading is just "computername," and I > need "computername\instance" to load. I have checked the > registry for the other instance and it is not there. The > only place I can find this instance is when I open the SQL > Server Service Manager and click the drop down menu for > server. When I select the "computername\instance" from > the drop down menu everything works fine, it is just > initially it loads a defective instance. Anyone have any > ideas?? Just a question.... to understand... you do have 2 MSDE instances installed.... a default instance and a named instance... please verify that both (or the instance you are interestd in) services are set to start at bootstrap, inspecting the Windows services manager (control panel->administrative tools->services).. startup has to be "Automatic"... why the default instance is not working? -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
hi Chris,
"Chris" <ckujawa@kcpag.com> ha scritto nel messaggio news:089801c4ad48$ccdfdc10$a501280a@phx.gbl [quoted text, click to view] > Hi, and thank you for the reply. Sorry that I did not > make this more clear to begin with. No, I do not have two > instances installed, and I don't want two instances > installed. I guess somewhere in the middle of all the > trouble I had installing MSDE it created some kind of > bogus instance. All the readings I have read say that a > default instance in the registry will be located under > MSSQL Server and a named instance will be under Microsoft > SQL Server. I have deleted the MSSQL Server key and then > everything works fine until I reboot, then the key is re- > created. I can log off and back on after the key is > deleted and it works like it is supposed to. > > When I open SVRNETCN.exe it says that I have two instances > installed: > 1.) computername > 2.) computername\instancename > > I cannot find a way to get rid of "computername" and that > is the way that it is loading by default. > > Let me know if you need more info and I hope I made it a > little more clear. > ok... you do have 2 MSDE instances installed =;-D a default instance, and a named instance named "instancename".... and both of them shoul'd run at startup as this is the default setting (please verify checking the services management tool) and please do not delete registy keys that easy, becouse, as someone elsewhere stated: [quoted text, click to view] >"And by the way, editing the registry is extremely dangerous and I'm not >responsible if you make a mistake and your hair is sure to fall out and you >will catch pneumonia blah blah blah..." =:-) so SQL Server Service Manager should list both instances, and both should be running... if you want to remove an MSDE instance, you should find an entry in the Add/Remove programs applet, and please use that... if you want to "manually" remove an MSDE instance, http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991 Knowledge Base article explains exactely the tasks to be performed as http://support.microsoft.com/default.aspx?scid=kb;en-us;320873 does... the second article uses a tool from the Platform SDK, Msizap.exe, which can clear the Windows Installer entries too... -- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |