Re: SQL/User Account

From: RAJ (RAJ_at_discussions.microsoft.com)
Date: 07/19/04 

Date: Mon, 19 Jul 2004 10:33:02 -0700

O yeah, it seems the logs don't actually indicate any errors. It list the various database & services starting up... 

-- 
RAJ
"Richard Waymire [MSFT]" wrote:
> What's the error you get?  What is in the SQL Server errorlog at \program 
> files\microsoft sql server\mssql\log\errorlog. ?
> 
> -- 
> Richard Waymire, MCSE, MCDBA
> 
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "RAJ" <RAJ@discussions.microsoft.com> wrote in message 
> news:090052B9-59E9-4AF6-AE15-1494AF67B09E@microsoft.com...
> > I've used SEM to grant a Windows user account (Bob) system admin rights to 
> > sql.  I mimicked the settings of the Builtin/administrator account to the 
> > "Bob" SQL user account.  How ever when I log on to the server using the 
> > "Bob" user account SQL doesn't start up.  I've followed the directions 
> > indicated in the "Adding a SQL Server Login" in SQL Server Books Online, 
> > but still no go.
> > -- 
> > RAJ
> >
> >
> > "Richard Waymire [MSFT]" wrote:
> >
> >> yes, setup and enterprise manager with both grant the correct rights if 
> >> you
> >> select an ordinary account to run the SQL Server services under.  Also
> >> review http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811 
> >> for
> >> details...
> >>
> >> -- 
> >> Richard Waymire, MCSE, MCDBA
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no 
> >> rights.
> >> "RAJ" <RAJ@discussions.microsoft.com> wrote in message
> >> news:3F931FDD-88E5-47D8-906D-6D4DED6F2CB2@microsoft.com...
> >> > Hello,
> >> > Is there any way to get SQL to run under a user account; user 
> >> > permissions?
> >> > I've setup a SQL server however SQL will only run when I login as
> >> > "Administrator."  My objective is to login w/ user permissions & have 
> >> > SQL
> >> > up & running for security reasons.
> >> > -- 
> >> > RAJ
> >>
> >>
> >> 
> 
> 
>

Relevant Pages

  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... Product Installation Status ... SQL Express Features: ... I don't even know if I need this SQL Server and I ... account password, invalid user account, user account does not have ...
    (microsoft.public.windowsupdate)
  • Re: SQL/User Account
    ... "Richard Waymire " wrote: ... > This posting is provided "AS IS" with no warranties, and confers no rights. ... SQL Server Service Manager indicated SQL was ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server user account
    ... We have not yet deployed any SQL dbs, ... the online docs say that the user account needs read/write ... >>a user account for SQL Server to use. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL/User Account
    ... All in all it seems I'll be able to remove the built in admin account now. ... What is in the SQL Server errorlog at \program ... >> I've used SEM to grant a Windows user account system admin rights to ... >> indicated in the "Adding a SQL Server Login" in SQL Server Books Online, ...
    (microsoft.public.sqlserver.security)
  • Re: Implementing row-level security (SQL/AD)
    ... (This has been implemented in both Access and for SQL ... >>> User account details are entered into a form and then I use a stored ... >>> the current database role and gets the current user's employeeid ... >>> The link between the login and an employee record is the hurdle I ...
    (comp.databases.ms-access)