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 12»»

Error while connecting to the server.. Expand / Collapse
Author
Message
Posted Wednesday, December 12, 2012 6:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 10, 2013 4:44 AM
Points: 15, Visits: 38
Please Help!!!!! This error is driving me crazy!
"A network-related or instance-specific error occured while establishing a connection to SQL Server. The server was not found or was not accessible. Verify taht the instance name is correct and that the SQL server is configured to allow remote connections. (Provider: Named pipes provider, Error:40- could not open connection to the SQL Serevr."
Post #1395623
Posted Wednesday, December 12, 2012 6:18 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:37 AM
Points: 708, Visits: 3,288
1) What authentication mode are you using?
2) Are you trying to connect to the server remotely?
3) Have you enabled remote access?
4) Is TCP/IP enabled?

You need to provide more info.


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


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1395625
Posted Wednesday, December 12, 2012 6:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:19 AM
Points: 5,216, Visits: 5,109
Firewall rules open and correct?

Named instance or default instance?

Static ports or dynamic ports?

SQL Browser Service running?

Can you telnet to the server over the correct port?

Can you connect via IP instead of hostname?

Is the hostname spelt correctly?

Do you need to use the FQDN instead of just the hostname?




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1395626
Posted Wednesday, December 12, 2012 6:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 10, 2013 4:44 AM
Points: 15, Visits: 38
server type: Database engine
authentication: windows Authentication.
yes remotely.
Im very fresh with SQL and struggling from time to time.
Im trying to create a report in BIDS and thats the type of error im fighting with, i thought Im doing everything like i should.
The problem must be somewhere deaper....
Can you please help me, ill follow any instructions.
Regards,
Mel.
Post #1395629
Posted Wednesday, December 12, 2012 7:01 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:37 AM
Points: 708, Visits: 3,288
Is TCP/IP enabled? Check this in sql server configuration manager.


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


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1395648
Posted Wednesday, December 12, 2012 7:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 10, 2013 4:44 AM
Points: 15, Visits: 38
TCP/IP enabled
The remote procedure call failed [0x800706be].
Post #1395650
Posted Wednesday, December 12, 2012 7:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 10, 2013 4:44 AM
Points: 15, Visits: 38
im using SQL Server express advanced eddition by the way.
Post #1395658
Posted Wednesday, December 12, 2012 7:28 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:37 AM
Points: 708, Visits: 3,288
I assume you also checked that sql server is configured to allow remote connections?

Are you trying to connect to a named instance or is it just a default instance?

Are you just putting the server name or are you using FQDN?

Also, have you created a login on the sql server?

Even with all this it could be a firewall issue on the machine that's hosting sql server!


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


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1395670
Posted Wednesday, December 12, 2012 7:28 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:37 AM
Points: 708, Visits: 3,288
You may have to create an inbound firewall rule but check the above first.

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


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1395671
Posted Wednesday, January 9, 2013 4:03 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 10, 2013 4:44 AM
Points: 15, Visits: 38
thank you I have found the problem.
Post #1404658
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse