Blog Archives

Download Recordings from Adobe Connect Pro

Thanks goes to Guillaume Privat on Adobe Learning Center (see references below for links):

(And a shout out to Matt Chambers for providing the links :D)

1) You need to ensure you are an account administrator of have full right on the recording.

2) Find the URL of the recording you want to extract.

3) Add /output/recording.zip?download=zip at the end of the recording URL.

4) Save the zip file on your desktop

Example download link:
http://aquo.adobe.acrobat.com/p14313281/output/recording.zip?download=zip

Open the zip, and verify contents. It should contain .flv and xml files. mainstream.flv is to playback all and the actual audio/video content is denoted by filenames with underscores.

The alternative is offline recording, which results in a couple flat .flv’s, but in this format, once downloaded… the fun begins.

Both richflv and Moyea seem to have trouble with the Sorenson Sparks / On2 VP6 / Nellymoser / Speex codec mishmash Adobe mashed up with their flv “pods” and XML.. “keyframes” (cue points) spot the video in random intervals, and cause issues with edited output playback and seek/fast forward/rewind.

Good luck. 😉

References:
Recordings Deep Dive part 1 and 2, http://connectusers.com/tutorials/2009/08/recordings_deep_dive_part1/index.php, http://connectusers.com/tutorials/2009/09/recordings_deep_dive_part2/index.php
RichFLV, http://richapps.de/?page_id=120
Moyea FLV Editor (PRO), http://www.moyea.com/flv-converter/
Nellymoser, http://en.wikipedia.org/wiki/Nellymoser_Asao_Codec
Sorenson (Sparks), http://en.wikipedia.org/wiki/Sorenson_codec
On2 VP6, http://en.wikipedia.org/wiki/VP6
Speex, http://www.speex.org/

Change default MSSQL Port and Connect

Changing default port of Microsoft SQL Server differs depending on the version. The following is for the latest version of MSSQL only.

If you’re using 2005, the steps are similar to those below, but the area you need to go is the SQL surface area configuration instead.

If you’re using 2000, it’s time to upgrade. 2000 is pretty out of date. We’ll probably be looking at something newer than SQL 2008 before long.

MSSQL 2008:
1) Goto: SQL Server Configuration Manager > SQL Server Services > (right click on your server instance) > Stop

2) Goto: SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for [Instance Name] > Right click TCP/IP (make sure it’s enabled) > IP Addresses Tab

3) Once you’re at this tab find the IP that corresponds to the address of your network adapter that is connected to the router (IP1 in my case though on servers this could easily be variable).

4) Remove 0 from “TCP Dynamic Ports” and set the “TCP Port” field to the number you want (default is 1433). If you scroll to the bottom you will also note there is an “IPAll” which I also did the same for.

5) Change any firewall rules that may block the connection (add a new port in Windows firewall).

6) Restart service instance. (step 1)

Some blogs and articles I came across mention starting the SQL Server Browser, however, I would like to mention that although you should have this service running for a couple reasons, the above configuration works without the browser and doesn’t technically need it to connect remotely if you know exactly which port you’re connecting to.

To connect remotely on different port make sure TCP/IP is enabled for the server instance in configuration manager, and in management studio or your application connection string specify:
servername,portnumber\instancename

Note that a different port number is specified using a comma, not a : like you may have expected.

References
Microsoft KB, http://support.microsoft.com/kb/914277
SQLServerPedia, http://sqlserverpedia.com/blog/sql-server-tutorial/how-do-i-change-a-sql-port-number/