SQL Change Automation Tool Upgrade errors
I have recently upgraded the ReadyRoll Projects in my VS2017 solution to SQL Change Automation. I’m facing below issues.
Visual Studio Version : Microsoft Professional VS 2017 15.8.7
Upgraded ReadyRoll Version : SQL Change Automation 3 version: 3.0.18291.2122
After updating the ReadyRoll Version we are unable to connect to servers (localdb)\ProjectsV13 or (localdb)\MSSQLLocalDB in SQL Change Automation window.Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Login timeout expired. Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.. Done building project "ProTransact.SQLAutomation.sqlproj" -- FAILED.
But when I connected to <Machine>/SQLEXPRESS2012 its working fine.
As all our developers are using localdb)\ProjectsV13 for development purpose I need to resolve this as early as possible. Tried multiple options but no luck.
Can anyone please reply us why I’m getting this error even though I upgraded to new ReadyRoll version.