Hello All,

I'm setting up a new BVC 5 store on a freshly installed windows server and Im having a problem running the SQLpatch.aspx. on the Database Update when I click start I get a error that says:

Server Error in '/' Application.
Runtime Error

I assigned dbo rights to the account I created to manage this database. I verified the account and database names are correct in the webconfig file.

My Setup
Windows 2003 server standard with SP2 installed
SQL server 2005
.net 2.0.50727

thanks
Tom

in the event log I get:

Login failed for user 'KTL01SQL\TFTDBADMIN'. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Thanks for getting back to me. I followed the instructions found here to switch the server to mixed mode http://www.hostmysite.co.../vps/windows/mixedmode/.

I'm still getting errors :

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 3/9/2009 6:19:05 PM
Event time (UTC): 3/9/2009 10:19:05 PM
Event ID: 858a251a2f244781a9dbfb6b2b54e4e5
Event sequence: 8
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/1326517865/Root-5-128811107429375000
Trust level: Full
Application Virtual Path: /
Application Path: C:\Inetpub\wwwroot\TunaFishTackle.com\www\
Machine name: KTL01SQL

Process information:
Process ID: 2772
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: SqlException
Exception message: Login failed for user 'TFTDBADMIN'.

Request information:
Request URL: http://beta.tunafishtackle.com/SqlPatch.aspx
Request path: /SqlPatch.aspx
User host address: 75.127.218.178
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: 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)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at BVSoftware.Bvc5.Core.Datalayer.SqlDataHelper.CreateDatabase() in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Datalayer\SqlDataHelper.vb:line 31
at BVSoftware.Bvc5.Core.Utilities.SqlPatchHelper.PatchVersion(Versions version) in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\SqlPatchHelper.vb:line 12
at BVSoftware.Bvc5.Core.Utilities.VersionHelper.RunSqlPatch() in c:\source\CommerceMain\WebApp\source\BVSoftware.Bvc5.Core\Utilities\VersionHelper.vb:line 34
at SqlPatch.StartButton_Click(Object sender, EventArgs e)
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.