Changing the SQL Server Agent ID

Hello,
We have are using SQL 2000 on a 2003 server. We have one
instance of 2000 up to service pack 3a.
We need to change the domain user id of the SQL Server
Agent. We changed it through the Services section of
Windows 2003. Then starting up it reports 'Access is
deniged'
The domain userid we are change it to is already an
administrator on the server, and is used on a different
server, and I am logged on as a local administrator.
Can anyone point the way ?
Thanks
Peter
it's recommended to change it using enterprise manager instead of in the
services window. you may need to search for a kb article about how to
manually change the account associated with the sqlagent. there's
registry settings, file permissions, etc that need to change.
Peter wrote:

> Hello,
> We have are using SQL 2000 on a 2003 server. We have one
> instance of 2000 up to service pack 3a.
> We need to change the domain user id of the SQL Server
> Agent. We changed it through the Services section of
> Windows 2003. Then starting up it reports 'Access is
> deniged'
> The domain userid we are change it to is already an
> administrator on the server, and is used on a different
> server, and I am logged on as a local administrator.
> Can anyone point the way ?
> Thanks
> Peter
|||A good start is to search Books Online for "level token".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"ch" <ch@.dontemailme.com> wrote in message news:4098DED6.AE35BF7D@.dontemailme.com...
> it's recommended to change it using enterprise manager instead of in the
> services window. you may need to search for a kb article about how to
> manually change the account associated with the sqlagent. there's
> registry settings, file permissions, etc that need to change.
>
> Peter wrote:
>

Changing the SQL Server Agent ID

Hello,
We have are using SQL 2000 on a 2003 server. We have one
instance of 2000 up to service pack 3a.
We need to change the domain user id of the SQL Server
Agent. We changed it through the Services section of
Windows 2003. Then starting up it reports 'Access is
deniged'
The domain userid we are change it to is already an
administrator on the server, and is used on a different
server, and I am logged on as a local administrator.
Can anyone point the way ?
Thanks
Peterit's recommended to change it using enterprise manager instead of in the
services window. you may need to search for a kb article about how to
manually change the account associated with the sqlagent. there's
registry settings, file permissions, etc that need to change.
Peter wrote:

> Hello,
> We have are using SQL 2000 on a 2003 server. We have one
> instance of 2000 up to service pack 3a.
> We need to change the domain user id of the SQL Server
> Agent. We changed it through the Services section of
> Windows 2003. Then starting up it reports 'Access is
> deniged'
> The domain userid we are change it to is already an
> administrator on the server, and is used on a different
> server, and I am logged on as a local administrator.
> Can anyone point the way ?
> Thanks
> Peter|||A good start is to search Books Online for "level token".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"ch" <ch@.dontemailme.com> wrote in message news:4098DED6.AE35BF7D@.dontemailme.com...eagreen">
> it's recommended to change it using enterprise manager instead of in the
> services window. you may need to search for a kb article about how to
> manually change the account associated with the sqlagent. there's
> registry settings, file permissions, etc that need to change.
>
> Peter wrote:
>
>

Changing the SQL Server Agent ID

Hello,
We have are using SQL 2000 on a 2003 server. We have one
instance of 2000 up to service pack 3a.
We need to change the domain user id of the SQL Server
Agent. We changed it through the Services section of
Windows 2003. Then starting up it reports 'Access is
deniged'
The domain userid we are change it to is already an
administrator on the server, and is used on a different
server, and I am logged on as a local administrator.
Can anyone point the way ?
Thanks
Peterit's recommended to change it using enterprise manager instead of in the
services window. you may need to search for a kb article about how to
manually change the account associated with the sqlagent. there's
registry settings, file permissions, etc that need to change.
Peter wrote:
> Hello,
> We have are using SQL 2000 on a 2003 server. We have one
> instance of 2000 up to service pack 3a.
> We need to change the domain user id of the SQL Server
> Agent. We changed it through the Services section of
> Windows 2003. Then starting up it reports 'Access is
> deniged'
> The domain userid we are change it to is already an
> administrator on the server, and is used on a different
> server, and I am logged on as a local administrator.
> Can anyone point the way ?
> Thanks
> Peter|||A good start is to search Books Online for "level token".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"ch" <ch@.dontemailme.com> wrote in message news:4098DED6.AE35BF7D@.dontemailme.com...
> it's recommended to change it using enterprise manager instead of in the
> services window. you may need to search for a kb article about how to
> manually change the account associated with the sqlagent. there's
> registry settings, file permissions, etc that need to change.
>
> Peter wrote:
> > Hello,
> >
> > We have are using SQL 2000 on a 2003 server. We have one
> > instance of 2000 up to service pack 3a.
> >
> > We need to change the domain user id of the SQL Server
> > Agent. We changed it through the Services section of
> > Windows 2003. Then starting up it reports 'Access is
> > deniged'
> >
> > The domain userid we are change it to is already an
> > administrator on the server, and is used on a different
> > server, and I am logged on as a local administrator.
> >
> > Can anyone point the way ?
> >
> > Thanks
> > Peter
>sql

Changing the MSSQLServer service account causes SQL Agent could not start

Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
running either a domain account or local system account, i.e.
MSSQLServer service is under a domain account, SQL Agent is under
local system.
For a reason, we need to switch the domain account to the other domain
account, the MSSQLServer service is started up with no problem but the
SQL Agent is not able to start up neither in local system or new
domain account, the error message is: "The SQL Server Agent
(MSSQLSERVER) service on Local Computer started and then stop
automatically if they have no work to do, for example, the Performance
Logs and Alerts service. "
Switch back to original domain account is fine, let the MSSQLServer
running on local system account is fine too for both MSSQLServer and
SQL Agent.
P.S. Both old/new domain accounts are in the server's local admin and
domain administrator groups and as well as SQL sa.
What is needed to use a domain account as the SQL service account?
Thanks,
Yvette.
Hi Yvette
"yvette.ye@.gmail.com" wrote:

> Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
> running either a domain account or local system account, i.e.
> MSSQLServer service is under a domain account, SQL Agent is under
> local system.
> For a reason, we need to switch the domain account to the other domain
> account, the MSSQLServer service is started up with no problem but the
> SQL Agent is not able to start up neither in local system or new
> domain account, the error message is: "The SQL Server Agent
> (MSSQLSERVER) service on Local Computer started and then stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts service. "
> Switch back to original domain account is fine, let the MSSQLServer
> running on local system account is fine too for both MSSQLServer and
> SQL Agent.
> P.S. Both old/new domain accounts are in the server's local admin and
> domain administrator groups and as well as SQL sa.
> What is needed to use a domain account as the SQL service account?
> Thanks,
> Yvette.
>
For the account types that can be used see
http://support.microsoft.com/kb/907557
and http://support.microsoft.com/kb/283811 describes the requirements for
the accounts if you don't use EM or SCM to change the account.
John
|||"John Bell" wrote:

> Hi Yvette
> For the account types that can be used see
> http://support.microsoft.com/kb/907557
> and http://support.microsoft.com/kb/283811 describes the requirements for
> the accounts if you don't use EM or SCM to change the account.
> John
Also try http://msdn2.microsoft.com/en-us/library/ms143504.aspx
John

Changing the MSSQLServer service account causes SQL Agent could not start

Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
running either a domain account or local system account, i.e.
MSSQLServer service is under a domain account, SQL Agent is under
local system.
For a reason, we need to switch the domain account to the other domain
account, the MSSQLServer service is started up with no problem but the
SQL Agent is not able to start up neither in local system or new
domain account, the error message is: "The SQL Server Agent
(MSSQLSERVER) service on Local Computer started and then stop
automatically if they have no work to do, for example, the Performance
Logs and Alerts service. "
Switch back to original domain account is fine, let the MSSQLServer
running on local system account is fine too for both MSSQLServer and
SQL Agent.
P.S. Both old/new domain accounts are in the server's local admin and
domain administrator groups and as well as SQL sa.
What is needed to use a domain account as the SQL service account?
Thanks,
Yvette.Hi Yvette
"yvette.ye@.gmail.com" wrote:
> Hi...a SQL2005 enterprise under W2K3 server. All the SQL services are
> running either a domain account or local system account, i.e.
> MSSQLServer service is under a domain account, SQL Agent is under
> local system.
> For a reason, we need to switch the domain account to the other domain
> account, the MSSQLServer service is started up with no problem but the
> SQL Agent is not able to start up neither in local system or new
> domain account, the error message is: "The SQL Server Agent
> (MSSQLSERVER) service on Local Computer started and then stop
> automatically if they have no work to do, for example, the Performance
> Logs and Alerts service. "
> Switch back to original domain account is fine, let the MSSQLServer
> running on local system account is fine too for both MSSQLServer and
> SQL Agent.
> P.S. Both old/new domain accounts are in the server's local admin and
> domain administrator groups and as well as SQL sa.
> What is needed to use a domain account as the SQL service account?
> Thanks,
> Yvette.
>
For the account types that can be used see
http://support.microsoft.com/kb/907557
and http://support.microsoft.com/kb/283811 describes the requirements for
the accounts if you don't use EM or SCM to change the account.
John|||"John Bell" wrote:
> Hi Yvette
> For the account types that can be used see
> http://support.microsoft.com/kb/907557
> and http://support.microsoft.com/kb/283811 describes the requirements for
> the accounts if you don't use EM or SCM to change the account.
> John
Also try http://msdn2.microsoft.com/en-us/library/ms143504.aspx
John

Changing SQL Service account passowrd on a cluster configuration

Hi,
I have SQL 2005 server (with Named Instance) running on a two node Cluster
Configuration (Active/Passive).
SQL Instance, SQL Server Agent, SQL Server Browser services are running
under a service account (domain account). Similarly Cluster service is also
running under a cluster service account (domain account).
I am looking for accurate steps to update password of SQL Service account
and Cluster service account that will cause minimum disruption of these
services. If there’s a link to documentation on how to update password, that
will be most useful.
For the cluster service account password:
http://support.microsoft.com/kb/305813/en-us
For the SQL 2005 Instance, use the SQL Configuration Manager to change the
password. It handles the "cluster magic".
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Mehul" <Mehul@.discussions.microsoft.com> wrote in message
news:C4EE5D43-00E3-4322-92C2-538B8CDEC12D@.microsoft.com...
> Hi,
> I have SQL 2005 server (with Named Instance) running on a two node Cluster
> Configuration (Active/Passive).
> SQL Instance, SQL Server Agent, SQL Server Browser services are running
> under a service account (domain account). Similarly Cluster service is
> also
> running under a cluster service account (domain account).
> I am looking for accurate steps to update password of SQL Service account
> and Cluster service account that will cause minimum disruption of these
> services. If there’s a link to documentation on how to update password,
> that
> will be most useful.
>
|||It could be just me, but I had problem using Configuration Manager to change
the SQL service account password from time to time. I don't remember the
exact error message now, but I remember not having success in getting the
change replicated among the nodes.
I've had more success with just using the services.msc mgmt console to
change the SQL service account password on each node. This is just a hassle
since on each node there are a few services to change. I know Configuration
Manager is not cluster aware, but had hoped that at least any change made
through it to the SQL registry entries would be automatically replicated by
the cluster service.
Linchi
"Geoff N. Hiten" wrote:

> For the cluster service account password:
> http://support.microsoft.com/kb/305813/en-us
> For the SQL 2005 Instance, use the SQL Configuration Manager to change the
> password. It handles the "cluster magic".
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Mehul" <Mehul@.discussions.microsoft.com> wrote in message
> news:C4EE5D43-00E3-4322-92C2-538B8CDEC12D@.microsoft.com...
>
|||Thanks Geoff. But I would really like to know what are the steps to perform.
Do I need to change password on both the nodes or only on the active node ?
Once the password for the account is updated in AD, is it immediately
reflected on the SQL servers ?
"Geoff N. Hiten" wrote:

