Vault Replication error: SQL server edition does not support replication

[Anonymous]

hi all

i am trying to replicate vault withing 2 vault servers in a network and later i will try it over the internet between tow different sites. i had e Vault server 2016 installed here that is working fine. in order to replicate it, I have installed SQL server 2012 Enterprise edition on this machine recently. 

but now when i right click on WorkGroups in ADMS and select enable vault replication, after typing down shared folder address and its required credentials, i click ok and it tells me that vault replication is not possible for this server due to mismatched SQL server edition.

is there any action previous to this that i missed?

[johannes.bauer]

Hi,

is HP2012 the publisher or the subscriber?

If subscriber, which edition is installed there?

Have you installed replication features in the Enterprise version of SQL?

Can you send result of

select @@version  from Publisher and Subscriber?

Thanks

[Jason.Courtemanche]

Hi @Anonymous,

I'm just checking in to see if you need more help with this. Where you able to get the information that @johannes.bauer had requested? 

If so, please click Accept as Solution on the posts that helped you so others in the community can find them easily.

Regards,

Jason

[Anonymous]

thanks for replay,

HP2012 will be the publisher

and there is also another machine that Vault pro 2016 with exactly the same version installed on it, named "Acer-pc". i do not have installed SQL server on it yet.

i remember that i have installed SQL server with all its components, is there any way that i could check?

can you please clarify me how could I get results of "@@version"?? 

[Anonymous]

i have checked the version of the vault database using SQL server management studio.

its version is "SQL server express x64" , while i am almost sure that i have installed SQL server 2012 enterprise

[Jason.Courtemanche · Accepted solution]

Hi @Anonymous,

You want to check the SQL Version on both servers (Vault Publisher & Vault Subscriber) to make sure they are the same. You can get the version by running a SQL query: Select @@version

To find out if the SQL Replication has been installed by using the SQL query: EXEC sp_MS_replication_installed

If it's installed you will get "Command(s) completed successfully.", if it's not installed you will get an error like: "RegOpenKeyEx() returned error 2, 'the system cannot find the file specified.' "

If you pre-install SQL and use a different instance name the Vault installer will not see the SQL Instance and it will install SQL Express instead of using the version of SQL that was pre-installed. Sounds like you might need to uninstall SQL, Vault and reinstall SQL. Then install Vault Server and make sure it finds the localhost\AutodeskVault instance. 

Regards,

Jason

[Anonymous]

hi Jason,

thanks a lot for the detailed help,

select @@version results in this:

"Microsoft SQL Server 2012 - 11.0.5058.0 (X64)
May 14 2014 18:34:29
Copyright (c) Microsoft Corporation
Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)"

and i am actually confused because i was installed MS SQL Server 2012 Enterprise edition, but let me mention that i had vault server on this machine and i was installed SQL server later. 

also, checking replication installation result was: "Command(s) completed successfully."

removing vault server is really a problem while it is in use by some users and if its necessary i have first track its down hours in a week to take it out of the network. 

the thing is that i remember that i had installed SQL server as an update for "AUTODESKVAULT", not as a new instance.

so by now, it seems that i need to reinstall SQL server, right?

sincerely

Reza

[Jason.Courtemanche]

Hi @Anonymous,

Thanks for the update. I understand needing to wait for the right time as end users are still using Vault. Before making any changes I would take a full vault backup by opening the ADMS Console and select Tools > Administrator > Backup and Restore.

You could try to upgrade the SQL AutodeskVault instance edition from Express to standard or Enterprise. I am a fan of uninstalling all of SQL and reinstall SQL so you keep the servers as clean as possible. To help avoid confusion later if you don't have two or three different versions of SQL.

I suspect if you look at the Services running on the server you will see on SQL Server (AutodeskVault) and I think you will see another SQL instance since SQL was installed more than once. 

Regards,

Jason

[Anonymous]

thank you for your advice, i have set a  scheduled backup on the server, but yes surely i will back it up before any changes. 

i am now thinking to install SQL server 2014 Enterprise ( that i am sure is Enterprise really  ) without changing or uninstalling anything,, but i know what you mean by having some other instances of SQL server on this machine.

what do you think?? 

about running SQL services, one instance as " AUTODESKVAULT" is installed by the ADMS, and another on is installed by me as an update to "AUTODESKVAULT", so, i do not think there is another instances. but i will check it tomorrow.

[Madhan_T · Accepted solution]

Hi,

Run the following on Publishing SQL and let me know the result

SELECT SERVERPROPERTY('EngineEdition')

SQL Replication is supported on 2 or 3 (Standard or Enterprise)

For more information please refer 

https://knowledge.autodesk.com/support/vault-products/learn-explore/caas/sfdcarticles/sfdcarticles/S...

Full Replication Requirements

System	32-bit	64-bit
Microsoft SQL Server 2012 Standard, Enterprise (SP3)		✓
Microsoft SQL Server 2014 Standard, Enterprise (SP2)		✓
Microsoft SQL Server 2016 Standard, Enterprise (SP1)		✓

Regards,

Madhan

[Jason.Courtemanche]

Hi @Anonymous,

I wanted to follow up to see if you were able to resolve this by reinstalling SQL to use the correct edition and version?  If not please provide more information about the issue and the step you are on.

Regards,

Jason