MSSQL Error

[KidJB]

Error running Breezenet.sql that GigaToni released.

Msg 15007, Level 16, State 1, Line 2
'WZAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'wz_api_user' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'WOAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'BNAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'bn_api_user' is not a valid login or you do not have permission.

in warz.sql

Msg 15007, Level 16, State 1, Line 2
'WZAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'wz_api_user' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'bn_api_user' is not a valid login or you do not have permission.
Msg 15023, Level 16, State 1, Line 2
User, group, or role '##MS_PolicyEventProcessingLogin##' already exists in the current database.
Msg 15023, Level 16, State 1, Line 2
User, group, or role '##MS_AgentSigningCertificate##' already exists in the current database.

 

[Pepperosam]

Do you import the file with the right rights?

 

[GigaToni]

do you import the files in the right database and you have full permission?

because all are valid logins^^

 

[d4mn]

You need first to create logins which are missing.

WZAdmin
wz_api_user
WOAdmin
BNAdmin
bn_api_user

Logins can be inserted by selecting Security > Logins right mouse click New login in SQL Server Management Studio.
Authentification type must be SQL Authentification.

 

[DNC]

http://forum.ragezone.com/f789/database-logins-need-removed-backup-923268/
I've posted it over here a while ago.

Just the usernames and databases associated. Nice add for the "how of it". Thank you

Here are the list of database users that will need removed from any database backup uploaded and "recreated" in your own sql server. Then you'll need to modify the code and api's to match the database user passwords you come up with.
This is not to be addressed now. Only for reference shortly. Please, don't go replying in here just yet.

breezenet db uses following logins:
bn_api_user
BNAdmin
map_WOAdmin
map_wz_api_user
map_WAZdmin

warz db uses following logins:
map_bn_api_user
wz_api_user
WAZdmin


databases:
breezenet
warz