> For the cluster service account password:
> http://support.microsoft.com/kb/305813/en-us
> For the SQL 2005 Instance, use the SQL Configuration Manager to change the
> password. It handles the "cluster magic".
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
>
> "Mehul" <Mehul@.discussions.microsoft.com> wrote in message
> news:C4EE5D43-00E3-4322-92C2-538B8CDEC12D@.microsoft.com...
>
|||Linchi, Thanks for your feedback.
So what steps do you follow to update password for all these services using
services.msc ?
"Linchi Shea" wrote:
[vbcol=seagreen]
> It could be just me, but I had problem using Configuration Manager to change
> the SQL service account password from time to time. I don't remember the
> exact error message now, but I remember not having success in getting the
> change replicated among the nodes.
> I've had more success with just using the services.msc mgmt console to
> change the SQL service account password on each node. This is just a hassle
> since on each node there are a few services to change. I know Configuration
> Manager is not cluster aware, but had hoped that at least any change made
> through it to the SQL registry entries would be automatically replicated by
> the cluster service.
> Linchi
> "Geoff N. Hiten" wrote:
|||Here are the steps I went through recently to update the password for the SQL
service account (the previous password expired. It shouldn't be set to
expire, but that's a different story):
1. Remote desktop to each node
2. Start -> Run, type services.msc
3. In the service list, locate all the SQL Server related services that use
the password.
4. Double click on each such service
5. Click on the "Log On' tab.
6. Type in the new password in the Password and Confirm Password textboxes.
7. Click on Apply and OK.
Linchi
"Mehul" wrote:
[vbcol=seagreen]
> Linchi, Thanks for your feedback.
> So what steps do you follow to update password for all these services using
> services.msc ?
> "Linchi Shea" wrote:
|||LInchi's advice on using the services applet on each node is a bit more
complex, but it is a certaintly.
As for when changes "take", AD may need up to fifteen minutes to replicate
the password change through the system when you have multiple controllers.
If an account is logged in to a resource, such as a service account already
running, you can leave it running or a while before changing it. The system
will not force it out immediately but the application may no longer be able
to access network resources after some time.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Mehul" <Mehul@.discussions.microsoft.com> wrote in message
news:7F18E2CD-E089-4642-898E-FB303324181E@.microsoft.com...[vbcol=seagreen]
> Thanks Geoff. But I would really like to know what are the steps to
> perform.
> Do I need to change password on both the nodes or only on the active node
> ?
> Once the password for the account is updated in AD, is it immediately
> reflected on the SQL servers ?
> "Geoff N. Hiten" wrote:
|||Linchi,
Here's what worked for me. Quite similar to the steps you have outlined:
1.Changed SQL Service account password in AD. Waited for about half an hour
so that password change gets replicated to all the domain controllers.
2.Updated the password on the active node of the SQL Cluster using SQL
Configuration manager for all the services.
3.Restarted the services using SCM. Everything looked fine till now.
4.On the passive node, using Services MMC, manually updated password for
the SQL services.
5.Fail over the cluster from node 1 to node 2, everything worked fine with
no errors.
I will be blogging these steps, but hope that other people who are in the
same situation will find this discussion useful.
Thanks Geoff and Linchi for your quick responses.
"Linchi Shea" wrote:
[vbcol=seagreen]
> Here are the steps I went through recently to update the password for the SQL
> service account (the previous password expired. It shouldn't be set to
> expire, but that's a different story):
> 1. Remote desktop to each node
> 2. Start -> Run, type services.msc
> 3. In the service list, locate all the SQL Server related services that use
> the password.
> 4. Double click on each such service
> 5. Click on the "Log On' tab.
> 6. Type in the new password in the Password and Confirm Password textboxes.
> 7. Click on Apply and OK.
> Linchi
> "Mehul" wrote:
|||I'm glad that you included step 5 to failover the SQL group among the nodes.
That's an abosolutely critical step to close loop the whole task.
Linchi
"Mehul" wrote:
[vbcol=seagreen]
> Linchi,
> Here's what worked for me. Quite similar to the steps you have outlined:
> 1.Changed SQL Service account password in AD. Waited for about half an hour
> so that password change gets replicated to all the domain controllers.
> 2.Updated the password on the active node of the SQL Cluster using SQL
> Configuration manager for all the services.
> 3.Restarted the services using SCM. Everything looked fine till now.
> 4.On the passive node, using Services MMC, manually updated password for
> the SQL services.
> 5.Fail over the cluster from node 1 to node 2, everything worked fine with
> no errors.
> I will be blogging these steps, but hope that other people who are in the
> same situation will find this discussion useful.
> Thanks Geoff and Linchi for your quick responses.
>
> "Linchi Shea" wrote:

Changing SQL Server Agent settings on the fly?

Hello all,

I have created a simple package that imports data from a flat file into a database. To run the package I'm using a SQL Server Agent Job. The location of the file is stored as a connection string in the Connection Managers tab in the SQL Server Agent Job.

Is there a way to change this connection string programmatically? If not programmatically, is there a way to change this setting right before I execute the package. I want to change the location of this file based on user input. Also, I'm executing the package using the sp_start_job stored procedure to run the job.

Thanks in advance for any advice!

-Dwayne

You could just create the entire job on the fly, they can be scripted in T-SQL.

If you want to keep the job, then you could use sp_update_jobstep to update the step command. Now I have not looked at the command for the SSIS subsystem, but I'd recommend use the CmdExec subsystem and calling DTEXEC myself, the logging is much better. Even MS recommend that approach in one of their KB's now. BTW could read it here first, illustrates why - http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html

Finally leave the job alone, and store the value in a table. You could manually use the Exec SQL Task to query the value, or perhaps better still use a SQL server based configuration. Have a look in Books Online about configurations, they are very useful, and I suggest you use them anyway to help manage connection details.

changing sql server account using sem ...

when trying to change the sql server and sql server agent accounts using the
sql enterprise manager what is the syntax for a domain account that should be
used ( i.e. domainname/username, just username, domainname\username, etc... )
? when attempting to add an existing domain account an error message keeps
poping-up that says 'the account (local computername)/accountname is not a
valid windows account' ( for some reason it thinks its a local system account
instead of a domain account ) even though sql server is installed on the pdc.
tia ...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using the
> sql enterprise manager what is the syntax for a domain account that should be
> used ( i.e. domainname/username, just username, domainname\username, etc... )
> ? when attempting to add an existing domain account an error message keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system account
> instead of a domain account ) even though sql server is installed on the pdc.
> tia ...
|||Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.
http://support.microsoft.com/default...b;en-us;283811
Sincerely,
Anthony Thomas

"mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ? when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
> tia ...
|||Thanks Anthony.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"Anthony Thomas" wrote:

> Yes, but the recommended approach is to do it through EM. This way all of
> the necessary permissions and user rights assingments will be given
> appropriately. However, using the services msc is an alternative as long as
> you follow the KB article that describes manually setting all of the other
> requirements.
> http://support.microsoft.com/default...b;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
> news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
> Hello E-Double.
> I find it easiest to change the account using the services console (type
> services.msc in Start>Run), that way you can browse the network and or check
> the name that you enter so it will be prefixed correctly with the domain. I
> just find I don't have to think about it this way.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "E-Double" wrote:
> the
> be
> etc... )
> keeps
> account
> pdc.
>
>

changing sql server account using sem ...

when trying to change the sql server and sql server agent accounts using the
sql enterprise manager what is the syntax for a domain account that should be
used ( i.e. domainname/username, just username, domainname\username, etc... )
? when attempting to add an existing domain account an error message keeps
poping-up that says 'the account (local computername)/accountname is not a
valid windows account' ( for some reason it thinks its a local system account
instead of a domain account ) even though sql server is installed on the pdc.
tia ...Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:
> when trying to change the sql server and sql server agent accounts using the
> sql enterprise manager what is the syntax for a domain account that should be
> used ( i.e. domainname/username, just username, domainname\username, etc... )
> ? when attempting to add an existing domain account an error message keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system account
> instead of a domain account ) even though sql server is installed on the pdc.
> tia ...|||Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.
http://support.microsoft.com/default.aspx?scid=kb;en-us;283811
Sincerely,
Anthony Thomas
"mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:
> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ? when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
> tia ...|||Thanks Anthony.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"Anthony Thomas" wrote:
> Yes, but the recommended approach is to do it through EM. This way all of
> the necessary permissions and user rights assingments will be given
> appropriately. However, using the services msc is an alternative as long as
> you follow the KB article that describes manually setting all of the other
> requirements.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
> news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
> Hello E-Double.
> I find it easiest to change the account using the services console (type
> services.msc in Start>Run), that way you can browse the network and or check
> the name that you enter so it will be prefixed correctly with the domain. I
> just find I don't have to think about it this way.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "E-Double" wrote:
> > when trying to change the sql server and sql server agent accounts using
> the
> > sql enterprise manager what is the syntax for a domain account that should
> be
> > used ( i.e. domainname/username, just username, domainname\username,
> etc... )
> > ? when attempting to add an existing domain account an error message
> keeps
> > poping-up that says 'the account (local computername)/accountname is not a
> > valid windows account' ( for some reason it thinks its a local system
> account
> > instead of a domain account ) even though sql server is installed on the
> pdc.
> > tia ...
>
>

changing sql server account using sem ...

when trying to change the sql server and sql server agent accounts using the
sql enterprise manager what is the syntax for a domain account that should b
e
used ( i.e. domainname/username, just username, domainname\username, etc...
)
? when attempting to add an existing domain account an error message keeps
poping-up that says 'the account (local computername)/accountname is not a
valid windows account' ( for some reason it thinks its a local system accoun
t
instead of a domain account ) even though sql server is installed on the pdc
.
tia ...Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using t
he
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username, etc..
. )
> ? when attempting to add an existing domain account an error message keep
s
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system acco
unt
> instead of a domain account ) even though sql server is installed on the p
dc.
> tia ...|||Yes, but the recommended approach is to do it through EM. This way all of
the necessary permissions and user rights assingments will be given
appropriately. However, using the services msc is an alternative as long as
you follow the KB article that describes manually setting all of the other
requirements.
http://support.microsoft.com/defaul...kb;en-us;283811
Sincerely,
Anthony Thomas
"mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
Hello E-Double.
I find it easiest to change the account using the services console (type
services.msc in Start>Run), that way you can browse the network and or check
the name that you enter so it will be prefixed correctly with the domain. I
just find I don't have to think about it this way.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"E-Double" wrote:

> when trying to change the sql server and sql server agent accounts using
the
> sql enterprise manager what is the syntax for a domain account that should
be
> used ( i.e. domainname/username, just username, domainname\username,
etc... )
> ? when attempting to add an existing domain account an error message
keeps
> poping-up that says 'the account (local computername)/accountname is not a
> valid windows account' ( for some reason it thinks its a local system
account
> instead of a domain account ) even though sql server is installed on the
pdc.
> tia ...|||Thanks Anthony.
regards,
Mark Baekdal
http://www.dbghost.com
+44 (0)208 241 1762
Database change management for SQL Server
"Anthony Thomas" wrote:

> Yes, but the recommended approach is to do it through EM. This way all of
> the necessary permissions and user rights assingments will be given
> appropriately. However, using the services msc is an alternative as long
as
> you follow the KB article that describes manually setting all of the other
> requirements.
> http://support.microsoft.com/defaul...kb;en-us;283811
> Sincerely,
>
> Anthony Thomas
>
> --
> "mark baekdal" <markbaekdal@.discussions.microsoft.com> wrote in message
> news:E4E1E754-CEE0-4703-9D8E-537C0994AD47@.microsoft.com...
> Hello E-Double.
> I find it easiest to change the account using the services console (type
> services.msc in Start>Run), that way you can browse the network and or che
ck
> the name that you enter so it will be prefixed correctly with the domain.
I
> just find I don't have to think about it this way.
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "E-Double" wrote:
>
> the
> be
> etc... )
> keeps
> account
> pdc.
>
>

