Installing Microsoft ODBC Driver for SQL Server failed

Automated deployment for web applications and databases

Moderators: Mike Upton, justin.caldicott, Sean.newham, csmith, chirayu, DavidSimner, david.conlin

Installing Microsoft ODBC Driver for SQL Server failed

Postby swinghouse » Tue Mar 19, 2013 10:58 am

I'm not entirely certain that this is caused by the latest version of Deployment Manager and/or the TeamCity plugin, since I unfortunately made some other changes on our "CI plus deployment" server at the same time (not very clever to change several things simultaneously, I know!), but currently we're encountering the following error in TeamCity:

[10:43:40]Updating database (20s)
[10:44:01]Creating scratch database sqlCI_69f21e75-4db1-4225-b58c-4ec2f4b66125
[10:44:02]Generating creation script (16s)
[10:44:19]Installing Microsoft ODBC Driver for SQL Server (1s)
[10:44:19][Installing Microsoft ODBC Driver for SQL Server] Starting: msiexec.exe /i "C:\\TeamCity\\buildAgent\\plugins\\RedGateSQLServer\\assets\\msOdbcSql\\x64\\msodbcsql.msi" /qn
[10:44:20][Installing Microsoft ODBC Driver for SQL Server] ##teamcity[buildStatus status='FAILURE' text='Installing Microsoft ODBC Driver for SQL Server failed with exit code 1603']
[10:44:24]sqlCI error occurred: RedGate.SQLCI.Engine.Error: Installing Microsoft ODBC Driver for SQL Server failed with exit code 1603


This error occurs when your TeamCity plugin tries to validate the creation script during the build process.

What I do know is that this worked beautifully until last week, when I updated to the latest versions of Deployment Manager and the TeamCity plugin.

Any help in solving this problem is most appreciated!

Version numbers:
Deployment Manager: 1.1.2.1
TeamCity Professional: 7.1.4 (build 24331)
Red Gate TeamCity plugin: 1.0.0.1029
SQL Server: 2008 R2 (Express Edition)
OS: Windows 7 Professional
swinghouse
 
Posts: 99
Joined: Mon Sep 12, 2011 10:51 am

Postby Emma A » Thu Mar 21, 2013 7:34 pm

Thank you for this feedback, we are aware of this issue and are validating the fix at the moment.
To workaround this, if you access the build agent machine and then get a copy of the msi (c:\\TeamCity\\buildAgent\\plugins\\RedGateSQLServer\\assets\\msOdbcSql\\x64\\msodbcsql.msi) and run the msi yourself, the TeamCity plugin will detect that it is installed and so not try to install.
Emma A
 
Posts: 40
Joined: Mon Mar 30, 2009 2:53 pm

Postby swinghouse » Fri Mar 22, 2013 8:50 am

Thanks Emma,

The workaround did the trick!

/Mattias
swinghouse
 
Posts: 99
Joined: Mon Sep 12, 2011 10:51 am


Return to Deployment Manager

Who is online

Users browsing this forum: No registered users and 0 guests