vikasmathodu a

vikasmathodu a

  • NA
  • 3
  • 7.8k

Using FileStream feature of SQL Server 2008 in production

Sep 2 2012 10:31 AM
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.

Answers (1)