Changing SQL and Agent Service account?

Are there any best practices recommending changing the SQL Server/Agent
domain service account password? I assume you do not want to leave these
the same forever after install, and I have a service pwd change utility
without restarting SQL server, but not seeing a lot of talk about changing
these account(s). Should they not change just like any other priveledged
user?"Brian" <bpollard@.idahodba.org> wrote in message
news:OCqXZ8KdEHA.3016@.tk2msftngp13.phx.gbl...
> Are there any best practices recommending changing the SQL Server/Agent
> domain service account password? I assume you do not want to leave these
> the same forever after install, and I have a service pwd change utility
> without restarting SQL server, but not seeing a lot of talk about changing
> these account(s). Should they not change just like any other priveledged
> user?
>
If you change these accounts it is probably easiest to do so through
Enterprise Manager. If you have not read the following paper, I recommend
it:
http://www.microsoft.com/technet/pr...n/sp3sec02.mspx
while it does not make any firm recommendation on account/password changes,
this really should default (IMO) to whatever policy is in place in the
domain. More importantly, follow the recommendation of using a "service"
account that is not local system and is not an administrator on the server.
Steve|||I guess this all depends upon your Security Policy that you have in place.
The service accounts should be running under a low privilege domain acount
and should be changed
based upon the password expiration you've set for other domain accounts.
So, yes I believe they should be changed.
Typically, you modify the account within SEM, but here's an article on how
to do it outside of SEM.
283811 How to change the SQL Server or SQL Server Agent Service account
without
http://support.microsoft.com/?id=283811
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

changing password for sql server service and sql agent service

If I change the password for sql server under the server/properties/security
tab and for sql agent under sql server agent/properties/general tab do I
still have to change the password in windows services? Or does changing the
passwords within em also change the password in services?
But if I change the passwords in windows services do I also have to change
the passwords in sql server?
Thanks,
Dan D.
Always change them in Enterprise Manager. That is enough. You don't have to
change them again from Services.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
> If I change the password for sql server under the
> server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing
> the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.
|||> If I change the password for sql server under the server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing the
> passwords within em also change the password in services?
Yes it does.

> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
No, but it is recommended to do this using SQLEM. There are other things
that EM does regarding to this operation. Read the "Important" note at the
end.
Changing Passwords and User Accounts
http://msdn.microsoft.com/library/de...stall_4p0z.asp
AMB
"Dan D." wrote:

> If I change the password for sql server under the server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.
|||I did try to change the password in sql agent/properties after changing the
password for sql agent in services and I got this message:
"SQL Server Agent start-up account could not be verifited."
Do you think it means that the password entered in SQL Agent/Properties and
the password entered in the SQL Agent service were not the same?
Thanks,
Dan D.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Yes it does.
>
> No, but it is recommended to do this using SQLEM. There are other things
> that EM does regarding to this operation. Read the "Important" note at the
> end.
> Changing Passwords and User Accounts
> http://msdn.microsoft.com/library/de...stall_4p0z.asp
>
> AMB
> "Dan D." wrote:
|||Dan,
Sorry, no idea.
AMB
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
|||Thanks.
Dan D.
"Narayana Vyas Kondreddi" wrote:

> Always change them in Enterprise Manager. That is enough. You don't have to
> change them again from Services.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
>
>
|||Are the two services using the same service account? I could imagine that if they aren't, then SQL
Server cannot verify the password for another account (Agent).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...[vbcol=seagreen]
>I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
|||The sql server service and the sql agen tservice are using different
accounts. But the account that the sql agent servce is using and the account
under sql agent/properties/general tab are the same.
Dan D.
"Tibor Karaszi" wrote:

> Are the two services using the same service account? I could imagine that if they aren't, then SQL
> Server cannot verify the password for another account (Agent).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...
>
|||Hello, I'm Legacy. I have no idea what sql server is, but could someone
please tell me how to change my password.
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:

changing password for sql server service and sql agent service

