I have successfully installed umbraco 4.5.2 on a windows xp machine using sqlserver 2008. I've now been asked to install it on the same xp machine but pointing to a sql 2005 server. Things go smoothly and the db is created, but I get the error "incorrect syntax near (" from the db script. When I go look, the db looks fine except that the table cmsPreviewXML is missing. I can use Umbraco, but the publish/preview throws an error because the table is missing.
So I tried scripting out the table from my 2008 database and when I run it on the 2005 server, I get that same message "incorrect syntax near (" but as far as I can tell, the syntax is fine.
I also tried installing the 4.5.1 umbraco package but got the same problem.
I tried creating the table manually but I don't know enough about sql server to know how to create the constraints by hand.
install help for umbraco for windows xp, sqlserver 2005
Hi,
I have successfully installed umbraco 4.5.2 on a windows xp machine using sqlserver 2008. I've now been asked to install it on the same xp machine but pointing to a sql 2005 server. Things go smoothly and the db is created, but I get the error "incorrect syntax near (" from the db script. When I go look, the db looks fine except that the table cmsPreviewXML is missing. I can use Umbraco, but the publish/preview throws an error because the table is missing.
So I tried scripting out the table from my 2008 database and when I run it on the 2005 server, I get that same message "incorrect syntax near (" but as far as I can tell, the syntax is fine.
I also tried installing the 4.5.1 umbraco package but got the same problem.
I tried creating the table manually but I don't know enough about sql server to know how to create the constraints by hand.
Any suggestions?
thank you.
is working on a reply...