Installing Umbraco 4.0.3 with SQL Server 2005 Express
I created the DB via the walkthrough, created UmbracoCMS databse and can login as umbracoUser in SQL Server MS 2005, but when I try to install Database with Umbraco, I get this error.
Database connection initialisation failed. The installer cannot connect to the database.
I am using the ASP.Net 3.5 Web.Config file, and altered the file to this
THat worked great thank you. I am now having a strange problem where whenever I ccreate something, (ie a stylesheet) it saves and then when I reload nodes it does not show up. Is there something wrong with my permissions? Thanks.
This is a problem with permession on css folder. Check permession on that forder and see if IUSR and ASP.NET pool user have write permission on that folder.
Installing Umbraco 4.0.3 with SQL Server 2005 Express
I created the DB via the walkthrough, created UmbracoCMS databse and can login as umbracoUser in SQL Server MS 2005, but when I try to install Database with Umbraco, I get this error.
Database connection initialisation failed. The installer cannot connect to the database.
I am using the ASP.Net 3.5 Web.Config file, and altered the file to this
<add key="umbracoDbDSN" value="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\UmbracoCMS.mdf;Integrated Security=True;User Instance=True;Database=UmbracoCMS; user=umbracoUser; password=*******;" />
What do I need to do to get this to work? Thanks.
Hi..
Maybe you need to check sql server configuration manager
please follow this link..
http://umbraco.org/documentation/books/install-umbraco-30-on-windows-vista/install-sql-server-2005-express-edition-sp2
Thats the walkthrough that I followed. Still getting error
Hi,
see if SQL accept tcp connection ( or pipe, memory ).
Have you tried to connect on local machine with SQL Manager? I suggest to create db directly into SQL and not attach file and use
<add key="umbracoDbDSN" value="Data Source=.\SQLEXPRESS; Integrated Security=True;User Instance=True;Database=UmbracoCMS; user=umbracoUser; password=*******;" />
I am confused by what you are saying. I used this tutorial
http://umbraco.org/documentation/books/install-umbraco-30-on-windows-vista/configure-sql-server-2005-express-for-umbraco
And followed it to a T.
If you followed that tutorial, your datasource is not .\SQLEXPRESS since you installed the default instance.
Try replacing .\SQLEXPRESS with (LOCAL)
HTH,
Peter
Or you can use MS Web Gallery for install umbraco
Peter,
THat worked great thank you. I am now having a strange problem where whenever I ccreate something, (ie a stylesheet) it saves and then when I reload nodes it does not show up. Is there something wrong with my permissions? Thanks.
This is a problem with permession on css folder. Check permession on that forder and see if IUSR and ASP.NET pool user have write permission on that folder.
Try permissions check
http://our.umbraco.org/wiki/reference/files-and-folders/permissions/perform-permissions-check
Petr
is working on a reply...