Connection dialog window freezes, doesn't close upon clicking OK

Asif

Visual studio enterprise 2015 and Ready roll pro is installed on my dev machine. Database projects build successfully without any errors. I click "Set the target database connection string for this project", then I choose database name and click OK nothing happens, connection dialog box doesn't close upon clicking OK but it closes when I click Cancel.
See attached:

dnlnln

I'm sorry to hear that you're running into a problem with the connection dialog. Would you mind trying the following:

1. Open the project designer (right-click the project in the Solution Explorer and select Properties)
2. Switch to the Debug tab and under Target Connection String, click Edit...
3. When the connection dialog appears, select the desired db

Are you able to click OK at this point?

Asif

Thanks @dnlnln for your response. I see below error when I clicked Debug

dnlnln

Thank you for posting the error details, that's quite an unusual one!

Would you mind trying the following to see if the problem can be reproduced with the standard Visual Studio SQL Server Database Projects (SSDT):

1. Close the solution.
2. If the ReadyRoll windows are still open, close them
3. Close VS and re-launch
4. Create new project, SQL Server, SQL Server Database Project
5. Open the project designer to the Debug tab. Does the error occur at this point?
6. Create new project, SQL Server, ReadyRoll SQL Server Database Project
7. Open the project designer to the Debug tab. Does the error occur again?

Asif

Hi @dnlnln
Same error with either of new project
New Sql server project:


New RR project:


Thanks

dnlnln

Judging by the results, unfortunately it seems like there could be a broader issue with the underlying database project system (SSDT).

To confirm this, please try uninstalling ReadyRoll and repeating steps 1-5. If the error still occurs, then the issue is likely to be an issue with the Visual Studio installation itself.

Try updating SSDT to the latest version:
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt

If it still doesn't work, then you may need to raise the issue with SSDT support:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=ssdt