Account for SQL Server services

Hi,
When I install cluster SQL Server in two nodes (active-passive), I used
valid administrator account for all nodes. After install, I changed SQL Agent
service account for replicate database. SA asked me to change the SQL Server
service account to not using currently administrator account under the
domain. If I changed what happy after stop and restart SQL, the cluster will
work or not? I mean the failover or fail back.
Regards!
-Chen
Use Enterprise Manager to change the SQL Server or SQL Agent service account
information. EM is cluster-aware and will make all necessary changes for
you.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chen" <Chen@.discussions.microsoft.com> wrote in message
news:51ED33DF-3880-46AB-879C-E00DE0E0670F@.microsoft.com...
> Hi,
> When I install cluster SQL Server in two nodes (active-passive), I used
> valid administrator account for all nodes. After install, I changed SQL
> Agent
> service account for replicate database. SA asked me to change the SQL
> Server
> service account to not using currently administrator account under the
> domain. If I changed what happy after stop and restart SQL, the cluster
> will
> work or not? I mean the failover or fail back.
> Regards!
> -Chen

account change causes DTS package jobs fail

DTS packages and jobs are created as domain administrator accounts
"\\ourdomain\administrator". For some reasons (separate database
account from network account), we switched to new domain administrator
account called "\\ourdomain\sqladm" as SQL Server, service startup
account. Some DTS jobs stop running. In DTSs, server connection uses
NT default acccount. Does anyone know what is going on here? Do I have
to change the DTS owmers to "\\ourdomain\sqladm"? or I have to change
all server connection in DTS packages as SQL account connection?
Thanks in advance.You should not need to change the ownereship of the DTS package. What is
the startup account for SQL Server Agent. It controls the execution of
jobs. Log in as the SQL Server Agent startup account on the server itself
and run the DTS packages that fail form Enterprise Manager. If they fail
there too, it could be a permissions problem with the account.
Rand
This posting is provided "as is" with no warranties and confers no rights.

account change causes DTS package jobs fail

DTS packages and jobs are created as domain administrator accounts
"\\ourdomain\administrator". For some reasons (separate database
account from network account), we switched to new domain administrator
account called "\\ourdomain\sqladm" as SQL Server, service startup
account. Some DTS jobs stop running. In DTSs, server connection uses
NT default acccount. Does anyone know what is going on here? Do I have
to change the DTS owmers to "\\ourdomain\sqladm"? or I have to change
all server connection in DTS packages as SQL account connection?
Thanks in advance.
You should not need to change the ownereship of the DTS package. What is
the startup account for SQL Server Agent. It controls the execution of
jobs. Log in as the SQL Server Agent startup account on the server itself
and run the DTS packages that fail form Enterprise Manager. If they fail
there too, it could be a permissions problem with the account.
Rand
This posting is provided "as is" with no warranties and confers no rights.

account change causes DTS package jobs fail

DTS packages and jobs are created as domain administrator accounts
"\\ourdomain\administrator". For some reasons (separate database
account from network account), we switched to new domain administrator
account called "\\ourdomain\sqladm" as SQL Server, service startup
account. Some DTS jobs stop running. In DTSs, server connection uses
NT default acccount. Does anyone know what is going on here? Do I have
to change the DTS owmers to "\\ourdomain\sqladm"? or I have to change
all server connection in DTS packages as SQL account connection?
Thanks in advance.You should not need to change the ownereship of the DTS package. What is
the startup account for SQL Server Agent. It controls the execution of
jobs. Log in as the SQL Server Agent startup account on the server itself
and run the DTS packages that fail form Enterprise Manager. If they fail
there too, it could be a permissions problem with the account.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Accidentally disable admin login

Hi, I have accidentally disabled the Administrator account in Sql Server 2005 (Douh!) on my clients server (double Dough!) & now I can login to enable it.

The <BuiltIn\Administartors> account is still active, The accout i disabled was <Domain\Administrator> (forgot I was logined via Terminal server).

Any help/assistance would be much appreciate!!

Cheers,

Nez

HI, i was unable to delte this post so may as well put the answer here.

to enable it again i used the SQLCMD.exe in the ".../90/tools/binn" folder

sp_grantlogin etc...

Cheers

|||Appreciate your solution and feedback here, in this case you can take help of DAC too if there is no other route.

Accessing the Report Builder Application

Hi,

Report Builder Application can be accessible only through Administrator previleged users or any user can access the report builder application? If it possible then how do we access it?.

Here we have a list of domain users, I have given the Report Builder rights to all domain users in the properties window in Report manager. When the domain user logging into the report manager, they can not able to see the report builder icon. Once I add my domain users into my server's administrator group they able to see the report builder icon as well as they can work with the application.

Expecting your answer in this.

Thanks in advance

You must also grant "Execute Report Definition" permissions, which is a system-level permission in SSRS|||

Thanks Russell.

If I set my users with administrator previlege with "Execute Report Definition" permissions, it is working fine.

I dont want to give "administrator" previlege to all the users to access the Report Builder application. Is it possible to access the reportbuilder application without giving the Administrator previlege

Advance Thanks and your help is highly appreciated.

|||

Hi,

Can anybody suggest how to access the report builder application in the asp.net webform so that the end user will able to drag and drop their required fields to get the desired o/p?

Can you please provide a sample demo for that?

|||

You don't need administrative privileges to run report builder. All you need is to grant your RB users an RS system role that contains "the execute report definitions permission".

In addition, if they want to use models, they will need access to the "report builder" role in the folder that contains the models.

|||

This is not currently supported. All you can do today is embed a URL to http://host/reportserver/ReportBuilder/ReportBuilder.application, which will cause Report Builder to be launched via clickOnce activation.