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; } } }

can't register database

KirstenLawrence

I am trying to register an sde database that I have stored on the same machine arcgis sever 10.1 is installed on. I am running 64 bit sql server express. This is the error I get:

Machine: xyz [database: The connection property set was missing a required property or the property value was unrecognized. Bad login user]

I am trying to add the database using operating system authentication.

can anyone help? thanks!

Vind meer berichten getagd met

Accepted answers

All comments

KirstenLawrence

i figured it out i needed to give permission to the ags account

BeckyCarr

I am having the EXACT SAME message with same versions of software, etc. However, my database HAS proper permissions to ags. Any other suggestions? Thanks.

AmyBrassieur

Having the same problem. Going in circles. Would pay for someone to remote into my computer and talk me through what has to happen for this to work.

I'm not a DBA, faking my way through SQL permissions.

error message.jpg

KimPeter

Did you install the DBMS client on the ArcGIS Server machine?

If so, and your ArcGIS administrator account has been added to your SQL Server instance and databases but you still get this message, check to make sure that the ArcGIS Server service is not running under the Windows "local service" account.

YungKaiChin

Having the same problem. Going in circles. Would pay for someone to remote into my computer and talk me through what has to happen for this to work.

I'm not a DBA, faking my way through SQL permissions.

You probably need to setup a database account that can be used by ArcGIS server.

AmyBrassieur

Thanks for the tips! I fumbled my way through SQL users and roles and got it to work.

Thanks!

Amy Brassieur

SolomonPulapkura3_2-1646700247564.png

CarlBrydon

Hi Amy, I'm having the same problem. Are you able to share which SQL users and roles you changed and/or updated to get things working?

CarlBrydon

Hi Kristen - where did you give permission to the ags account? In SQL Server, or on the geodatabase in ArcCatalog?

The permissions I've set for SQLEXPRESS are...

agsadmin - server roles are public and sysadmin

Permissiosn on the geodatabase in SQLEXPRESS are..

Owned Schemas - agsadmin

Role Members are db_datareader, db_datawriter, db_owner

I also checked on ESRIAdmin, ESRIReadData, and ESRIWriteData just to see if that would help, but it didn't.

In ArcCatalog, I have the asgadmin user as a server administrator on SQLEXPRESS.

Is there anywhere else I should be checking?

ChaseWetzel

Carl,

Did you ever figure this problem out?

AitorCalero_García

I faced the same problem and the solution is to add the user that starts the ArcGIS Server service to the SQL Database. Say that .\arcgis is the ArcGIS Service user that is shown in the services window (services.msc command). You have to add this same user to the SQLGeodatabase.

To do this you only need to execute the "Add User" tool. This tool either in the toolbox, or right click in the geodatabase\Administration\Add user. There you have to put NameOfYourServer\arcgis as the user to create. In my case was like this:

ClintonMcFall1

One other thing to take into account, if you are running a multi-machine site make sure that the SQL Native Client is installed on both machines. If you do it on one but not the other, it will error out with this message.

JonathanClayton2

I'm running into this same error message, and I'm sure it's just user error on my part. We have 10.5 desktop on our local machine, arcgis server (enterprise) basic on a 2016 server, and our sde database is sitting on another server(2008). I have 2012 Server Client installed on my computer. Where am I going wrong...btw I am no DBA...just fumbling through it.

CarlosPires1

I had exactly the same problem, despite the arcgis account already been a database user.

I solved this issue by installing the Microsoft® ODBC Driver 11 for SQL Server, avaible in http://www.microsoft.com/en-us/download/details.aspx?id=36434.

I found this tip at Unable to register gdb with the server due to sql server client incompatibility - Geographic Information Systems Stack E…

JonathanDandois

I recently had a similar issue and got here through googling. Our IT needed to change the architecture of our DBs and this resulted in a change the SDE DB Server host name (not the DB name). I was able to get my regular SDE connections in Pro and other maps working fine with a quick host change, but I couldn't get the Data Store to update on my Portal site. I created a new SDE connection file with the new host and every time I imported I got a error like this. The SQL DB had my the correct Server Service AGS user, but it turned out the new DB Server did not have that user. Adding that user to the DB server (along with the DB) solved the problem for me. Just wanted to drop this in here for anyone else that might get here with a related problem. xkcd: Wisdom of the Ancients

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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