Thursday, March 29, 2012
Error when trying to deploy report
I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
to our reporting server I get the following error:
"A connection could not be made to the report server
http://sqlreportserver/ReportServer"
I can browse to the Report Manager and view reports. I am also able to debug
reports in VS.NET 2003. I've double checked the TargetFolder and
TargetServerURL in the project properties.
I am on a different domain than the report server. Could this be why I am
unable to deploy? If so, does anybody know how I can work around this.
Thanks
John a.k.a.HansHi again,
I'm still having problems with this. If anyone could give me a few pointers
that would be much appreciated.
Thanks
J
"Hans Gruber" wrote:
> Hi,
> I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
> to our reporting server I get the following error:
> "A connection could not be made to the report server
> http://sqlreportserver/ReportServer"
> I can browse to the Report Manager and view reports. I am also able to debug
> reports in VS.NET 2003. I've double checked the TargetFolder and
> TargetServerURL in the project properties.
> I am on a different domain than the report server. Could this be why I am
> unable to deploy? If so, does anybody know how I can work around this.
> Thanks
> John a.k.a.Hans
>|||OK. I've made some progress. Hopefully this may help other people with the
same problem.
1) In IE. Tools --> Internet Options --> Connections --> LAN Settings.
Uncheck the 'Use a proxy server for your LAN (These.....' box.
2) Restart VS.NET 2003
3) I can now deploy reports.
Still frustrating because my colleague does not have to uncheck this box in
order to deploy...so any pointers would be much appreciated.
J
> > Hi,
> >
> > I'm running Reporting Services 2000 SP1. Everytime I try and deploy a report
> > to our reporting server I get the following error:
> >
> > "A connection could not be made to the report server
> > http://sqlreportserver/ReportServer"
> >
> > I can browse to the Report Manager and view reports. I am also able to debug
> > reports in VS.NET 2003. I've double checked the TargetFolder and
> > TargetServerURL in the project properties.
> >
> > I am on a different domain than the report server. Could this be why I am
> > unable to deploy? If so, does anybody know how I can work around this.
> >
> > Thanks
> > John a.k.a.Hans
> >
> >
Friday, March 23, 2012
Error when importing data from AS/400 - appeared after SP1
Import and Export Wizard.
This is what happends:
In SQL server Import and Export wizard, I choose IBM AS400 OLE DB Provider,
with Properties:
Data Source: (IP adress of my AS/400)
User name, password: (My username/password on AS/400)
Default Collection: (library on AS/400)
Then I choose destination database, and Next, it starts transfering list of
tables . After a few seconds I get this error:
'IBMDA400.DataSource.1' failed with no error message available, result code:
E_INVALIDARG (0x80070057)
Additional Information:
'IBMDA400.DataSource.1' failed with no error message available, result code:
E_INVALIDARG (0x80070057). (System.Data)
Error appeared shortly after installation of SP1, so I suspect of SP1
(although I am not yet sure) . Error happends always, nevermind the number
of tables in library.
This is important error for us because we cannot do transfer from AS400 at
all.I have gotten the same error and I was wondering if you had found an
answer to this problem?
*** Sent via Developersdex http://www.codecomments.com ***sql
Friday, March 9, 2012
Error when "Open Table" in SQL Server Management Studio
I get the following error when I try and open a table in SQL Server Management Studio. Installing SP1 did not fix as I hoped it might. What can I do about this - I can't see my data?
===================================
Unspecified error
(MS Visual Database Tools)
Program Location:
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)
I have the exact same problem.
Did you happen to solve it in any way? Can't find any good information about this failure :(