Is there a possibility to create DSN (ODBC to SQL Server) using different Windows account than current coputer login account? I’m trying to create System DSN to SQL Server and I would like to create this connection using Windows authentication using my admin account. I’m creating this DSN using my normal windows account.
Sql-server – DSN, ODBC: How to create DSN using different windows account
dsnodbcsql serverwindows-xp
Related Topic
- Sql-server – How to get this SQL Server ODBC Connection working
- Sql-server – How to configure Windows user accounts for ODBC network with NT authentication
- Windows 7 – Unable to Create System DSN on 64-bit
- Sql-server – How to connect an ODBC DSN to nondefault SQL Server instance on default port
- Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator
- Sql-server – Problems connecting to SQL Server using ODBC
- Windows – Issues Programmatically Adding ODBC DSN to ODBC Administrator on Windows
Best Answer
A System DSN by definition applies to the entire computer irrespective of which logon account is used, so (if I'm reading your question right) that means that (1) the answer is "yes", and (2) you will need Admin rights to create the DSN.
Have you looked as DSN-less connections, by the way? I believe that they would be much more appropriate for your requirement, and would also remove the need for client configuration before your app could be used.