• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

Connect SQL Server Standard Edition to local machine

I wish to connect the sql server 2008 SSMS to my local machine itself. I am using the full paid version and not the express one.
it is giving me error all the time. Like the one attached below.
Kindly  let me know how to connect to local.
1. I tried even chooosing (local) in teh server name dropdown.
2. I tried putting my computer name in teh server name and tried to connect.
Pls help
Regards
Doc20.doc
0
siva_iaf
Asked:
siva_iaf
  • 4
  • 4
  • 2
1 Solution
 
pcelbaCommented:
You should try  wldn0186113\MSSQL2008  as the server name.
0
 
dwkorCommented:
Do you have default or named instance of SQL Server? If your instance is named one - you should use: .\<Name> as the server name. Also, press the "options" button and select either "shared memory" or "default" as the protocol.
0
 
pcelbaCommented:
The right name of your SQL Server instance is visible among running Services, so try to look at it (in Control Panel, Administrative tools) and ensure the appropriate service is not stopped.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
siva_iafAuthor Commented:
Hi  pcelba

I tried wldn0186113\MSSQL2008 but gave me teh same error.
also there are so many services in the admin tool. not sure what to check for.

Pls see attached the services list.
Doc20.doc
0
 
dwkorCommented:
Are you sure you have SQL Server installed on this machine? It does not have sql server service there.
0
 
siva_iafAuthor Commented:
I am sure it is installed. I am able to connect to remote servers using the SSMS and even run simple queries using query window.
0
 
pcelbaCommented:
Yes, you've installed client tools only, no SQL Server.

The service name is "SQL Server" followed by SQL Server instance name.
0
 
siva_iafAuthor Commented:
Hi But pls see the attached image. It is sql server 2008 and advice.

Doc20.doc
0
 
pcelbaCommented:
If you execute SQL Server Configuration Manager you will see all installed components at a glance.

If you right click on SQL Server 2008 in Control Panel it will allow to install missing parts. You just need the installation DVD and install the Core Database Engine.

BTW, did you restart the computer after installation?
0
 
siva_iafAuthor Commented:
Thanks
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now