Posting Yak Master
Posted - 11/18/2013 : 03:29:00
| HI Experts,
Need a help, one of our user is trying to access the DTS package, he got all the access on the database and he got execute access for DTS packages, but when he is trying to connect or execute the package he is getting the below error
Login Failed for user ‘XXX\user
When I checked in the error log I found this
Error: 18456, Severity: 14, State: 11.
Login failed for user 'XXX\user'. [CLIENT: <named pipe>]’
The user is having domain account where the SQL services are running under local, can you please help me how to over come this issue.
Thank You All In Advance