Re: MSDE - Setting up security

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Greg Low [MVP] (greglow_at_lowell.com.au)
Date: 09/08/04 

Date: Wed, 8 Sep 2004 16:13:30 +1000

Hi Jan,

There's a tool at our site (MSDE Manager) that's free for personal use.
It'll help you do all these sorts of things.

HTH, 

-- 
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Jan F" <JanF@discussions.microsoft.com> wrote in message 
news:7F184178-D650-4B0B-9BD1-A1DE4C12FD44@microsoft.com...
>I am just missing the big picture. I am having some problems that I think I
> can correct by entering sp_grantlogin to grant a login to the SQL Server 
> and
> sp_adduser to add a user to the database.
>
> I have no idea where these commands go. What tool/process am I using to 
> get
> the commands into MSDE to change the security? I tried cranking up OSSQL 
> but
> it just kept showing me the list of commands.
>
> Sorry to be dumb.
>

Relevant Pages

  • Re: MSDE
    ... We have a program called MSDE Manager that's free for personal use. ... Greg Low [MVP] ... MSDE Manager SQL Tools ...
    (microsoft.public.sqlserver.msde)
  • Re: Client tools licensing question
    ... "Jake" wrote in message ... >> Greg Low ... >> MSDE Manager SQL Tools ...
    (microsoft.public.sqlserver.msde)
  • Re: SQL App. to access db remotely
    ... We've also got a free personal edition of MSDE Manager on our site. ... MSDE Manager SQL Tools ... "Dustin" wrote in message ...
    (microsoft.public.sqlserver.tools)
  • Re: HOW DO YOU USE MSDE?? HELP NEEDED.
    ... you might want to try our free personal tool MSDE Manager. ... MSDE Manager SQL Tools ... I was in DOS. ...
    (microsoft.public.sqlserver.msde)
  • Re: granting permission to ASPNET user
    ... just download an eval version of MSDE Manager from my ... HTH, ... MSDE Manager SQL Tools ...
    (microsoft.public.sqlserver.msde)