locked
Connect to SQL Server Name is blank RRS feed

  • 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

    Thursday, July 12, 2012 8:21 PM

Answers

  • 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

    • Marked as answer by GeorgeFeig Friday, July 13, 2012 6:22 PM
    Friday, July 13, 2012 2:35 PM

All replies

  • 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

    Friday, July 13, 2012 12:25 AM
  • 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.



    Friday, July 13, 2012 11:22 AM
  • 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

    Friday, July 13, 2012 1:18 PM
  • 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

    • Marked as answer by GeorgeFeig Friday, July 13, 2012 6:22 PM
    Friday, July 13, 2012 2:35 PM