Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
- 1 Answers
- 1200 Views
- I also Faced
- E-Mail Answers
Answer Posted / Banti
In SQL Server, version 6.5 used SAS (SQL Authentication Service) for authentication while version 7.0 introduced Windows Authentication (also known as Integrated Security). The main difference lies in the method of authentication: SAS uses SQL Server-specific user names and passwords, whereas Windows Authentication relies on the security context provided by the operating system.nnIn version 6.5, you could have mixed-mode authentication that supports both SAS and Windows Authentication. However, it's recommended to use only Windows Authentication in modern versions of SQL Server.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different subsets of sql?
Equi join and non equi join is possible with sql server?
What is the primary use of the model database?
What is acid mean in sql server?
Can one drop a column from a table?
What are the kinds of subquery?
What is standby servers? Explain types of standby servers.
What is clustered index
what is spatial nonclustered index
How raid can influence database performance?
What are the different types of subquery?
What is the difference between for xml raw and for xml auto?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is subquery? Explain the properties of a subquery?
