topic Re: Unable to connect Geodatabase in Data Management Questions

Unable to connect Geodatabase

vijaybadugu — Tue, 28 Dec 2021 20:35:16 GMT

I am using ArcGIS Pro to connect SQL Server Geodatabse 2017. Just want to upgrade it latest version. for this sde user required to login to the sde connection. I forgot the password of sde user and changed in sql server. after that, i tried to connect to Geodatabase, I am getting below error. I am able to connect to other databases and able to create new enterprise database. How to troubleshoot the issue ?

Re: Unable to connect Geodatabase

George_Thompson — Tue, 28 Dec 2021 21:09:52 GMT

Have closed and re-opened ArcGIS Pro?

Does the password have special characters?

Re: Unable to connect Geodatabase

vijaybadugu — Tue, 28 Dec 2021 21:11:51 GMT

I reopened ArcGIS Pro. Nothing worked.

Password does not contain any special characters.

Re: Unable to connect Geodatabase

George_Thompson — Tue, 28 Dec 2021 21:12:22 GMT

Can you provide clarification for the "no"?

"no" to special characters or "no" to both?

Re: Unable to connect Geodatabase

vijaybadugu — Tue, 28 Dec 2021 21:13:20 GMT

I reopened ArcGIS Pro. Nothing worked.

Password does not contain any special characters.

Re: Unable to connect Geodatabase

George_Thompson — Tue, 28 Dec 2021 21:21:42 GMT

Ok, thanks for that.

What is the version of ArcGIS Pro?

You said that you can connect to other geodatabases on the same SQL Server 2017 instance, correct?

Can other DB users connect on that same EGDB?

Re: Unable to connect Geodatabase

vijaybadugu — Tue, 28 Dec 2021 21:23:09 GMT

What is the version of ArcGIS Pro? 2.9

You said that you can connect to other geodatabases on the same SQL Server 2017 instance, correct? Yes

Can other DB users connect on that same EGDB? No

Re: Unable to connect Geodatabase

George_Thompson — Wed, 29 Dec 2021 11:56:11 GMT

Ok, so can you connect via SSMS to the SQL Server DB using the SDE user credentials?

Re: Unable to connect Geodatabase

vijaybadugu — Wed, 29 Dec 2021 12:07:49 GMT

Yes . I’m able to connect from SSMS

Re: Unable to connect Geodatabase

George_Thompson — Wed, 29 Dec 2021 12:40:01 GMT

Have you restarted the machine (reboot) that ArcGIS Pro is installed on?

It may be best to work with Esri technical support on this issue.

Re: Unable to connect Geodatabase

vijaybadugu — Wed, 29 Dec 2021 12:44:37 GMT

I restarted the system. And created a case for it .

Re: Unable to connect Geodatabase

vijaybadugu — Wed, 29 Dec 2021 13:02:13 GMT

Is there any other alternative to create new enterprise database and copy existing one to new database ?

Re: Unable to connect Geodatabase

George_Thompson — Wed, 29 Dec 2021 13:51:50 GMT

Random question: Is this DB a restored one in SQL Server?

If so, was the name changed during the restore?

Re: Unable to connect Geodatabase

vijaybadugu — Wed, 29 Dec 2021 16:22:55 GMT

No.

Re: Unable to connect Geodatabase

DougGreen — Wed, 29 Dec 2021 18:02:26 GMT

Have you updated the password in the connection set up in your ArcGIS Pro project? Right-click > Connection Properties.