MS SQL - add a domain to create new users.

Community TechTalk
1

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.

2

You are wanting to use Active Directory domain, for SQL login, is this correct?

3

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

4

Mystery solved, my server was added to the Windows domain, it wasn’t there.

Thanks,
Richard

5

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