Red Gate forums :: View topic - SQL Server Management Studio add-in: How to specify API key?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Deployment Manager
Deployment Manager forum

SQL Server Management Studio add-in: How to specify API key?

Search in Deployment Manager forum
Post new topic   Reply to topic
Jump to:  
Author Message
elofgren



Joined: 12 Jul 2013
Posts: 2
Location: Covington, KY

PostPosted: Fri Jul 12, 2013 10:42 pm    Post subject: SQL Server Management Studio add-in: How to specify API key? Reply with quote

If I set requireApiKey to true in C:\Program Files (x86)\Red Gate\Deployment Manager\NuGet\Web.config and attempt to publish to Red Gate Deployment Manager's nuget feed I get the following error:

Quote:
Failed to push to package feed at 'http://mysub.mydomain.com/nuget/'. This may be because the server requires an API key to push packages.
(The server responded with: [500] Internal Server Error)


It works fine if change C:\Program Files (x86)\Red Gate\Deployment Manager\NuGet\Web.config back to:
<add key="requireApiKey" value="false"/>

I would like to require an API key to publish packages to my Deployment Manager package feed. Is there a way to tell the SQL Server Management Studio add-in the apiKey value to use for the nuget feed?

Thanks for creating this amazing tool!

- Elijah

Edit: I am using the latest versions of Red Gate Deployment Manager and SQL Server Management Studio add-in as of June 11th or 12th, 2013. Thanks!
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Tue Jul 16, 2013 11:50 am    Post subject: Reply with quote

Thanks for your post.

You actually need to enter an API key on the first step (see screenshot below)- you'll find this on your user profile page within the DM console (i.e. click on "Administrator" at top right)

Back to top
View user's profile Send private message
elofgren



Joined: 12 Jul 2013
Posts: 2
Location: Covington, KY

PostPosted: Tue Jul 16, 2013 1:45 pm    Post subject: Reply with quote

Ah, I see the shared API key must have been replaced with the user-specific API keys. Thanks!
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1116
Location: My desk.

PostPosted: Tue Jul 16, 2013 3:18 pm    Post subject: Reply with quote

Actually, that may not help after all (mainly because I didn't properly read your original post!)

The out-of-the-box Nuget server that comes with DM wasn't really intended to be reconfigured in any way; and as a result, the SSMS plugin doesn't have the functionality within to pass the key (the key you need to enter is a DM API key, not a Nuget key)

If you want to use authentication on the feed like that, then you need to publish from something that's able to do it. This would normally be part of a bigger CI solution using something like TeamCity, and you can then utilise SQLCi.exe with the key needed to push to your Nuget repository. We'd generally assume by this point you've configured your own Nuget as opposed to still using the default-installed one too, although this wouldn't be required specifically.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group