MS SQL - add a domain to create new users.

Discussion in 'TechTalk' started by richlion, Apr 25, 2008.

  1. richlion

    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.
  2. Stephen

    Stephen US Operations Staff Member

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

    richlion Guppy

    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. richlion

    richlion Guppy

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

    Thanks,
    Richard
  5. Stephen

    Stephen US Operations Staff Member

    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

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services