Connect to Server (Login Page) Reporting Services

Use this tab to view or specify the following options when connecting to Microsoft SQL Server 2005 Reporting Services (SSRS).

Options

  • Server type
    When registering a server from Object Explorer, select the type of server to connect to: Database Engine, Analysis Services, Reporting Services, SQL Server 2005 Compact Edition, or Integration Services. The rest of the dialog shows only the options that apply to the selected server type. When registering a server from Registered Servers, the Server type box is read-only, and matches the type of server displayed in the Registered Servers component. To register a different type of server, select Database Engine, Analysis Services, Reporting Services, SQL Server 2005 Compact Edition, or Integration Services from the Registered Servers toolbar before starting to register a new server.
  • Server name
    Specify the report server instance to connect to. In Management Studio, you can access a report server through its instance name. You can have one report server instance for each SQL Server instance that you install. If you are using the default instance, type the name of the SQL Server instance. If you are using a named instance, specify the named instance to connect to the report server in the format MSSQL$InstanceName.
  • Authentication
    Authentication to a report server is made through Internet Information Services (IIS). Select from one of the following authentication modes when connecting to Reporting Services:
  • Windows Authentication Mode (Windows Authentication)
    Connect to the report server instance using your Microsoft Windows credentials.
  • Basic Authentication
    Connect using Basic Authentication if your Reporting Services installation is configured to use Basic Authentication.
  • Forms Authentication
    Connect using Forms Authentication if your Reporting Services installation is configured to use a custom authentication extension.
  • User Name
    Enter the login name to use for the connection. This option is only available if you have selected Basic or Forms Authentication.
  • Password
    Enter the password for the user name. This option is only editable if you have selected Basic or Forms Authentication.
  • Remember password
    Store the password you have entered. This option is only displayed if you click Options, and it is only editable if you have selected to connect using Basic or Forms Authentication.
  • Connect
    Connect to the selected server.
  • Options
    Display additional server connection options, such as remembering the password.

See Also

Other Resources

Configuring a Report Server Database Connection
How to: Connect to SQL Server from Windows Vista

Help and Information

Getting SQL Server 2005 Assistance