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?

  • 3
    What is the exact error you get when you try to connect ? – Mat Mar 6 '13 at 5:13
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.

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.

  • 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

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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