nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Database connection fails when using db authentication, succeeds using OS

RandallClark2

Hi All,

When i attempt to make a connection to a database on my SQL 2014 sever via Database connections in ArcCatalog using with db authentication i get the lovely "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.

Any thoughts?

ArcGIS 10.3, ArcGIS for Server 10.3, SQL 2014.

Edit:

The account in question is not a account in our AD just and account in the db

Edit 2:

here is the link where i got the latest version of SQL Native Client (Installing SQL Server Native Client)

Najděte více příspěvků označených jako

Accepted answers

Anonymous User

Hi Randall,

Is the OS user who can connect a member of the sysadmin server role?

If you right click on the database connection and choose properties and then the connections tab is this geodatabase currently accepting connections?

Was this database recently restored from a backup?

Are both the SQL Server Native Client and Microsoft ODBC driver 11 for SQL Server installed?

All comments

JakeSkinner

Hi Randall,

Is your SQL Server instance configured to use Mixed-mode Authentication? You can check this by right-clicking on the instance in SQL Server Management Studio > Properties > Security. Ex:

RandallClark2

Hi jake,

Yes it is set up for mixed-mode authentication.

Anonymous User

Hi Randall,

Is the OS user who can connect a member of the sysadmin server role?

If you right click on the database connection and choose properties and then the connections tab is this geodatabase currently accepting connections?

Was this database recently restored from a backup?

Are both the SQL Server Native Client and Microsoft ODBC driver 11 for SQL Server installed?

RandallClark2

Are both the SQL Server Native Client and Microsoft ODBC driver 11 for SQL Server installed?

No the ODBC driver was not, Once i had that installed i was able to connect using both db authentication and OS authentication.

So i am assuming that both the native client and the ODBC drivers are needed then?

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.