SQL Server direct connect issues with clients that also have SQL Server Compact Edition.

MichaelSmith1 — Wed, 01 Jul 2015 20:48:39 GMT

I am migrating an organization to enterprise geodatabases, there is a group of engineers that use AutoDesk AutoCAD 2015 with AutoTurn 2015. As far as I can tell, these apps use the SQL Server Compact Edition either 3.5 SP2 or 4.0.

When I do a direct connect with OS authentication I get an error, if I use a database account I don't.

More info:

I am using SQL Server 2012, and the 10.1 SP2 ArcGIS client. I create a new database connection, use the instance, choose OS authentication, and then try to get the database list.

Error message I get is:

Unable to connect to database server to retrieve database list; please verify your server name, user name, and password info and try again.

Underlying DMBS error [Microsoft SQL Server Native Client 11.0: Login failed for user <domain>\<username>. No extended error.]

If I have this same user try on a different machine without AutoCAD (and thus without SQL Server Compact Edition), it works fine - so it is not actually the user permissions. Also if I use a database account as a test, and not an OS account, that also work.

I have migrated several others with no issues, it is only these folks with AutoCAD and SQL Server Compact Edition.

Suggestions?

topic SQL Server direct connect issues with clients that also have SQL Server Compact Edition. in Geodatabase Questions

SQL Server direct connect issues with clients that also have SQL Server Compact Edition.