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?
 
LowfatspreadConnect With a Mentor Commented:
.... 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
 
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
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
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
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
>> 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.