0

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?

Improve this question
1
  • 3
    What is the exact error you get when you try to connect ?
    – Mat
    Commented Mar 6, 2013 at 5:13

2 Answers 2

Reset to default
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.

Improve this answer
0

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.

Improve this answer
1
  • TCP isn't used to connect to a local instance. Shared memory is used, and is enabled by default.
    – mrdenny
    Commented Mar 13, 2013 at 0:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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