topic Re: Cannot Connect to SDE when I Running Post Installation using SQL Sever Backup Fil in Data Management Questions

Cannot Connect to SDE when I Running Post Installation using SQL Sever Backup Files.

Anonymous User — Mon, 03 May 2010 01:21:20 GMT

Original User: arya

Dear All

I have some problem using the SDE here my Story :

First I backup the SDE form my SQL data base using built in feature in SQL Server, and i create a file called xxx.bak, after that i install new sde databease on other computer/server.
I restore the xxx.bak to new server and do a post installation in SDE, before that i already assign teh SDE user to DB Owner and SDE Schema owner.

My problem is, when i create new USER (just view, SELECT) , is always return "Insufficient Connection". but for SDE user (ADMIN) work fine.

Please help why is this..??
Thanks

Re: Cannot Connect to SDE when I Running Post Installation using SQL Sever Backup Fil

Anonymous User — Mon, 03 May 2010 13:51:27 GMT

Original User: vangelo

Make sure your userid/loginids match -- see http://forums.esri.com/Thread.asp?c=158&f=2290&t=236645
or search on sp_change_users_login

- V

Re: Cannot Connect to SDE when I Running Post Installation using SQL Sever Backup Fil

Anonymous User — Fri, 10 Dec 2021 22:45:24 GMT

Original User: arya

Thank for reply Van,

I Have Try the step mentioned, I`m using this query

use sde
go
EXEC sp_change_users_login 'Auto_Fix', 'sde',null, '12345'
go

and result

The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.

and i try connect to my SDE and still have problem, and why return 0 user.??

Re: Cannot Connect to SDE when I Running Post Installation using SQL Sever Backup Fil

AlexeyTereshenkov — Mon, 10 May 2010 06:41:08 GMT

Hi,

Would using another option - update - help?

exec sp_change_users_login 'update_one', 'sde', 'sde'