yujunjun/OpenMetadata
1
0
Fork 0
mirror of https://github.com/open-metadata/OpenMetadata.git synced 2025-07-07 17:18:23 +00:00
Code Issues Packages Projects Releases Wiki Activity
OpenMetadata/openmetadata-docs/content/v1.8.x-SNAPSHOT/connectors/database/mssql/troubleshoot.md
Pere Miquel Brull 34fbe5d64c
Docs - Prepare 1.7 docs and 1.8 snapshot (#20882) 
* DOCS - Prepare 1.7 Release and 1.8 SNAPSHOT

* DOCS - Prepare 1.7 Release and 1.8 SNAPSHOT
2025-04-18 12:12:17 +05:30

2.2 KiB
Raw Permalink Blame History

title slug
Troubleshooting for MSSQL /connectors/database/mssql/troubleshooting

{% partial file="/v1.8/connectors/troubleshooting.md" /%}

Resolving SQL Server Authentication Issue for Windows User

This guide addresses a common issue when connecting to a SQL Server instance using Windows OS. If you encounter the error below, follow the steps outlined to resolve it effectively.

Error Description

When attempting to connect to SQL Server using a Windows user, the following error appears:

(pyodbc.InterfaceError) ('28000', "[28000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Login failed for user 'domain\\user'. (18456)")

Additionally, the SQL Server logs display:

Login failed for user 'domain\user'. Reason: Attempting to use an NT account name with SQL Server Authentication.

Root Cause

The error occurs because the connection is configured to use SQL Server Authentication instead of Windows Authentication. Windows Authentication requires a connection scheme that supports integrated security.

Resolution

Step 1: Verify Connection Configuration

  1. Ensure that you are connecting to SQL Server using Windows Authentication.
  2. Update the connection scheme to use mssql+pymssql instead of mssql.pyodbc.

Step 2: Update the Connection Details in Collate

  1. Navigate to MSSQL Service Configuration in the Collate UI.
  2. Update the Connection Scheme to mssql+pymssql.
  3. Retain the following connection details:
    • Host and Port: e.g., 10.121.89.148:62452.
    • Database: Specify the target database (e.g., OneSumx_Stoging).
    • Username: Use the Windows account username, e.g., domain\user.
  4. Save the updated configuration.

Step 3: Test the Connection

  1. After saving the changes, click Test Connection in the Collate UI.
  2. Confirm that the following steps pass successfully:
    • CheckAccess
    • GetDatabases
    • GetSchemas
    • GetTables
    • GetViews
    • GetQueries

Expected Outcome

After updating the connection scheme, the connection should succeed. The status will display:

Connection Status: Success