Sunday, March 11, 2012

connection from SQLS database to Visual Studio. Timeout failed.

I have a databse in SQL Server 2005 Sept Beta 2. On another partition I have Visual Studio 8. I want to establish a connection between the two.

Doing it programmatically in a C# code program fails.The connection string does not give me an error on debug.

Doing it via GUI in VS fails on the account of "timeout failed..."

I tried to copy the whole database from SQL Server directory into VS directory - the same result.

Amazingly, I was able to connect to my FoxPro 9 database with no problem. Also an Access database is connected.

Is there a way to increase this parameter: timeout? Where is set up?

Thanks.Most likely the SQL Server is not running. Is this the same machine (SQL Server and VS)? Copying files is not necessary. Being on different partitions is ok as well. Can you connect using sqlcmd? If not, what is the error message you get?

When you type 'net start' in the command line do you see SQL Server started? Or check services in the Control Panel.

Boris.

No comments:

Post a Comment