VS 2005and SQLserver Express intergration

Hi,

I've installed the following on my Windows 2000 sp4 system.

VS studion 2005 standard edition
SQLServer Expresss
SQLSever Express management tools.

I know the SQL server is working as I can get to it from the management tools. I've successfully created a DB, made tables, and done selects.

My VS 2005 appears to have installed without problem and isn't giving me any problems except as follows.

VS 2005 won't open a connection to the database. I've tried it both programically and through the database tools in VS 2005. In both cases I get the same the message. A connection cannot be opened and that the possible cause is that the server will not accept remote access. I went to SQLServer and found a general server property for this and checked yes to allow the remote connection. This had no effect.

Any suggestions on how to fix this Is there also a databse specific property to allow remote access

Thanks,

Bob


Answer this question

VS 2005and SQLserver Express intergration