<< Back again! | Home | MCTS .Net Framework book >>
EPiServer 4.6.x and SQL Server Express 2005

...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)


Bookmark with :
Digg It! DZone StumbleUpon Technorati Reddit Del.icio.us Newsvine Furl Blinklist
posted @ Wednesday, June 06, 2007 11:46 AM | in SQL EPiServer

Comments

Gravatar
# re: EPiServer 4.6.x and SQL Server Express 2005
Posted by epiguru
on 7/9/2007 11:23 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.

Post Comment

Title *
Name *
Email
Url
Comment *  


Please add 2 and 2 and type the answer here: