Introduction to SQL Server
Management Studio
The
SQL Server administrator’s primary tool for interacting with system is SQL
Server Management Studio. Both Admin and end users can use this tool to
administer multiple severs, develop databases.
To
open this tool, click START menu, Programs, Microsoft SQL Server2005 and
then SQL Server Management Studio then
it shows the Connect to Server
Dialog
box which appears right after choosing SQL Server management Studio .
1. For Server type and Server
name we need not enter anything
2. We have 2 authentications in
Authentication list box
a. Windows Authentication : you
will be connected to SQL Server using windows account
b. SQL Server Authentication:
you will be connected to SQL Server using own.
Note:
Default login name is sa and password is sa123
After
connecting to SQL Server ,then it appears as follows
Click
on New Query (available under File menu)
to get Query Editor in which you
can create queries.
No comments:
Post a Comment