Error when trying to deploy report

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.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
> >
> >

Error when opening a Lookup in a Legacy DTS package

Hi all,

the SQL Management Studio keeps crashing out on me everytime i try to open a Lookup in one of my DTS packages i am using in the Legacy section.

I am copying the DTS package across and need to change the server connections (which i do), but then i was getting a permissions based error when the package ran when it tries to access the Lookup.

I tried to open the Lookup and the SQL Management Studio hanged when it tried to display the details for the lookup. It's done this many times and i have tried different files incase one was corrupted to no avail.

Anyone have any ideas of what i can try?

Thanks

Jordan

Hi Jordan,

Want to know the following:

1) Have you installed DTS 2000 Designer utility from the Feature Pack release?

2) Once the above utility is installed and then importing the DTS package into Legacy section of Management Studio, are you able to successfully decrypt the Package with password you have used to encrypt and open it successfully?

3) Assuming that this file is corrupt, another way is to embed your DTS Package in a newly created SSIS Package using DTS 2000 Task.

Hope ensuring the above steps should solve your problem.

Thanks

Subhash Subramanyam

|||

Hi Subhash,

1) How do i determine this? I can already view the DTS package in the Legacy section of 2005, does this mean it is already installed?

2) To install the package i have Saved it out of SQL 2000 as a DTS file and opened the package in SQL 2005 and saved it to the server. Should i be doing something else?

3) i haven't looked at SSIS yet. I'm not sure what that would involve.

Thanks

Jordan

Subhash512525 wrote:

Hi Jordan,

Want to know the following:

1) Have you installed DTS 2000 Designer utility from the Feature Pack release?

2) Once the above utility is installed and then importing the DTS package into Legacy section of Management Studio, are you able to successfully decrypt the Package with password you have used to encrypt and open it successfully?

3) Assuming that this file is corrupt, another way is to embed your DTS Package in a newly created SSIS Package using DTS 2000 Task.

Hope ensuring the above steps should solve your problem.

Thanks

Subhash Subramanyam

Error using Db Engine Tuning Advisor

I am running SQL 2005 Standard, obtained from a recent Launch event.
I got the Database Engine Tuning Advisor to run only once. Everytime after
that I get a runtime error: "R6031 Attempt to initialize the CRT more than
once. This indicates a bug in your application."
I had the same problem with the Sept. CTP release. Re-booting the machine
does not solve this problem. Basicaly, this is a useless tool if I need to
un-install and re-install it everytime I need to use it. I have tried
deleting all the sessions and creating a new one, re-booting.
Any ideas how to solve this? Do I need to wait for a Service Pack?
We are looking at the issue currently. It has been reported by a few other
people. Please gi ve us some more detail:
- does this happen immiediately after you start DTA UI or after you connect
to the server and the connection dialog goes away?
- if this is the second case (error after connecting) does the problem occur
if you simply Cancel the connection dialog?
- have you tried command-line DTA to see if it work? Run 'dta.exe /?' to see
the options if you have not seen it yet.
- does the error message contain any more information?
- can you check if at the time you see the error there is a dtaengine90.exe
process running on your system?
Thanks,
Maciek
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:438AAABC-1BA2-4677-B272-5D7766BEF9E2@.microsoft.com...
>I am running SQL 2005 Standard, obtained from a recent Launch event.
> I got the Database Engine Tuning Advisor to run only once. Everytime after
> that I get a runtime error: "R6031 Attempt to initialize the CRT more than
> once. This indicates a bug in your application."
> I had the same problem with the Sept. CTP release. Re-booting the machine
> does not solve this problem. Basicaly, this is a useless tool if I need to
> un-install and re-install it everytime I need to use it. I have tried
> deleting all the sessions and creating a new one, re-booting.
> Any ideas how to solve this? Do I need to wait for a Service Pack?
|||Is this TechNet discussion forum the best place to correspond regarding tech
support and error information?
I would be happy to supply any information you need. Can you e-mail me a
valid address so that we can take this 'off-line'?
Thank you.
todd_dot_chittenden_at_morantug_dot_com
"Maciek Sarnowicz [MSFT]" wrote:

> We are looking at the issue currently. It has been reported by a few other
> people. Please gi ve us some more detail:
> - does this happen immiediately after you start DTA UI or after you connect
> to the server and the connection dialog goes away?
> - if this is the second case (error after connecting) does the problem occur
> if you simply Cancel the connection dialog?
> - have you tried command-line DTA to see if it work? Run 'dta.exe /?' to see
> the options if you have not seen it yet.
> - does the error message contain any more information?
> - can you check if at the time you see the error there is a dtaengine90.exe
> process running on your system?
> Thanks,
> Maciek
>
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:438AAABC-1BA2-4677-B272-5D7766BEF9E2@.microsoft.com...
>
>
|||I will take this off-line as Todd requested. We will post back to the group
once we know the root cause of the issue.
Thanks,
Maciek
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:F4881BF8-E66B-403B-9DA0-1BC4020DDF7F@.microsoft.com...[vbcol=seagreen]
> Is this TechNet discussion forum the best place to correspond regarding
> tech
> support and error information?
> I would be happy to supply any information you need. Can you e-mail me a
> valid address so that we can take this 'off-line'?
> Thank you.
> todd_dot_chittenden_at_morantug_dot_com
> "Maciek Sarnowicz [MSFT]" wrote:
|||I'm experiencing the same problem. See my answers below.
"Maciek Sarnowicz [MSFT]" <macies@.online.microsoft.com> wrote in message
news:OnFxcW0$FHA.2392@.TK2MSFTNGP09.phx.gbl...
> We are looking at the issue currently. It has been reported by a few other
> people. Please gi ve us some more detail:
> - does this happen immiediately after you start DTA UI or after you
> connect to the server and the connection dialog goes away?
It happens after I connect to the server and the connection dialog goes
away.

> - if this is the second case (error after connecting) does the problem
> occur if you simply Cancel the connection dialog?
The problem does not occur if I press the Cancel button at the connection
dialog. But the problem does occur if I thereafter attempt to connect from
within the DTA.

> - have you tried command-line DTA to see if it work? Run 'dta.exe /?' to
> see the options if you have not seen it yet.
I tried using the command-line and had the same problem.

> - does the error message contain any more information?
It's a very vague message. Similar to Todd, I get the following:
Microsoft Visual C++ Runtime Library
Runtime Error!
Program: C:\Progr...
R6031 Attempt to initialize the CRT more than once. This indicates a bug in
your application.

> - can you check if at the time you see the error there is a
> dtaengine90.exe process running on your system?
Yes, both dtaengine90.exe and DTASHELL.EXE are loaded. My only recourse is
to kill both processes.
Chris

> Thanks,
> Maciek
>
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:438AAABC-1BA2-4677-B272-5D7766BEF9E2@.microsoft.com...
>
|||>> - have you tried command-line DTA to see if it work? Run 'dta.exe /?' to
> I tried using the command-line and had the same problem.
BTW, after returning to the command line, I see the following:
"Failed to initialize MSDB database for tuning (exit code: 1)."
Chris
|||Thanks Chris.
This confirms what Todd has reported. We are closing down on the issue,
please stay tuned.
Regards,
Maciek Sarnowicz
SQL Server SDE
This posting is provided "AS IS" with no warranties, and confers no rights
"Chris" <chris@.newsgroup.nospam> wrote in message
news:erbS$VRAGHA.2132@.TK2MSFTNGP14.phx.gbl...
> BTW, after returning to the command line, I see the following:
> "Failed to initialize MSDB database for tuning (exit code: 1)."
> Chris
>
|||I am having the same exact problem. I de-installed everything and
re-installed to no avail. All other tools and services are working fine so
far. I have never been able to "connect to the database using DTA". If I
hit cancel at the login, there is no error. When I try to connect the same
error is thrown on my machine. What is interesting is I just did a very
clean install on my computer less than 30 days ago. The only install issue
was that I was not running IIS for reporting services as it is not needed for
me.
I am running XP Pro with all SP and updates and .Net/updates prior to SQL
2005 Developer Install.
Software would be Office 03 and misc business apps.
Hope the problem is solved soon.
Thank you,
kirk
"Maciek Sarnowicz [MSFT]" wrote:

> Thanks Chris.
> This confirms what Todd has reported. We are closing down on the issue,
> please stay tuned.
>
> Regards,
> Maciek Sarnowicz
> --
> SQL Server SDE
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Chris" <chris@.newsgroup.nospam> wrote in message
> news:erbS$VRAGHA.2132@.TK2MSFTNGP14.phx.gbl...
>
>
|||Anything new to report on this? Thanks.
"Maciek Sarnowicz [MSFT]" <macies@.online.microsoft.com> wrote in message
news:OctJ8zTAGHA.3976@.TK2MSFTNGP09.phx.gbl...
> Thanks Chris.
> This confirms what Todd has reported. We are closing down on the issue,
> please stay tuned.
>
> Regards,
> Maciek Sarnowicz
> --
> SQL Server SDE
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Chris" <chris@.newsgroup.nospam> wrote in message
> news:erbS$VRAGHA.2132@.TK2MSFTNGP14.phx.gbl...
>
|||Hi Chris
This issue is being investigated presently and is probably a
consequence of a filed windows/appcompat bug
(issue due to appcompat shimming and nothing to do with DTA process
itself -).
1.Can you check if you have registry entries corresponding to
HKLM\Software\Microsoft\Windows
NT\CurrentVersion\AppCompatFlags\Layers?
In the past we have seen "explorer.exe " as an entry and removing that
fixed the problem
2.Also please check if an environment variable __COMPAT_LAYER is set?
"set __COMPAT_LAYER=" , basically disabled the compat layer and dta
ran OK
Please note that none of these are set by the tuning advisor exe - At
this point i am not sure what app does this
Manoj
Chris wrote:[vbcol=seagreen]
> Anything new to report on this? Thanks.
> "Maciek Sarnowicz [MSFT]" <macies@.online.microsoft.com> wrote in message
> news:OctJ8zTAGHA.3976@.TK2MSFTNGP09.phx.gbl...