Torben Rügge 27 posts 47 karma points

Sep 13, 2009 @ 16:47

Login failed for user 'DBUSER'

Installing umbraco

First time I fire this: http://localhost/umbraco/default.aspx

Server Error in '/umbraco' Application.

Login failed for user 'DBUSER'.

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 'DBUSER'.

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 'DBUSER'.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +428
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +65
   umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +37
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +68

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +126
   umbraco.BusinessLogic.User.setupUser(Int32 ID) +132
   umbraco.BusinessLogic.User..ctor(Int32 ID) +101
   umbraco.BusinessLogic.User.GetUser(Int32 id) +89
   umbraco.content.LoadContentFromDatabase() +82
   umbraco.content.LoadContent() +89
   umbraco.content.get_XmlContentInternal() +81
   umbraco.content.get_XmlContent() +76
   umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) +887
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
   System.Web.UI.Page.OnPreInit(EventArgs e) +8699534
   System.Web.UI.Page.PerformPreInit() +31
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +282

Version Information: Microsoft .NET Framework Version:2.0.50727.4918; ASP.NET Version:2.0.50727.4918

Request Details
Session Id:	yhiakoq5ased1cve2qwk4b45	Request Type:	GET
Time of Request:	13-09-2009 16:39:01	Status Code:	500
Request Encoding:	Unicode (UTF-8)	Response Encoding:	Unicode (UTF-8)

Trace Information
Category	Message	From First(s)	From Last(s)
aspx.page	Begin PreInit
umbracoInit	handling request	0,0077523819368104	0,007752
Unhandled Execution Error	Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) at umbraco.BusinessLogic.User.setupUser(Int32 ID) at umbraco.BusinessLogic.User..ctor(Int32 ID) at umbraco.BusinessLogic.User.GetUser(Int32 id) at umbraco.content.LoadContentFromDatabase() at umbraco.content.LoadContent() at umbraco.content.get_XmlContentInternal() at umbraco.content.get_XmlContent() at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.OnPreInit(EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)	0,116639964017773	0,108888

Control Tree
Control UniqueID	Type	Render Size Bytes (including children)	ViewState Size Bytes (excluding children)	ControlState Size Bytes (excluding children)
__Page	ASP.default_aspx	0	0	0

Session State
Session Key	Type	Value

Application State
Application Key	Type	Value
umbracoNeedConfiguration	System.Boolean	True
umbracoUrl	System.String	localhost:80/umbraco

Request Cookies Collection
Name	Value	Size

Response Cookies Collection
Name	Value	Size

Headers Collection
Name	Value
Connection	Keep-Alive
Content-Length	0
Accept	image/jpeg, application/x-ms-application, image/gif, application/xaml+xml, image/pjpeg, application/x-ms-xbap, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, /
Accept-Encoding	gzip, deflate
Accept-Language	da-DK
Host	localhost
User-Agent	Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; OfficeLiveConnector.1.4; OfficeLivePatch.1.3; .NET CLR 1.1.4322)

Response Headers Collection
Name	Value
X-AspNet-Version	2.0.50727
Cache-Control	private
Content-Type	text/html

Form Collection
Name	Value

Querystring Collection
Name	Value

Server Variables
Name	Value
ALL_HTTP	HTTP_CONNECTION:Keep-Alive HTTP_CONTENT_LENGTH:0 HTTP_ACCEPT:image/jpeg, application/x-ms-application, image/gif, application/xaml+xml, image/pjpeg, application/x-ms-xbap, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, / HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:da-DK HTTP_HOST:localhost HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; OfficeLiveConnector.1.4; OfficeLivePatch.1.3; .NET CLR 1.1.4322)
ALL_RAW	Connection: Keep-Alive Content-Length: 0 Accept: image/jpeg, application/x-ms-application, image/gif, application/xaml+xml, image/pjpeg, application/x-ms-xbap, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, / Accept-Encoding: gzip, deflate Accept-Language: da-DK Host: localhost User-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; OfficeLiveConnector.1.4; OfficeLivePatch.1.3; .NET CLR 1.1.4322)
APPL_MD_PATH	/LM/W3SVC/1/ROOT/umbraco
APPL_PHYSICAL_PATH	C:\inetpub\wwwroot\umbraco\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH	0
CONTENT_TYPE
GATEWAY_INTERFACE	CGI/1.1
HTTPS	off
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID	1
INSTANCE_META_PATH	/LM/W3SVC/1
LOCAL_ADDR	::1
PATH_INFO	/umbraco/default.aspx
PATH_TRANSLATED	C:\inetpub\wwwroot\umbraco\default.aspx
QUERY_STRING
REMOTE_ADDR	::1
REMOTE_HOST	::1
REMOTE_PORT	49294
REQUEST_METHOD	GET
SCRIPT_NAME	/umbraco/default.aspx
SERVER_NAME	localhost
SERVER_PORT	80
SERVER_PORT_SECURE	0
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	Microsoft-IIS/7.5
URL	/umbraco/default.aspx
HTTP_CONNECTION	Keep-Alive
HTTP_CONTENT_LENGTH	0
HTTP_ACCEPT	image/jpeg, application/x-ms-application, image/gif, application/xaml+xml, image/pjpeg, application/x-ms-xbap, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, /
HTTP_ACCEPT_ENCODING	gzip, deflate
HTTP_ACCEPT_LANGUAGE	da-DK
HTTP_HOST	localhost
HTTP_USER_AGENT	Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; GTB6; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; OfficeLiveConnector.1.4; OfficeLivePatch.1.3; .NET CLR 1.1.4322)