If I change the password for sql server under the server/properties/security
tab and for sql agent under sql server agent/properties/general tab do I
still have to change the password in windows services? Or does changing the
passwords within em also change the password in services?
But if I change the passwords in windows services do I also have to change
the passwords in sql server?
Thanks,
--
Dan D.Always change them in Enterprise Manager. That is enough. You don't have to
change them again from Services.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
> If I change the password for sql server under the
> server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing
> the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||> If I change the password for sql server under the server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing the
> passwords within em also change the password in services?
Yes it does.
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
No, but it is recommended to do this using SQLEM. There are other things
that EM does regarding to this operation. Read the "Important" note at the
end.
Changing Passwords and User Accounts
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
AMB
"Dan D." wrote:
> If I change the password for sql server under the server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||I did try to change the password in sql agent/properties after changing the
password for sql agent in services and I got this message:
"SQL Server Agent start-up account could not be verifited."
Do you think it means that the password entered in SQL Agent/Properties and
the password entered in the SQL Agent service were not the same?
Thanks,
--
Dan D.
"Alejandro Mesa" wrote:
> > If I change the password for sql server under the server/properties/security
> > tab and for sql agent under sql server agent/properties/general tab do I
> > still have to change the password in windows services? Or does changing the
> > passwords within em also change the password in services?
> Yes it does.
> > But if I change the passwords in windows services do I also have to change
> > the passwords in sql server?
> No, but it is recommended to do this using SQLEM. There are other things
> that EM does regarding to this operation. Read the "Important" note at the
> end.
> Changing Passwords and User Accounts
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
>
> AMB
> "Dan D." wrote:
> > If I change the password for sql server under the server/properties/security
> > tab and for sql agent under sql server agent/properties/general tab do I
> > still have to change the password in windows services? Or does changing the
> > passwords within em also change the password in services?
> >
> > But if I change the passwords in windows services do I also have to change
> > the passwords in sql server?
> >
> > Thanks,
> > --
> > Dan D.|||Dan,
Sorry, no idea.
AMB
"Dan D." wrote:
> I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
> > > If I change the password for sql server under the server/properties/security
> > > tab and for sql agent under sql server agent/properties/general tab do I
> > > still have to change the password in windows services? Or does changing the
> > > passwords within em also change the password in services?
> >
> > Yes it does.
> >
> > > But if I change the passwords in windows services do I also have to change
> > > the passwords in sql server?
> >
> > No, but it is recommended to do this using SQLEM. There are other things
> > that EM does regarding to this operation. Read the "Important" note at the
> > end.
> >
> > Changing Passwords and User Accounts
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
> >
> >
> > AMB
> >
> > "Dan D." wrote:
> >
> > > If I change the password for sql server under the server/properties/security
> > > tab and for sql agent under sql server agent/properties/general tab do I
> > > still have to change the password in windows services? Or does changing the
> > > passwords within em also change the password in services?
> > >
> > > But if I change the passwords in windows services do I also have to change
> > > the passwords in sql server?
> > >
> > > Thanks,
> > > --
> > > Dan D.|||Thanks.
--
Dan D.
"Narayana Vyas Kondreddi" wrote:
> Always change them in Enterprise Manager. That is enough. You don't have to
> change them again from Services.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
> > If I change the password for sql server under the
> > server/properties/security
> > tab and for sql agent under sql server agent/properties/general tab do I
> > still have to change the password in windows services? Or does changing
> > the
> > passwords within em also change the password in services?
> >
> > But if I change the passwords in windows services do I also have to change
> > the passwords in sql server?
> >
> > Thanks,
> > --
> > Dan D.
>
>|||Are the two services using the same service account? I could imagine that if they aren't, then SQL
Server cannot verify the password for another account (Agent).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...
>I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>> > If I change the password for sql server under the server/properties/security
>> > tab and for sql agent under sql server agent/properties/general tab do I
>> > still have to change the password in windows services? Or does changing the
>> > passwords within em also change the password in services?
>> Yes it does.
>> > But if I change the passwords in windows services do I also have to change
>> > the passwords in sql server?
>> No, but it is recommended to do this using SQLEM. There are other things
>> that EM does regarding to this operation. Read the "Important" note at the
>> end.
>> Changing Passwords and User Accounts
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
>>
>> AMB
>> "Dan D." wrote:
>> > If I change the password for sql server under the server/properties/security
>> > tab and for sql agent under sql server agent/properties/general tab do I
>> > still have to change the password in windows services? Or does changing the
>> > passwords within em also change the password in services?
>> >
>> > But if I change the passwords in windows services do I also have to change
>> > the passwords in sql server?
>> >
>> > Thanks,
>> > --
>> > Dan D.|||The sql server service and the sql agen tservice are using different
accounts. But the account that the sql agent servce is using and the account
under sql agent/properties/general tab are the same.
--
Dan D.
"Tibor Karaszi" wrote:
> Are the two services using the same service account? I could imagine that if they aren't, then SQL
> Server cannot verify the password for another account (Agent).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...
> >I did try to change the password in sql agent/properties after changing the
> > password for sql agent in services and I got this message:
> >
> > "SQL Server Agent start-up account could not be verifited."
> >
> > Do you think it means that the password entered in SQL Agent/Properties and
> > the password entered in the SQL Agent service were not the same?
> >
> > Thanks,
> >
> > --
> > Dan D.
> >
> >
> > "Alejandro Mesa" wrote:
> >
> >> > If I change the password for sql server under the server/properties/security
> >> > tab and for sql agent under sql server agent/properties/general tab do I
> >> > still have to change the password in windows services? Or does changing the
> >> > passwords within em also change the password in services?
> >>
> >> Yes it does.
> >>
> >> > But if I change the passwords in windows services do I also have to change
> >> > the passwords in sql server?
> >>
> >> No, but it is recommended to do this using SQLEM. There are other things
> >> that EM does regarding to this operation. Read the "Important" note at the
> >> end.
> >>
> >> Changing Passwords and User Accounts
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
> >>
> >>
> >> AMB
> >>
> >> "Dan D." wrote:
> >>
> >> > If I change the password for sql server under the server/properties/security
> >> > tab and for sql agent under sql server agent/properties/general tab do I
> >> > still have to change the password in windows services? Or does changing the
> >> > passwords within em also change the password in services?
> >> >
> >> > But if I change the passwords in windows services do I also have to change
> >> > the passwords in sql server?
> >> >
> >> > Thanks,
> >> > --
> >> > Dan D.
>|||Hello, I'm Legacy. I have no idea what sql server is, but could someone
please tell me how to change my password.
"Dan D." wrote:
> I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties and
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
> > > If I change the password for sql server under the server/properties/security
> > > tab and for sql agent under sql server agent/properties/general tab do I
> > > still have to change the password in windows services? Or does changing the
> > > passwords within em also change the password in services?
> >
> > Yes it does.
> >
> > > But if I change the passwords in windows services do I also have to change
> > > the passwords in sql server?
> >
> > No, but it is recommended to do this using SQLEM. There are other things
> > that EM does regarding to this operation. Read the "Important" note at the
> > end.
> >
> > Changing Passwords and User Accounts
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_4p0z.asp
> >
> >
> > AMB
> >
> > "Dan D." wrote:
> >
> > > If I change the password for sql server under the server/properties/security
> > > tab and for sql agent under sql server agent/properties/general tab do I
> > > still have to change the password in windows services? Or does changing the
> > > passwords within em also change the password in services?
> > >
> > > But if I change the passwords in windows services do I also have to change
> > > the passwords in sql server?
> > >
> > > Thanks,
> > > --
> > > Dan D.

