This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

SQL Server Permissions

Question
0

Sign in to vote

Hi All

I have a problem which I've not seen before.

At a particular site, the security permissions on the SQL server are being wiped.

It's a Server 2008 R2 OS with SQL 2008 R2 SP1 CU6 and ConfigMgr 2012 SP1 installed.

After I install SQL 2008 R2, I have verified everything was OK, installed ConfigMgr - no problems.

Later on (days/weeks) I notice odd behaviour in ConfigMgr - during troubleshooting I realise in SQL Management Studio my access is no longer. My account has very limited rights and the Groups which were added during the initial installation of SQL are also gone.

I suspect it's something external at this particular site but I have no way of proving it. This is the second time it's happened. I've implemented ConfigMgr well over a dozen times now, never have I encountered anything like this.

How can I determine what is causing these permissions to be nuked?

Thursday, July 25, 2013 5:34 AM

All replies

0

Sign in to vote

Any chance that you are using a trial version of ConfigMgr. It will remove all perissions after the trial period, but that's logged to the event log.
Torsten Meringer | http://www.mssccmfaq.de

Thursday, July 25, 2013 7:00 AM
0

Sign in to vote

Any chance that you are using a trial version of ConfigMgr. It will remove all perissions after the trial period, but that's logged to the event log.

Torsten Meringer | http://www.mssccmfaq.de

Nope, it's the full version. I saw the client downloaded it from their Volume License portal.

Thursday, July 25, 2013 11:21 AM
0

Sign in to vote

Have you asked the DBAs? DBAs have had basic security concepts drilled into their heads and are notorious for doing things like this.

As for auditing SQL permissions, that's a great question for a SQL Serve forum.
Jason | http://blog.configmgrftw.com

Thursday, July 25, 2013 1:53 PM