>>>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.

But my colleague is going now, so we would have to do this tomorrow anyway.