how to specify domain SLASH user in Query Analyzer when creating users and granting permissions

From: Timo (timo_at_nowhere.org)
Date: 01/30/04 

Date: Fri, 30 Jan 2004 08:45:21 -0500

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

Relevant Pages

  • RE: MELL and SQL
    ... At this point I'm logged in as admin and since ... have the necessary permissions for the installation. ... > Most third party apps don't use Windows Authentication, they use SQL ...
    (microsoft.public.windows.server.sbs)
  • Re: Using Windows Authentication
    ... Doug Steele, Microsoft Access MVP ... I can programmatically control their permissions. ... I'm using Access 2007, SQL Server 2005, Windows ... SQL is set up for Windows Authentication because my users already ...
    (microsoft.public.access.security)
  • RE: Help with database transfer
    ... if using windows authentication you just need to look at the users and roles ... by default sql will allow local admins on the box to have dbo priveledges on ... "David" wrote: ... > I am having permissions issues now. ...
    (microsoft.public.sqlserver.server)
  • Re: Hiding database objects
    ... I'm afraid that Enterprise Manager and Query Analyzer are not designed to ... can't deny any permissions to members of the sysadmin role, ...
    (microsoft.public.sqlserver.security)
  • Re: OWA Troubles
    ... I also have Integrated Windows Authentication selected. ... >> We recently put an intranet site on our IIS server that hosts OWA. ... so I'm sure its permissions that's causing the problem. ...
    (microsoft.public.exchange.admin)