Creating new login on SQL server

hello,
I am facing problem to create a new login account on SQL server
which is on different domain.
Can any one help me out?
Thanks.It is OK if the domains have a trust relationship - if not you can't do it.
"Sushi" <sushi_20003@.yahoo.co.uk> wrote in message
news:8f9a3b2.0403142131.7a420e66@.posting.google.com...
> hello,
> I am facing problem to create a new login account on SQL server
> which is on different domain.
> Can any one help me out?
> Thanks.|||Hi,
Are you able to connect to SQL server using SQL server authentication, If
yes, then you will not have any problems in creating the login.
1. Connect to SQL Server using SA user
2. Use SP_ADDLOGIN (refer books online) to add the login
3. Use SP_ADDUSERS (refer books online) to add the user to database
4. Use SP_ADDROLEMEMBER to add the database role to that user.
Note:
If you are not able to connect to the SQL server,Check with system
administrator on Trust Relationship. If it is not created ask him to
create the Trust relationship and then perform the above steps to create
Login.
Thanks
Hari
MCDBA
"Sushi" <sushi_20003@.yahoo.co.uk> wrote in message
news:8f9a3b2.0403142131.7a420e66@.posting.google.com...
> hello,
> I am facing problem to create a new login account on SQL server
> which is on different domain.
> Can any one help me out?
> Thanks.