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