Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: web.config

  1. #1
    jamotion is offline Senior Member
    Join Date
    Jul 2007
    Posts
    215

    Default 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"/>

  2. #2
    Louie is offline Senior Member
    Join Date
    Oct 2008
    Posts
    126

    Default

    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

  3. #3
    jamotion is offline Senior Member
    Join Date
    Jul 2007
    Posts
    215

    Default

    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

  4. #4
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    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.