Link to home
Create AccountLog in
Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America

asked on

sql error 5001 User must be in the master database

I moved a database from a 2008 r2 sql server to a 2016 sql server.   2016 sql server is running the database in sql 2008 compatibility.   the user setup looks right to me... ie.. the sql users configured to access the database from the app.  Some of the app features work using the new database location.  One feature that doesn't work is searching for a record by its unique id.  when i try this function, i receive the following error.  

 5001 which translates to "user must be in the master database.  

For a test, i gave the user sys admin rights and i still get the same result.  Any ideas?

SOLUTION
Avatar of lcohan
lcohan
Flag of Canada image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ASKER CERTIFIED SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account