Question Locked

SQL Server User Error 15401 - How to work around it?

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I get this error message when I try and create a new user in MS SQL Server 2000 by attempting to create a new user with / in the SQL Server Enterprise Manager. I know that the domain name and username is valid.

ERROR 15401: Windows NT User or Group '/' not found. Check the name again.

Here is the setup:

I have Win 2K Server with MS SQL Server 2000 installed. That server is part of a standard group called WORKGROUP. However, it is not joined on any domain for security reasons (it is a web server).

I have a corporate network that is on a domain, .com. Is there a way to get the Win 2k box to at least recognize the domain without physically joining the domain tree through system properties settings?

I have scoured the net for a fix or how to's on configuration, but with little or no luck. Has anyone figured out a way around without joining the domain tree through other means other than through system properties settings?

Any ideas or workarounds?

-E

3 replies

by fred123456

Sorry but without some serious hacking you can not get the SQL server to validate Active Directory accounts without the machine being part of the Domain.

It sounds like SQL is installed on the same server as IIS. You should move SQL off and give it its own server. Then you can create the link between the web server, off the domain, and the SQL server on the domain.

Plus hosting the SQL server on the same box as the web server is just asking for trouble. If someone hacks the web server they then have direct access to the SQL server and your stored data.

by esalo

Thanks for the reply. I certainly appreciate your response.

What about SQL data cloning of specific tables of interest?

How secure would that be?

Thanks,

-E

This discussion is closed to new replies.