Connecting to a DATABASE in visual studio 2010
Such a problem. Created in sql server 2008 managment database. But I want to connect to it in visual studio 2010. Click connect to server, but the server name box is empty. Through sql server 2008, all properly connected. I cant undestand why? Help me please
Suthish NairPosted Jun 21, 2011, 7:13 AM
Or, go to Server Explorer (Crtl+Alt+S) and Add New Connection.
Also, refer article: Find Database Connection and Generate Connection String using Visual Studio
Sam HobbsPosted Jun 21, 2011, 9:06 PM
Mike JonsonPosted Jun 21, 2011, 3:32 PM
Pradeep ChandrakerPosted Jun 21, 2011, 2:53 PM
On Server Explorer click on Add Connection. Provide servername/IP, select authentication type (if it is SQL Server Authentication provide username and password). If you already have database, select database. And click on Ok.