Database Reference
In-Depth Information
Connecting to a Database Service
Microsoft has made it very easy to connect to an SQL Server Relational Database Engine service. Just
follow these steps:
1. Open SQL Server Management Studio.
2. Click Connect in the Object Explorer window.
3. Select Database Engine from the Server Type drop-down menu.
The Connect to Server dialog box shown in Figure 8-2 opens.
Figure 8-2: Connecting to an SQL Server Relational Database Engine service.
4. Choose the appropriate server name and authentication method.
If you don't know the authentication method to use, contact the administrator.
5. Click Connect.
Now that you have connected to the service, you can expand the databases folders in the Object
Explorer window to see if there are any databases created on the service. By default there aren't any.
SQL Server Security
SQL Server security is quite extensive and complex to master. The full scope of security capabilities
are beyond the scope of this topic, but we'll tell you how to get up and running with your analytics
system. At a very high level, there are three levels of access that you should be concerned with:
Server, Database, and Database Objects.
Server access
Server access security has two aspects: login and server roles (see Figure 8-3).
 
Search WWH ::




Custom Search