Access to SQL Server 6.5 from Non-Standard-Domains with mixed security

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hello!

I have a problem with SQL-Server 6.5. I want to allow access for users to a database from a domain that is not the standard-domain in SQL-Server but trusts to the standard domain using integrated security. I didn't find a way in SQL Security Manager to add users or user groups from another Domain. SQL Server is configured for mixed security.

Thanks a lot for your help!

Noriko

-- Anonymous, April 23, 1999

Answers

Noriko,

In the SQL Server Books Online article titled, "Integrated Security", I find the following: If multiple SQL Server computers participate in a domain managed by a Windows NT Server, a single network login for each user is sufficient to enable access for all of the SQL Servers. For users defined on other domains, SQL Server provides map characters to map the domain name and username to a SQL Server login ID (for example, salesdomain_Chris). These map characters also provide a way to map Windows NT usernames that are not valid SQL Server login IDs to valid SQL Server login IDs.

This should get you started.

Good Luck,

Eric

-- Anonymous, April 26, 1999


Moderation questions? read the FAQ