gauravflame
asked on
Account
How to create a Trusted User account in SQL Server ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
user somedbname
-- somedbname is sqlserver
-- somedbname is sqlserver
sorry, mean to write:
use somedbname
somedbname should be replace w/ the name of your database
use somedbname
somedbname should be replace w/ the name of your database
ASKER
getting syntax error for
user somedbname
user somedbname
remove the r from user, and replace somedbname w/ the name of a database on your machine.
create login [domain\username] from windows
go
user somedbname
go
create user someusername for login [domain\username]