I have installed uCommerce but keeping getting the message, "Login failed for user" when I am trying to create a product - I am not sure what permissions to set or where to set the permissions?
At /umbraco/create.aspx?nodeId=ProductCatalog&nodeType=Catalog_Root&nodeName=Product%20Catalog&rnd=42.1&rndo=43 (Referred by: http://localhost:56567/umbraco/create.aspx?nodeId=ProductCatalog&nodeType=Catalog_Root&nodeName=Product Catalog&rnd=42.1&rndo=43): System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'root'. 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.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) 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 SubSonic.DataProviders.DbDataProvider.CreateConnection(String connectionString) at SubSonic.DataProviders.DbDataProvider.CreateConnection() at SubSonic.DataProviders.AutomaticConnectionScope..ctor(IDataProvider provider) at SubSonic.DataProviders.DbDataProvider.ExecuteReader(QueryCommand qry) at SubSonic.Linq.Structure.DbQueryProvider.Execute[T](QueryCommand`1 query, Object[] paramValues) at lambda_method(Closure ) at SubSonic.Linq.Structure.DbQueryProvider.Execute(Expression expression) at SubSonic.Linq.Structure.QueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression) at System.Linq.Queryable.Any[TSource](IQueryable`1 source, Expression`1 predicate) at UCommerce.Entities.ProductCatalogGroup.Exists(Expression`1 expression) at UCommerceWeb.Umbraco.UCommerce.Catalog.CreateProductCatalogGroup.UniqueNameValidator_ServerValidate(Object source, ServerValidateEventArgs args) at System.Web.UI.WebControls.CustomValidator.OnServerValidate(String value) at System.Web.UI.WebControls.CustomValidator.EvaluateIsValid() at System.Web.UI.WebControls.BaseValidator.Validate() at System.Web.UI.Page.Validate() at System.Web.UI.Page.Validate(String validationGroup) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler...
And also
At /favicon.ico (Referred by: ):
I have installed uCommerce 1.5.1.0 with uCommerce Store 1.1.1.0, and the site is running off a MySQL database.
I would prefer to work with MSSQL but my current employers setup uses MySql - alot more hassle then it is actually worth as quite a few good packages only support MSSQL.
Can't create a product - Login failed for user
I have installed uCommerce but keeping getting the message, "Login failed for user" when I am trying to create a product - I am not sure what permissions to set or where to set the permissions?
Thanks in advance for an help
Hi Sean,
Are you getting any useful info in umbracoLog?
Also which version of Umbraco/uCommerce are you running?
Hi Soren
Here is the information from the umbracoLog
And also
I have installed uCommerce 1.5.1.0 with uCommerce Store 1.1.1.0, and the site is running off a MySQL database.
uCommerce 1.0 doesn't support MySql. SQL Server Express is free also and supports a wider featureset and MySql.
uCommerce 2.0 would in theory support MySql, but we've only had a single request for MySql support so far, so we haven't invested in doing it.
Sorry about the inconvenience.
I would prefer to work with MSSQL but my current employers setup uses MySql - alot more hassle then it is actually worth as quite a few good packages only support MSSQL.
Will keep my fingers crossed.
Thanks for your help Soren, greatly appreciated.
+1 on MySql compatibility.
Thanks for the suggesting the feature. it greatly helps us prioritize new features for uCommerce. Keep up the good work.
is working on a reply...