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?

Marian
15.8k2 gold badges62 silver badges75 bronze badges
asked Mar 6, 2013 at 3:10
1
  • 3
    What is the exact error you get when you try to connect ? Commented Mar 6, 2013 at 5:13

2 Answers 2

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.

answered Mar 6, 2013 at 12:36
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.

answered Mar 6, 2013 at 12:08
1
  • TCP isn't used to connect to a local instance. Shared memory is used, and is enabled by default. Commented Mar 13, 2013 at 0:53

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.