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
siva_iafAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.