sql server connect: Bug ?->Can not make a new connection to SQL Server 2005 X64 -- sql server connect

Bug ?->Can not make a new connection to SQL Server 2005 X64

Kiran
2/17/2006 2:30:07 PM

sql server connect: Can not make a new connection to SQL Server 2005 X64 until the SQL Server
service is restarted.
OS is Windows 2003 X64 Enterprise Edition all updates are applied.

This repeats every few hours. Server protocols enabled are TCP IP and Named
Pipes
Client protocols are Named Piped only.

The following error is thrown MSg 17
"SQL Server does not exist or access is denied"

Since I am not finding solution this problem on many forums I assume this is
a bug.

Thanks
Kiran

Re: Bug ?->Can not make a new connection to SQL Server 2005 X64

Rick Byham [MS]
2/17/2006 2:50:16 PM

"SQL Server does not exist or access is denied" could indicate a problem
resolving the name of the instance. Is this a default instance listening on
the default named pipe, or a named instance? The second would require the
SQL Server Browser Service or require connecting to a specific pipe name. So
is the SQL Server Browser Service running?
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.

[quoted text, click to view]