Toad World® Forums

Copy/Move Database - will not start SQLAgent in the correct SQL Server Instance.


#1

Copy/Move Database - will not start SQLAgent in
the correct SQL Server Instance.


#2

Hello Hank,

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

Thanks,

Pavel
image006.jpeg


#3

Hello Hank,

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

Thanks,

Pavel
image001.jpeg


#4

Hello Hank,

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

Thanks,

Pavel
image002.jpeg


#5

Hello Hank,

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

Thanks,

Pavel
image001.gif


#6

Hello Hank,

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

Thanks,

Pavel
image002.jpeg


#7

Hello Hank,

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

Thanks,

Pavel
image003.png


#8

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

@Hank, Yes I can manually start any server instance from the Services
Dialog… It does not start with an error !!!

The error happens when the Wizard is either trying to start the service…
Remember the 2005 instances is named and I believe the wizard is trying to start
the default instance SQL Server Agent and it cannot because the SQL Server
instance (default) is not started, thus the error.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image001.gif


#9

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

@Hank, Yes I can manually start any server instance from the Services
Dialog… It does not start with an error !!!

The error happens when the Wizard is either trying to start the service…
Remember the 2005 instances is named and I believe the wizard is trying to start
the default instance SQL Server Agent and it cannot because the SQL Server
instance (default) is not started, thus the error.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image002.jpeg


#10

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

@Hank, Yes I can manually start any server instance from the Services
Dialog… It does not start with an error !!!

The error happens when the Wizard is either trying to start the service…
Remember the 2005 instances is named and I believe the wizard is trying to start
the default instance SQL Server Agent and it cannot because the SQL Server
instance (default) is not started, thus the error.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image006.jpeg


#11

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

@Hank, Yes I can manually start any server instance from the Services
Dialog… It does not start with an error !!!

The error happens when the Wizard is either trying to start the service…
Remember the 2005 instances is named and I believe the wizard is trying to start
the default instance SQL Server Agent and it cannot because the SQL Server
instance (default) is not started, thus the error.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image001.jpeg


#12

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

@Hank, Yes I can manually start any server instance from the Services
Dialog… It does not start with an error !!!

The error happens when the Wizard is either trying to start the service…
Remember the 2005 instances is named and I believe the wizard is trying to start
the default instance SQL Server Agent and it cannot because the SQL Server
instance (default) is not started, thus the error.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image003.png


#13

Need to clarify – can you manually start SQL Server Agent (SS_2005_DEV)
from the Services dialog? Does It start without error?

@Hank, Yes I can manually start any server instance from the Services
Dialog… It does not start with an error !!!

The error happens when the Wizard is either trying to start the service…
Remember the 2005 instances is named and I believe the wizard is trying to start
the default instance SQL Server Agent and it cannot because the SQL Server
instance (default) is not started, thus the error.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678-414-0090 my cell Primary
image002.jpeg


#14

Hi Hank,

I still cannot reproduce this issue and I need more details.

“Yes I can manually start any server instance from the Services
Dialog”

And what about agents?

Could you please also attempt to start/stop Agents from Toad’s Object
Explorer?

Are your SQL Server and Toad locates on different physical machines?

Could you please provide me your Copy/Move details using following templates?
image003.png


#15

Hi Hank,

I still cannot reproduce this issue and I need more details.

“Yes I can manually start any server instance from the Services
Dialog”

And what about agents?

Could you please also attempt to start/stop Agents from Toad’s Object
Explorer?

Are your SQL Server and Toad locates on different physical machines?

Could you please provide me your Copy/Move details using following templates?
image001.gif


#16

Hi Hank,

I still cannot reproduce this issue and I need more details.

“Yes I can manually start any server instance from the Services
Dialog”

And what about agents?

Could you please also attempt to start/stop Agents from Toad’s Object
Explorer?

Are your SQL Server and Toad locates on different physical machines?

Could you please provide me your Copy/Move details using following templates?
image002.jpeg


#17

Hi Hank,

I still cannot reproduce this issue and I need more details.

“Yes I can manually start any server instance from the Services
Dialog”

And what about agents?

Could you please also attempt to start/stop Agents from Toad’s Object
Explorer?

Are your SQL Server and Toad locates on different physical machines?

Could you please provide me your Copy/Move details using following templates?
image006.jpeg


#18

Hi Hank,

I still cannot reproduce this issue and I need more details.

“Yes I can manually start any server instance from the Services
Dialog”

And what about agents?

Could you please also attempt to start/stop Agents from Toad’s Object
Explorer?

Are your SQL Server and Toad locates on different physical machines?

Could you please provide me your Copy/Move details using following templates?
image002.jpeg


#19

Hi Hank,

I still cannot reproduce this issue and I need more details.

“Yes I can manually start any server instance from the Services
Dialog”

And what about agents?

Could you please also attempt to start/stop Agents from Toad’s Object
Explorer?

Are your SQL Server and Toad locates on different physical machines?

Could you please provide me your Copy/Move details using following templates?
image001.jpeg


#20

Pavel, if you like I show you this issue via a GoToMeeting… Your call.

If you are in St. Petersburg, we can do it on your schedule like early in the
morning. Just let me know.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn.com

678.414.0090 my cell Primary
image001.gif