Database Reference
In-Depth Information
3.
As shown in Figure 1-2, set the following options:
a.
Set “Server type” to Database Engine.
b.
Set “Server name” to localhost\<your server name>. For me, as shown in
Figure 1-1, the name is SQL2012, so the server name will be
localhost\SQL2012. Also note that the server name is not case-sensitive; you
can type in any case (lower or upper) you want.
c.
Set Authentication to Windows Authentication. This is the default
authentication type SQL Server gets installed with. This indicates that the
machine's logged-in user name will be carried over to connect to SQL Server.
d.
Set “User name” to the user credentials by which you want to connect to SQL
Server. Many SQL Server databases are installed with Windows
Authentication, and hence you will see the same machine's logged-in user
name by default added here. In many cases, it might be Administrator or a
unique name like you see in Figure 1-2, which is Redmond\v-vidyag.
4.
Click the Connect button, and you will be taken to SQL Server Management
Studio, which will look something like Figure 1-3.
Figure 1-3.
SQL Server Management Studio after successful connection to SQL Server database engine
5.
If instead of having a window as shown in Figure 1-3 you get an error after
clicking the Connect button in the Connect to Server dialog, it will look like
Figure 1-4.
