Connect to SQL Server Name is blank

Question

When I try to connect to the Server Name..it is blank.

I tried the ".", "(localserver)\SQLEXPRESS" "BSS02205\SQLEXPRESS" ..No luck

But I can connect through SQL Server Management Studio

TCP/IP is enabled.

Any help would be appreciated.

Thanks

George

Answer 1

What windows login do you use when you login to your client machine?

You can try using run as to execute Management Studio and enter your windows credentials there instead. You can do this via Start -> Run, then enter "Runas /user:<yourdomain>\<yourwindowsusername> SSMS.exe". Also you can check your current user name by running "echo %USERNAME%" from a command prompt.

Thanks

---

/Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005/2008), MCAD, ITILv3, OCA 11g) Please click the Mark as Answer button if a post solves your problem

Answer 2

This is what I normally do:
Start Management Studio.
Copy the Server name from the drop down box.
Paste it into the Server name edit box of the other tool (is it the SSMA tool?)

Also, installing the browser service might help.

Answer 3

Hello,

Please start SQL Server Browser Service. Enable Named Pipes protocol and restart SQL Server service for the changes to take effect.

http://msdn.microsoft.com/en-us/library/ms191294(v=sql.100).aspx

Configure or disable Windows Firewall.

http://msdn.microsoft.com/en-us/library/ms175043(v=sql.100)

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 4

To all,

I just realized that I mistakingtly put the word "cannot" in the wrong place.

I CAN connect with Management Studio I CAN'T connect using Microsoft SQL Server Migration Assistant

I will open a new question

Thanks for all your help