Versions Compared

Old Version 2

changes.mady.by.user user-dd014

Saved on

compared with

New Version Current

changes.mady.by.user Paulo Tsuchiya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Overview

SQL Server

Easy Heading Macro
headingIndent40
navigationTitleOn this page
selectorh2,h3
wrapNavigationTexttrue
navigationExpandOptiondisable-expand-collapse
This page presents information about how to make a connection with SQL Server.

Description

Microsoft SQL Server

is a relational database management system developed by Microsoft. As a database server,

it is a software product with the

its primary function

of

is storing and retrieving data, as

requested by

other software applications

, which

request. These applications may run

either

on the same

computer

or

on

another computer across a network

(including the Internet)

.

Microsoft makes

SQL Server is available in multiple editions, each with

different

distinct feature sets

and targeting

tailored to different users.

This document

will focus

focuses on SQL Server Express Edition,

which is

a scaled-down

,

free

edition

version of SQL Server

and

that includes the core database engine.

On this page:

Table of Contents
maxLevel3
stylenone

SQL Server Management Studio

SQL Server Management Studio is a GUI tool included with SQL Server 2005 and later that is used for configuring, managing, and administering all components within Microsoft SQL Server. The tool includes both comprises script editors and graphical tools that work with objects and features of the server. SQL Server Management Studio You can also be used to create use it to:

  • Create a new database
, change
  • .
  • Change any existing database schema by adding or modifying tables and indexes.
  • Analyze performance.

It includes a , or analyze performance — including the query windows, which provide a GUI-based interface to write and execute queries.

Create

Creating a New Account

SQL Server Authentication is a default mechanism to connect to MS SQL Server. However, but there are times that when you need to use SQL Server Authentication to connect to the server. In order to use SQL Server Authentication, you need To use it, follow the steps below to create a SQL Server Authentication Login ID.1.

  1. Run Microsoft SQL Server Management Studio.
2. Expand the Security item in the
  1. In the Object Explorer,
right.
  1. access Security.
  2. Right-click Logins, and choose New Login.
..

Click New Login...Image Removed
  1. Image Added
3.
  1. Enter an account name in the Login name field
and choose
  1. .

  2. Select the SQL Server

authentication. Then,

  1. Authentication option and enter a password for the account.

    Note

    Uncheck the following options to set the password as you want:

    • Enforce password policy.
    • Enforce password expiration.
User
    • The user must change the password at the next login.

    If the above options are checked, you

should

  1. will be required to set the password according to the security policy in Windows.

4. Choose master from


  2. Set the Default database
drop-down list
  1. to master.

Remember to uncheck the options aforementionedImage Removed

5. Go to the Server Roles page and select
  1. Image Added
  2. Access Server Roles.
  3. Check sysadmin.

Image Removed

6. Go to the User Mapping page and choose master and
  1. Image Added
  2. Access User Mapping.
  3. Check Master.
  4. Check db_
db
  1. owner.

Choose master and db owner.Image Removed

7. Go to the Status page. Set the
  1. Image Added
  2. Access Status.
  3. Set Permission to connect to database engine
to
  1.  to Grant and
set
  1. Login to Enabled.

Status page optionsImage Removed

8.

Connect and disconnect buttonsImage Removed

9.
  1. Click OK.
    Image Added
  2. Disconnect the database server
in the Object Explorer and reconnect to it using the ID you have just created.
  1. . After, reconnect it.
  1. Choose SQL Server Authentication from the Authentication drop-down list and enter the ID and password. Then,
click
  1. click Connect.
Enter your login and password, then click ConnectImage Removed
  1. Image Added

Connecting With Dataset Module

Go to Datasets → DBs on the Available Providers ListBox

To connect with the Dataset module, follow the steps below:

  1. Access Datasets / DBs.
  2. Click the plus icon.
  3. Fill in the Name field.
  4. In the Provider field, select SqlClient Data Provider
and choose SQL Server
  1. .

Create new Database connection optionsImage Removed

The following configurations require the user to be logged in as an Administrator.

In the LogonName column, insert the newly created user. In the LogonPassword column, insert the password.

LogonName and LogonPassword columnsImage Removed

In the ConnectionString column, the fields are configured as in the image.

Info
  1. Click OK.
    Image Added
  2. Enter the password you created before in the Logon Password column.
  3. Open the Connection String column options and enter the username you created in the User Id setting in the Additional Parameters field. Use
You must always use
  1. the Test button to make sure the connection is correctly configured.
Image Removed

Image Added

Info

The user must have administrator privileges to configure the connection as described above.


In this section

...

:

Page Tree
root@parent
spacesV10