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

Server Connection Timeout Expand / Collapse
Author
Message
Posted Tuesday, May 26, 2009 3:42 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:22 AM
Points: 446, Visits: 649
HI All,
I have got 2 servers.
A server which is a live one.
B server which is the failover server.

Every 15 mins my data gets transferred from A server to B server by a job.

I want to access data from B server by writting a query in Query Analyzer I recieve an error
Server: Msg 17, Level 16, State 1, Line 1
SQL Server does not exist or access denied.

This is something related with the server connections...
The job run2 every 15 mins so once the job has executed and if i execute the query in the A server I can access the data. But if its more than 10 mins then I cannot access the server.
Please Help..
Thanks in advance
Harsha
Post #723124
Posted Tuesday, May 26, 2009 3:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:49 AM
Points: 1,391, Visits: 608
while restoring the data, you can't access the data, once process completed, you didn't get this problem.



Post #723130
Posted Tuesday, May 26, 2009 3:56 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:22 AM
Points: 446, Visits: 649
Its not the matter of restoring.
If I do a normal select query i get the error.

In server A if i execute the query as
select * from B.databsename.dbo.Tablename
I get the error
Post #723131
Posted Tuesday, May 26, 2009 3:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:49 AM
Points: 1,391, Visits: 608
which ver. of SQL server using ?


Post #723133
Posted Tuesday, May 26, 2009 3:59 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:22 AM
Points: 446, Visits: 649
SQL server 2000 Windows 2003
Post #723135
Posted Tuesday, May 26, 2009 4:04 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:49 AM
Points: 1,391, Visits: 608
when this problem occurred ? (means today or long back)

Could you please do the following:

> Check the Client Network Protocols of SQL Server.
> Possible, restart the SQL Server or reboot the machine.




Post #723138
Posted Tuesday, May 26, 2009 4:06 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 5:22 AM
Points: 446, Visits: 649
Its not possible for me to reboot the machine or restart the server..
This happens very frequently... and its happening now also.
I am not familiar with the client network utility..
what should i check in them..
Post #723143
Posted Tuesday, May 26, 2009 4:19 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: Thursday, April 03, 2014 1:06 AM
Points: 525, Visits: 1,124
Hi Harsha,

How you are transferring data from one server to another. There are many ways like backup and restore, dts and bcp, database mirroring, logshipping etc..

version of both sql server and sp version.?
did u try to connect from server a to server b using the query analyzer.
Did u check whether the login you are using has sufficient permissions on the server b.
Did u try the concept of linked server.

Thanks
Chandra Mohan N


Thanks
Chandra Mohan
Post #723150
Posted Tuesday, May 26, 2009 4:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, March 13, 2014 5:49 AM
Points: 1,391, Visits: 608
I think SQL Server 2000 Service Pack 4 may exist in your machine.

Problem may be ODBC Drivers or TCP/IP ports.

Run the following commands if server is offline:

DBCC UPDATEUSAGE ([DBNAME])
DBCC CHECKDB
DBCC DROPCLEANBUFFERS
sp_spaceused.

for more information, see the DBCC related command in SQL BOL.

check the below links, it may solve your problem:

http://www.alagad.com/go/blog-entry/one-solution-to-this-error-sql-server-does-not-exist-or-access-denied
http://blogs.msdn.com/sql_protocols/archive/2005/12/19/505372.aspx
http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/Q_20789603.html
http://support.microsoft.com/kb/314530



Post #723152
Posted Tuesday, May 26, 2009 4:27 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: Thursday, April 03, 2014 1:06 AM
Points: 525, Visits: 1,124
Hi Kishore,

I dont understand why you are recommending harsha to run the dbcc commands. DBCC commands has nothing to do with this problem. There might be connectivity issues or some other things.

Harsha, Please dont run DBCC commands unless required.

Thanks
Chandra Mohan N


Thanks
Chandra Mohan
Post #723154
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse