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 |
|
fcoreyesv
Starting Member
18 Posts |
 Posted - 2006-05-26 : 11:23:23
|
| Hello,I am creating some DTS packages to create flat files. The person is going to use those packages does not have experience in SQL server and I am having problems to execute the packages.I am using a trusted connection to create the packages but I am getting the following error when I try to run it."Error Source: Microsoft OLE DB Provider for SQL Server""Error Description: Login Failed for user 'Administrator. Reason: Not associated with a trusted SQl Server connection"Any help will be appreciated,Jose |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-26 : 12:48:50
|
| Brett, the service account is only relevant for jobs. Jose,Is this error coming from a job or just by executing the package in Enterprise Manager? If it's not from a job, then read on...You said you are using a trusted connection to create the packages, but are you using a trusted connection inside the data source?Is Administrator a SQL account or a Windows account? If it's a SQL account, did you specify Mixed Mode authentication when SQL Server was installed? If not, then that's the problem. To fix it:Open Enterprise ManagerRight click on the server name and click PropertiesSelect the Security tab For "Authentication", select "SQL Server and Windows"You will need to restart SQL Server for the change to take effect.Tara Kizeraka tduggan |
 |
|
|
fcoreyesv
Starting Member
18 Posts |
Posted - 2006-05-26 : 13:20:28
|
| Thank you, it works now...you are the best :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-26 : 13:22:10
|
| Could you let us know what fixed the problem in case someone has the same problem in the future we can refer to this thread?Tara Kizeraka tduggan |
|
|
|
|
|
|
Issue with User