Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Creating login in sql 7 on windows 2000

Author  Topic 

Eve
Starting Member

4 Posts

Posted - 2002-09-26 : 09:41:32
Hi

My platform is mainly windows nt4 server with two windows 2000 member servers. We recently acquired a higher spec machine to replace the old sql 7 server that is on windows NT4 box. The new server is a windows 2000 box and I have installed sql 7 on it.

The problem is when I try to create a new login it does not give me the option to select my domain. When I select new login and go for windows nt4 authentication the drop arrow for Domain only has the server name and not the domain name. If I manually input the domain name it rejects it.

I do not have Active Directory or a local dns server running on my network as we have no intention of migrating to Win2000 until next year. Our internet service provider handles our dns issues.

Is it not possible to install sql7 on win2k box.

Thanks
Eve



Eve

davy_boy2000
Starting Member

28 Posts

Posted - 2002-09-30 : 05:38:34
When you are adding the users do you type the user name as follows:
<domain>\<username>?

This should automatically fill in the domain name for you.

Go to Top of Page
   

- Advertisement -