SQL Server Conn String login failure

[bassist695]

I have a connection string that is allowing me to return a data set from a SQL Server. Here is my connection string:

"Data Source=SERVER101;Integrated Security=SSPI;Initial Catalog=HPLX3;User ID=dnbftpsvc;Password=dbflatftp"

That user is correctly set up on the server, yet when I run the application, I get an exception stating that the login failed for "user (NULL)."

Any advice?

[Edneeis]

You can't use Integrated Security=SSPI and the username and password in the same connection string. The Integrated Security=SSPI part tells it to use the currently logged in windows account for the username and password so there is no need to provide one. Either that or take the Integrated Security part out.

Actually don't take out Integrated Security just change it to Integrated Security=False.

[bassist695]

If that fixes it I will be super frustrated with myself! I'll let ya know Monday.

Thanks!

[bassist695]

Now my application is just giving me a WebException and is timing out. Yuck.

[Edneeis]

And the Web Exception is.....

Also the whole stack trace would be better.

[bassist695]

I didn't even have the correct user set up in SQL Server...that was my problem...

~Mike