Developer Forum

In Query Analyzer I am trying to execute SPs creating logons and
granting permissions but the DOMAIN\USER format is illegal because
of the SLASH character. How do youreference a specific
domain\user in QA?

I'm trying to set up logons and object permissions for SQLServer
2000 in a mixed Windows Authentication / SQL Server Authentication
environment, using Windows Authentication. Specifically, I'm
trying to grant the built-in SERVERNAME\ASPNET user access to
certain databases and then grant it some object permissions. IIS
and SQL2000 are running on the same machine.

I'm working in Query Analyzer because the Enterprise Manager
dialogs seem to get confused when we pick users from the list
after having specified the domain: EM keeps displaying an error
like "{myusername} already exists", but the error message does not
give the domain\ chunk of the username. Is EM ignoring the domain
prefix? Is this a known bug?

Thanks for the help.
Timo

Timo,

Logins can have the slash, but users cannot. Once you have added the login,
just:

sp_grantdbaccess 'DOMAIN\USER' -- let the username default

Russell Fields

Try using [domain\username]

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.