the database principal <SID> does not exist

[Former Member]

Experts

I am doing a System Copy for my System which is based on SQL Server. When I am trying to the Source System Export proces, I am getting the following error.

4 ETW000 [dev trc ,00000] ExecuteAndFlush: line 6670. hr: 0x80040e14 Setuser failed because of one of the following reasons: the database principal 'BDA' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

4 ETW000 102 0.309609

4 ETW000 [dev trc ,00000] sloledb.cpp [ExecuteAndFlush,line 6670]: Error/Message: (err 15157, sev 0), Setuser failed because of one of the following reasons: the database principal 'BDA' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

4 ETW000 116 0.309725

4 ETW000 [dev trc ,00000] Procname: [ExecuteAndFlush - no proc] 32 0.309757

4 ETW000 [dev trc ,00000] setuser 'BDA' failed -- connect terminated 46 0.309803

4 ETW000 [dev trc ,00000] Mon Jan 31 11:18:48 2011 5422 0.315225

4 ETW000 [dev trc ,00000] failed to establish conn. 0 40 0.315265

4 ETW000 [dblink ,00433] ***LOG BY2=>sql error -1 performing CON [dblink#4 @ 433] 211 0.315476

4 ETW000 [dblink ,00433] ***LOG BY0=>Setuser failed because of one of the following reasons: the database principal 'BDA' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission. [dblink#4 @ 433]

Regards,

Mahesh

[clas_hortien · Accepted solution]

Hi,

the schema you are trying to use, must be in lower case letters. So please check the SAP profiles for dbs/mss/schema and set it to lowercase. Check the environment of the <sid>adm user and set MSSQL_SCHEMA to lowercase letters as well.

Regards

Clas

[Former Member]

Clas

Thanks for the Help. it helped me in resolving the issue. I also ran a SQL Server STL Tool ( Downloaded from market Place) which set all the requried variables and check the requiresemtns for the SQL Server.

Regards,

Mahesh Shetty