SQL Change Automation Tool Upgrade errors

Sai · October 26, 2018 10:20AM

Hi Team,

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.

PeterG · October 29, 2018 4:44PM

Can you try running

sqlcmd -S "(localdb)\mssqllocaldb"

and if that fails you can try the fix in https://stackoverflow.com/a/44640176

Sai · October 29, 2018 5:49PM

Thank you so much for your responses...It helped me a lot.. After downloading the ODBC Driver 13.1 for SQL Server the issue got resolved....Thanks a lot Peter

PeterG · October 29, 2018 11:52AM

Hi Sai,

There shouldn't be a problem with connecting to localdb, to help diagnose further could you contact support@red-gate.com with following information:

Version you upgraded from:
Version you upgraded to: 3.0.18291.2122
Visual Studio version: 15.8.7
SQLCmd version:

And the logs from %LOCALAPPDATA%\Red Gate\Logs\SQL Change Automation\VS

Also are you able to connect to (localdb)\ProjectsV13 from the visual studio server explorer?

Sai · October 29, 2018 12:56PM

Hi Peter,

To my surprise I'm not able to connect to (localdb)\ProjectsV13 from the visual studio server explorer. Is that some issue..please let me know.

thanks,

Archana

PeterG · October 29, 2018 1:13PM

Probably means the instance is corrupt or something. You might want to recreate it using the command line: https://docs.microsoft.com/en-us/sql/relational-databases/express-localdb-instance-apis/command-line-management-tool-sqllocaldb-exe?view=sql-server-2017

sqllocaldb.exe stop ProjectsV13
sqllocaldb.exe delete ProjectsV13
sqllocaldb.exe create ProjectsV13

This will force recreate the ProjectsV13 instance on localdb

Sai · October 29, 2018 2:52PM

Hi Peter,

Thanks for your instant replies. Really appreciate it.

I tried the above option of recreating the ProjectsV13 instance, but still its not working.

Please let me know what could be the root cause.

Thanks,

Sai · October 29, 2018 4:28PM

Please find my SQL Change Automation-VS.log file attached

SQL Change Automation Tool Upgrade errors

Best Answers

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk