Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Use System DSN

Posted on 2016-08-03
6
Medium Priority
?
106 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 11

Author Comment

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

Assisted Solution

by:Barry Cunney
Barry Cunney earned 450 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 43

Expert Comment

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

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 52

Accepted Solution

by:
Vitor Montalvão earned 1050 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This article is about my experience upgrading my consulting machine to Windows 10 Version 1709 (The Fall 2017 Creator Update)
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

972 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