23 Aug 2005
18 Sep 2006
Link to this post
All sample websites (Primavera for example) is shipped to use the Access database - file that is a part of the distribution. For some reason this does not work out of the box, as I am suggested to install MDAC. I tried to install the most recent version of MDAC and the installation failed with the message that this functionality is already a part of Windows XP SP2.
Trying to use SQL Server 2005 instead of Access, led to more documentation problems: the tutorial uses SQL Server 7, while I would expect SQL Server 2005 Management Studio (we are close to the end of the year 2006 :-) I tried to create a new database as close as possible to what is descrived in tutorial, but am still not sure whether I did all that is required, not even whether SiteFinity really supports SQL Server 2005.
The documentation further suggest to run the aspnet_regsql.exe application to properly format the new database, so I did. However, going through the Sitifinity Project Manager's wizzard, I got the following message at the last step of the wizzard:
There's a problem setting the Database.
Please, make sure that the SQL Server Database doesn't contain 'Sitefinity' tables & objects.
SQL Error: There is already an object named 'aspnet_Applications' in the database.
This indicates that the Sitifinity Project Manager's wizzard tries to do some of the actions already done by aspnet_regsql.exe. True?
Can someone describe to me how to create a SiteFinity website using the SQL Server 2005 as the database server, please?