I have installed SQL Managemant studio in my windows XP machine. I was trying to connect one of my SQL server. OOPS …the below error pop up
Below three steps i found to resolve this issue.
1) Check the SQL Server Browser service is started in SQL server ( If not start this service. you have to restart the SQL server Service as well)
2) Check TCP/IP is enabled in SQL Server Configuration Manager ( Start –> Programs –> SQL Server 2008 –>Configuration Tools. If it’s disabled make it enable.
3) Give the Servername\instance name while connecting from SQL Management Studio.
Hope you will be able to connect the SQL server now. I was able to connect when i follow above 3 steps.