changing password for sql server service and sql agent service

If I change the password for sql server under the server/properties/security
tab and for sql agent under sql server agent/properties/general tab do I
still have to change the password in windows services? Or does changing the
passwords within em also change the password in services?
But if I change the passwords in windows services do I also have to change
the passwords in sql server?
Thanks,
--
Dan D.Always change them in Enterprise Manager. That is enough. You don't have to
change them again from Services.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
> If I change the password for sql server under the
> server/properties/security
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing
> the
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||> If I change the password for sql server under the server/properties/securityn">
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing th
e
> passwords within em also change the password in services?
Yes it does.

> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
No, but it is recommended to do this using SQLEM. There are other things
that EM does regarding to this operation. Read the "Important" note at the
end.
Changing Passwords and User Accounts
http://msdn.microsoft.com/library/d...nstall_4p0z.asp
AMB
"Dan D." wrote:

> If I change the password for sql server under the server/properties/securi
ty
> tab and for sql agent under sql server agent/properties/general tab do I
> still have to change the password in windows services? Or does changing th
e
> passwords within em also change the password in services?
> But if I change the passwords in windows services do I also have to change
> the passwords in sql server?
> Thanks,
> --
> Dan D.|||I did try to change the password in sql agent/properties after changing the
password for sql agent in services and I got this message:
"SQL Server Agent start-up account could not be verifited."
Do you think it means that the password entered in SQL Agent/Properties and
the password entered in the SQL Agent service were not the same?
Thanks,
Dan D.
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Yes it does.
>
> No, but it is recommended to do this using SQLEM. There are other things
> that EM does regarding to this operation. Read the "Important" note at the
> end.
> Changing Passwords and User Accounts
> http://msdn.microsoft.com/library/d...nstall_4p0z.asp
>
> AMB
> "Dan D." wrote:
>|||Dan,
Sorry, no idea.
AMB
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing th
e
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties an
d
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>|||Thanks.
--
Dan D.
"Narayana Vyas Kondreddi" wrote:

> Always change them in Enterprise Manager. That is enough. You don't have t
o
> change them again from Services.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:EA51464A-9EFE-4B41-B397-3129AF4378FB@.microsoft.com...
>
>|||Are the two services using the same service account? I could imagine that if
they aren't, then SQL
Server cannot verify the password for another account (Agent).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...[vbcol=seagreen]
>I did try to change the password in sql agent/properties after changing the
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties an
d
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>|||The sql server service and the sql agen tservice are using different
accounts. But the account that the sql agent servce is using and the account
under sql agent/properties/general tab are the same.
--
Dan D.
"Tibor Karaszi" wrote:

> Are the two services using the same service account? I could imagine that
if they aren't, then SQL
> Server cannot verify the password for another account (Agent).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:B411CAE6-B998-4D72-A658-7943BA7BDCA5@.microsoft.com...
>|||Hello, I'm Legacy. I have no idea what sql server is, but could someone
please tell me how to change my password.
"Dan D." wrote:
[vbcol=seagreen]
> I did try to change the password in sql agent/properties after changing th
e
> password for sql agent in services and I got this message:
> "SQL Server Agent start-up account could not be verifited."
> Do you think it means that the password entered in SQL Agent/Properties an
d
> the password entered in the SQL Agent service were not the same?
> Thanks,
> --
> Dan D.
>
> "Alejandro Mesa" wrote:
>

Changing NT Passwords used by SQL Server

Dear All,
Our Server department would like to change the passwords
of our Domain User accounts used by SQL Server and SQL
Server Agent Accounts.
Can anyone tell me the impact of this and whether we need
to do anything at the SQL end.
Regards
Peter
Hi,
After changing the password of the domain os user account, you need to
change the password entry in
control panel -- Admin tools -- services -- MSSQL server (double click
miuse) -- go to "Log on" tab-- type the new password and restart the MSSQL
server service
Do the same for SQL Agent service as well.
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter
|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:#hkuRfBYEHA.2944@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After changing the password of the domain os user account, you need to
> change the password entry in
> control panel -- Admin tools -- services -- MSSQL server (double click
> miuse) -- go to "Log on" tab-- type the new password and restart the
MSSQL
> server service
I am not completely sure but I do not think that you have to restart
MSSQL server service.

> Do the same for SQL Agent service as well.
>
> --
> Thanks
> Hari
> MCDBA
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:2511801c46015$9f076c20$a401280a@.phx.gbl...
>
|||To get to the SQL AGent login in SEM right click SQL Agent and go to
properties...
I have heard of an issue with changing the password on the full text index
search service, that requires special attention, but I do not remember the
details... It seems like as long as you set the login/password via SEM
things worked, but if you did it via windows services, there was a
disconnect somehow... You might want to google it.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter
|||Thanks for all your responses, you have told me what I
need to know.
Peter

>--Original Message--
>Dear All,
>Our Server department would like to change the passwords
>of our Domain User accounts used by SQL Server and SQL
>Server Agent Accounts.
>Can anyone tell me the impact of this and whether we need
>to do anything at the SQL end.
>Regards
>Peter
>.
>

Changing NT Passwords used by SQL Server