Microsoft

Copy Link

Roel Snetselaar 151 posts 305 karma points

Sep 13, 2009 @ 17:26

Did you encounter this error during installation or did you already install the application?

Copy Link

Torben Rügge 27 posts 47 karma points

Sep 13, 2009 @ 19:16

I encountered this during installation

Copy Link

Sebastiaan Janssen 5045 posts 15478 karma points MVP admin hq

Sep 13, 2009 @ 19:23

Make sure your web.config is writeable for the user that your application pool is using. Did you get instructions to manually update your web.config?

It looks like you didn't change the defaults for the database configuration during the installation. You could go to /install/default.aspx and try the installation again. Make sure that you create a database first and know the username and password for that database.

Also refer to the installation manual (page 12 and further) for information on how to install and configure SQL server.

Copy Link

Roel Snetselaar 151 posts 305 karma points

Sep 13, 2009 @ 20:08

also make sure the dbuser you created has 'dbowner' permissions on your database.

and most likely like Sebastiaan says the NETWORK SERVICE user needs write persmissions on your web.config (if your application pool is running under the NETWORK SERVICE identity)

Copy Link

Peter Dijksterhuis 1442 posts 1722 karma points

Sep 13, 2009 @ 20:09

Did you initially create a virtual directory somehow? Check if the umbraco-firectory is a virtual-directory. If so, remove that.

Copy Link

Torben Rügge 27 posts 47 karma points

Sep 13, 2009 @ 22:17

1) I encountered this during installation

2) If I go to install/default.aspx I get an error

3) I have been following the Insallation Manual (I hope to the point)

4) how do I check that the user I created (umbracoUser! (and umbracoUser) has the proper access rights (dbowner) to the db?

5) I am not aware having created any virtual directories..

thanks all you nice guys trying to help

Torben

Copy Link

Torben Rügge 27 posts 47 karma points

Sep 13, 2009 @ 22:25

umbracoUser1 sems to be OK but user: umbracoUser is not

Copy Link

Sebastiaan Janssen 5045 posts 15478 karma points MVP admin hq

Sep 14, 2009 @ 00:28

Torben, maybe, to start off with, it's easier if you try out the Web Platform Installer version. It should set-up everything correctly for you so you wouldn't run into all of these problems.

Copy Link

Torben Rügge 27 posts 47 karma points

Sep 14, 2009 @ 11:00

Thanks for your advice
I have run into quite a few hiccups.

1) How much do I have to dele/uninstall?

2) Does the MS version of Umbraco give me the same product?

Torben

Copy Link

Sebastiaan Janssen 5045 posts 15478 karma points MVP admin hq

Sep 14, 2009 @ 13:00

Yes, it is absolutely the same, no worries. Umbraco is provided TO Microsoft.

The WPI should check what's already installed and configured and finish up for you, I don't think you'd have to uninstall anything.

Copy Link

Torben Rügge 27 posts 47 karma points

Sep 14, 2009 @ 15:32

See this was sound advice.

Umbraco is now installed, db and all, tables created.

The last step in the install procedure asks if I want to install Runway.. Do you recommend this?

I have also ben recommended to install "Creative Website Starter"

Torben

Copy Link

Torben Rügge 27 posts 47 karma points

Sep 15, 2009 @ 17:41

Thank you everyone

Copy Link

is working on a reply...

Flag this post as spam?

Login failed for user 'DBUSER'

Server Error in '/umbraco' Application.

Login failed for user 'DBUSER'.

Request Details

Trace Information

Control Tree

Session State

Application State

Request Cookies Collection

Response Cookies Collection

Headers Collection

Response Headers Collection

Form Collection

Querystring Collection

Server Variables