Solved

Use System DSN

Posted on 2016-08-03
6
87 Views
Last Modified: 2016-08-18
Hi,

Can we make use of one System DSN on the connection string? Is there an example to that?
0
Comment
Question by:HuaMinChen
6 Comments
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 41740330
Hi HuaMinChen
The following is an example of basic connection string referencing System DSN:
DSN=myDsn;Uid=myUsername;Pwd=;
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 41740339
What should be 'Uid' in above?
0
 
LVL 17

Assisted Solution

by:Barry Cunney
Barry Cunney earned 150 total points
ID: 41740349
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
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 41

Expert Comment

by:pcelba
ID: 41740453
The best reference to connection strings is here: http://www.connectionstrings.com/
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 41741683
Barry,
I put Windows account below (as database user and password is already System DSN)
6a.png
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?
0
 
LVL 47

Accepted Solution

by:
Vitor Montalvão earned 350 total points
ID: 41742511
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).
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Viewers will learn how the fundamental information of how to create a table.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question