Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 VWD 2010 connection issue with SQL 2008 R2

Author  Topic 

JonnyToppa
Starting Member

8 Posts

Posted - 2011-12-19 : 07:04:50
Im using MS Visual Web Developer 2010 Express with SQL Server 2008 R2 Express. When attempting to make a connection to server from VWD the server Name is found but the Databases contained cannot be located. Error message is 'A Network related or Instance Specific error occured while establishing connection etc Error - 40 ' .
Any help much appreciated.

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-12-19 : 12:49:15
There is some info here which may be helpful. In particular, if you are using SQLExpress, the instance name would be COMPUTERNAME\SqlExpress
Go to Top of Page

JonnyToppa
Starting Member

8 Posts

Posted - 2011-12-19 : 16:58:03
Problem solved.
The Add Connection box finds Instance name but needed \SQLExpress to find DB.
Thanks for your help.
Go to Top of Page
   

- Advertisement -