TeamCity Plugin

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace, andy.campbell.smith

TeamCity Plugin

Postby ehuggz » Fri Nov 16, 2012 2:40 am

I am getting errors when trying to implement the SQLDOC generator in the TeamCity plugin. No matter what I do, the password is not stored in the SQLDOC configuration file - and the SQLDOC generation fails with: [Generating documentation] Error: Failed to generate documentation, reason 'Login failed for user 'sa'.'.

When I open the SQLDOC configuration file in SQLDOC I have no problem accessing the DB.

Ideas?
Eric Huggins | Continuous Integration Manager
Pinnacle of Indiana
ehuggz
 
Posts: 7
Joined: Tue Aug 14, 2012 9:41 pm
Location: South Bend, IN

Figured it out

Postby ehuggz » Fri Nov 16, 2012 3:59 am

SQLDoc is only storing the password the first time you create the configuration file. Re-created the file from scratch and saved pw. Many issues with edit, took me a while to realize that selecting edit saved none of the original data. Could not figure out why the SQLDOC would not run until I realized my original entries had been wiped out when editing.

Not good design.
Eric Huggins | Continuous Integration Manager
Pinnacle of Indiana
ehuggz
 
Posts: 7
Joined: Tue Aug 14, 2012 9:41 pm
Location: South Bend, IN

Postby chriskelly » Tue Nov 20, 2012 6:34 pm

Thank you for your post.

The SQL Doc generator is changing. The development team have redesigned this so that it will no longer be necessary to store passwords in the project file. This will mean that it will automatically use the credentials in the TeamCity build runner step.

This new build will be release shortly, I am told, although I don't yet have a date.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Source Control 3

Who is online

Users browsing this forum: No registered users and 0 guests