March 2, 2009 at 9:02 pm
Hi,
I am getting a following error message while running the System Db backup using Dts package..
model_backup_20090302150004', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "The server principal "CORP\HR-DEV" is not able to access the database "model" under the current security context. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2009-03-02 15:00:04.66 Code: 0xC002F210 Source: Back Up All System Databases Execute SQL Task Description: Executing the query "BACKUP DATABASE [,... The package execution fa... The step failed.
Do you have any idea,The same login ,i can run a single db of system db's and other application databases
March 2, 2009 at 9:39 pm
Hi Shine,
Looks like the Service Principal Name (SPN) for SQL Server is missing. I feel instead of the the server name, if you use localhost\InstanceName or .\Instance name, the package will succeed.
To fix this issue you may want to use the SetSPN tool. You can find more info about SPN here
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply