Ok, how many connections are currently open?
Check for any messages from SQL Server in the Application Event Log and in the ERRORLOG file (by default located in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG directory).
>>>>Is the named pipes protocol enabled on the test server? Also, how many sqlserver connections are open?
>>>>
>>>
>>>How can I figure answer on these questions? A bit tired right now...
>>
>>Tomorrow check them. Check if SQLServer Agent is running if you need it. Check the type of authentication you are using and if you have a default database setup if it isn't specified...
>
>The Pipes are enabled, I checked. Opened SQL Server Configuration panel. We're using Web authentication with userID and password.
>
>The service is running.
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
