Creating a Generic SQL Server Connection String

If you are moving an SQL Server VB.NET project from machine-to-machine, (such as from home, to a lab, to a classroom) you need to have a generic connection string for your database.

Use this:

server=(local\NetSDK;Trusted_Connection=yes;database=Cottages)

where NetSDK is your INSTANCENAME and Cottages is your database name.