Can't attach to the local laptop machine

Question

Can't attach to the local laptop machine

caselig

SSC Veteran

Points: 229
More actions
June 20, 2009 at 2:38 pm

#205768

I'm trying to start the Management Studio for the 2005 express edition.
It doesn't give me the option to start on my local system. I am using the Windows Authentication. What can I do to start up the Management Studio?

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Can you maybe explain the problem in more detail? I'm not sure I understand what's wrong.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

caselig SSC Veteran Points: 229 More actions · Answer 2

The login screen says:

Server Type: Database Engine

Server Name:___________________

Authentication: Windows Authentication

Running Windows XP.

Why can't I logon to my local laptop system?

When browsing I get no option to select my local computer.

I do have SQL 2005 Developer Edition running on my LAN for my desktop system.

I just want to work on my laptop/local computer.

Chuck

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

If you type in the local machine name can you connect?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

ps. One Orange Chip Points: 29422 More actions · Answer 4

GilaMonster (6/20/2009)
If you type in the local machine name can you connect?

OR type a period (.) in the Server Name and then connect. This will connect you to the default instance.

OR type IP 127.0.0.1 in the server name and connect.

Pradeep Singh

WayneS SSC Guru Points: 95409 More actions · Answer 5

ps (6/20/2009)
GilaMonster (6/20/2009)
If you type in the local machine name can you connect?
OR type a period (.) in the Server Name and then connect. This will connect you to the default instance.
OR type IP 127.0.0.1 in the server name and connect.

Recalling back from when I was using Express Edition last year, it installs with a named instance (SQLExpress) that you need to specify to connect to it. See this link for more information.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

ps. One Orange Chip Points: 29422 More actions · Answer 6

Thanks for the link Wayne. However, we still have the option to toggle with the radio button on the installation wizard page which asks user whether to install a named/default instance(only the default behaviour's changed). I suggest OP to check this out on his system.

Pradeep Singh

ps. One Orange Chip Points: 29422 More actions · Answer 7

he can also connect his named instance on local machine by typing

.\instance_name

OR

127.0.0.1\instance_name

Pradeep Singh

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

ps (6/20/2009)
he can also connect his named instance on local machine by typing
.\instance_name
OR
127.0.0.1\instance_name

Assuming he knows what the instance name is.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

caselig SSC Veteran Points: 229 More actions · Answer 9

I tried your suggestions (. or 127.0.0.1) but get an error.

Cannot connect to 127.0.0.1

Additional information:

A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify the instance name is correct and that SQL Server is configured to allow remote connections.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

Go to Services (Start-Control Panel-Administrative tools) and look for a service that has SQL Server in the name. Post the exact name of that service here (or take a screenshot and post here). Is the service running?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

caselig SSC Veteran Points: 229 More actions · Answer 11

That's just it. What is the instance_name? Can I change this somehow to a default instance? Maybe get the installation wizard to open again to select this option.

Chuck

ps. One Orange Chip Points: 29422 More actions · Answer 12

Pls post the complete name of the service as suggested by Gail.

Also, you cannot change the name of an instance without removing the installation and re-installing it or by installing a second instance (default)

Pradeep Singh

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 13

caselig (6/21/2009)
That's just it. What is the instance_name?

No idea. That's why I'm asking to see the name of the Windows service.

Also to check that it's running.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

caselig SSC Veteran Points: 229 More actions · Answer 14

I'm looking through the services and can't find anything with the SQL name in it.

Sorry. I feel like a total idiot.