Command: Connect

 

Connect to a reporting services interface.

 

SSRS Version:

 

2000, 2005 (N), 2005 (I), 2008 (N), 2008 (I),2008r2(N), 2008r2(I), Azure

 

(N)=Native

(I)=Integrated

 

 

Syntax

 

Connect ReportServer [[/U:<UserName>] [/P:Password]|/E:Password] [/s:site] [/A]

Connect [/?] displays help

 

 

Parameters

 

 

If no user is specified then current Windows user is used

 

ReportServer   Name of the report server

               user the reportserver soap inteface

                eg.

                         http://www.acme.com/reportserver

                         https://www.acme.com/reportserver

/U:username    Windows username (domain\user)

/P:password    Users password

                 If password has spaces wrap in double quotes

                 If password has " replace with ""

/E:password    Users password- encrypted password- used password encryption application to create password

                 If password has spaces wrap in double quotes

                 If password has " replace with ""

/S:site        Connect to the SharePoint site

               Note: This is optional it can be specified later using SetSite

                     To list sites use the command GetSites

/A             SQL Azure. URL Must start with https://

 

 

 

 

Examples

 

Native mode

 

connect http://192.168.1.1/reportserver /u:dev1\fred /p:welcome1

 

In this example it defines the following

 

ReportServer                : http://192.168.1.1/reportserver.

Username                : dev1\fred   (the domain is dev1 and the user is fred)

Password                : welcome1

 

 

 

connect http://192.168.1.1:8080/reportserver /u:dev1\fred /p:welcome1

 

Native mode connection with different port (8080)

In this example it defines the following

 

ReportServer                : http://192.168.1.1:8080/reportserver. The port is also defined here  (8080)

Username                : dev1\fred   (the domain is dev1 and the user is fred)

Password                : welcome1

 

 

 

 

 

Integrated mode

 

connect http://192.168.1.76:8080/reportserver /u:dev1\fred /p:welcome1  /s:http://dev1/sites/ssrs

 

In this example it defines the following

 

ReportServer                : http://192.168.1.1:8080/reportserver. The port is also defined here  (8080)

Username                : dev1\fred   (the domain is dev1 and the user is fred)

Password                : welcome1

 

 

Remarks

 

•The evaluation version can only connect to local host.

•Rather than use /P for the password use /E can be used to encrypt the password and hide the password on the screen and in a batch file.

 You will need to use the password encryption application

•/S does not need to be specified on the connection it can be chosen later using the command SetSite

 

See Also

 

 GetSites        List site names (used only in integrated mode)

SetSite        For setting the site name (used only in integrated mode)