Skip to main content
Database Administrators

Return to Question

SQL and SQL Server are different things, so I reworded accordingly. Improved formatting. Corrected capitalization. Added the generic tag of the DBMS ofrelevance. Etc.
Source Link
MDCCL
MDCCL
  • 8.5k
  • 3
  • 31
  • 62

Can't change server authentication mode from windows modeWindows to both sqlSQL Server and windows inWindows

As the title suggests I'm having problems changing the authentication mode from windowsWindows to both sqlSQL Server and windowsWindows mode in version 12.0.2. I have tried right right-clicking the server, go to security and change it there but I'm getting an error when doing this. I installed it originally using both but changed it to windows only mode earlier this evening.

The error message I'm getting is long winded but the end of it is:

"The EXECUTE permission was denied on the object 'xp_instance_regwrite', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error; 229)

The EXECUTE permission was denied on the object 'xp_instance_regwrite', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error; 229)

Any idea what that means? I'm guessing I don't have the required permission but I'm not familiar enough with it to know what to do next. I have the sasa password but can't enter it while I'm stuck in windowsWindows mode.

I've been trying to figure out why I can't seem to write to the database all day and in desperation tried changing the mode to see if that would fix it... but it's only made things worse :(.

While connected using windowsWindows credentials I tried " ALTER LOGIN sa ENABLE"ALTER LOGIN sa ENABLE also and was given "Cannot alter the login 'sa', because it does not exist or you do not have permission."following error message in response.:

Cannot alter the login 'sa', because it does not exist or you do not have permission.

I did try altering the registry too to change the mode but realised I was reading a post relating to sql serverSQL Server 2005

Thanks in advance for your help.

Can't change server authentication mode from windows mode to both sql and windows in

As the title suggests I'm having problems changing the authentication mode from windows to both sql and windows mode in version 12.0.2. I have tried right right-clicking the server, go to security and change it there but I'm getting an error when doing this. I installed it originally using both but changed it to windows only mode earlier this evening.

The error I'm getting is long winded but the end of it is:

"The EXECUTE permission was denied on the object 'xp_instance_regwrite', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error; 229)

Any idea what that means? I'm guessing I don't have the required permission but I'm not familiar enough with it to know what to do next. I have the sa password but can't enter it while I'm stuck in windows mode.

I've been trying to figure out why I can't seem to write to the database all day and in desperation tried changing the mode to see if that would fix it... but it's only made things worse :(

While connected using windows credentials I tried " ALTER LOGIN sa ENABLE" also and was given "Cannot alter the login 'sa', because it does not exist or you do not have permission." in response. I did try altering the registry too to change the mode but realised I was reading a post relating to sql server 2005

Thanks in advance for your help.

Can't change authentication mode from Windows to both SQL Server and Windows

As the title suggests I'm having problems changing the authentication mode from Windows to both SQL Server and Windows mode in version 12.0.2. I have tried right right-clicking the server, go to security and change it there but I'm getting an error when doing this. I installed it originally using both but changed it to windows only mode earlier this evening.

The error message I'm getting is long winded but the end of it is:

The EXECUTE permission was denied on the object 'xp_instance_regwrite', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error; 229)

Any idea what that means? I'm guessing I don't have the required permission but I'm not familiar enough with it to know what to do next. I have the sa password but can't enter it while I'm stuck in Windows mode.

I've been trying to figure out why I can't seem to write to the database all day and in desperation tried changing the mode to see if that would fix it... but it's only made things worse.

While connected using Windows credentials I tried ALTER LOGIN sa ENABLE also and was given the following error message in response:

Cannot alter the login 'sa', because it does not exist or you do not have permission.

I did try altering the registry too to change the mode but realised I was reading a post relating to SQL Server 2005

Thanks in advance for your help.

Source Link
DarrenG
DarrenG
  • 13
  • 1
  • 1
  • 3

Can't change server authentication mode from windows mode to both sql and windows in

As the title suggests I'm having problems changing the authentication mode from windows to both sql and windows mode in version 12.0.2. I have tried right right-clicking the server, go to security and change it there but I'm getting an error when doing this. I installed it originally using both but changed it to windows only mode earlier this evening.

The error I'm getting is long winded but the end of it is:

"The EXECUTE permission was denied on the object 'xp_instance_regwrite', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error; 229)

Any idea what that means? I'm guessing I don't have the required permission but I'm not familiar enough with it to know what to do next. I have the sa password but can't enter it while I'm stuck in windows mode.

I've been trying to figure out why I can't seem to write to the database all day and in desperation tried changing the mode to see if that would fix it... but it's only made things worse :(

While connected using windows credentials I tried " ALTER LOGIN sa ENABLE" also and was given "Cannot alter the login 'sa', because it does not exist or you do not have permission." in response. I did try altering the registry too to change the mode but realised I was reading a post relating to sql server 2005

Thanks in advance for your help.