SQL 2008 Express permissions issues

Hi all,

I have a remote server server running Windows 2008 standard with SQL 2008 express.

My login is a member of the Administrators group. When I login and fireup SQL management studio I connect to the instance using windows authentication.

I want to try and change the setup to "mixed-mode" but when I do I get the following error:
---------------------------------------------------------------------------
Alter failed for Server '277171-WEB1\SQLEXPRESS'.  (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
xp_regread() returned error 5, 'Access is denied.'
xp_regread() returned error 5, 'Access is denied.'
xp_regread() returned error 5, 'Access is denied.' (Microsoft SQL Server, Error: 22001)
----------------------------------------------------------------------------------------------------

I also can't change the 'sa' login password.

If I'm a member of the Administers group should'nt I be able to configure all these settings?

Thanks in advance,

Nellster
nellster1000Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LowfatspreadCommented:
depends what the internal security setting of the server/instance actually are...

builtin administrators aren't necessarily "sa" in a system


what command are you actually truing to run?

have you tried doing it locally?
0
nellster1000Author Commented:
Its via the SQL Studio Manage GUI. Can only get remote desktop access to the box as its a dedicated server as part of a web hosting package.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Do you have permissions on that server..
If so, then try using DAC mode as given below..

http://www.mssqltips.com/tip.asp?tip=1005
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

nellster1000Author Commented:
I have "Administrator" permissions if thats what you mean? What permissions I have regarding SQL I'm not sure.

If the security mode is set to "Windows Authentication Mode" should'nt local admins have sysadmin permissions on the instance? Or do they need to be assigned by a login that does i.e 'sa'?
0
LowfatspreadCommented:
.... the Sysadmin will assign the permissions to the relevant users... good practice would remove sysadmin by default
from normal members of the builtin administrators group  since they shouldn't normally be Database Sysadmins....
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> If the security mode is set to "Windows Authentication Mode" should'nt local admins have sysadmin permissions on the instance? Or do they need to be assigned by a login that does i.e 'sa'?

Not necessarily..
Unless otherwise you have used User Account Provisioning tool and added logins as sysadmins for SQL Server, local admins would not have Sysadmin privileges on the instance.
or else Local sysadmins can Right click SSMS and choose Run as Administrator to get sysadmin rights temporarily by impersonating a sysadmin..

And if you have sa login available, try using sa password and do it out..
0
nellster1000Author Commented:
Gonna split the points guys as both your solutions led me to a better understanding. I eventually re-installed SQL. The previous installation was not done by me and I had no access to the windows user tied to the SQL Administration or the sa credentials. All fine and dandy now. Many thanks for your help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.