I've developed an ASP .Net 2 application. Locally, everything was fine. However, when I deployed it on a remote server. I got this error:

Login failed for user 'domain\userx'.

My connection string is:
connectionString="Data Source=ServerName;Initial Catalog=Aspect;User Id =domain\userx;Password = abc"

I'm quite sure that connection string is fine. I need to mention that whenever I try to connect to the remote server from my client by the Sql authentication, I get the message that login failed for this user. But when I try to connect by windows authentication, it works and there is no error.
I asked the administrator, and he told me that Sql Server authentication is in mixed mode.
So, I really can't figure out what is the problem.

You need a SQL login, not a windows login for this to work.

--

Joe (Microsoft MVP - XML)

To connect to SQL Server using Windows Authentication, your connection string will look like this:

"Data Source=ServerName;Initial Catalog=Aspect;Integrated Security=SSPI;"


SQL Server Helper
http://www.sql-server-helper.com