SQL Server Timeout Issue

[initroot]

I'm having issue with SQL Server.
Local connects fine, server is set to use SQL and Windows Authentication modes.
IP/TCP and named pipes is enabled on the SQL configuration.

However all the connections timeouts on the first attempt.
1. Connect using sa login - fails say within event viewer that password is incorrect.
2. Connects successfully on 2nd attempt.

Password in both instances is more than fine.

I've done the following:

• Restart
• recheck login
• adjust DNS host file
• recheck IP and ports

None of these helped.
Any other suggestions?

 

[skimread]

I once had weird authentication issues like that for windows authentication where I prevously installed SQL Server while logged in on local computer account and domain users had an annoying delay when opening SMS query windows and couldn't connect via .net apps . Reinstalling SQL Server resolved it

 

[etienne_marais]

Reinstalling SQL Server resolved it

Ouch

 

[TheFriendlyGhost]

1. Geographical differences in the location of your servers?
2. connection to the instance using IP only - will rule out DNS
3. run a continuous ping from the remote server to the SQL instance, timeouts will point to network connectivity

 

[Nerfherder]

I once had weird authentication issues like that for windows authentication where I prevously installed SQL Server while logged in on local computer account and domain users had an annoying delay when opening SMS query windows and couldn't connect via .net apps . Reinstalling SQL Server resolved it

Probably just the management studio


I just moved from 2008 to 2012 and was amazed how many issues were fixed

 

[Nerfherder]

I'm having issue with SQL Server.
Local connects fine, server is set to use SQL and Windows Authentication modes.
IP/TCP and named pipes is enabled on the SQL configuration.

However all the connections timeouts on the first attempt.
1. Connect using sa login - fails say within event viewer that password is incorrect.
2. Connects successfully on 2nd attempt.

Password in both instances is more than fine.

I've done the following:

• Restart
• recheck login
• adjust DNS host file
• recheck IP and ports

None of these helped.
Any other suggestions?

Do you have a load balanced or mirrored environment ?