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)
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
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 127.0.0.1
Server name = (local)
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.
EmoticonEmoticon