SQL SERVER 2005: Unable to complete login process due to delay in opening server connection??
Posted on 2011-03-08
I've just completed a database migration between servers and now I can't run basic commands on the sql server. The migration is for our AV database and was carried out using a simple backup from one server, then copy to the other server and restore the database there. Both are running SQL Server 2005 and neither are newly installed servers. The AV management service on the AV server is not restarting correctly so following their advice I'm trying some sql commands to troubleshoot.
I haven't personally ran the below commands myself before this migration so I'm not sure if the migration has had an adverse affect or if the command would always have returned the same errors.
Upon running the following from the command line(where mssqlserver is the instance name) I get the below error
OSQL -E -S .\\mssqlserver -Q "SELECT NAME FROM SYSDATABASES"
[SQL Native Client]Unable to complete login process due to delay in opening
I've been researching various remedies and I've tried all the below but I'm still getting the same error:
Checked TCP/IP is enabled
Started the Server Browser Service
Ensured Windows Firewall is disabled.
Ensured I have full permissions on the DB
Set the DatabaseConnection MS for the particular database to Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=DBname;Data Source=SQLServer\instancename;
and also below without the servername so as to try both
Provider=SQLOLEDB;Integrated Security=SSPI;Initial Catalog=DBname;Data Source=instancename;
Any helpful ideas would be greatly appreciated.
Thanks in advance,