Connect to Server (Reporting Services)
Applies To: SQL Server 2016 Preview
Use this dialog to view or specify options when connecting to Microsoft Reporting Services.
- Server type
When registering a server from Object Explorer, select the type of server to connect to: Database Engine, Analysis Services, Reporting Services, 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, or Integration Services from the Registered Servers toolbar before starting to register a new server.
- Server name
The server mode of the report server instance you are connecting to determines the value you must enter.
For a report server that runs in native mode, specify the report server instance to connect to. If you are using the default instance, the server name is typically the name of the computer. If you installed a named instance, append the instance name to the server name in this format: <servername>\<InstanceName>. Reporting Services uses the backslash character to delimit the instance name.
For a report server that runs in SharePoint integrated mode, you must specify a SharePoint site. You can specify any site in a site collection that is integrated with Reporting Services. The URL that you provide must include the HTTP or HTTPS prefix. You must have permission to access the SharePoint site in order to connect to it in Management Studio. The permission level you are assigned to will determine which items you can view and manage. For more information, see Connect to a Report Server in Management Studio.
Reporting Services can be configured to accept Windows Authentication requests or Forms authentication requests that are handled by a custom authentication extension that you provide. 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.
Enter the password for the user name. This option is only editable if you have selected Basic or Forms Authentication.
Click to connect to the server selected above.
Click to display additional server connection options, such as registering a server and remembering the password.