Not able to set data source in SQL Management Studio

DavidVer

Hi,

Currently I am not able to set my database that is required to be updated in SQL Server Management studio with the SCA plugin. For me it is a blocker at the moment since there is no support for VS2022.

Regards,
David.

DanC

Hi @DavidVer

I'm going to reach out via a support ticket as in this case I think it would be good to get the log files!

DanC

Hi David,

Sorry to hear you're experiencing this issue!

Could you try removing the "<TargetDatabase>" and "<TargetConnectionString>" from the ".sqlproj.user" file, then open the project from SSMS and this will allow you to select a development database.

Let me know if this helps!

DavidVer

Hi @DanC

These are the only lines in my .sqlproj.user file at the moment.

<?xml version="1.0" encoding="utf-8"?>

<Project ToolsVersion="Current" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"></Project>

DanC

 Hi David,

Interesting, thanks for that update. 

When you open the project in SSMS, are you prompted to set the development source?

DavidVer

Hi Dan,

Yes I am prompted for setting a data source. Attached are some screenshots from my local SMSS and SCA.
After testing the DB connection OK and clicking on OK I still have the "No Development Source" showing.


 

DavidVer

Thank you for your great help today @DanC. I see this issue as resolved.