PeterDC


I have been having problems after I make a connection from my application to a SQL Server 2005 database that is located on a different machine. After a few minutes it gives me the SQL Server Does Not exist or Access denied message. I am able to connect to it through SQL Server management studio. I am doing some data intensive operations by copying data from different tables on the remote server onto text files on my local machine. Any suggestions



Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

Emanuel Peixoto


Did you alread verify your string connection

verify the error log to looking for a possible user dennied access. "sp_readerrorlog"







Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

Madhu K Nair

Post back your version/edition of SQL Server. Are you connecting to SQL Server express userinstance

Madhu







Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

PeterDC

My version of SQL Server is SQL 2005 not the Express version. The MSSQL Server Management Studio reports a version of 9.00.3042.00. I also looked at the SQL error log and the only error I see is Error 17207, Severity 16, Statr 1.




Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

Emanuel Peixoto

Hi, Peter, did you promote your SQL server after you have been instaled you SQL on your server






Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

Emanuel Peixoto

See this Microsoft article:

http://support.microsoft.com/kb/929665/en-us






Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

PeterDC

That article did not really help as I am able to access the remote SQL server but after some time the connection gets dropped. I do not understand what you mean by promoting myself on the server i am always logging on as sa so i assume i have all the rights I need





Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

PeterDC

Some further information

We are using a lot of Dynamic SQL in our queries and most of the queries are just Select statements run across the network. Further more these problems have started being reported recently after we had migrated to SQL 2005. Still need to do more testing on SQL 2000 to confirm if that is the case. In the meanwhile has this been a problem on SQL2005





Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

Emanuel Peixoto

Sorry Peter, I would meam "did you also promote your server to a Domain controler after SQL instaled "






Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

PeterDC

I am not sure I know how to do this. Can u tell me how

Thanks





Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

PeterDC

One other thing I have noticed is that if I run the same application through the debugger this problem does not occur. Does that help





Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

PeterDC

One more piece of information. I have tried the same application but this time off of SQL 2000 and the problem goes away. So it seems to have happened after we moved to SQL2005.





Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

PeterDC

Any hints or suggestions





Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

PeterDC

no more suggestions





Re: SQL Server Does Not exist or Access denied happens shortly after a successful connect

Madhu K Nair

few more ...

(a) Check whether database has AUTO_CLOSE setting if is then switchit off

(b) switch off Antivirus software if any.

Madhu