Server Connection Timeout

Question

Post reply

Server Connection Timeout

HBhagat

Hall of Fame

Points: 3341
More actions
May 26, 2009 at 3:42 am

#73095

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

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 1

while restoring the data, you can't access the data, once process completed, you didn't get this problem.

HBhagat Hall of Fame Points: 3341 More actions · Answer 2

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

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 3

Kishore.P

SSCrazy Eights

Points: 8147

May 26, 2009 at 3:58 am

#999786

which ver. of SQL server using ?

HBhagat Hall of Fame Points: 3341 More actions · Answer 4

HBhagat

Hall of Fame

Points: 3341

May 26, 2009 at 3:59 am

#999788

SQL server 2000 Windows 2003

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 5

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.

HBhagat Hall of Fame Points: 3341 More actions · Answer 6

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..

Chand00 SSCertifiable Points: 6466 More actions · Answer 7

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

[font="Verdana"]Thanks
Chandra Mohan[/font]

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 8

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

Chand00 SSCertifiable Points: 6466 More actions · Answer 9

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

[font="Verdana"]Thanks
Chandra Mohan[/font]

Kishore.P SSCrazy Eights Points: 8147 More actions · Answer 10

Hi Chandra,

If database have not enough space, at that time also you get this problem. I faced this problem long back, after I ran DBCC command(s) issue was resolved (note: Win 2000 & SQL 2000 with SP 4). That's why I suggested.

During transferring the data, SQL Server requires more space to do this operation.

Connectivity problem occurs in may ways like ODBC / MDAC drivers may be corrupted, poor network, ports may changed, etc.

HBhagat Hall of Fame Points: 3341 More actions · Answer 11

Hi,

I using the login for SQL administrator.

I think I know whats the problem but cannot resolve it.

There is some server connection timeout happening between the server.

As I said once my 15min job is executed the connection between the server gets refreshed.

I am not concer with my job I am concern with the connection problem.

If I do not connect for 10 mins to the server with a query or so I have to wait till my job runs.

E.G.

my job executes at 10:45

at 10:55 if I execute a normal select query it does not work.

In query analyzer of A server I execute a select query to retrive data from B server.

But when the job is execute at 11:00 and use the same query it returns the data..

HBhagat Hall of Fame Points: 3341 More actions · Answer 12

my database size is 104587.31 MB

and unallocated space is 3959.97 MB

reserved data index_size unused

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

102986144 KB 58855568 KB 41977184 KB 2153392 KB

I have not executed any dbcc commands.

Chand00 SSCertifiable Points: 6466 More actions · Answer 13

Harsha,

You mean to say that whenever the job is running you are unable to retrieve the data using query analyzer and once the job gets completed you are able to retrieve the data. Tell me where i got it correctly or not.

Thanks

Chandra Mohan N

[font="Verdana"]Thanks
Chandra Mohan[/font]

HBhagat Hall of Fame Points: 3341 More actions · Answer 14

Its the other way round

At 10:30 my job is executed.

at 10:32 in QA I execute the query select * from A.dbname.dbo.tablename- Retirves data

At 10:45 my job is executed.

at 10:56 at 10:32 in QA I execute the query select * from A.dbname.dbo.tablename- does not Retirves data, throws the error