I have susccesfully installed Umbraco 4.0.2.1 on Win XP + IIS 5.1 + MS SQL Express 2005
But when I'm trying to launch Umbraco I get the following error:
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.
I configured MS SQL and IIS as described in the "Install umbraco 4 on Windows Vista" document (except Vista-only steps).
Then I successfully configured Umbraco itself (throug web configuration wizard).
I haven't 'DBUSER' in my db, I used the same as in the doc ('umbracoUser'), I've checked 'web.config' - the connection string configured to use my user.
I'm really surprised that Umbraco tries to connect to db as 'DBUSER'.
The important thing when testing a connection to SQL server is to go to the advanced options and select 'TCP/IP' as the connection mechanism (that's what umbraco uses). By default, SQL Server does not enable tcp/ip connections. And, by default, when you log in to management studio you will be using named pipes, which umbraco doesn't use.
So, my guess is that you simply need to enable tcp/ip connection in sql server.
Do you have a virtual directory somehow that holds a different web.config? Looks like there still is an original web.config that has the default username and password.
First time I tried to install Umbraco in the virtual directory and call it 'umbraco'. Then I copied Umbraco to the root but forgot remove virtual dir.
So during installation it uses correct web.config, but at the launch time it requests 'umbraco' direcotry and hits virtual directory with default web config.
Login failed for user 'DBUSER'.
Hello All!
I have susccesfully installed Umbraco 4.0.2.1 on Win XP + IIS 5.1 + MS SQL Express 2005
But when I'm trying to launch Umbraco I get the following error:
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:
Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082
Any ideas how to fix?
Thanks in advance!
How did you install?
Have you run the install steps of umbraco?
Do you have an user with sufficient access in your db called 'DBUSER'?
Ron
I configured MS SQL and IIS as described in the "Install umbraco 4 on Windows Vista" document (except Vista-only steps).
Then I successfully configured Umbraco itself (throug web configuration wizard).
I haven't 'DBUSER' in my db, I used the same as in the doc ('umbracoUser'), I've checked 'web.config' - the connection string configured to use my user.
I'm really surprised that Umbraco tries to connect to db as 'DBUSER'.
Can you send an example of that part of your web.config
Here it is
<add key="umbracoDbDSN" value="server=.\sqlexpress;database=UmbracoCMS;user id=umbracoUser;password=***" />
Try to login with those credentials in SqlServer, and see or you have access...
Already checked. Access allowed.
Have you tried restarting your app? It seems umbraco is using an old connectionstring.
What you can do is open Visual Studio
Go to Tools
-Connect to database, give credentials, and select your umbraco db, then click advanced, there you find the connectionstring you can use
The important thing when testing a connection to SQL server is to go to the advanced options and select 'TCP/IP' as the connection mechanism (that's what umbraco uses). By default, SQL Server does not enable tcp/ip connections. And, by default, when you log in to management studio you will be using named pipes, which umbraco doesn't use.
So, my guess is that you simply need to enable tcp/ip connection in sql server.
Let us know what you find out.
cheers,
doug.
Good point Douglas, i think this is the most logic problem.
TCP/IP is the only protocol enabled for my server.
The main question is why does Umbraco connect as 'DBUSER' but not as the user specified in the Web.config?
Do you have a virtual directory somehow that holds a different web.config? Looks like there still is an original web.config that has the default username and password.
You are right Peter!
First time I tried to install Umbraco in the virtual directory and call it 'umbraco'. Then I copied Umbraco to the root but forgot remove virtual dir.
So during installation it uses correct web.config, but at the launch time it requests 'umbraco' direcotry and hits virtual directory with default web config.
Thanks Peter and everybody for support.
is working on a reply...