How to create logins using windows Authentication mode?
Answer Posted / ram suresh.l
While u create a user login in enterprise manager,u will be
given an option of creating the user with windows
authentication/SQL server authhentication mode.
You can choose the appropriate one
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is page in sql server?
Explain the concept of view and Types of views in SQL server?
How to convert character strings into numeric values?
Explain the properties of sub-query in sql server?
What is cursor in ms sql server?
Can you name some of the dml commands in sql?
What happens if null values are involved in string operations?
What is the difference between stored procedure and user defined functions?
What is the function of sql server agent windows service?
Is BCNF better than 2NF & 3NF? Why?
Can you get second highest salary from the table?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is report subscription?
What are sparse columns?