authentication - Deploy SQL Server Database to Hosting Environment -
i want deploy web application including sql server 2008 database local machine hoster.
so far used windows authentication, necessary switch username , password when want make application public on internet?
and if that's case, what's best practice hide information if saved strings in web.config
?
side note: use linq entities object mapper , within code use httpcontext.current.user
authenticate user
- if not using shared hosting, can keep using windows authentication more secure having sql server user.
- you should disable remote connections no 1 can directly access sql server make more secure.
- for encrypting connection string check site.
Comments
Post a Comment