Use System DSN


Can we make use of one System DSN on the connection string? Is there an example to that?
LVL 11
HuaMinChenBusiness AnalystAsked:
Who is Participating?
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
If you're using an AD Account then you can't provide an UID and PWD, since those fields are only for SQL Server logins.
For AD Accounts you'll need to use Trusted Connection or Integrated Security options (it will use the credentials of current logged user).
Barry CunneyCommented:
Hi HuaMinChen
The following is an example of basic connection string referencing System DSN:
HuaMinChenBusiness AnalystAuthor Commented:
What should be 'Uid' in above?
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Barry CunneyConnect With a Mentor Commented:
The 'Uid' should be the user name associated with the DSN

So if the DSN pointed to a SQL Server database, then the Uid would be the SQL Server user/login

Please let me know if this helps
The best reference to connection strings is here:
HuaMinChenBusiness AnalystAuthor Commented:
I put Windows account below (as database user and password is already System DSN)
but then it is not prompting me with the password (which I expect to happen).

As we're using Third-party report tool (called Ariacom), which is deploying web report using their DLL file, on IIS. It is depending on System DSN and is running fine within Win 2003 server. Now within Win 2008 server, how can I refer to relevant System DSN in above?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.