What is Sql Server And how to install it

What is a SQL Server?

SQL Server is a Microsoft product used to manage and store information. Technically, SQL Server is a “relational database management system” (RDMS). Broken apart, this term means two things. First, that data stored inside SQL Server will be housed in a “relational database”, and second, that SQL Server is an entire “management system”, not just a database. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.

How to install Sql Server

Before installing SQL server to our system we need to install service pack ,you can download service pack from the Microsoft website . Here i am explaining how to install SQL server version 8, installing all the version of SQL server are same ,there is not any difficulty to install SQL server, it is easy as other s/w to install

After installing service pack Run the SQL server setup and click on the installation and then click on the 1st link as shown in above

Here it will ask for the product key which will have in your setup

After that terms and condition ,accept in and click on next

in following image select all the checkbox ,these are the features which will be available in our SQL server.

This is the following steps, click on next and go ahead

in following image show that if you want to give credential to your SQL Server setup and give here.

this is the final step to install SQL Server, it will take little time to install

after click on next your SQL Server to ready means it installed successfully.

Now your SQL server is ready to work ,you can open it form your all Programme window ,and run it .

Connecting to SQL Server using SSMS

SQL Server Management Studio (SSMS), is the client tool that can be used to write and execute SQL queries. To connect to the SQL Server Management Studio
1. Click Start
2. Select All Programs
3. Select Microsoft SQL Server 2005, 2008, or 2008 R2 (Depending on the version installed)
4. Select SQL Server Management Studio
You will now see, Connect to Server window.
1. Select Database Engine as the Server Type. The other options that you will see here are Analysis Services(SSAS), Reporting Services (SSRS) and Integration Services(SSIS).
Server type = Database Engine
2. Next you need to specify the Server Name. Here we can specify the name or the server or IP Address.If you have SQL Server installed on your local machine, you can specify, (local) or just . (Period) or
Server name = (local)
3. Now select Authentication. The options available here, depends on how you have installed SQL Server. During installation, if you have chosen mixed mode authentication, you will have both Windows Authentication and SQL Server Authentication. Otherwise, you will just be able to connect using windows authentication.
4. If you have chosen Windows Authentication, you dont have to enter user name and password, otherwise enter the user name and password and click connect.
You should now be connected to SQL Server. Now, click on New Query, on the top left hand corner of SSMS. This should open a new query editor window, where we can type sql queries and execute.
SSMS is a client tool and not the Server by itself. Usually database server (SQL Server), will be on a dedicated machine, and developers connect to the server using SSMS from their respective local (development) computers.

Share this

Related Posts

Next Post »