|
|
|
date: Thu, 20 Dec 2007 13:00:01 -0800,
group: microsoft.public.sqlserver.security
back
Re: Not allowed to switch authentication modes
Ken (Ken@discussions.microsoft.com) writes:
> I have a copy of SQL that comes with MS Vista, and downloaded SQL Server
> mgmt studio express to work with it.
>
> I want to change the authentication mode to SQL Server and Windows, and
> create an sa account. I have a database I then want to restore into
> this new system.
>
> I go into Server Properties, and change the server authentication mode,
> but receive an error when I hit OK. The error is
>
> An Exception occured while executing a Transact-SQL statement of batch:
> Microsoft.SqlServer.Express.Connectioninfo)
>
> the Execute permission was denied on the object 'exp_instance_reqwrite''
>
> Do you know why I am getting this?
Apparently you are not running with sysadmin privileges. Start SSMS Express
with Run As Administrator from the context menu. Once you are an admin
in Windows, you will be one in SQL Server as well. For future use, either
add your own user to the sysadmin server role, or activate sa as you had
planned.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
date: Thu, 20 Dec 2007 14:52:59 -0800
author: Erland Sommarskog
Re: Not allowed to switch authentication modes
1) Sorry, I meant the SQL that comes with office 2007. I can't figure out
if it is the full blown 2005, or the express version. It does not say
"express" anywhere.
2) How do I "Run As Administrator from the context menu"
Thanks!!
Ken
"Erland Sommarskog" wrote:
> Ken (Ken@discussions.microsoft.com) writes:
> > I have a copy of SQL that comes with MS Vista, and downloaded SQL Server
> > mgmt studio express to work with it.
> >
> > I want to change the authentication mode to SQL Server and Windows, and
> > create an sa account. I have a database I then want to restore into
> > this new system.
> >
> > I go into Server Properties, and change the server authentication mode,
> > but receive an error when I hit OK. The error is
> >
> > An Exception occured while executing a Transact-SQL statement of batch:
> > Microsoft.SqlServer.Express.Connectioninfo)
> >
> > the Execute permission was denied on the object 'exp_instance_reqwrite''
> >
> > Do you know why I am getting this?
>
> Apparently you are not running with sysadmin privileges. Start SSMS Express
> with Run As Administrator from the context menu. Once you are an admin
> in Windows, you will be one in SQL Server as well. For future use, either
> add your own user to the sysadmin server role, or activate sa as you had
> planned.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
date: Thu, 20 Dec 2007 15:00:00 -0800
author: Ken
Re: Not allowed to switch authentication modes
I just thought abour what you meant, I only have one login on Vista, and I am
an admin. But for some reason, I am not an admin with SQL.
"Erland Sommarskog" wrote:
> Ken (Ken@discussions.microsoft.com) writes:
> > I have a copy of SQL that comes with MS Vista, and downloaded SQL Server
> > mgmt studio express to work with it.
> >
> > I want to change the authentication mode to SQL Server and Windows, and
> > create an sa account. I have a database I then want to restore into
> > this new system.
> >
> > I go into Server Properties, and change the server authentication mode,
> > but receive an error when I hit OK. The error is
> >
> > An Exception occured while executing a Transact-SQL statement of batch:
> > Microsoft.SqlServer.Express.Connectioninfo)
> >
> > the Execute permission was denied on the object 'exp_instance_reqwrite''
> >
> > Do you know why I am getting this?
>
> Apparently you are not running with sysadmin privileges. Start SSMS Express
> with Run As Administrator from the context menu. Once you are an admin
> in Windows, you will be one in SQL Server as well. For future use, either
> add your own user to the sysadmin server role, or activate sa as you had
> planned.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
date: Thu, 20 Dec 2007 15:03:00 -0800
author: Ken
Re: Not allowed to switch authentication modes
this is the exact error message if this helps:
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Alter failed for Server 'DADDY-PC\MSSMLBIZ'.
(Microsoft.SqlServer.Express.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
The EXECUTE permission was denied on the object 'xp_instance_regwrite',
database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error:
229)
BUTTONS:
OK
------------------------------
"Erland Sommarskog" wrote:
> Ken (Ken@discussions.microsoft.com) writes:
> > I have a copy of SQL that comes with MS Vista, and downloaded SQL Server
> > mgmt studio express to work with it.
> >
> > I want to change the authentication mode to SQL Server and Windows, and
> > create an sa account. I have a database I then want to restore into
> > this new system.
> >
> > I go into Server Properties, and change the server authentication mode,
> > but receive an error when I hit OK. The error is
> >
> > An Exception occured while executing a Transact-SQL statement of batch:
> > Microsoft.SqlServer.Express.Connectioninfo)
> >
> > the Execute permission was denied on the object 'exp_instance_reqwrite''
> >
> > Do you know why I am getting this?
>
> Apparently you are not running with sysadmin privileges. Start SSMS Express
> with Run As Administrator from the context menu. Once you are an admin
> in Windows, you will be one in SQL Server as well. For future use, either
> add your own user to the sysadmin server role, or activate sa as you had
> planned.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>
date: Thu, 20 Dec 2007 15:08:02 -0800
author: Ken
Re: Not allowed to switch authentication modes
From SSMS - connect to your database in Object Explorer. Open the
folder for Security, logins, select the sa account's properties and set
the password.
Or, you can open a query and execute sp_password (see BOL).
Jeff
Ken wrote:
> Thanks!! That worked!
>
> Do you know what the password for sa is, or how I can set it? I did not
> install SQL so I did not set one.
>
> "Jeffrey Williams" wrote:
>
>
>> Ken wrote:
>>
>>> i can't seem to get it to believe that I am an admin. I think I need to
>>> uninstall the entire sql server, and reinstall from scratch. I have built
>>> in/user but no built in/admin.
>>>
>>> "Ken" wrote:
>>>
>>>
>>>
>>>> I have a copy of SQL that comes with MS Vista, and downloaded SQL Server mgmt
>>>> studio express to work with it.
>>>>
>>>> I want to change the authentication mode to SQL Server and Windows, and
>>>> create an sa account. I have a database I then want to restore into this new
>>>> system.
>>>>
>>>> I go into Server Properties, and change the server authentication mode, but
>>>> receive an error when I hit OK. The error is
>>>>
>>>> An Exception occured while executing a Transact-SQL statement of batch:
>>>> Microsoft.SqlServer.Express.Connectioninfo)
>>>>
>>>> the Execute permission was denied on the object 'exp_instance_reqwrite''
>>>>
>>>> Do you know why I am getting this?
>>>>
>>>>
>> In Vista - to run as admin you have to tell Vista that you want to run
>> that program as an Administrator. Right-click on the short-cut that you
>> are using to launch the management studio and there will be an option to
>> Run As Administrator.
>>
>>
date: Thu, 20 Dec 2007 22:19:57 -0800
author: Jeffrey Williams
|
|
