February 22, 2005 at 9:07 am
A PC here has MSDE installed and the SQL service is set to start automatically. However, when rebooting the PC and logging in to windows, trying to conect to the database brings up a SQL Server doesn't exist message. Checked the Services and the MSSQLSERVER service is running. Stopping and then re-starting the service resolves the problem but it's a bit of a pain for the user having to do this everytime as they are not technical at all.
I understand this is a known issue with MSDE, anyone know if there's a fix available?
Thanks
Steve
Steve Williams
February 23, 2005 at 1:29 pm
By default, when installing MSDE Revision A or SP3, all network protocols for connecting to MSDE are turned off, except for shared memory protocol. Try specifying in the connection string to use server name "(local)", or put "lpc:" before the server/instance name (e.g. "lpc:myserver/instance2" in your connection string to force shared memory protocol.
Mark
Mark
February 24, 2005 at 12:23 pm
Try this solution if you're trying to connect to the db through Enterprise Manager:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=159785#bm159790
--Lester
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply