How to Configure MS SQL Server for Testing with Visual Studio

When setting up MS SQL Server for test projects with Visual Studio I generally  stumble across the following problems only:

  • Use SQL Server Express or Developer Edition?
  • Enabling remote access
  • What are the default database instance names

With Oracle I have a little more trouble. See How to Configure Oracle for Testing with Visual Studio

Use SQL Server Express or Developer Edition

For testing it is OK to install SQL Server on a development Workstation – in case you don’t want to test things like real-world performance. I hope the service pack install problems with Express edition and Developer Edition installed on one machine are solved. I recommend always installing Express Edition, because it is cumbersome to tell AppFabric to use the Developer Edition instead of Express. Install

Enable SQL Server Remote Connections

To enable remotely connection to an SQL Server:

  • Computers should be in same Workgroup or Domain
  • On SQL Server machine:

Default Database Instance Names

Because it is cumbersome to wait for the connect timeout when entering the wrong name or browsing, it is good to know how to connect to the SQL Sever default instances.

To connect to the default database instance on the local machine use:

  • Developer Edition: (local)
  • Express Edition: localhost\SQLExpress or .\SQLExpress

About Peter Meinl

IT Consultant
This entry was posted in Computers and Internet and tagged , , , . Bookmark the permalink.

One Response to How to Configure MS SQL Server for Testing with Visual Studio

  1. kiquenet says:

    Suggestions: Powershell script for configure it

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s