Dear All,
Our Server department would like to change the passwords
of our Domain User accounts used by SQL Server and SQL
Server Agent Accounts.
Can anyone tell me the impact of this and whether we need
to do anything at the SQL end.
Regards
PeterHi,
After changing the password of the domain os user account, you need to
change the password entry in
control panel -- Admin tools -- services -- MSSQL server (double click
miuse) -- go to "Log on" tab-- type the new password and restart the MSSQL
server service
Do the same for SQL Agent service as well.
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter|||"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:#hkuRfBYEHA.2944@.TK2MSFTNGP11.phx.gbl...
> Hi,
> After changing the password of the domain os user account, you need to
> change the password entry in
> control panel -- Admin tools -- services -- MSSQL server (double click
> miuse) -- go to "Log on" tab-- type the new password and restart the
MSSQL
> server service
I am not completely sure but I do not think that you have to restart
MSSQL server service.
> Do the same for SQL Agent service as well.
>
> --
> Thanks
> Hari
> MCDBA
> "Peter" <anonymous@.discussions.microsoft.com> wrote in message
> news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> > Dear All,
> > Our Server department would like to change the passwords
> > of our Domain User accounts used by SQL Server and SQL
> > Server Agent Accounts.
> >
> > Can anyone tell me the impact of this and whether we need
> > to do anything at the SQL end.
> >
> > Regards
> > Peter
>|||To get to the SQL AGent login in SEM right click SQL Agent and go to
properties...
I have heard of an issue with changing the password on the full text index
search service, that requires special attention, but I do not remember the
details... It seems like as long as you set the login/password via SEM
things worked, but if you did it via windows services, there was a
disconnect somehow... You might want to google it.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:2511801c46015$9f076c20$a401280a@.phx.gbl...
> Dear All,
> Our Server department would like to change the passwords
> of our Domain User accounts used by SQL Server and SQL
> Server Agent Accounts.
> Can anyone tell me the impact of this and whether we need
> to do anything at the SQL end.
> Regards
> Peter|||Thanks for all your responses, you have told me what I
need to know.
Peter
>--Original Message--
>Dear All,
>Our Server department would like to change the passwords
>of our Domain User accounts used by SQL Server and SQL
>Server Agent Accounts.
>Can anyone tell me the impact of this and whether we need
>to do anything at the SQL end.
>Regards
>Peter
>.
>

Changing name on Sql server

I change the name on my SQL2005 server, after that i run sp_dropserver and
sp_addserver, but when i tru do delete som sql agent job or create new one
iam getting error:"An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused
by the fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server) (.Net SqlClient Data Provider)"
any help please
Did you restarted SQL when you changed SQL names?
And also one thing ... did you executed
"sp_addserver 'servername', local"?
"Viktor" <serguienkov@.hotmail.com> wrote in message
news:ef9Sza%23yHHA.1776@.TK2MSFTNGP03.phx.gbl...
>I change the name on my SQL2005 server, after that i run sp_dropserver and
>sp_addserver, but when i tru do delete som sql agent job or create new one
>iam getting error:"An error has occurred while establishing a connection to
>the server. When connecting to SQL Server 2005, this failure may be caused
>by the fact that under the default settings SQL Server does not allow
>remote connections. (provider: Named Pipes Provider, error: 40 - Could not
>open a connection to SQL Server) (.Net SqlClient Data Provider)"
> any help please
>

Changing name on Sql server

I change the name on my SQL2005 server, after that i run sp_dropserver and
sp_addserver, but when i tru do delete som sql agent job or create new one
iam getting error:"An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused
by the fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server) (.Net SqlClient Data Provider)"
any help pleaseDid you restarted SQL when you changed SQL names?
And also one thing ... did you executed
"sp_addserver 'servername', local"?
"Viktor" <serguienkov@.hotmail.com> wrote in message
news:ef9Sza%23yHHA.1776@.TK2MSFTNGP03.phx.gbl...
>I change the name on my SQL2005 server, after that i run sp_dropserver and
>sp_addserver, but when i tru do delete som sql agent job or create new one
>iam getting error:"An error has occurred while establishing a connection to
>the server. When connecting to SQL Server 2005, this failure may be caused
>by the fact that under the default settings SQL Server does not allow
>remote connections. (provider: Named Pipes Provider, error: 40 - Could not
>open a connection to SQL Server) (.Net SqlClient Data Provider)"
> any help please
>

Changing name on Sql server

I change the name on my SQL2005 server, after that i run sp_dropserver and
sp_addserver, but when i tru do delete som sql agent job or create new one
iam getting error:"An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused
by the fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server) (.Net SqlClient Data Provider)"
any help pleaseDid you restarted SQL when you changed SQL names?
And also one thing ... did you executed
"sp_addserver 'servername', local"?
"Viktor" <serguienkov@.hotmail.com> wrote in message
news:ef9Sza%23yHHA.1776@.TK2MSFTNGP03.phx.gbl...
>I change the name on my SQL2005 server, after that i run sp_dropserver and
>sp_addserver, but when i tru do delete som sql agent job or create new one
>iam getting error:"An error has occurred while establishing a connection to
>the server. When connecting to SQL Server 2005, this failure may be caused
>by the fact that under the default settings SQL Server does not allow
>remote connections. (provider: Named Pipes Provider, error: 40 - Could not
>open a connection to SQL Server) (.Net SqlClient Data Provider)"
> any help please
>

changing merge agent profile for HTTPS - mergeSubscriberType = anonymous

Hi

We are using HTTPS merge replication

Our setup is as follows:

subscription.CreateSyncAgentByDefault = False -- I wrote a windows service to synchronise
subscription.UseWebSynchronization = True
subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication
subscription.SubscriberType = MergeSubscriberType.Anonymous

Some of our subscribers have low-quality internet connections - how do I get the agent at the publisher/distributer use a slower profile - I've read How to: Work with Replication Agent Profiles (Replication Transact-SQL Programming)
but can't see where you specifiy an alternate agent profile

On the distributer / publisher (same machine) I go to replication monitor -> Warnings and Agents - I can only set the profile for the snapshot agent....

thanks
Bruce

To see the various profiles, in replication monitor, right-click on a merge subscription and select Agent Profile. YOu should see various agent profiles, such as High Volume Server-to-Server Profile, Slow link agent profile, etc.

You can assign a non-default profile programmatically, look up AgentProfile Class.

|||

I right click on the merge subscription and there is no such option - is this 'cause subscription.CreateSyncAgentByDefault = False

Thanks
Bruce

|||
Bruce,

If your using RMO in your service to synchronise then try this property of the mergesynchronizationagent

mergesynchronizationagent.ProfileName = "Slow link agent profile."

Rab