IIS 7 and Above
How to get the streaming file from SQL Server and send it the client...
Last post May 03, 2011 11:20 AM by nnmanobala
Mar 31, 2010 02:38 PM|eagle_tsui|LINK
Apr 01, 2010 04:49 PM|eagle_tsui|LINK
Apr 07, 2010 05:22 AM|Nicolas.Drouin|LINK
Hi, I am not an MS professional, but as I understand it, Smooth Streaming is a client/server protocol. The client is Silverlight, the (prefered) server is IIS Media.
Using SQL is out of scope for IIS Media, you will need another server solution. The IIS Smooth Streaming Transport Protocol is a published protocol, you can find out more about it here:
If you are highly motivated, you could create your own server to bridge between SQL and the client side. An equivalent of the pushencoder, or an implementation of the Smooth Streaming Format SDK (it would pick up the SQL stream and push it to IIS Media).
You might also be able to piece something together with VLC and Wowza.
Best of luck,
Apr 07, 2010 07:59 PM|richma|LINK
Hi , Sorry for the delay from the Microsoft side, but I wanted to confirm that Nick is correct with respect to not supporting any direct connection to a SQL data source. At this time the only supported source is the file system.
Apr 11, 2010 10:33 AM|eagle_tsui|LINK
May 03, 2011 11:20 AM|nnmanobala|LINK
Sir, the problem I'm currently facing is "if photo and video are stored in database how to play it (without draw data from database and save as file)". Currently I don't know any other method other than SQL Server FileStream to store video in a database.
I'd be very much delighted if you reply to this post with any other possible method to stream video from a DB without saving it as a file. Thanks in advance.