Re: SQL Express setup -- what's my username - from a Newbie

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wilf (wilf.ratzburg_at_gmail.com)
Date: 10/29/04 

Date: 29 Oct 2004 09:41:43 -0700

Dana, your response got my brain working, and i think I've figured out
my 'username'... but now, when i run

SQLCMD.exe -S (local)\SQLExpress -E

AND THEN

> EXEC sp_grantlogin '[machineName]\[userName]'
> GO

I get the following message:

Cannot grant, deny, or revoke permission to owner, dbo,
information_schema, ... or yourself.

Where do I go from here?

Thanks,
Wilf
================================

"Dana Brash" <dbrash@gmail.com> wrote in message news:<eHq$yu#uEHA.3376@TK2MSFTNGP09.phx.gbl>...
> If you install SQL Express (or install another instance) using the GUI
> install, you can clear the 'hide advanced options' tick box and make
> authentication selections (Windows Authentication/Mixed Mode), set the sa
> password, etc.
>
> You are apparently connecting to your instance somehow if you're attempting
> to run an EXEC command. What username are you using to connect?
>
> I installed in Mixedmode
> Logged with admin rights, I can connect like this:
>
> C:\Documents and Settings\######>sqlcmd -S <systemNETBIOSname>\SQLEXPRESS
> 1>
>
> or like this (because I set my sa password):
>
> C:\Documents and Settings\######>sqlcmd -S <systemNETBIOSname>\SQLEXPRESS -U
> sa
> Password:
> 1>
>
> once logged in, I can:
>
> 1> EXEC sp_grantlogin '<NETBIOSdomainname>\<username>'
> 2> go
>
> and this completes successfully.
>
>
> --
> HTH,
> =d=
>
>
> Dana Brash
> MCSE, MCDBA, MCSA
>
> dbrash@NOSPAM.gmail.com
>
> >> > ====================

Relevant Pages

  • Re: Bypassing permissions
    ... >> Dana wrote: ... >> unemployment and/or prosecution. ... Ease of support: standard configurations make it a lot quicker to fix ... "no-one except IT support may install any software on any machine ...". ...
    (comp.os.ms-windows.nt.admin.security)
  • Re: ?? "Access is Denied" during USB Driver Installation
    ... then "applied" to reset folder; BUT when I go back and check later, ... Step 2 of the install still does not work. ... > Hi Dana, ... >> so I know the driver files should be OK. ...
    (microsoft.public.windowsxp.basics)
  • Re: ?? "Access is Denied" during USB Driver Installation
    ... then "applied" to reset folder; BUT when I go back and check later, ... Step 2 of the install still does not work. ... > Hi Dana, ... >> so I know the driver files should be OK. ...
    (microsoft.public.windowsxp.basics)
  • Re: Where do updates download to?
    ... I'm planning to install it eventually, I just can't at this moment ... Dana ... > eventually cease, in the meantime the easiest way: ...
    (microsoft.public.windowsupdate)