SQL Connectionstring

Reporting, Environmental variables and SQL configurations can all be configured with one easy connectionstring. The string below is the most common, optional items that are often added are shown below.

Data Source=SERVERNAME;Initial Catalog=DATABASENAME;Provider=SQLNCLI10.1;Integrated Security=SSPI;

User Id=USER
Password=Password

Secondly there is a very handy way to build a connectionstring.
1. Create .txt file on your desktop
2. Rename the file to .udl
3. Enter connection details & save
4. Open file with notepad, and there is your connectionstring!