Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dootam
Starting Member
1 Post |
 Posted - 2015-04-16 : 04:22:12
|
| I have a SQL Server 2012 (SSDB01) with two instances of database engine running (INSTA and INSTB).I created a linked server in INSTA and was able to copy data from a table in INSTB, using the following:INSERT INTO [INSTA].dbo.myTable SELECT * FROM [SSDB01\INSTB].DOMIN.dbo.RM00101It executed without error, but when I try to automate this by creating a Maintenance Plan to run at 10:00 PM, the above failed with the following:Error number: -1073548784Error message: Executing the query "INSERT INTO [INSTA].dbo.myTable SELECT *..." failed with the following error: "Login failed for user 'CORP\\SSDB01$'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.CORP is the domainApparently the Maintenance Plan uses a different credential than when executing the T-SQL in a query; how can I fix this? I appreciate any suggestions / help. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-04-16 : 12:31:28
|
| Provide the permissions to the SQL Server service account. It needs access to the server that's configured in the linked server.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Help with maintenance plan