I try to setup this package. It always fails with a SQL login error for umbracouser which is the database user I use for Umbraco DB. Already tried setup under Umbraco 4.7.1.1 and 4.7.2 with Webmatrix and IIS 7.5 (always Windows 7 64 Bit). The error is always:
I'm not sure if the package will run correct under Webmatrix, but IIS should work fine. Did your installation of Umbraco work fine? Does the "umbracouser" have to right permissions?
Can you install other packages and make changes to content nodes etc?
My installation of Umbraco didn't show any problems. I have 2 other packages installed (ImageGen and uComponents), both work fine. I can add and edit content without errors.
"umbracouser" is member of db_datareader, db_datawriter, db_ddladmin, db_securityadmin and public.
In the sql logs I can see "Error: 18456, Severity: 14, State: 8 - Login failed for user 'umbracouser'. Reason: Password did not match that for the login provided."
In web.config under appSettings section the key is:
Changed the connectionstring to the one you sugested. Re-installed your package, error still the same. Edit content works also with new connectionstring.
By any chance, do you use some type of encryption on connect to database?
Thank you for your patient! There was a minor bug in the connectionstring (we added support for multiple active recordset in last minor version) and it's fixed now.
Unable to install Newsletter Studio
Hi,
I try to setup this package. It always fails with a SQL login error for umbracouser which is the database user I use for Umbraco DB. Already tried setup under Umbraco 4.7.1.1 and 4.7.2 with Webmatrix and IIS 7.5 (always Windows 7 64 Bit). The error is always:
[SqlException (0x80131904): Fehler bei der Anmeldung für den Benutzer 'umbracouser'.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +6351920 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +53 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +6366878 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +6366793 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +352 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +831 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +49 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +6368598 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +78 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +2194 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +89 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +6372110 System.Data.SqlClient.SqlConnection.Open() +300 System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +67 [EntityException: The underlying provider failed on Open.] System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition, DbConnection storeConnectionToOpen, DbConnection originalConnection, String exceptionCode, String attemptedOperation, Boolean& closeStoreConnectionOnFailure) +11108990 System.Data.EntityClient.EntityConnection.Open() +142 System.Data.Objects.ObjectContext.EnsureConnection() +97 System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) +66 System.Data.Objects.ObjectQuery`1.GetIListSourceListInternal() +30 System.Web.UI.DataSourceHelper.GetResolvedDataSource(Object dataSource, String dataMember) +115 System.Web.UI.WebControls.ReadOnlyDataSource.System.Web.UI.IDataSource.GetView(String viewName) +52 System.Web.UI.WebControls.DataBoundControl.ConnectToDataSourceView() +420 System.Web.UI.WebControls.DataBoundControl.GetData() +9 System.Web.UI.WebControls.ListView.PerformSelect() +209 NewsletterStudio.Usercontrols.Dashboard.Page_Load(Object sender, EventArgs e) +491 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25 System.Web.UI.Control.LoadRecursive() +71 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Control.LoadRecursive() +190 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064
IIS AppPool Identity is "Network Service", Integrated Pipeline, Framework 4
Connection-String is Umbraco standard, no modifications.
Already checked
th2tran.blogspot.com/.../...er-failed-on-open.html
http://forums.asp.net/t/1421189.aspx/1
Could you give me a hint what else could be the cause of this error?
TIA
Lothar Jung
Hi!
I'm not sure if the package will run correct under Webmatrix, but IIS should work fine. Did your installation of Umbraco work fine? Does the "umbracouser" have to right permissions?
Can you install other packages and make changes to content nodes etc?
HI Marcus,
thanks for your reply.
My installation of Umbraco didn't show any problems. I have 2 other packages installed (ImageGen and uComponents), both work fine. I can add and edit content without errors.
"umbracouser" is member of db_datareader, db_datawriter, db_ddladmin, db_securityadmin and public.
In the sql logs I can see "Error: 18456, Severity: 14, State: 8 -
Login failed for user 'umbracouser'. Reason: Password did not match that for the login provided."
In web.config under appSettings section the key is:
<add key="umbracoDbDSN" value="datalayer=SqlServer;server=.\sqlexpress;database=hr-autocomfort.de;user id=umbracouser;password=****************" />
Using SQL Server Management Studio I can access the database using the credentials above.
What version of umbraco are you running? Try changeing the connectionstring to:
<add key="umbracoDbDSN" value="server=.\sqlexpress;database=hr-autocomfort.de;user id=umbracouser;password=****************" />
On this site we run Umbraco 4.7.1.1
Changed the connectionstring to the one you sugested. Re-installed your package, error still the same. Edit content works also with new connectionstring.
By any chance, do you use some type of encryption on connect to database?
Hi!
Seems that the latest version of the package have some bug related to this. We'll look at it before lunch, I'll keep you posted.
Hi,
thanks for this info. Appreciate your effort on this!
Hi Lothar!
Thank you for your patient! There was a minor bug in the connectionstring (we added support for multiple active recordset in last minor version) and it's fixed now.
Please download the latest version here:
http://our.umbraco.org/projects/backoffice-extensions/newsletter-studio
And let me know what you think! I would love to hear your feedback!
Hi Markus,
loaded new version and setup works as expected.
I will quickly setup a sample newsletter for this client. I will have a demo to them this week and I will let you know what they think about it.
Thanks for your help!
Great!
Please let me know want you and your customers think!
(Could you mark the post as solved as well?)
is working on a reply...