HomeHome Product Discus... Product Discus...SmithCartSmithCartInstallation IssueInstallation Issue
Previous
 
Next
New Post
1/3/2012 10:36 AM
 

I just installed the current trial version of smithcart on a new DNN 6.0.2 install.  Installation was successful.
When I installed the Smith.BuyNow module on the Store page, I received the following error:

A critical error has occurred.Cannot open database "balance_com" requested by the login. The login failed. Login failed for user 'balance3_user'

Here is the event log entry:

AssemblyVersion: 6.1.2

PortalID: 0

PortalName: Balance3

UserID: 1

UserName: host

ActiveTabID: 86

ActiveTabName: Store

RawURL: /Store.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer: http://balance3.ecwdev.com/Admin/LogViewer.aspx

UserAgent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 2c6a0fd1-f6ad-4492-9ba3-4a96476f16ea

InnerException: Cannot open database "balance_com" requested by the login. The login failed. Login failed for user 'balance3_user'.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlInternalConnection.OnError

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Cannot open database "dnn_balance_com" requested by the login. The login failed. Login failed for user 'balance3_user'. ---> System.Data.SqlClient.SqlException: Cannot open database "dnn_balance_com" requested by the login. The login failed. Login failed for user 'balance3_user'. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, 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 Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at Smith.DNN.Modules.BuyNow.SqlDataProvider.ListProductByFilter(Int32 PageNum, Int32 Records, String catergoryName, String Filter, Int32 tabModuleId, Int32 PortalId, String MySort, String VendorID, String PIDList) at Smith.DNN.Modules.BuyNow.ProductsController.ListProductByFilter(Int32 PageNum, Int32 Records, String categoryName, String Filter, Int32 tabModuleId, Int32 PortalId, String MySort, String VendorID, String PIDList) at Smith.DNN.Modules.BuyNow.ProductsList.bindDtProductList() at Smith.DNN.Modules.BuyNow.ProductsList.Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

 

Any Ideas?

 
New Post
1/3/2012 5:26 PM
 

Hi John,

Please confirm that you have the following 2 sql connection strings in your web config:

 

<connectionStrings>

<add name="SiteSqlServer" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=dnn551cart;User ID=sa;Password=xxxx"/>

</connectionStrings>

      

<appSettings>

<add key="SiteSqlServer" value="Data Source=.\SQLEXPRESS;Initial Catalog=dnn551cart;User ID=sa;Password=xxxxxxxxx"/>

</appSettings>

 

Thanks,

 
New Post
1/5/2012 6:35 AM
 
Thank you - it was my error in the webconfig file - works great now.
 
New Post
1/5/2012 5:56 PM
 
Hi John,

Thanks for posting back with an update, glad you have resolved the issue.
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartInstallation IssueInstallation Issue