SQL Server 2005 introduced a means to enforce password and lockout policies for SQL Server login accounts when using SQL Server Authentication. SQL Server 2008 continues to do so.

I've got a SQL server that I'm reviewing that uses mixed mode authentication. I have an entry in the syslogins table that lists a user with a NULL password, this user is an NTUser that does have ...

Under the cover, the authentication code automatically acquires a service ticket for the file server based on your logon ticket. If you access a SQL Server database or a Microsoft IIS-protected ...

The report relies on a database on ServerA. They design the data source for the report to rely on Windows Authentication to the SQL Server instance on ServerA. They then deploy the report (which ...

I realized after reviewing the past few posts that I omitted a new piece of functionality introduced in SQL Server 2008 R2. This feature, known as Extended Protection for Authentication (Extended ...

SQL authentication only-for obvious reasons, integrated security cannot be implemented, but this may be an issue for your security model. Unsupported features compared to SQL Server 2008 include: The ...

They come as a response to user feedback. Microsoft has updated its Azure SQL Data Warehouse service with several key new features including Azure Active Directory authentication, eased cloud ...