sp_FxDatabaseverion

Gerd Wiggen

Vote:

Hi, Now I am setting up a developing environment on my machine. I have installed Episerver and restored a database from my customer. I have set up the connectionstrings. When I then try to run the solution, I get the following error:

Could not find stored procedure 'sp_FxDatabaseVersion'.

In another episerver solution I have, this stored procedure is found. Is this a Episerver stored procedure? How can I get this to work in my customers solution?

#76054

Oct 16, 2013 12:36

sgodrich

Vote:

It looks like an EPiServer stored procedure. I'd copy it over manually via SQL Server Management studio. There is also one called sp_DatabaseVersion. I'd copy that one as well if it hasn't come over. They are owned by the dbo user so they will need the relevant permissions set too.

#76060

Oct 16, 2013 13:00

Johan Björnfot

Vote:

sp_FxDatabaseVersion is a stored procedure used by EPiServer.Data (DDS). Could it be that the customer have separated DDS and CMS to different databases?

#76112

Oct 17, 2013 8:15

Gerd Wiggen

Vote:

Thank you so much for your answer. I copied it over and it worked :)

#76126

Oct 17, 2013 12:40

Masoud Memariani

Vote:

I just realized that this problem happens when I restore the database from somewhere else, but then in the Options page of "Restore Database" window under "Restore the database files" I forget to set the file paths to the target database's mdf and ldf files. So for other people who get this problem: check that you set the correct target mdf and ldf file paths! :)

#79006

Dec 06, 2013 10:23

Per Magne Skuseth

Vote:

I just ran into the error myself when I was going to do an upgrade from CMS 6 to 7 CMS. I got a fresh backup from the customer, and after restoring and starting up the site, I got this error. As it turned out, I'd been handed an EPiServer 5(!) database, from an upgrade I did a year ealier. The old database had not been removed from the db server, and the customer had picked the wrong one ;-)

#79257

Dec 11, 2013 18:38