MS SQL connection string

Use current user’s identity:

Server=MyServer;Database=MyDBName;Connection Timeout=180;Application Name=MyAppName;Integrated Security=true

With a DB user:

Server=MyServer;Database=MyDBName;Connection Timeout=180;Application Name=MyAppName;uid=myuserName;pwd=myPassword

The Application Name value is mainly for tracking purpose.

Advertisements
This entry was posted in SQL and tagged . Bookmark the permalink.

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