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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply