How do I connect to SQL Server using Visual Studio .NET?

 

SUMMARY
Visual Studio .NET 2002 includes a built in database management tool (similar to Microsoft Enterprise Manager).
The following functions are available with this tool.
Retrieve and edit data
Create tables, views, and stored procedures (Enterprise & Architect Version only)

DETAILS
To connect to your Microsoft SQL Server database with Visual Studio .NET, follow the steps listed below.

  1. Open Server Explorer (View -> Server Explorer)

  2. The Server Explorer should show up on the left hand side of the IDE

  3. Right click on \"Data Connections\" and select \"Add Connection\".

  4. Enter the Server Name in the first textbox (do not use the drop down box). MS SQL Server name is sql.yourdomain.com

  5. Check \"Use a specific user name and password:\"

  6. Enter your SQL username & password

  7. Select your database from the dropdown list.

  8. Click \"Ok\"

  9. Once connected, you should see a new entry in the Data Connections Section.

Was this answer helpful?

 Print this Article

Also Read

What is the port that SQL Server clients (Enterprise Manager, Query Analyser, etc) use?

SQL Clients (Enterprise Manager, Query Analyser, etc) use TCP port 1433. If you cannot connect to...

I get this error when trying to connect to my database using SQL Management Studio 2008. "The server principal "username" is not able to access the database "some_database_name" under the current security context. (Microsoft SQL Server, Error: 916)"

This error can be encountered when connecting to either SQL 2005 or SQL 2008 databases using SQL...

I get \"SQL Server does not exist or access is denied\" error when I tried to connect to MS SQL database on your server?

  This error indicates that Enterprise Manager cannot make a connection the remote SQL...

How can I reduce my Database size Buy Truncating and Shrinking it?

For each transaction, the database create a log file, by over time, the high volume of database...

How can I migrate my data from MySQL to SQL Server?

Microsoft TechNet has an article specificaly for migrating MySQL databases to SQL Server. Follow...