I have several SQL Server instances. All of them are setup in the same domain, and have been working for years. One of these instances serves as an aggregator for the data of the others, and a sync service has been taking care of this for years. What was not setup before I got here was server maintenance, and centralized reporting from the aggregator.
To tackle this, I setup linked servers on the aggregator pointing to each of the other servers to enable central call to remote maintenance procedures.
The linked servers have mapped credentials using both Windows and SQL logins on both sides for various purposes, but now one of them isn’t working when I’m trying to set it up.
There’s a SQL login being setup on all servers with identical rights, let’s call it “Maint”.
The aggregator runs a job, which calls a remote procedure. The job uses “Maint” as the user, and the linked server passes this through to login as “Maint” on the remote server. These users have identical passwords. The job always fails with a login failure for “Maint” with the logs indicating mismatched password.
- The only other consideration is the job’s step is doing a direct EXEC call to the remote procedure, so “EXEC [RemoteServer].master.dbo.ProcName ‘paramValue'”, if this matters.
Things I’ve tried:
Setting the passwords again using a copy/pasted string to the aggregator and the test server multiple times.
Setting the Linked Server Properties to pass through current credentials, and alternately explicitly adding “Maint” to the remote login mappings using the copy/pasted password explicitly
Logging in manually to both servers as “Maint” using the copy/pasted password, and had both succeed.
Any ideas on what’s causing the linked server functionality when run from a job go sideways like this? Other jobs work just fine.
✓ Extra quality
ExtraProxies brings the best proxy quality for you with our private and reliable proxies
✓ Extra anonymity
Top level of anonymity and 100% safe proxies – this is what you get with every proxy package
✓ Extra speed
1,ooo mb/s proxy servers speed – we are way better than others – just enjoy our proxies!
USA proxy location
We offer premium quality USA private proxies – the most essential proxies you can ever want from USA
Our proxies have TOP level of anonymity + Elite quality, so you are always safe and secure with your proxies
Use your proxies as much as you want – we have no limits for data transfer and bandwidth, unlimited usage!
Superb fast proxy servers with 1,000 mb/s speed – sit back and enjoy your lightning fast private proxies!
99,9% servers uptime
Alive and working proxies all the time – we are taking care of our servers so you can use them without any problems
No usage restrictions
You have freedom to use your proxies with every software, browser or website you want without restrictions
Perfect for SEO
We are 100% friendly with all SEO tasks as well as internet marketing – feel the power with our proxies
Buy more proxies and get better price – we offer various proxy packages with great deals and discounts
We are working 24/7 to bring the best proxy experience for you – we are glad to help and assist you!