Ray K (1/4/2012)
Well, I tried it with the sa login. No dice; I'm getting the same thing.GilaMonster (1/4/2012)
Does the login 'UserName' exist?No; in fact, I'm trying to create it. This is what's generating the error.
If the login doesn't exist, you'll first need to create it with CREATE LOGIN, then switch to the specific DB and run CREATE USER ... FOR LOGIN ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability