February 27, 2016 at 7:28 am
Hi Team,
When I run my SSIS package directly using command utility,there are no issues.
When I execute same package via .net c# code, I get login failed for 'xxxx'.
SSIS package uses dtsconfig and there is ann element for connectionstring which is like below:
"data source=localhost;User ID=sa;Password=test123;Provider=SQLNCLI10";
Though, when I set it to "Integrated Security=SSPI;" it executes successfuly via c#.
I have to use SQL user id as this is the only login with dbcreator role.
Any pointers would be helpful.
February 27, 2016 at 7:56 am
Sorry if this is an obvious question, but has the SQL instance been set to mixed mode authentication?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
February 27, 2016 at 9:31 am
Yes, no problems with SQL instance
February 29, 2016 at 5:51 am
GonnaCatchIT (2/27/2016)
Yes, no problems with SQL instance
Did you get this working? My next suggestion would be to attempt to capture the exact command line which is being sent by the C# program and see whether that gives you any pointers.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
February 29, 2016 at 8:37 am
I am using Integrated Security = SSPI now, unable to resolve this error.
February 29, 2016 at 9:03 am
GonnaCatchIT (2/29/2016)
I am using Integrated Security = SSPI now, unable to resolve this error.
That's the better solution anyway.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply