Error with ASP.net Web page when accessing database

[Newbie19]

I'm having an issue with viewing my ASP/SQL application in Internet Explorer. I get the error from my Server (located on my PC using IIS 5.0) stating:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I am connected to the database because I can view it in VS 05 and run test queries on it in VS.

However, when I view the application on Internet explorer I get the error. My connection string is:
ConnectionString="Data Source=Hostname address; Initial Catalog=databasename; trusted_connection=true;"

I've even added: User ID=ID; password = Password; and put trusted_connection as false, but I get failed to login error instead.


This is the stack I get:

Code: ( sql )
[SqlException (0x80131904): Login failed FOR user '(null)'. Reason: NOT associated WITH a TRUSTED SQL Server connection.]
System.DATA.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, BOOLEAN breakConnection) +734931
System.DATA.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) +188
System.DATA.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838
System.DATA.SqlClient.SqlInternalConnectionTds.Com pleteLogin(BOOLEAN enlistOK) +33
System.DATA.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, BOOLEAN redirectedUserInstance) +628
System.DATA.SqlClient.SqlInternalConnectionTds..ct OR(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, BOOLEAN redirectedUserInstance) +170
System.DATA.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359
System.DATA.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.DATA.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) +424
System.DATA.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) +66
System.DATA.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +496
System.DATA.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +82
System.DATA.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.DATA.SqlClient.SqlConnection.Open() +111
System.DATA.Common.DbDataAdapter.FillInternal(DATA SET dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.DATA.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.DATA.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
System.Web.UI.WebControls.SqlDataSourceView.Execut eSelect(DataSourceSelectArguments arguments) +1770
System.Web.UI.DataSourceView.SELECT(DataSourceSele ctArguments arguments, DataSourceViewSelectCallback callback) +17
System.Web.UI.WebControls.DataBoundControl.Perform SELECT() +149
System.Web.UI.WebControls.BaseDataBoundControl.Dat aBind() +70
System.Web.UI.WebControls.GridView.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.Ens ureDataBound() +82
System.Web.UI.WebControls.CompositeDataBoundContro l.CreateChildControls() +69
System.Web.UI.Control.EnsureChildControls() +87
System.Web.UI.Control.PreRenderRecursiveInternal() +41
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Control.PreRenderRecursiveInternal() +161
System.Web.UI.Page.ProcessRequestMain(BOOLEAN includeStagesBeforeAsyncPoint, BOOLEAN includeStagesAfterAsyncPoint) +1360


Thank you for any help that can be provided.

Newbie19

[Frinavale]

I'm having an issue with viewing my ASP/SQL application in Internet Explorer. I get the error from my Server (located on my PC using IIS 5.0) stating:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I am connected to the database because I can view it in VS 05 and run test queries on it in VS.

However, when I view the application on Internet explorer I get the error. My connection string is:
ConnectionString="Data Source=Hostname address; Initial Catalog=databasename; trusted_connection=true;"

I've even added: User ID=ID; password = Password; and put trusted_connection as false, but I get failed to login error instead.

This is the stack I get:

...

Thank you for any help that can be provided.

Newbie19

Hi there,

Check out the sections on Connection strings in this .NET Article on how to use a database in your program....try just using one like the example and see if it makes a difference...also check to make sure that your user name and password matches that of the database user.

Cheers!
-Frinny

[nateraaaa]

Check your web.config to be sure that you added
<identity impersonate="true" />

Your trusted connection will not work properly if this is not added to the web.config.

Nathan

[Newbie19]

Thank you for all your help, nateraaaa your advice help a lot.

Thanks again everyone.

Newbie 19