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