How to: Connect to a SQL Server Database with "Quadrant"

  • Article

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

This topic shows how to connect Microsoft code name “Quadrant” to a SQL Server database. You can create multiple sessions per database. For more information about sessions, see About Database Sessions in "Quadrant".

Once you have created a session, you can create, update, and delete rows from a table. For more information about editing data, see Editing Data in "Quadrant".

If the instance of SQL Server is on a remote machine, you must enable it to allow remote connections. For more information, see How to: Enable Remote Connections on SQL Server.

Database Sessions

To create a new session

  1. In “Quadrant”, on the File menu, click New, and click Session… (or press Control-Shift-N). The New Database Session dialog box appears.

  2. In the Server box, type the name of the computer that is hosting the instance of SQL Server. If the instance is on the same computer that “Quadrant” is installed on, leave the box set to "." (period). The period indicates that the current computer hosts the database.

    Tip

    If you have already connected to a server in a previous session by using “Quadrant”, click the dropdown arrow. The names of previously-used servers appear in the drop-down list.

  3. In the Database box you can set the name of a database. If the database uses Windows authentication, click the drop-down button to see all databases that are discoverable. If the database uses SQL Server authentication, type the name of the database.

  4. The session name box is populated with the name of the database. You can overwrite the value as long as it is unique. That is the name that will be displayed in the explorer to identify the session.

  5. Optional. Click the More heading to change how the user is authenticated.

    Set the Authentication method to either Windows Authentication or SQL Server Authentication.

    Set the UserName and Password fields as appropriate to the authentication method.

  6. Click the Create button.

    Note

    If the attempt to connect fails, an error window appears with the name of the failed database connection as the title. You can press F5 to try to connect again.

To connect to a SQL Azure database

  1. On the File menu, click New, and then click Session.

  2. In the Server box type the TCP address of the database. For example: tcp:yourServer.ctp.database.windows.net

  3. In the Database box type the name of the database.

  4. Optional. Overwrite the value in the Session Name box to rename the session.

  5. Click More to expand the section.

  6. Click Authentication and select SQL Server Authentication.

  7. In the Username box type your username in the format: user@server: user@ yourServer

  8. In the Password box, type your password.

  9. Optional. Click the Remember password option box.

  10. Click Create.

To access a session with no open workpads

  • On the View menu, click Explorer. A menu list appears containing the names of all open sessions. Click a database name to show it in a workpad.

See Also

Tasks

How to: Enable Remote Connections on SQL Server