Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Business Intelligence » Error while connecting to the server..
Add to briefcase
11 posts, Page 1 of 2
12»»

Error while connecting to the server.. Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Marlena.ibek
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
Abu Dina
Posted Wednesday, December 12, 2012 6:18 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 507, Visits: 2,229
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.

-----------------------------------
http://www.SQL4n00bs.com
Post #1395625
anthony.green
Posted Wednesday, December 12, 2012 6:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 2:40 AM
Points: 5,075, Visits: 4,833
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
Marlena.ibek
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
Abu Dina
Posted Wednesday, December 12, 2012 7:01 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 507, Visits: 2,229
Is TCP/IP enabled? Check this in sql server configuration manager.

-----------------------------------
http://www.SQL4n00bs.com
Post #1395648
Marlena.ibek
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
Marlena.ibek
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
Abu Dina
Posted Wednesday, December 12, 2012 7:28 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 507, Visits: 2,229
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!

-----------------------------------
http://www.SQL4n00bs.com
Post #1395670
Abu Dina
Posted Wednesday, December 12, 2012 7:28 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 10:26 AM
Points: 507, Visits: 2,229
You may have to create an inbound firewall rule but check the above first.

-----------------------------------
http://www.SQL4n00bs.com
Post #1395671
Marlena.ibek
Posted Wednesday, January 09, 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
11 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.