>>>>When you get Login dialog just open Server name combo. There you should have all instances of your server + all servers SSMS found.
>>>
>>>It gives me 2 servers. One I can connect using Windows Authentication, another I can not.
>>>
>>>>Also if you open SQL Server Configuration Manager there you could see what services you have. On my office computer i have:
>>>>SQL Server (MSSQLSERVER)
>>>>SQL Server (SQLSERVEREXPRESS) (or something like that)
>>>>
>>>>Right click on every instance and see all properties for it.
>>>
>>>If I found my database files in one directory, how can I make them available in the instance I'm running this?
>>>
>>>Thanks again.
>>
>>We're getting 'Timeout expired' trying to use test server database from the ASP.NET application. Do you know what can I adjust?
>>
>>Thanks again.
>
>In VFP we have SQLSETPROP(connectionm "QueryTimeOut",number of seconds) But in ASP, I don't know.
>If you want to set it for whole server, run SSMS and right click on Server. Properties->Advanced->Query Wait. I never tried this though.

I was getting timeout error the whole morning. Then for a short period of time it worked. Now I'm getting

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)