MS SQL - add a domain to create new users.

R

richlion

Guppy
Hi Everyone,

I am bit new with MS-SQL, usually I work with Oracle. I have a production and test server both with MS-SQL 2000. THe first one was set up to see my domains, the other one does not have that set up. And I need to create logins and users for my domain Windows users.
Where can I find some information how to make MS-SQL see the domain?
I've been googling for hours with any result. The best I would find was this page:
http://msdn2.microsoft.com/en-us/library/aa215680(SQL.80).aspx

Thanks in advance,
Richard.
 
You are wanting to use Active Directory domain, for SQL login, is this correct?
 
Hi Stephen,

to be honest, I don't know how this was set up, if we have a domain in AD like UK, users should have accounts like "UK\name.surname".
And they have "name.surname", that's what I see is set up in the database. But yes, we are in an Active Directory domain.

Thanks,
Richard
 
Good to know you got it fixed, I wasn't sure what to say. As it should work in the forum of domain\user even on a domain/ad network
 
You must log in or register to reply here.
Back
Top