When i attempt to make a connection to a database on my SQL Server 2014 sever via Database connections in ArcCatalog using with db authentication i get

"Connection was attempted with an older version of SQL Server Client...."

error message. However this is incorrect as the client is up to date. I download and re-installed the 2014 Client.

Also when i use "OS Authentication" i can connect just fine.

ArcGIS 10.3, ArcGIS for Server 10.3, SQL Server 2014.

The account in question is not a account in our AD (active directory) just and account in the db resolved.

  • 1
  • 1
    Make sure you have Service Pack 1 installed for your SQL 2012 client. – Radar Jul 29 '15 at 16:35
  • @NickO download and install the latest service pack which i guess in now SP2 (msdn.microsoft.com/en-us/library/ms131321(v=sql.120).aspx) but still no dice. – Randall Jul 29 '15 at 17:04
  • 1
    What version of the native client did you install? I think you have to use the 32 bit version of the SQL Server native client for ArcGIS Desktop, even if your workstation is 64 bit. I just use the version of the SQL Server native client that came with the ArcGIS installer. Also make sure your database is set to allow mixed mode authentication. Finally ArcGIS Server requires the 64bit version of the native client. Again use the native client that comes with the software download, it includes both versions of the client.32 and 64 bit. – Dowlers Jul 30 '15 at 5:06
  • @Dowlers 64bit. i will try the 32bit – Randall Jul 30 '15 at 15:36

It was the ODBC driver 11 for SQL Server that was missing. It seems that the drivers are the SQL Native Client

  • consider marking your own answer. – Farid Cheraghi Oct 9 '15 at 18:19
  • 1
    @FaridCher. Done. i think. Still figuring out how to properly use stackexchange. – Randall Oct 9 '15 at 21:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.