September 16, 2005 at 10:21 am
Hi
I am trying to execute a dts package from tsql on my local install of sql server. However, I keep getting user login failed error. I am using the 'sa' username.
See dump below:
Error: -2147467259 (80004005); Provider Error: 18452 (4814)
Error string: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.
Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0
Any advice will be greatly appreciated.
Thanks
September 16, 2005 at 10:25 am
The error indincates that your trying to log in using sa (Sql server login) but it wants a trusted connection (Check the server properties to see that it is in mixed mode)
in EM Right click on Server, Select properties, Security Tab make sure on authentication the sql server, and windows option is selected.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply