Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL SERVER 2005: Unable to complete login process due to delay in opening server connection??

Posted on 2011-03-08
6
Medium Priority
?
1,526 Views
Last Modified: 2012-06-27
Hello,

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
server connection


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,

Brian
 
0
Comment
Question by:Greythorn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 35076809
mssqlserver is usally what is referred to as the "Default" instance.  Are you sure that your server is running in an instance.  Typically you would see (INSTANCE NAME) in the services list in the control panel.

You most likely are running the default instance which doesn't have a name.
0
 
LVL 1

Author Comment

by:Greythorn
ID: 35077008
I've checked the services and MSSQLSERVER is listed on 4 of the SQL services there. Its also listed under the SQL Server Configuration Manager under Network Configuration so I'm assuming it is running that instance.

thanks
0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 1000 total points
ID: 35077570
So those are the default instances most likely.

try this from the local server:


OSQL -E -Q "SELECT NAME FROM SYSDATABASES"

Without -S i will attempt to attach to the default instance on the local server.
0
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 
LVL 1

Author Closing Comment

by:Greythorn
ID: 35078256
The initial and follow up responses were very quick and easy to follow.
0
 
LVL 1

Author Comment

by:Greythorn
ID: 35078269
That worked straight away and listed the required database. I guess it just couldn't connect to the default database with the earlier command.

Thanks a lot for you help Brandon.
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 35078447
It's not the default database, it's the default, non-named instance.

I'd recommend reading over this article I wrote.  Hopefully it will clear things up.

http://www.sqlservernation.com/home/what-are-instances.html
0

Featured Post

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question