Hey all,
I am making a new script to add a user to our database. I have so far written this.
EXEC sp_addlogin @loginame = 'TESTER'
,@passwd = 'pwd'
, @defdb = 'BBS TEST'
, @deflanguage = 'British English'
EXEC sp_adduser @loginame = 'TESTER'
,@name_in_db = 'TESTER'
, @grpname = 'BBSUSER'
Ok - well a new user appears, and its a member of BBSUser but....
If i then go onto this user using EM, goto database access then to BBSTest I get an error of
"The name TESTER was not found in the users collection. If the name is a qualified name, use [] to separate the various parts and try again"
Any ideas?
Dan