Before you begin reading, please be aware that I have little knowledge of SQL server and even less of Sharepoint.
I have a client with a server in a domain which hosts sharepoint 2010 standard and MS SQL server 2008 (not R2). The admin (and developer) had originally setup the environment to 'play around' with sharepoint and it quickly became a production server with 150 users using it daily.
Now, he wishes to upgrade to sharepoint 2013 to take advantage of some new features. Having been given an extortionate quotation from a 3rd party, he has tasked me with this challenge. So I have P2V'd his DC and sharepoint server and took them back to my lab to do a trial run. I setup the VMs and added a new VM with server 2012, sharepoint 2013 and SQL server 2014.
I found an article here: http://www.codeproject.com/Articles/663663/Live-Migration-of-SharePoint-to-SharePoint
I have been following this article and have come to the point where I am copying the database from the old server to the new one but have hit a problem.
As I said above, the source server uses SQL server 2008 and the destination uses SQLserver 2014. During the wizard, I am asked to enter the destination server details. When I browse for the destination server it cant find any. when I manually type in the name of the destination server, I get the following:
Failed to connect to server 'destinationservername'
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify the instance name is correct and that SQL Server is configured to allow remote connections. 9provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL server) (Microsoft SQL Server, Error:5)
I then cancel the database copy wizard and restart it. This time, when I manually enter the destination server details, it continues to the end and then fails on:
Create failed for JobStep.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Conne
The @flags parameter is not valid for a job step of type 'SSIS'. (Microsoft SQL Server, Error: 14545)
I can ping both servers from each other and openly browse the c$ share so its obviously an SQL thing. Perhaps moving a database from SQL server 2008 to 2014 isn't possible? I know that I could do the detach are reattach thing but I don't know where that would leave me with the step-through article.
All help appreciated.