Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
LOGIN PROBLEM WITH SSMS 2012 ON WIN 7

Answered LOGIN PROBLEM WITH SSMS 2012 ON WIN 7

  • Saturday, September 22, 2012 7:39 PM
     
     
    Sign In to Vote
    0

    I have just downloaded & installed a version of SSMS 2012 from:

    http://download.microsoft.com/download/8/D/D/8DD7BDBA-CEF7-4D8E-8C16-D9F69527F909/ENU/x64/SQLManagementStudio_x64_ENU.exe

    on my new laptop with Win 7 (64 Bit Version)

    I seek to start SQL learning on my very on local laptop but the moment I start the SSMS 2012 I fail to login. Server Type shows Database Engine in read-only mode. No server name is found in either the Local/Netwrok Servers List. DOS CMD osql -L also represents:

    Servers:

       --NONE--

    Upon googling I have found out the following different recommendations and tried them out all without any success while even running the program as an administrator and even if the Firewall is totally turned off:

    1. Inserting the computer name (i.e. Faraz) as Server Name and Windows Authentication being used;

    2. Using Faraz\SQLExpress encountering the famous problem of server not found or accessible with error: 26

    3. Using Faraz\SQLServer2012 encountering the same message;

    4. Also no luck with Faraz\SQLServer2008 as Server name;

    5. Even the entry (local) also presents the error: 2 with named pipes termed as provider.

    Any help in this regard shall be highly obliged, enabling me to start SSMS on my local machine.

    Do please note that being a complete novice in this regard, I might even have not downloaded the necessary files. Is it necessary to download some other file as well in addition to the SSMS file (link above)?

    Thanks in advance.

    Best Regards, Faraz A Qureshi


     

All Replies