ODBC not working with domain users

_{Thursday, November 19, 2015 8:06 AM}

Dear members,

we have purchased an ERP system from a vendor which uses system DSN for all the reports. The system automatically creates DSN with Sa with SQL Server. The problem is the DSN is not working with AD users.

Active Directory server: Windows Server 2008 32 Bit.

SQL Server: Windows Server 2012 64 Bit. This server is already member of my Domain. e.g. CompDomain.com

What should I need to do in client PCs or Server to avail ODBC to AD users.

Br,

Bhavin.

_{Friday, November 20, 2015 7:36 AM ✅Answered | 2 votes}

When you create the odbc entry it has to be system instead of user so the credentials are carried over unless your users have individual logins to the database server. And ensure tcp/ip is enabled on the server, can also try with other protocol.

_{Thursday, November 19, 2015 8:18 AM}

you can find a similar thread 

https://social.technet.microsoft.com/forums/windowsserver/en-US/99ab1e86-f928-4bfb-ba70-8e67e1720cf5/odbc-system-data-sources-not-working-for-domain-users

_{Friday, November 20, 2015 6:23 AM}

Use System DSN.

You can always configure your ODBC driver to authenticate with sa user instead of AD user.

What ERP system? Should you check with your ERP vendor as well?

chanmm

Please mark an answer if this idea help.

chanmm