Good afternoon,
I was to make the exchange of the account that go up the services of the SQL
Server and the SQL Agent.
Of the SQL Server it was modified without problems, to put when I was to
modify of the SQL Agent I received the following error:
Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
and I do not obtain to change the account.
Anybody has some ideia of that to make?
Raphael Soares
where did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
need some permissions.
Search Books Online for "level token", and you will find information about service accounts and
needed permissions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
> Good afternoon,
> I was to make the exchange of the account that go up the services of the SQL
> Server and the SQL Agent.
> Of the SQL Server it was modified without problems, to put when I was to
> modify of the SQL Agent I received the following error:
> Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
> and I do not obtain to change the account.
> Anybody has some ideia of that to make?
> Raphael Soares
|||Tibor
I'm having the same problem that Raphael has.
In my case the account I'm trying to use to start the SQL Server Agent
service, belongs to the local administrators group at the database server,
the account is just a domain account that belongs to Domain users.
I'm trying to change this in the Enterprise Manager
This server has enabled the Terminal services in Application server mode.
Which permission I'm lacking?
It is not supposed that if I do it from Enterprise Manager I'm avoiding to
give manually the permissions that the Books Online article talks about?
Thanks
Guillermo
"Tibor Karaszi" wrote:
> where did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
> need some permissions.
> Search Books Online for "level token", and you will find information about service accounts and
> needed permissions.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
> news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
>
>
Showing posts with label exchange. Show all posts
Showing posts with label exchange. Show all posts
Thursday, March 8, 2012
Change the SQL Server or SQL Server Agent Service account
Good afternoon,
I was to make the exchange of the account that go up the services of the SQL
Server and the SQL Agent.
Of the SQL Server it was modified without problems, to put when I was to
modify of the SQL Agent I received the following error:
Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
and I do not obtain to change the account.
Anybody has some ideia of that to make?
Raphael Soareswhere did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
need some permissions.
Search Books Online for "level token", and you will find information about service accounts and
needed permissions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
> Good afternoon,
> I was to make the exchange of the account that go up the services of the SQL
> Server and the SQL Agent.
> Of the SQL Server it was modified without problems, to put when I was to
> modify of the SQL Agent I received the following error:
> Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
> and I do not obtain to change the account.
> Anybody has some ideia of that to make?
> Raphael Soares|||Tibor
I'm having the same problem that Raphael has.
In my case the account I'm trying to use to start the SQL Server Agent
service, belongs to the local administrators group at the database server,
the account is just a domain account that belongs to Domain users.
I'm trying to change this in the Enterprise Manager
This server has enabled the Terminal services in Application server mode.
Which permission I'm lacking?
It is not supposed that if I do it from Enterprise Manager I'm avoiding to
give manually the permissions that the Books Online article talks about?
Thanks
Guillermo
"Tibor Karaszi" wrote:
> where did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
> need some permissions.
> Search Books Online for "level token", and you will find information about service accounts and
> needed permissions.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
> news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
> > Good afternoon,
> > I was to make the exchange of the account that go up the services of the SQL
> > Server and the SQL Agent.
> > Of the SQL Server it was modified without problems, to put when I was to
> > modify of the SQL Agent I received the following error:
> > Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
> > and I do not obtain to change the account.
> >
> > Anybody has some ideia of that to make?
> >
> > Raphael Soares
>
>
I was to make the exchange of the account that go up the services of the SQL
Server and the SQL Agent.
Of the SQL Server it was modified without problems, to put when I was to
modify of the SQL Agent I received the following error:
Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
and I do not obtain to change the account.
Anybody has some ideia of that to make?
Raphael Soareswhere did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
need some permissions.
Search Books Online for "level token", and you will find information about service accounts and
needed permissions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
> Good afternoon,
> I was to make the exchange of the account that go up the services of the SQL
> Server and the SQL Agent.
> Of the SQL Server it was modified without problems, to put when I was to
> modify of the SQL Agent I received the following error:
> Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
> and I do not obtain to change the account.
> Anybody has some ideia of that to make?
> Raphael Soares|||Tibor
I'm having the same problem that Raphael has.
In my case the account I'm trying to use to start the SQL Server Agent
service, belongs to the local administrators group at the database server,
the account is just a domain account that belongs to Domain users.
I'm trying to change this in the Enterprise Manager
This server has enabled the Terminal services in Application server mode.
Which permission I'm lacking?
It is not supposed that if I do it from Enterprise Manager I'm avoiding to
give manually the permissions that the Books Online article talks about?
Thanks
Guillermo
"Tibor Karaszi" wrote:
> where did you make the modifications? Enterprise Manager? If so, then the SQL Server service account
> need some permissions.
> Search Books Online for "level token", and you will find information about service accounts and
> needed permissions.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Raphael Soares" <Raphael Soares@.discussions.microsoft.com> wrote in message
> news:E2FFA01B-7E1C-4A30-BCD0-75BF24AAE6F4@.microsoft.com...
> > Good afternoon,
> > I was to make the exchange of the account that go up the services of the SQL
> > Server and the SQL Agent.
> > Of the SQL Server it was modified without problems, to put when I was to
> > modify of the SQL Agent I received the following error:
> > Error:22043: xp_SetSQLSecurity() returned error 5, ' Access Denied '
> > and I do not obtain to change the account.
> >
> > Anybody has some ideia of that to make?
> >
> > Raphael Soares
>
>
Friday, February 10, 2012
Change Notifications
Hello
I have a requirement to update the Exchange contacts folder according
to a table in MSSQL 200. Also changes in the db has to be updated in
the contacts.
The solution that I have thought about is to write a trigger and
contact a COM object that does the update. Is there a better way to do?
Thank you and regards
Renjith V.I helped someone with a similar requirement a while back. We ended up using
DAV and a Windows Service that checked the table to do the updates en masse
every 5 minutes or so. Depends on your requirements - if you need to have
immediate updates you could write an XP and avoid COM; or you could go the
COM route and use the 'sp_OA%' stored procs to invoke/manage it. I've never
invoked a COM routine from within a Trigger, however, so I couldn't tell you
about possible performance or other potential problems (although if you
don't properly destroy COM objects and/or you're not on SP 4, you can end up
with serious memory leaks.)
"Renjith" <v.renjith@.gmail.com> wrote in message
news:1150338308.044717.160160@.y41g2000cwy.googlegroups.com...
> Hello
> I have a requirement to update the Exchange contacts folder according
> to a table in MSSQL 200. Also changes in the db has to be updated in
> the contacts.
> The solution that I have thought about is to write a trigger and
> contact a COM object that does the update. Is there a better way to do?
> Thank you and regards
> Renjith V.
>|||Thank you Mike for the comments. But I am not sure what DAV and XP
mean. Could you please tell me a bit more about it?
Mike C# wrote:
> I helped someone with a similar requirement a while back. We ended up usi
ng
> DAV and a Windows Service that checked the table to do the updates en mass
e
> every 5 minutes or so. Depends on your requirements - if you need to have
> immediate updates you could write an XP and avoid COM; or you could go the
> COM route and use the 'sp_OA%' stored procs to invoke/manage it. I've nev
er
> invoked a COM routine from within a Trigger, however, so I couldn't tell y
ou
> about possible performance or other potential problems (although if you
> don't properly destroy COM objects and/or you're not on SP 4, you can end
up
> with serious memory leaks.)
> "Renjith" <v.renjith@.gmail.com> wrote in message
> news:1150338308.044717.160160@.y41g2000cwy.googlegroups.com...|||"Renjith" <v.renjith@.gmail.com> wrote in message
news:1150339498.386101.227740@.g10g2000cwb.googlegroups.com...
> Thank you Mike for the comments. But I am not sure what DAV and XP
> mean. Could you please tell me a bit more about it?
DAV is a web-based protocol you can use to retrieve and update information.
You can use it to update your Exchange folders. XP is an extended stored
procedure written in C++ and compiled to a DLL that SQL Server can invoke to
perform functions that are outside the normal scope of T-SQL.|||If you can update the contacts through Active Directory you can look linking
to the AD through VB/VBScript (DTS ActiveX Task), you could also link to SQL
Server through the same script, produce a recordset of the changes and apply
the changes to the AD.
If this is an option the best place to start would probably be:
http://www.microsoft.com/technet/sc...er/default.mspx
Ray
"Renjith" wrote:
> Hello
> I have a requirement to update the Exchange contacts folder according
> to a table in MSSQL 200. Also changes in the db has to be updated in
> the contacts.
> The solution that I have thought about is to write a trigger and
> contact a COM object that does the update. Is there a better way to do?
> Thank you and regards
> Renjith V.
>
I have a requirement to update the Exchange contacts folder according
to a table in MSSQL 200. Also changes in the db has to be updated in
the contacts.
The solution that I have thought about is to write a trigger and
contact a COM object that does the update. Is there a better way to do?
Thank you and regards
Renjith V.I helped someone with a similar requirement a while back. We ended up using
DAV and a Windows Service that checked the table to do the updates en masse
every 5 minutes or so. Depends on your requirements - if you need to have
immediate updates you could write an XP and avoid COM; or you could go the
COM route and use the 'sp_OA%' stored procs to invoke/manage it. I've never
invoked a COM routine from within a Trigger, however, so I couldn't tell you
about possible performance or other potential problems (although if you
don't properly destroy COM objects and/or you're not on SP 4, you can end up
with serious memory leaks.)
"Renjith" <v.renjith@.gmail.com> wrote in message
news:1150338308.044717.160160@.y41g2000cwy.googlegroups.com...
> Hello
> I have a requirement to update the Exchange contacts folder according
> to a table in MSSQL 200. Also changes in the db has to be updated in
> the contacts.
> The solution that I have thought about is to write a trigger and
> contact a COM object that does the update. Is there a better way to do?
> Thank you and regards
> Renjith V.
>|||Thank you Mike for the comments. But I am not sure what DAV and XP
mean. Could you please tell me a bit more about it?
Mike C# wrote:
> I helped someone with a similar requirement a while back. We ended up usi
ng
> DAV and a Windows Service that checked the table to do the updates en mass
e
> every 5 minutes or so. Depends on your requirements - if you need to have
> immediate updates you could write an XP and avoid COM; or you could go the
> COM route and use the 'sp_OA%' stored procs to invoke/manage it. I've nev
er
> invoked a COM routine from within a Trigger, however, so I couldn't tell y
ou
> about possible performance or other potential problems (although if you
> don't properly destroy COM objects and/or you're not on SP 4, you can end
up
> with serious memory leaks.)
> "Renjith" <v.renjith@.gmail.com> wrote in message
> news:1150338308.044717.160160@.y41g2000cwy.googlegroups.com...|||"Renjith" <v.renjith@.gmail.com> wrote in message
news:1150339498.386101.227740@.g10g2000cwb.googlegroups.com...
> Thank you Mike for the comments. But I am not sure what DAV and XP
> mean. Could you please tell me a bit more about it?
DAV is a web-based protocol you can use to retrieve and update information.
You can use it to update your Exchange folders. XP is an extended stored
procedure written in C++ and compiled to a DLL that SQL Server can invoke to
perform functions that are outside the normal scope of T-SQL.|||If you can update the contacts through Active Directory you can look linking
to the AD through VB/VBScript (DTS ActiveX Task), you could also link to SQL
Server through the same script, produce a recordset of the changes and apply
the changes to the AD.
If this is an option the best place to start would probably be:
http://www.microsoft.com/technet/sc...er/default.mspx
Ray
"Renjith" wrote:
> Hello
> I have a requirement to update the Exchange contacts folder according
> to a table in MSSQL 200. Also changes in the db has to be updated in
> the contacts.
> The solution that I have thought about is to write a trigger and
> contact a COM object that does the update. Is there a better way to do?
> Thank you and regards
> Renjith V.
>
Subscribe to:
Posts (Atom)