July 8, 2009 at 3:03 pm
I need to implement forms authentication and I seem to recall there being some reason that a certain minimum edition was necessary, but I can't find any reference to this information now. Anyone who might know this off the top of your head would be appreciated.
July 28, 2009 at 10:10 pm
SQL Server supports 2 authentication methods, integrated (aka Windows or trusted) and SQL.
Forms authentication is (as I remember) as web page authentication term and has very little to do with the underlying authentication method. But (again as I remember) ASP.NET can use SQL Express for authentication.
Not 100% sure that answers your question.
CEWII
July 29, 2009 at 2:52 am
please clear your answer in sql server terms.
most possible answer no restriction on edition with authentication.
most suitable way is to use your own usename and password or sa username or password.
July 30, 2009 at 4:05 am
If you are talking about forms authentication from an asp.net web page it basically means "You do your own security"
So you'd need a database table with the usernames and passwords and a connection to it (use a sql login) and a page to get user input and call a stored procedure to read it/validate the user and another for updates and so on.
That should apply to any edition of SQL Server.
However I believe you can also implement Forms authentication in Reporting Services. Again it's DIY security and requires code and assemblies. I don't know enough about it but you should be able to Google it and get more information.
Using sa login is WRONG.
sa should never be used for any general access and should hardly ever be used. SQL Admins should be give sys admin privileges on their windows accounts so you can monitor who's done what.
Other users and applications should have their own account with minimum necessary access rights. The only time I've needed an sa login on the forty odd servers I manage has been for installations and COTS packages which are badly written and have to use sa to install.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply