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.