1

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.

Farid Cheraghi
8,7891 gold badge25 silver badges55 bronze badges
asked Jul 29, 2015 at 16:28
7
  • 1
    support.esri.com/en/knowledgebase/techarticles/detail/37287 Commented Jul 29, 2015 at 16:32
  • 1
    Make sure you have Service Pack 1 installed for your SQL 2012 client. Commented Jul 29, 2015 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. Commented Jul 29, 2015 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. Commented Jul 30, 2015 at 5:06
  • @Dowlers 64bit. i will try the 32bit Commented Jul 30, 2015 at 15:36

1 Answer 1

4

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

answered Oct 9, 2015 at 16:09
2
  • consider marking your own answer. Commented Oct 9, 2015 at 18:19
  • 1
    @FaridCher. Done. i think. Still figuring out how to properly use stackexchange. Commented Oct 9, 2015 at 21:47

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.