March 10, 2013 at 3:52 am
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]. 😀
March 10, 2013 at 4:37 am
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
March 10, 2013 at 4:46 am
Ok did not no that. Thank you.
[font="Comic Sans MS"]System going down at 5 this afternoon to install scheduler bug[/font]. 😀
March 10, 2013 at 4:49 am
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]. 😀
March 10, 2013 at 5:04 am
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
March 10, 2013 at 5:09 am
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]. 😀
March 10, 2013 at 6:09 am
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
March 10, 2013 at 10:19 am
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]. 😀
March 10, 2013 at 10:35 am
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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply