Hi,
I have a Web Service created that have to connect to a SQL Server 2005 Database with mixed authentication. If I use the "virtual IIS" provided by Visual Studio I retrieve data, but if I put the project in local IIS, using localhost, I get an error in the connection, it says that I can’t connect with the user ' ' to the database. I think is a problem with the mixed authentication SQL Server has, but I don’t how to solve it if. I have always made the connections with user and password, never with Windows or mixed authentication. Any help would be appreciated.
Thanks in advance.
SQL Server 2005 Connection with mixed authenticacion
Yarik
What are you using for your connection string It should be something like this:
"server=(local);database=MyDatabase;trusted_connection=yes"
Floax
Hi,
I was using this connection string:
Data Source=ARALE;Initial Catalog=Security;Integrated Security=True
I changed it for the one you provided and I have the same error:
System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
....
MKMahesh
I have solved the problem with this line
<identity impersonate="true" />
But now, when i call the Web Service from the client applicacion, I get another error:
The request failed with HTTP status 401: Access Denied