Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Login Error Expand / Collapse
When I want to login to the server i recieve the following error message: Error 02. What can I do?
Poll ResultsVotes
Please help!
 
100%
2
Member Votes: 2, Anonymous Votes: 0. You don't have permission to vote within this poll.
Author
Message
Posted Sunday, March 10, 2013 3:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 3:21 PM
Points: 16, Visits: 33
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



System going down at 5 this afternoon to install scheduler bug.
Post #1428965
Posted Sunday, March 10, 2013 4:37 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 42,481, Visits: 35,550
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 2008, MVP
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

Post #1428971
Posted Sunday, March 10, 2013 4:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 3:21 PM
Points: 16, Visits: 33
Ok did not no that. Thank you.

System going down at 5 this afternoon to install scheduler bug.
Post #1428973
Posted Sunday, March 10, 2013 4:49 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 3:21 PM
Points: 16, Visits: 33
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

System going down at 5 this afternoon to install scheduler bug.
Post #1428974
Posted Sunday, March 10, 2013 5:04 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 42,481, Visits: 35,550
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 2008, MVP
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

Post #1428976
Posted Sunday, March 10, 2013 5:09 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 3:21 PM
Points: 16, Visits: 33
Ok checked everything in config manager and all is ok but still get this error. I am at my wits end with this one.

System going down at 5 this afternoon to install scheduler bug.
Post #1428977
Posted Sunday, March 10, 2013 6:09 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 42,481, Visits: 35,550
Is the service running?
Are you specifying the correct server and instance name?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1428979
Posted Sunday, March 10, 2013 10:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 1, 2014 3:21 PM
Points: 16, Visits: 33
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


System going down at 5 this afternoon to install scheduler bug.
Post #1428991
Posted Sunday, March 10, 2013 10:35 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 42,481, Visits: 35,550
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 2008, MVP
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

Post #1428993
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse