sql server agent issue

I am trying to configure log shipping between for two databases one being primary in DomainA and Secondary in domain2. But after a day the 2 different domains became one single domain (Domain A). so now the primary and the secondary are in the single domain. But for some reason the LS alert job on the secondary instance is trying to connect to the server in the earlier different domain(DomainB) and the job is failing , and hence even the copy job is failing. I am not sure if this is dns resolution or something like that, that its still looking connect to server in the domain that does not exist. Any help is appreciated. I am not sure which direction to go in now?

  • Error: Failed to connect to server DomainB\Instance.(Microsoft.SqlServer.ConnectionInfo) 2012-10-18 09:45:16.79 Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)(.Net SqlClient Data Provider) ***

more ▼

asked Oct 18, 2012 at 01:52 PM in Default

avatar image

Katie 1
1.4k 132 164 205

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

If domains have changed then you may need to review security on the location where the backups are stored. Has either SQL server been restarted since the domain changes?

more ▼

answered Oct 18, 2012 at 02:16 PM

avatar image

Fatherjack ♦♦
43.8k 79 102 118

yes they have been all the services are running and security and service account info also has been validated everything seems ok.

Oct 18, 2012 at 02:29 PM Katie 1

So, I'd be looking to have rebooted at least one of the SQL servers after the domain changes took effect. Just to be sure it got the latest state of things from DNS etc. Have a Network Admin guy on standby and have your sa account and password to hand just in case it doesnt restart as you'd expect it to.

Oct 18, 2012 at 02:34 PM Fatherjack ♦♦

And remember, SQL Agent can have a different security context than the rest of the server and that might affect things.

Oct 18, 2012 at 03:16 PM Grant Fritchey ♦♦

it seems like while changing the domain name also changed the computer name and thats the reason it was showing as an error.

Oct 18, 2012 at 09:00 PM Katie 1

@Katie - Yup... FQDN includes Domain.

Oct 19, 2012 at 01:51 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left

If you are fully qualifying the servers servera.domaina.xxx and serverb.domainb.xxx then when serverb joined domainA then the FQDN changed. If a DNS recorded was not created to enable name resolution then this would start failing. You can update the entry in MSDB or simply remove log shipping and set it back up again.

more ▼

answered Oct 18, 2012 at 11:55 PM

avatar image

40.9k 39 95 168

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 18, 2012 at 01:52 PM

Seen: 913 times

Last Updated: Oct 19, 2012 at 01:51 PM

Copyright 2018 Redgate Software. Privacy Policy