Re: SQL/User Account
From: RAJ (RAJ_at_discussions.microsoft.com)
Date: Fri, 16 Jul 2004 09:58:06 -0700
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 > > >