Thread: web.config

What should I use for my user id and password if Im using Windows Authenication for SQL?

<add key="DBConn" value="data source=localhost;initial catalog=AspDotNetStorefront;user id=;password=;persist security info=True;packet size=4096"/>

You need to use any User ID and Password if your using Windows Authentication. Just replace user and password with integrated security=true. See the example connection string below:

<add key="DBConn" value="data source=localhost;initial catalog=AspDotNetStorefront;integrated security=true;packet size=4096"/>

Refer from the link below for more details:

http://manual.aspdotnetstorefront.co...ntication.aspx

Have anyone receive this error and can assist?

Server Error in '/AspDotNetStorefront' Application.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): Login failed for user ''. The user is not associated with a trusted SQL Server connection.]
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) +578
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) +84
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +1645767
System.Data.SqlClient.SqlConnection.Open() +258
AspDotNetStorefront.Global.cnLP9Is5q(Object , EventArgs ) +576
AspDotNetStorefront.Global.Application_BeginReques t(Object sender, EventArgs e) +94
System.Web.SyncEventExecutionStep.System.Web.HttpA pplication.IExecutionStep.Execute() +80
System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously) +171

Make sure you've specified a userid and password in your web.config DBConn line, sounds like you're trying to use 'integrated security' but don't have SQL configured properly. You'll need to add a login in SQL Server Mgmt Studio if you don't already have one set up, then add that login as a user on your specific database. Make sure it has 'dbowner' rights.