Does EPiManager support SQL Server 2005 as a database?

I tried to install EPiServer using an SQL Server 2005 Express but EPiManager doesn't recognize the database it just tells me "SQL Server missing or access denied" when I try to list the databases on my local machine. Is this behavior expected or am I missing something? Regards Pontus
Nov 25, 2005 15:26
You need to change the value in the "Server:" textbox from "machine_name" to "machine_name\SQLExpress" in order to get it to work correctly. The handling will be improved in the next release of EPiServer Manager.
Nov 28, 2005 14:51
Now I have tried this but it still does not work. I have also enabled remote connection for both TCP\IP and Named Pipes in the SQL Server 2005 Surface Area Configuration utility but to no avail. It does not find the sql server. Any body got any ideas?
Dec 09, 2005 10:37
We have upgraded the site from MSDE to MS SQL 2005 Express (the freeware version) in order to see if it might be possible to bundle the Express with EPiServer. From the limitations with Express, 2GB dataase and 1GB RAM it looks like it might power some pretty large sites. We will do some performance tests in the near future. I will ask Johan (who upgraded the server) to take a look at your problems. rgds, Mikael Runhem, EP
Dec 10, 2005 7:04
Verify that tcp/ip (or named pipes, whichever is appropriate for your setup) really is enabled in SqlServer Configuration Manager.(tcp/ip is disabled by default) /johan
Dec 10, 2005 21:38
Hi all! I found out what the problem was. The database was created with the compability level set to 9.0. When I changed it to 8.0 it worked fine. Pontus
Jan 24, 2006 9:39
Hi Pontus Where did you change compability level? In the installation process of SQL Express? Thanks! Daniel
Mar 06, 2006 10:31
I now have stumbled into the same problem.. Ive done everything up to the comp level. Where do I set that?
Aug 29, 2006 16:32
I found out how and here it is if anyone else run into the problem: I found it after some searching. I installed the program "Microsoft SQl Server management Studio Express" from microsoft (works like enterprice manager for sql server 2000) and there I was able to change the compability level on the database. Though i still have problem installing EPiServer but I wrote about that in other thread.
Sep 04, 2006 14:42
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.