June 15, 2007 at 10:27 pm
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.
June 18, 2007 at 1:31 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 18, 2007 at 2:03 am
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
June 18, 2007 at 11:56 pm
Rule of thumb #42: when asking about a query that gives an error, post the query.
February 2, 2009 at 11:07 pm
dear port no. for the sql server is correct now what i do ?????????????
August 10, 2009 at 3:35 am
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
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply