Popular Posts

  • Retrieving the data posted to a JSP file from HTML file
    Now I will show you how to retrieve the data posted from a HTML file in a JSP page. Consider an html page that prompts the user to enter his...
  • Accessing the Standard CGI Variables
    Accessing the Standard CGI Variables: To build the successful web application, you often need to know a lot about the environment in which ...
  • INTRODUCTION TO C
    INTRODUCTION TO 'C': C is a programming language developed at AT & T's Bell laboratories of USA in 1972.it was designed by d...
  • SQL ALIASES
    SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
  • Learning about Events (Continue)
    Learning about Events (Continue) Lets program the Form_Load event. "MsgBox" is Visual Basic command that launch a message box. for...
  • Exercise 11.3: Polymorphism
    Steps to follow: 1. Write Person.java as shown below in Code-11.3.a under polypackage directory. (You are welcome to do this work using eit...
  • The Command Button's KeyPress, KeyDown and KeyUp Events
    The Command Button's KeyPress, KeyDown and KeyUp Events The events that will be mentioned in the following pages are commonly used, and ...
  • SQL AVG
    The SQL AVG aggregate function selects the average value for certain table column. Have a look at the SQL AVG syntax: SELECT AVG(Column1) FR...
  • INTERFACES EXAMPLES
    package interfaceexercise; // Define an interface with three abstract methods. // Any class that implements this interface has to // impleme...
  • SQL LIKE
    We will use the Customers table to illustrate the SQL LIKE clause usage: FirstName LastName Email DOB Phone John Smith John.Smith@yaho...

Wednesday, March 18, 2009

Selecting authentication mode while installing

SQL Server (and SQL Server Express) supports two authentication modes:

1. Windows Authentication mode
2. Mixed Mode (Windows Authentication and SQL Authentication)

If you select "Windows Mode", you have to use your windows user id and password to connect to SQL Server. Microsoft recommends "Windows Mode" for security reasons.

If you select "Mixed Mode", you have both the options - either use your windows account or create users in SQL Server.

For learning purpose, let us select "Mixed Mode" when you install SQL Server. When you select this mode, a default administrative account called "sa" will be created on SQL Server. You have to select a password for this account.




Enter a secure password in the above dialog and proceed. Don't forget this password. This is your administrative password and you should use this account to create new users in SQL Server.

Your Administrative Account in SQL Server: sa
Administrative password:

If you installed SQL Server Express Advanced Edition, then it will also install SQL Server Management Studio automatically. SQL Management Studio Express is a tool that is used to view, edit, create and manage databases.

If you installed regular version of SQL Server Express, then you must install Management Studio Express separately. Proceed to next chapter for installation instructions on Management Studio Express
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)