Windows 10: Sync Center not showing SQL Express 2019 Subscriptions

We are in the process of migrating from SQL 2008R2 to 2019. We use transactional and merge replication. When creating the pull subscriptions from the subscribing PC under 2008R2, it was always necessary to change the registry permissions in order for the subscriptions to show in Sync Center so the user could sync their data. Now with 2019, even changing the permissions does not cause them to be displayed in Sync Center. The subscriptions are seemingly correctly registered in: Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\Replication\Subscriptions\PUBLISHERublisherDBubName:subscriber name:subscriptionDB.


Are there other reasons these subscriptions won't display in Sync Center?

:)

 

SQL server Express Edition

What's the last version of SQL server standard i can use on Windows 7 SP1?

Also, I DID install the express edition 2014, but i found out that the "SQL Agent' is not functional.. you must have full SQL for this..

SQL Server Agent (SQLEXPRESS) automatically stop

SQL agent in Express 'starts', then 'stops' and unable to even start the services in services.msc..

There are 'possible' workarounds like deleting and creating new user under Users & Groups, but that doesn't work either for me.

If SQL server standard my only option ? I'm assuming the SQL Server Agent brings mage and control dabases which is what i need in Nopcomerence.

 

SQL Server 2017 Express Issue with 3 Tier database access.

Hi, I am facing an issue with SQL Server 2017 Express.

My client is on PC1, SQL server is configured on PC2 and the database is on PC3. I could successfully connect to SQL server on PC2 through client on PC1, but if I try to access the database on PC 3 using client on PC1, I get following error...

"Msg 5120, Level 16, State 101, Line 2

Unable to open the physical file "\\MD1Z549C.ad001.siemens.net\Database_DT\Products\ProductDB.mdf". Operating system error 5: "5(Access is denied.)".

Msg 1802, Level 16, State 7, Line 2

CREATE DATABASE failed. Some file names listed could not be created. Check related errors."

When i access the database on PC2 there is no Issue. or if i use other SQL server from PC1 then I could access database database on PC3 as well. (here no intermediate PC2 is used)

So issue is when I have Client, SQL Server and Database on 3 different machines. (it gives above errro message)

The same scenario used to work well with SQL server 2008 R2 Express.

The same issue is reproducible with SQL server 2017 full version and SQL server 2019.

All the three PCs, shared drives and SQL server are configured well, which used to work with SQL server 2008 R2 express.

Is there any limitation or restriction introduced with the latest version of SQL server ? OR anything I need to try out to make the scenario work on three different machine.

Thanks a lot in advance.

 

SQL Express 2016 - Adventureworks Database

What is the best Adventureworks Database to install on SQL Server Express 2016? I see there are several different 2016 AW databases. I am a beginner - just installed SQL Express on my computer. I need
to use Adventureworks to learn to build tables and write T-SQL queries