Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server 2005 Driver for PHP Interview Questions > SQL Server 2005 Management Studio Connection to Se...

:: Categories ::

Interview Question in SQL Server 2005 Driver for PHP


 

Interview Question :: SQL Server 2005 Management Studio Connection to Server dialog - cannot proceed


I want to use SQL Server 2005 on my home PC. No networks, servers or anything. I've installed it and when I launch Management Studio, it shows a "Connect to Server" dialog.

Screenshot here:
http://img520.imageshack.us/my.php?image...

I've tried entering various terms like 'localhost', 'local', my machine name etc. in the 'Server Name' box. There is no server listed in the drop-down box as well as when i try osql -L from command-line. Is there anything wrong with my install? What do I exactly need to do to get it up and running?

Thanks for specific instructions, please.
Answers to "SQL Server 2005 Management Studio Connection to Server dialog - cannot proceed"
RE: SQL Server 2005 Management Studio Connection to Server dialog - cannot proceed?

When you installed SQL did you make it a default instance or give it a name? If its SQL Express it could be something like



MachineName\SQLEXPRESS if its default. Or

localhost\SQLEXPRESS



Did the installation fail at any point?
 
Vote for this answer ::  
RE: SQL Server 2005 Management Studio Connection to Server dialog - cannot proceed?

Check under services what SQL service you have installed that can guide you. What edition of SQL did you install?



Also (local) or just a dot "." should work for local instances.
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License