January 15, 2010 at 6:21 am
Hi
I have installed SQL Server 2008 Express onto my laptop with Vista home edition o/s. I can connect to databases (.mdb files) using Visual Studio Express but I cannot connect to my local instance via the Management Studio. When I look up the meaning of the error, I am told:
SQL Server did not respond to the client request because the server is probably not started.
How do I start this service on Vista - I cannot find Services.
Help would be much appreciated.
Thanks
Lorna
January 15, 2010 at 6:57 am
The services should be in administration tools / services under "SQL Server (SQL EXPRESS)" or something like that.
Make sure it's set to automatic start and that it is started.
You can also use the sql configuration manager under start / all programs / sql server / configuration tho I'm not sure this is installed with Express.
Other options if that does not work is to look at the application logs for more specific errors.
Also make sure that your admin login has access to the DB, maybe VS as an automatic way to go around that problem...
January 15, 2010 at 7:10 am
Lorna-331036 (1/15/2010)
HiI have installed SQL Server 2008 Express onto my laptop with Vista home edition o/s. I can connect to databases (.mdb files) using Visual Studio Express but I cannot connect to my local instance via the Management Studio. When I look up the meaning of the error, I am told:
SQL Server did not respond to the client request because the server is probably not started.
How do I start this service on Vista - I cannot find Services.
Help would be much appreciated.
Thanks
Lorna
When you are in VS2005/8 Express you are connecting to a user instance which is in your document folder, you need to connect it to management studio to access it. Check below for details for how to connect user instance to management studio.
Kind regards,
Gift Peddie
January 17, 2010 at 7:28 am
Thanks - I have checked and the service is Started and is set as automatic. However, I still cannot connect to my local server. I am logged on to Vista home as an administrator so thought that it would let me log on using this authentication. Could I have perhaps said I wanted to connect as sa when installing SQL Express? If this is the problem then I have another problem, I didn't take a note of the sa password when installing!
January 17, 2010 at 8:08 am
Did you add the local admin accounts to the server in the wizard? If not, then you won't be able to get in even if you're god on your pc.
Check out the configuration tools to correct the problem.. there may be something in there to do that!
January 17, 2010 at 8:41 am
Thanks but don't know anything about the wizard so probably not! Should I uninstall then reinstall Management Studio or will that just give me more problems??
January 17, 2010 at 8:47 am
Lorna-331036 (1/17/2010)
Thanks but don't know anything about the wizard so probably not! Should I uninstall then reinstall Management Studio or will that just give me more problems??
You need to read and apply what I posted because if you are running a user instance you must connect the Named Pipe to SMS.
Kind regards,
Gift Peddie
January 18, 2010 at 6:31 am
Thanks Gift Peddie - I've read the link and the stuff looks really interesting but when I open SQL Server Management Stuidio it asks me to connect to a server but I can't even get to the server which presumably I need to be able to do to carry out any of the instructions in the link. I have tried logging in using Windows Authentication but it just comes up with an error 🙁
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply