We help IT Professionals succeed at work.

SQL Server 2000 to 2005

584 Views
Last Modified: 2008-09-17
i have to genrate a Store procedures script from SQL sever 2000 when i try to execute these script on Sql Server 2005 it gives the following Error "Msg 15157,Setuser failed because of one of the following reasons: the database principal 'nust' 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.
"
Comment
Watch Question

CERTIFIED EXPERT
Awarded 2008
Awarded 2008
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
mazher_yasinManager Web Services

Author

Commented:
user is there but now it show the access denied some store procedure are creeate with the user "dbo" and the remaining one with theuser "mike" but the store procedure with the user "mike" fail to create with the script  access denied error.
CERTIFIED EXPERT
Awarded 2008
Awarded 2008

Commented:
huh?
thiyagukTech Lead
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.