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
Showing posts with label mssqlserver. Show all posts
Showing posts with label mssqlserver. Show all posts
Tuesday, March 27, 2012
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
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
Thursday, March 22, 2012
Changing the database from MSAccess to MSSQLServer.
Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackAnswered in .newusers
Please keep your posts to one newsgreoup. What you want to do is well
documented in a few thousand different pages all over the internet
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:427EBA98-380A-42EC-A3C5-47097790D9F9@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack|||MS Access 2000 Migration Guide
http://www.microsoft.com/technet/pr...
/acssmgde.mspx
After porting over the tables and data, read up on the techniques for
optimizing a SQL Server application:
http://msdn.microsoft.com/library/d...
etHowTo03.asp
http://msdn.microsoft.com/library/d...
ethowto04.asp
http://msdn.microsoft.com/SQL/2000/...rf/default.aspx
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:427EBA98-380A-42EC-A3C5-47097790D9F9@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackAnswered in .newusers
Please keep your posts to one newsgreoup. What you want to do is well
documented in a few thousand different pages all over the internet
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:427EBA98-380A-42EC-A3C5-47097790D9F9@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack|||MS Access 2000 Migration Guide
http://www.microsoft.com/technet/pr...
/acssmgde.mspx
After porting over the tables and data, read up on the techniques for
optimizing a SQL Server application:
http://msdn.microsoft.com/library/d...
etHowTo03.asp
http://msdn.microsoft.com/library/d...
ethowto04.asp
http://msdn.microsoft.com/SQL/2000/...rf/default.aspx
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:427EBA98-380A-42EC-A3C5-47097790D9F9@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
Changing the database from MSAccess to MSSQLServer.
Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack
see the response in .newusers
Please only post the same question to one group...
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:4C0633A4-44A2-402B-8C6B-91A646D8B988@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
sql
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack
see the response in .newusers
Please only post the same question to one group...
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.expertsrt.com - not your average tech Q&A site
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:4C0633A4-44A2-402B-8C6B-91A646D8B988@.microsoft.com...
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from
> MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
sql
Changing the database from MSAccess to MSSQLServer.
Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack
Hi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
Jack
Hi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
Changing the database from MSAccess to MSSQLServer.
Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackHi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Acce
ss
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackHi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Acce
ss
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
Changing the database from MSAccess to MSSQLServer.
Hello all,
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackHi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
I got a application which is developed using VB6.0 as front end and
MS-Access as backend. Now i would like to change the database from MS-Access
to MS-SQLserver.
How do I change the databse from MS-Access to MS-SQLServer?
Regards
JackHi Jack
You don't say which version of SQL Server you wish to upgrade to?
The guys in the Access newsgroup tend to have their own opinons regarding
the Access upgrade wizard so you may want to ask in there!
The upgrade wizard may provide enough to upgrade your database but then you
should look at tuning and re-writing the code so that it is more compatible
with SQL server, such as choosing more appropriate data types etc.
As an alternative you can do this manually and piecemeal using the Import
Wizard in SQL server (i.e DTS/SSIS).
Before you try anything make sure that you have a recoverable backup. It
will be worthwhile honing the upgrade on a separate system before attempting
anything on the live database.
John
"Jack" wrote:
> Hello all,
> I got a application which is developed using VB6.0 as front end and
> MS-Access as backend. Now i would like to change the database from MS-Access
> to MS-SQLserver.
> How do I change the databse from MS-Access to MS-SQLServer?
> Regards
> Jack
Tuesday, March 20, 2012
changing sql server service account password
SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes.
We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT
services use.
When I change the password for this account in active directory, I also
changed the password for the services in the Services properties on both
cluster nodes
The services Startup Type has to be Manual, or else the following error
occurs:
"17050: initerrlog: could not open error log file ... (the correct path
to the error log follows)"
The error log is on the shared drive of the cluster.
Also, when the servers boot up, the following error is in Event Viewer:
"The Data portion of event 19002 from MSSQLServer is invalid"
Microsoft (Q230393) says this is a bug and ignore it, but it didn't occur
until I changed the password.
Are these normal consequences of changing the account password?
Are there other steps I should take?
Thanks
Bill
Go back into Enterprise Manager and change the service accounts there. That
will fix any permissions and setup issues. Service startup type as Manual
is correct. That allows the cluster service to control the actual service
start/stop.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"bill" <belgie@.datamti.com> wrote in message
news:uOYfAolLFHA.904@.tk2msftngp13.phx.gbl...
> SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes.
> We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT
> services use.
> When I change the password for this account in active directory, I also
> changed the password for the services in the Services properties on both
> cluster nodes
> The services Startup Type has to be Manual, or else the following error
> occurs:
> "17050: initerrlog: could not open error log file ... (the correct path
> to the error log follows)"
> The error log is on the shared drive of the cluster.
> Also, when the servers boot up, the following error is in Event Viewer:
> "The Data portion of event 19002 from MSSQLServer is invalid"
> Microsoft (Q230393) says this is a bug and ignore it, but it didn't occur
> until I changed the password.
> Are these normal consequences of changing the account password?
> Are there other steps I should take?
> Thanks
> Bill
>
>
We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT
services use.
When I change the password for this account in active directory, I also
changed the password for the services in the Services properties on both
cluster nodes
The services Startup Type has to be Manual, or else the following error
occurs:
"17050: initerrlog: could not open error log file ... (the correct path
to the error log follows)"
The error log is on the shared drive of the cluster.
Also, when the servers boot up, the following error is in Event Viewer:
"The Data portion of event 19002 from MSSQLServer is invalid"
Microsoft (Q230393) says this is a bug and ignore it, but it didn't occur
until I changed the password.
Are these normal consequences of changing the account password?
Are there other steps I should take?
Thanks
Bill
Go back into Enterprise Manager and change the service accounts there. That
will fix any permissions and setup issues. Service startup type as Manual
is correct. That allows the cluster service to control the actual service
start/stop.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
"bill" <belgie@.datamti.com> wrote in message
news:uOYfAolLFHA.904@.tk2msftngp13.phx.gbl...
> SQL Server 2000 running on W2K3 Advanced Server Cluster with 2 nodes.
> We have a domain level account which the MSSQLSERVER and SQLSERVERAGENT
> services use.
> When I change the password for this account in active directory, I also
> changed the password for the services in the Services properties on both
> cluster nodes
> The services Startup Type has to be Manual, or else the following error
> occurs:
> "17050: initerrlog: could not open error log file ... (the correct path
> to the error log follows)"
> The error log is on the shared drive of the cluster.
> Also, when the servers boot up, the following error is in Event Viewer:
> "The Data portion of event 19002 from MSSQLServer is invalid"
> Microsoft (Q230393) says this is a bug and ignore it, but it didn't occur
> until I changed the password.
> Are these normal consequences of changing the account password?
> Are there other steps I should take?
> Thanks
> Bill
>
>
Sunday, March 11, 2012
Changing services on different account....
If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
SmithHi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
are[vbcol=seagreen]
>
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
SmithHi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
are[vbcol=seagreen]
>
Changing services on different account....
If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
Smith
Hi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>
|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
are
>
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
Smith
Hi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>
|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
are
>
Changing services on different account....
If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
SmithHi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> > If I change the login account for MSSQLSERVER and SQLSERVERAGENT what
are
> > all the things that I should cross check to make sure that everything is
> > fine and smooth transition.
> >
> > 1. All scheduled job on SQL Server.
> >
> > Any thing else I am missing in the above list?
> >
> > SQL 2K.
> >
> > Thanks,
> >
> > Smith
> >
> >
> >
>
all the things that I should cross check to make sure that everything is
fine and smooth transition.
1. All scheduled job on SQL Server.
Any thing else I am missing in the above list?
SQL 2K.
Thanks,
SmithHi,
If you are changing to an Login account which has got the identical
privilege as old account then there is
no issues.
Thanks
Hari
SQL Server MVP
"Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> If I change the login account for MSSQLSERVER and SQLSERVERAGENT what are
> all the things that I should cross check to make sure that everything is
> fine and smooth transition.
> 1. All scheduled job on SQL Server.
> Any thing else I am missing in the above list?
> SQL 2K.
> Thanks,
> Smith
>
>|||Thank you.
Smith
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eWaK7yZgFHA.572@.TK2MSFTNGP14.phx.gbl...
> Hi,
> If you are changing to an Login account which has got the identical
> privilege as old account then there is
> no issues.
> Thanks
> Hari
> SQL Server MVP
> "Govardhan Smith" <Gov_Smith@.hotmail.com> wrote in message
> news:%23L0deuZgFHA.2700@.TK2MSFTNGP15.phx.gbl...
> > If I change the login account for MSSQLSERVER and SQLSERVERAGENT what
are
> > all the things that I should cross check to make sure that everything is
> > fine and smooth transition.
> >
> > 1. All scheduled job on SQL Server.
> >
> > Any thing else I am missing in the above list?
> >
> > SQL 2K.
> >
> > Thanks,
> >
> > Smith
> >
> >
> >
>
Saturday, February 25, 2012
Changing Name of Host Server Box and MSDE
Please help!
I have changed the name of my Win2KAS Server box and cannot find out how to
get the MSDE MSSQLServer Service to start back up.
MSDE was installed as part of Crystal Enterprise, so I do not have ANY
source CD's to use. I cannot find a "setup.exe" file to re-run either.
Any help would be appreciated.
Thanks in advance...
Hi
What does the NT Event log say? It is a login failure, a Crystal failure etc?
Regards
Mike
"jmr" wrote:
> Please help!
> I have changed the name of my Win2KAS Server box and cannot find out how to
> get the MSDE MSSQLServer Service to start back up.
> MSDE was installed as part of Crystal Enterprise, so I do not have ANY
> source CD's to use. I cannot find a "setup.exe" file to re-run either.
> Any help would be appreciated.
> Thanks in advance...
I have changed the name of my Win2KAS Server box and cannot find out how to
get the MSDE MSSQLServer Service to start back up.
MSDE was installed as part of Crystal Enterprise, so I do not have ANY
source CD's to use. I cannot find a "setup.exe" file to re-run either.
Any help would be appreciated.
Thanks in advance...
Hi
What does the NT Event log say? It is a login failure, a Crystal failure etc?
Regards
Mike
"jmr" wrote:
> Please help!
> I have changed the name of my Win2KAS Server box and cannot find out how to
> get the MSDE MSSQLServer Service to start back up.
> MSDE was installed as part of Crystal Enterprise, so I do not have ANY
> source CD's to use. I cannot find a "setup.exe" file to re-run either.
> Any help would be appreciated.
> Thanks in advance...
Subscribe to:
Posts (Atom)