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

Run-time error ''-2147467259(80004005)'' :SQL Server does not exist or access denied Expand / Collapse
Author
Message
Posted Friday, June 15, 2007 10:27 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 1, 2013 5:22 AM
Points: 165, Visits: 205

Hello Everyone,

   Here i have a query that  am getting the below error message while connecting to the remote server from local using a data collection tool.
I have tested the  sql server services and client network utility tool and all are ok.

Run-time error '-2147467259(80004005)'
[DBNETLIB][ConnectionOpen(Connect()).] :SQL Server does not exist or access denied

Can any one help me on this issue?
This would be very very helpful to me....


Thanks,
Bagath.

Post #374488
Posted Monday, June 18, 2007 1:31 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: 2 days ago @ 2:01 PM
Points: 40,390, Visits: 36,823

Check the server name and check the login name being used.

That message usually means that the server name specified is not a running sql server or that the login name being used does not have access to the server.




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 #374549
Posted Monday, June 18, 2007 2:03 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, November 17, 2014 7:05 AM
Points: 3,461, Visits: 353
Have you given the right port number for SQL Server. Check if the port number specified is also correct.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Post #374554
Posted Monday, June 18, 2007 11:56 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, November 9, 2014 12:08 PM
Points: 1,618, Visits: 1,553
Rule of thumb #42:  when asking about a query that gives an error, post the query.



My blog: SQL Soldier
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring
Microsoft Certified Master: SQL Server 2008
Principal DBA: Outerwall, Inc.
Also available for consulting: SQL DBA Master
Post #374843
Posted Monday, February 2, 2009 11:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 11, 2009 8:19 PM
Points: 1, Visits: 5
dear port no. for the sql server is correct now what i do ?????????????
Post #648583
Posted Monday, August 10, 2009 3:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 10, 2009 3:33 AM
Points: 1, Visits: 1
on the server that is running sql server 2000 start the server network utility
on the general tab click the instance that you want in the instance list
click named pipes and then click properities
on the general tab verify that named pipe
Post #767695
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse