Using FileStream feature of SQL Server 2008 in production
I am using Filestream feature for storing BLOBS.
1.I found in the MSDN site that Filestream feature uses only Windows Authentication.
2.myConnectionString = "Data Source=localhost\sqlexpress;Initial Catalog=AdventureWorks;Integrated Security=SSPI;";
3.I am using a web application.
4.After
deploying in the server ,how can I give access to the clients to access
the database using Windows authentication,since every user cannot be
added to server to have the access to db.
5.I also found that it wont accept the SQl Server authentication so that one user can be granted full access.
6.What is the best practice of using Filestream in production environment.