Did you remember to add yourself & the account the sqlexecutive service is
running to the sqladmins group, and then log off/log back on?
Richard Waymire, MCT, MCSE, MVP (SQLServer)
Principal Engineer, ARIS Corp.
President, Pacific NW SQLServer Users Group (http://www.pnwssug.org)
Visit us at http://www.aris.com
> I too, experienced this very frustrating aspect of Security Manager. In
> the NT global group that I created I named SQL Admins as well. When I
> SA privileges from the Administrator group, SQL locked me completely out
> Enterprise Manager and Security Manager. I had to restore the Master
> previous backup, which has now created a whole new set of unresolved
> Lorena Vajda
> Systems Engineer, DoD Health Affiars
> > This may be dumb but some of my security changes didn't take effect
> > rebooted the server. Especially the change from Integrated to
> > Tom
> > >I'm using SQL 6.5 and decided to change from standard security to
> > >integrated security. I made a Group called SQL Admins with
> > >accounts in it, and added that to security manger then revoked
> > >Administrators from security mgr. Since I've made the change I've not
> > >able to connect in security manger. Also, I can't change the security
> > >SQL Enterprise mgr conifguration either.
> > >Thanks for any help.
> > >Dave Harris