EPiServer 4.6.x and SQL Server Express 2005

by Dan Matthews 6. June 2007 10:46

...and straight off I have something to share with you :)

If you're installing using EPiServer manager and using SQL Server 2005 Express, you need to be aware of the following, otherwise you get all sorts of 'SQL Server unavailable' and user authentication errors:

1) Make sure you NAME THE INSTANCE in the install, otherwise it will install on your default instance (which in my case, stupidly, was an MSDE instance!)

2) Make sure you have both Shared Memory and TCP/IP turned on in your SQL2005 Configuration. The installation uses Shared Memory, but the site itself uses TCP/IP.

3) Make sure mixed-mode authentication is turned on for your SQL Express instance

4) Make sure that your website is running as ASP.NET1.1 during the install (do the .NET2 templates and stuff afterwards)

Tags:

EPiServer

Comments

7/9/2007 10:23:22 PM #

And do remember that EPiServer Manager will authenticate (vis-a-vis SQL Server) as the logged on windows user, not the user entered in the manager fields.

epiguru |

Powered by BlogEngine.NET 1.5.0.7
Theme by Interakting

Interakting

A full service digital agency offering online strategy, design and usability, systems integration and online marketing services that deliver real business benefits and ensure your online objectives are met.

Calendar

<<  February 2012  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011

View posts in large calendar