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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2013-11-18 : 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\userWhen 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 AdvanceKRS39 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-11-18 : 12:36:05
|
| Is the user specifying a trusted connection/windows authentication or SQL authentication? How is the user executing the package?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Login issue