Saturday, 14 September 2013

Enough permitions to login a created user

Enough permitions to login a created user

Every time Im launching SQL server I always run script that destroys my
little local base,refills it with exaple data, destroys some logins that
was artificially created using this script.
exec sp_addlogin @loginame = 'strong', @passwd ='strong', @defdb
=KornDurnDB_new;
exec sp_adduser @loginame = 'strong', @name_in_db = 'strng';
To this login Im gives ALL grants. But It is not enough to authorize using
this login, when sql management studio launches(sql management studio
returns me error 18456)
What can a add to make a login with that account and password?

No comments:

Post a Comment