Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Could Active Directory Be Causing a connection manager to point to wrong server


Could Active Directory Be Causing a connection manager to point to wrong server

Author
Message
dndaughtery
dndaughtery
SSC-Addicted
SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)

Group: General Forum Members
Points: 456 Visits: 1071
I have a connection manager that is getting its connection string from table. I've checked the table several times and the configuration is correct. I set the server to a server named MyServer and the database named MyDatabase. WhenI run this package on laptop which points to the same configuration table as the package that resides on my qa server, I get the correct record counts from the source "MyServer server and MyDatabase" but when I run it from the qa server in a job I get more records than I should. I've checked the configuration tab for the job and its blank. Could it be that Active Directory could be mapping the MyServer name to another server with a database called MyDatabase?
anthony.green
anthony.green
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6102 Visits: 6078
Not AD, but DNS could.

If your machine uses one set of DNS servers and the QA server uses another set, then yes you could potentially have a mismatch of DNS entries.

Speak to your network guys/server admins, to find out if your DNS servers differ from your QA servers, and if they do find out what MyServer they both want to connect to.


Edit: Also check for entries in yours and the servers host files, which will bypass DNS and send the connection somewhere else



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


dndaughtery
dndaughtery
SSC-Addicted
SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)SSC-Addicted (456 reputation)

Group: General Forum Members
Points: 456 Visits: 1071
Could this happen even if Im using the server name?
anthony.green
anthony.green
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: General Forum Members
Points: 6102 Visits: 6078
Yes, as with anything networking it needs an IP address not a hostname, so your DNS servers handle the hostname to IP address lookup for you.

If your laptop is using DNS server 10.0.1.1 and your servers are using 192.168.1.1 and they both have an entry for MyServer, your DNS server could say well MyServer is on IP 10.45.6.7, while the servers DNS server may say that MyServer is on 192.168.34.6. So you will go to two different servers depending where your running the package from.

So you will need to double check if both your laptop and your servers are sharing the same DNS servers, if they are, then there is something else going on like hostfile entires which will bypass your DNS servers, or even something like DNS caching where either one of you have the wrong IP stored in your DNS cache, or something more sinister is happening.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
When a question, really isn't a question - Jeff Smith
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search