Difference between System DSN and User DSN

01 February,2013 by Jack Vamvas

A regular question from application developers creating DSNs to connect to SQL Server database - what is the difference between a System DSN and User DSN ?



The quick answer is : A User DSN is available only to the user who created the DSN on the server  . A System DSN is available to all users on the server

 Notes :

 1)       SQL Server and IIS require System DSN

2)       You can use a DSN-less connection string and avoid creating a DSN

3)       Both system DSN and user DSN are stored in the System Registry


Read More

Excel Connect to SQL Server - SQL Server DBA

SQL Server - SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed

SQL Kill connections to a database

SQL Server - Login failed for user 'username'. The user is not associated with a trusted SQL Server connection
SQL Server - How to setup ODBC for IBM AS/400 - SQL Server DBA

Author: Jack Vamvas (http://www.sqlserver-dba.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on Difference between System DSN and User DSN

sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer