on 03-12-2004 2:13 PM
hello,
I have restored a database backup from another server. I can find and select the restored company when I login however the DI cannot find the new restored company using the "GetCompanyList" method.
anyone has experience with this? why GetCompanyList does not list the restored company?
thanks
Marcos
Hi, I have had the same problem, i have resolved the problem with enterprise manager :
1) Open Enterprise Manager and open the DB that you don't see in Choose from list
2) select user menu
3) select the obscommon user and delete it
4) right click in the user windows .. new db user
5) select OBSCommon and ensure permission public and db_owner are selected.
good luck
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Marcos,
this is due to SQL SERVER 2000 restore procedure. Sqlserver does not create the same database users during the restore process. check and correct your user table (compare with original database) and it all will work again.
HTH Lutz Morrien
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.