Login Error

  • TITLE: Connect to Server

    Cannot connect to β€œmy machine name”.

    ADDITIONAL INFORMATION:

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

    Error Number: 2

    Severity: 20

    State: 0

    [font="Comic Sans MS"]System going down at 5 this afternoon to install scheduler bug[/font]. πŸ˜€

  • The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections

    Have you done that and checked that the service is 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
  • Ok did not no that. Thank you.

    [font="Comic Sans MS"]System going down at 5 this afternoon to install scheduler bug[/font]. πŸ˜€

  • How do I disable a remote connection. I cannot recall enabling the server for remote connection. This is just an evaluation edition that I am practicing on. Thank you

    [font="Comic Sans MS"]System going down at 5 this afternoon to install scheduler bug[/font]. πŸ˜€

  • Paul_Data_Smart (3/10/2013)


    How do I disable a remote connection.

    Why do you want to disable remote connections? Eval should have then pre-enabled iirc.

    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
  • Ok checked everything in config manager and all is ok but still get this error. I am at my wits end with this one.

    [font="Comic Sans MS"]System going down at 5 this afternoon to install scheduler bug[/font]. πŸ˜€

  • Is the service running?

    Are you specifying the correct server and instance name?

    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
  • Yes they are correct. I checked application error log. And recieved the following notification "Your evaluation edition of SQL Server has ended"

    Thank you SQL Master for replying though. Regards

    [font="Comic Sans MS"]System going down at 5 this afternoon to install scheduler bug[/font]. πŸ˜€

  • Paul_Data_Smart (3/10/2013)


    And recieved the following notification "Your evaluation edition of SQL Server has ended"

    Yes, that'll be the cause. Evaluation's expired, service won't be running. You'll need to install a full version of SQL Server (Express or Dev would probably be best) to continue.

    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

Viewing 9 posts - 1 through 8 (of 8 total)

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