Publishing SQL Express June CTP as a "Prerequisite"?

Hello,

I have not conducted extensive testing yet, but I have installed the June CTP of SQL Express and everything is working fine with my Beta 2 copy of VS.NET 2005. I see that "SQL Server 2005 Express Edition Beta" is listed in the "Choose which prerequisites to install" list of the VS.NET 2005 project settings for a basic Windows Forms Application.

My question is: Is this functionality expected to work fine in the Beta 2 for testing? Meaning, if I were to test publishing my app on a new test-copy of Windows XP Pro SP2, can I expect that in most cases it will deploy the June CTP components just fine?

Thanks much,

Sean H.If it does not work then its a bug and should be reported.

-Euan|||

FYI - From what I can tell this feature does (and yet does not) work with "ClickOnce" deployment and the publish feature. It seems that even though you can select SQL Express as a prerequisite and it does seem to install properly on test clients, it installs a previous version of SQL Express and not the June CTP.

I haven't investigated fully, but I get the error:

"The database 'C:\Test.MDF' cannot be opened because it is version 607. This server supports version 603 and earlier. A downgrade path is not supported."

.. when attempting to use the prerequisite publish feature with June CTP created databases. I would imagine this will be fixed in the final build.

For now, it seems ClickOnce publishing does not support the June CTP of SQL Express 2005.

|||I think this is because VS B2 understands the april CTP not the June CTP, this should be fixed for RTM.

-Euan|||

Do you know how to solve this problem without downloading a new version of SQL 2005

Thanks

Regards,Vincent

|||I think you will need a new version of VS and SQL Server Express if it does not work in the VS June CTP.

-Euan