connection could not be made to Report Server

Hi,

My report server and report manager was working fine till yesterday. But suddenly today when i tried to deploy a report i got error: "A connection could not be made with report server at https://webserver1/ReportServer "

So when i tried to browse the report manager from IIS, I get error:"Could not establish trust relationship with remote server."

I think its someting to do with SSL. Please help me with that 'czo out of the blue today I have started getting this error.

Thanks

Hi,

try this :

- open "c:\program files\microsoft sql server\mssql.3\reporting services\reportserver\web.config"

- remove the xmlns="http://schemas.microsoft.com..." attribute in the first <configuration> tag

- restart RS service

Also check that the certificate name maps with the server name in the RSWebApplication.config file.

Fabrice

Connection cannot be made to http://localhost/ReportServer

I have developed a reports in Business Intelligence Development studio and when I am tring to deploy it.
It says that
Connection cannot be made to http://localhost/ReportServer
What does it really mean.Is SSRS service running ?|||

Do you have Reporting Services install on Localhost?

Has it been configured?

Is IIS running?

That's a start.

BobP

|||Yess, it is runnning .|||IIS install - > start, control panel, add remove progs, add/remove windows components ->
tick IIS, click next etc...

Think you need to be running XP pro to do this, don't think you can do it from Home edition

Shurely you need to do this before you install RS, no? I can't remember the install process of RS....|||

It wont let you install SSRS without IIS.

BobP

|||If IIS is running then it must be user permissions on the IIS folder.

Connecting to Visual FoxPro

I am trying to setup a report that uses a Visual FoxPro database. I can get
the report to work fine on my development machine, but when I deploy it to
the web server I get different error message, depending on the data source
setup.
Here are some of the different error messages I get:
Setup 1:
Connection type: OLE DB
Connection String: Provider=VFPOLEDB.1;Data
Source=\\server\path\dbname.dbc;Collating Sequence=GENERAL
Connect Using: Creditials stored securely in the report server (using admin
credentials for testing)
Check "Use as Windows credentials"
Error Message: Cannot open file \\server\path\table.dbf
Setup 2:
Same as above except
Connection String: VFPOLEDB.1;Data Source=\\server\path;Collating
Sequence=MACHINE
Error Message: File "table.dbf" does not exist
Setup 3:
Sames as Setup 2 except "Use as Windows Credentials" is unchecked
Error Message: Invalid path or file name.
The web server that I am deploying the report project to has several ASP.NET
applications that use the same connection string as setup 1 with no problem.
Any help would be appreciated.Hi!
Problems like this are usually permissions issues. The account that the
report server runs under needs to have permissions to the directory where
the DBFs are located. As far as I know the credentials you mention are for
SQL Server logins and not for file server directory permissions.
--
Cindy Winegarden
cindy@.cindywinegarden.com
VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
"jweesies" <jweesies@.discussions.microsoft.com> wrote in message
news:607B1301-9764-4A49-93EF-2AA9A5673CF2@.microsoft.com...
>I am trying to setup a report that uses a Visual FoxPro database. I can
>get
> the report to work fine on my development machine, but when I deploy it to
> the web server I get different error message, depending on the data source
> setup.
> Here are some of the different error messages I get:
> Setup 1:
> Connection type: OLE DB
> Connection String: Provider=VFPOLEDB.1;Data
> Source=\\server\path\dbname.dbc;Collating Sequence=GENERAL
> Connect Using: Creditials stored securely in the report server (using
> admin
> credentials for testing)
> Check "Use as Windows credentials"
> Error Message: Cannot open file \\server\path\table.dbf
> Setup 2:
> Same as above except
> Connection String: VFPOLEDB.1;Data Source=\\server\path;Collating
> Sequence=MACHINE
> Error Message: File "table.dbf" does not exist
> Setup 3:
> Sames as Setup 2 except "Use as Windows Credentials" is unchecked
> Error Message: Invalid path or file name.
> The web server that I am deploying the report project to has several
> ASP.NET
> applications that use the same connection string as setup 1 with no
> problem.
> Any help would be appreciated.|||Thanks for your reply. The Report Server service runs under
NTAuthority/Network Services. Do you know if this needs to run under a
domain account that has access to the server where the dbfs exist? If we
change it to a domain account, will it have any effect on the reports that
are currently running or any other effect on security? Thanks.
"Cindy Winegarden" wrote:
> Hi!
> Problems like this are usually permissions issues. The account that the
> report server runs under needs to have permissions to the directory where
> the DBFs are located. As far as I know the credentials you mention are for
> SQL Server logins and not for file server directory permissions.
> --
> Cindy Winegarden
> cindy@.cindywinegarden.com
>
> VFP OLE DB: http://msdn2.microsoft.com/en-us/vfoxpro/bb190232.aspx
> VFP ODBC: http://msdn2.microsoft.com/en-us/vfoxpro/bb190233.aspx
>
>
> "jweesies" <jweesies@.discussions.microsoft.com> wrote in message
> news:607B1301-9764-4A49-93EF-2AA9A5673CF2@.microsoft.com...
> >I am trying to setup a report that uses a Visual FoxPro database. I can
> >get
> > the report to work fine on my development machine, but when I deploy it to
> > the web server I get different error message, depending on the data source
> > setup.
> >
> > Here are some of the different error messages I get:
> >
> > Setup 1:
> > Connection type: OLE DB
> > Connection String: Provider=VFPOLEDB.1;Data
> > Source=\\server\path\dbname.dbc;Collating Sequence=GENERAL
> > Connect Using: Creditials stored securely in the report server (using
> > admin
> > credentials for testing)
> > Check "Use as Windows credentials"
> > Error Message: Cannot open file \\server\path\table.dbf
> >
> > Setup 2:
> > Same as above except
> > Connection String: VFPOLEDB.1;Data Source=\\server\path;Collating
> > Sequence=MACHINE
> > Error Message: File "table.dbf" does not exist
> >
> > Setup 3:
> > Sames as Setup 2 except "Use as Windows Credentials" is unchecked
> > Error Message: Invalid path or file name.
> >
> > The web server that I am deploying the report project to has several
> > ASP.NET
> > applications that use the same connection string as setup 1 with no
> > problem.
> > Any help would be appreciated.
>
>