Can not access / login to SQL Server

  • "Can not access / login to SQL Server" [Sql Server 2014 Express]

    Q1: Is there a way to fix this problem?

    When I installed this instance as MYSVR\Admin, I was under the impression that the sa account could be used to gain access and that the system would create a windows account for the user (MYSVR\Admin) who installed it. I set an sa password and configured it for dual login (windows + user/password). Neither account seem to be on this instance!   Or something else prevents me connecting.

    So I configured this instance to start in single user mode (startup parameter -m) in the belief than any valid user could gain access, and that a valid windows user would be mapped to a local sql server admin account.  [ Q2: Does it still work that way with Sql Server 2014 Express? ]

    In computer management, Services. It now shows:
    Name:    SQLEXPRESS
    Status:    Running
    Startup Type:    Automatic
    Log On As:    Local System

    So now I try to connect to the running service via SQL Server Man Studio:

    Server Name:    MYSVR\SQLEXPRESS
    Authentication:    Windows
    User Name:      MYSVR\Admin

    While I am logged on to this server using the MYSVR\Admin account. It just throws back "A network-related or instance specific error occurred while establishing a connection to Sql Server." [Error: 2]

  • mark4asp - Wednesday, July 12, 2017 5:49 AM

    that the system would create a windows account for the user (MYSVR\Admin) who installed it.

    Only if you told the setup to do so 😉

    Mark4asp - Wednesday, July 12, 2017 5:49 AMOr something else prevents me connecting.

    Very likely

    Mark4asp - Wednesday, July 12, 2017 5:49 AMSo I configured this instance to start in single user mode (startup parameter -m) in the belief than any valid user could gain access

    You need to understand what constitutes a valid user.
    The user must be a member of the local administrators group on the Windows machine

    Mark4asp - Wednesday, July 12, 2017 5:49 AM
    While I am logged on to this server using the MYSVR\Admin account. It just throws back "A network-related or instance specific error occurred while establishing a connection to Sql Server." [Error: 2]

    Check sql server configuration manager to see if the service is actually running

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Is there anything relating to network protocols or the login failures in the ERRORLOG file?

    path similar to:

    C:\Program Files\Microsoft SQL Server\MSSQL12.SQL2014\MSSQL\Log

    And are you connecting locally on the box, or remotely from another?  SSMS?

    ------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NFDallasDBAs.com/BlogWhy is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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