Getting Started With SQL Server

In my previous blog I listed the differnce between Various versions of SQL Server and installation steps for SQL Server.

In this blog we will see how to start working with SQL.

Opening SQL Sever Instance:

Follow the below steps to Start Open SQL Server Instance.

Start -- > All Programs -- >MicroSoft SQL Server 2005 ( or what ever the instance you have in your system ) -- >SQL Server Management Studio

A popup will be displayed asking for the credentails:

Enter your credentials in the above Window.
SQL Server has its own built in system for security that covers logins and roles.There are 2 types of authentications in SQL Server.
  • Windows Authentication
  • SQL Server Suthentication
Windows Authentication: When you are accessing SQL Server from the same computer it
is installed on, you shouldn't be prompted to type in an username and password. In Windows Authentication server uses the system login credentials to enter into Database.Ideally, Windows authentication must be used when working in an Intranet type of an environment.

 SQL Server Suthentication:SQL Authentication is the typical authentication used for various database systems, composed of a username and a password.Obviously, an instance of SQL Server can have multiple such user accounts (using SQL authentication) with different usernames and passwords. In shared servers where different users should have access to different databases, SQL authentication should be used.Also, when a client (remote computer) connects to an instance of SQL Server on other computer than the one on which the client is running, SQL Server authentication is needed.

Here are the differences between SQL Server and Windows Authentication:

Enter into the Database with your credentials.

We will learn about System Databases in the next blog.

Bookmark the permalink.

Leave a reply