Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Win 2K Server in a NT4 domain

    I'm having problems getting Win 2k recognising logins on a MS SQL 7 server from my NT4 domain.

    The Win 2k machine is part of the domain and allows me to login to it with NT authentication but when I come to add new users to the SQL Server it says it can't verify the user and will only let me setup local users.

    Any idea's anyone.

    Many thanks

    Phil

  2. #2
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: Win 2K Server in a NT4 domain

    Phil,
    Upon which machine does SQL Server reside? How is user authentication configured in SQL server?

    Joe
    Joe

  3. #3
    New Lounger
    Join Date
    Aug 2002
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Win 2K Server in a NT4 domain

    The SQL Server resides on Win 2K and is setup for NT Authentication. We are the SQL onto a more powerful server and Win 2K. We have managed to port all the existing users across but can't setup new ones as the Win 2K server doesn't recognise the NT authentication.

  4. #4
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Win 2K Server in a NT4 domain

    Okay, I have no experience with MS SQL 7...or any other version of SQL server, however, the first thing I would look at, is the service...the actualy SQL Server service. What account is it using to run as? Try setting your network Admin account as the account, as a test to see if that fixes things.

    There is also a hidden 'channel' that NT servers (and 2000 servers) use to communicate with each other. I think the program you use to check/reset that channel is NetDom. You may have to download it from Microsoft. If you can't find anything about netdom, let me know, and I'll go find the right command name.

  5. #5
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: Win 2K Server in a NT4 domain

    Phil.
    What are the service pack levels of Win2k, SQL server, & NT 4.0?

    Joe
    Joe

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •