Connecting to a Workspace in SQL Server

Once a workspace has been created on the Enterprise Analyzer server machine, other users can connect to the workspace from EA clients.

If you use the local MS SQL connection, you need db_owner permissions, because this type of connection creates a database. But if you use the left option, MS SQL via OLE DB, you need a database already created by an administrator. For this database you may have less permissions and the roles can be: db_writer and db_reader.

To grant permissions, run these queries:

USE mydatabase;
GRANT ALTER TO myuser;
GRANT REFERENCES TO myuser;
GO

ALTER permissions are required when upgrading, or using Configuration Manager in the Administration tool. ALTER is also needed by the Batch Refresh Process and Code Search.

When you connect to a workspace, you create a link file with connection information that points to the workspace. Because the connection information is already stored in the file, you do not have to enter it again when you reopen the workspace connection. Like a workspace file, a link file has a .rwp extension.

Open Micro Focus Enterprise Analyzer Administration.
Click File > Build New Connection. The dialog opens. This opens the Options - Define Server Workspace Connection dialog box.
Specify the database connection details:
- Select the database type fro the Database Provider list.
- In the Data Source Name field, type the DSN for the database. Alternatively, click ODBC Manager to open the Select Data Source dialog box. Specify the file dat asource that describes the driver that you wish to connect to.
- In the Database Schema Name field, type your database schema name. select the integrated security provider interface in use at your site. Choose:
  - In the User Name field, type the user name for the database schema.
  - In the Password field, type the password for the corresponding user.
- If you chose Server Authentication, enter the database login name in the User Name field and the login password in the Password field.
  Note: The database user name and login name are typically, but not always, the same. If you have trouble connecting, it may be because you are specifying the database user name rather than the login name.
When you are satisfied that your entries are complete, click the Browse button for the Save Link As (.rwp) field. The Save Server Workspace Connectivity dialog opens.
In the Save Server Workspace Connectivity dialog, choose the location for the workspace link in the Save in drop-down. In the File name field, enter the name of the link. Click Save. The linked workspace opens in the Enterprise Analyzer main window. EA creates a link file (.rwp) in the specified location.