hw to connect ms visual studio2008 pro to ms sql server2008

Question

with details if connection is possible

Riyaz Akhtar · Answer

Hi Vivek, Follow below step to connect sql server with VS : In Server Explorer/Database Explorer click Connect to Database . In the Choose Data Source dialog box, select Microsoft SQL Server , and then click OK . If the Add Connection dialog box opens, and the Data source is not Microsoft SQL Server , click Change to open the Choose/Change Data Source dialog box. For more information, see Choose/Change Data Source Dialog Box. Select a server name from the drop-down list, or type the name of the server where the database you want to access is located. Based on the requirements of your database or application, select either Windows Authentication or use a specific user name and password to log on to the SQL Server ( SQL Server Authentication ). For more information, see Add/Modify Connection (Microsoft SQL Server). Select the database you want to connect to from the drop-down list. Click OK . See below link for details: http://msdn.microsoft.com/en-us/library/s4yys16a(v=vs.90).aspx

hw to connect ms visual studio2008 pro to ms sql server2008

Answers (1)