[Solved] Error while doing user mapping in MSSQL: Create failed for User (Microsoft.SqlServer.Smo)

Axpert Web 11.x

Last Post by Axpert Support 2 years ago

2 Posts

2 Users

0 Reactions

412 Views

RSS

Posts: 2

pavithra

Topic starter

Jan 30, 2024 10:56 am

(@pavithra)

Active Member

Joined: 2 years ago

Issue: After restoring the axpert database in mssql, there is an error as shown below when mapping the db user login with the default database.

1 Reply

Posts: 602

Axpert Support

Admin

Jan 30, 2024 11:09 am

(@axpertsupport)

Honorable Member

Joined: 2 years ago

To resolve this issue, Run the below command on the restored database using SA login.
exec sp_change_users_login 'auto-fix', @userVar

2 Forums
18.2 K Topics
18.9 K Posts
2 Online
3,320 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

PLATFORM

RESOURCES

THE COMPANY

Agile Developer is designed for introducing, instructing and training of Axpert developers for ease of use of the product. Although tutorials, references, and examples are regularly checked for inconsistencies, we can guarantee that the content is sufficiently and entirely accurate to the best of our knowledge with exceptions. You agree to have reading our terms of use and accepting them before using Agile Developer.

Ask Axi

[Solved] Error while doing user mapping in MSSQL: Create failed for User (Microsoft.SqlServer.Smo)