Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have installed SQL Server 2008 management studio. When I connect, it shows an error. Also when I go to the SQL Server configuration manager and click on SQL Server SERVER services, this message is shown:

There are no items in list to view

No connections are found in the SQL Server configuration manager while my local network is connected.

How can I fix this?

share|improve this question
3  
What is the exact error you get when you try to connect ? –  Mat Mar 6 '13 at 5:13

2 Answers 2

Sounds like you only installed the management studio and not the actual database engine. You need to connect to a remote SQL Server instance not to your local machine as your local machine doesn't appear to have a SQL Server instance installed.

If you need your own database engine installed you'll need to run through the installer again and install the database engine.

share|improve this answer

Check the TCP/IP is enabled or not.

to check this open Server configuration manager --> Sql Server network configuration --protocols for 'sql server instance name' --> TCP/IP.

if it is disabled enable it.

share|improve this answer
    
TCP isn't used to connect to a local instance. Shared memory is used, and is enabled by default. –  mrdenny Mar 13 '13 at 0:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.