all groups > sql server connect > june 2006 >
You're in the

sql server connect

group:

Sometimes yes, sometimes no, connect to a SQL 2005 Server


Sometimes yes, sometimes no, connect to a SQL 2005 Server Javier
6/19/2006 8:26:02 AM
sql server connect: I have the problem that at times I can't connected to the database via
Microsoft SQL Server Management Studio.

The error is: "Timeout expired. The timeout period elapsed prior to
completion of the operation or the server is not responding".

But in other times I can obtain a positive connection, I don't understand
what is the problem.

Before it functioned well but I had to install a new hard disk in my PC of
work and now intermittent fails the connection.

The server is Windows 2003 Server Enterprise with all the patches and
updatings and all is up to date and the workstation is Windwos XP Pro with
all the patches and updatings up to date and antivirus too.

The SQL Server 2005 is Standard Edition with the SP1 installed, and mixed
authentication.

Best Regards,

Re: Sometimes yes, sometimes no, connect to a SQL 2005 Server Roger Wolter[MSFT]
6/19/2006 1:01:25 PM
Chances are, something is slower in your new environment and the 15 second
default connection timeout is too short. When the connection dialog box
comes up, click on the Options button and you can increase the connection
timeout value from the 15 second default.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]

Re: Sometimes yes, sometimes no, connect to a SQL 2005 Server Javier
6/19/2006 3:27:02 PM
Thanks Roger for you answer:

I changed the connection timeout value to 30 seconds and seems it work. You
can tell me what is working slowly?

Javier Salvatierra

[quoted text, click to view]
AddThis Social Bookmark Button