topic Re: can't register database in ArcGIS Enterprise Questions

can't register database

KirstenLawrence — Wed, 22 May 2013 19:54:21 GMT

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: XXXX [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!

Re: can't register database

KirstenLawrence — Wed, 22 May 2013 22:00:01 GMT

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

Re: can't register database

BeckyCarr — Thu, 01 Aug 2013 13:15:53 GMT

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.

Re: can't register database

AmyBrassieur — Mon, 26 Aug 2013 18:50:09 GMT

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.

Re: can't register database

KimPeter — Mon, 26 Aug 2013 21:33:07 GMT

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.

Re: can't register database

YungKaiChin — Fri, 30 Aug 2013 22:38:05 GMT

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.

Re: can't register database

AmyBrassieur — Tue, 01 Oct 2013 18:21:28 GMT

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

Thanks!

Amy Brassieur

Re: can't register database

CarlBrydon — Wed, 22 Apr 2015 18:45:32 GMT

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?

Re: can't register database

CarlBrydon — Thu, 23 Apr 2015 13:06:05 GMT

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?

Re: can't register database

ChaseWetzel — Mon, 08 Jun 2015 18:20:37 GMT

Carl,

Did you ever figure this problem out?

Re: can't register database

AitorCalero_García — Thu, 20 Aug 2015 10:32:08 GMT

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:

Re: can't register database

ClintonMcFall1 — Thu, 23 Feb 2017 18:30:02 GMT

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.

Re: can't register database

JonathanClayton2 — Thu, 29 Jun 2017 20:18:17 GMT

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.

Re: can't register database

CarlosPires1 — Thu, 20 Jul 2017 14:33:29 GMT

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…

Re: can't register database

JonathanDandois — Wed, 21 Aug 2019 13:02:11 GMT

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