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 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...
>
>

change ssis connection.

Hi,

i have SSIS proj whice now it connect to server A (whice is our test server)

now i want to modified our project that when we want it'll connect to server B (Our Prod server).

now i'm looking for something global that will switch the connection strings whenever i want.

what i find so far is to declare var for each package and give the var default value and to create script to change the value of the var.

is there a solution that will be for all the project and i don't have to change each package (i have alot of pckgs).

Thanks in advanced.

Configurations, as referenced in your other posts.