How to Create a System ODBC Data Source on Windows Server
Applies to: Windows Server 2019, 2022 and 2025, subject to vendor support.
A System DSN provides a named database connection to services and all users. Driver architecture must match the application.
Business application deployment must follow vendor licensing and backup requirements. Visit networkmanager.info.
Prerequisites
- Install supported ODBC driver.
- Know 32-bit or 64-bit requirement.
- Create least-privilege database login.
- Protect secrets.
Procedure
Step 1: List drivers
Review installed drivers.
Get-OdbcDriver | Select Name,Platform,VersionStep 2: Create DSN
Use integrated or separately protected authentication.
Add-OdbcDsn -Name 'CorpAppDB' -DsnType System -Platform '64-bit' -DriverName 'ODBC Driver 18 for SQL Server' -SetPropertyValue @('Server=sql01.corp.example','Database=CorpApp','Encrypt=Yes','TrustServerCertificate=No')Step 3: Inspect
Review properties.
Get-OdbcDsn -Name CorpAppDB -DsnType SystemStep 4: Test
Use the real service identity and application.
Step 5: Track driver lifecycle
Record version and update process.
Verification
Confirm DSN platform and driver.
Get-OdbcDsn -Name CorpAppDB -DsnType System | Format-ListRollback
Remove-OdbcDsn after restoring the previous application configuration.
Operational notes
Do not store database passwords in DSN properties.
Official references
Explore Netcloud24 Canada.
