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

<<  July 2010  >>
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678

View posts in large calendar