So I've been following the directions here http://connect.nintex.com/files/folders/upgrading_from_nw2007_to_nw2010/default.aspx to move from 2007 to 2010.
Our DBA moved a copy of our Nintex 2007 db to our new environment. I don't know if it matters but the new environment is in a different domain than the 2007 farm.
I installed Nintex 2010 on the new farm. SharePoint content dbs are *not* attached. I get the following error when I attempt to attach the existing db.
Unexpected SQL error occurred. Server name: oldserver\oldinstance; Database name: NW2007DB.
The correlation id doesn't turn up much in the logs either.
logging Correlation Data xmnv Medium Name=Request (POST:http://server:port/_admin/NintexWorkflow/DatabaseSettings.aspx?action=add&databaseType=configuration&dataSource=)
I am a bit confused about the part on page 6 below. So, do you run the command on the old farm after the Nintex db has been copied and moved to the new environment? What does that accomplish? Or on the new farm after the successful attach?
http://connect.nintex.com/files/folders/tutorials/entry1213.aspx
Could there be a permissions issue in SQL? Why is it finding the db in the other server name/instance and not the db name in the new server/instance?
Thanks.