CREATE LOGIN my20170403 WITH PASSWORD='pwd1'
alter login my20170403 ENABLE
alter login my20170403 WITH PASSWORD='mypwd'
alter login my20170403 WITH DEFAULT_DATABASE = mydb
create user my20170403 for login my20170403 with default_schema = [dbo]
to connect with sql management studio
also needs user in master database - because deafult database not there
No comments:
Post a Comment