Name Lookup of Enterprise Manager

Hello!
I have noticed a strange behaviour of Enterprise Manager (or every
program to connect to SQL Server; as in Visual Studio, Query Analyser
and ODBC-Connection Manager), which I cannot get sorted out.
I try to connect to an MSDE-Instance on a clients' Server. The Server
has, for our Maintenance, a dial-up connection with dynamic IP and
runs a service to keep the IP up-to-date, so we can access it by
servername.dyndns.org.
I can ping the server and I can connect to it in pcAnywhere (using the
dyndns.org lookup).
If I try to connect to the MSDE as servername.dyndns.org\Instance, I
get an error: Server not found: Connection.Open(Connect()).
Trying to make an ODBC-Connection gives some numbers on the error:
SQLState: 01000
Server Error: 11004
followed by
SQLState: 08001
Server Error: 6
I can connect to MSDE by using the IP a ping gave me,
1.2.3.4\Instance.
Username and Password must be correct, because a connection with
IP\Instance works fine for the IP looked up a second ago. So my
Question is: Why does Name-Lookup work for ping, work for pcAnywhere,
but not for sql server?
I wonder if someone can give a hint on that on... looking Google
Groups and Knowledge base for the last 2 hours wasn't helpful...
Thanks!Sorry, but since nobody answered, and I really need a little help
here, I *bumped* this one up again.

> Hello!
> I have noticed a strange behaviour of Enterprise Manager (or every
> program to connect to SQL Server; as in Visual Studio, Query Analyser
> and ODBC-Connection Manager), which I cannot get sorted out.
> I try to connect to an MSDE-Instance on a clients' Server. The Server
> has, for our Maintenance, a dial-up connection with dynamic IP and
> runs a service to keep the IP up-to-date, so we can access it by
> servername.dyndns.org.
> I can ping the server and I can connect to it in pcAnywhere (using the
> dyndns.org lookup).
> If I try to connect to the MSDE as servername.dyndns.org\Instance, I
> get an error: Server not found: Connection.Open(Connect()).
> Trying to make an ODBC-Connection gives some numbers on the error:
> SQLState: 01000
> Server Error: 11004
> followed by
> SQLState: 08001
> Server Error: 6
> I can connect to MSDE by using the IP a ping gave me,
> 1.2.3.4\Instance.
> Username and Password must be correct, because a connection with
> IP\Instance works fine for the IP looked up a second ago. So my
> Question is: Why does Name-Lookup work for ping, work for pcAnywhere,
> but not for sql server?
> I wonder if someone can give a hint on that on... looking Google
> Groups and Knowledge base for the last 2 hours wasn't helpful...
> Thanks!

N Preceding Strings when Scripting Objects

When an Object is scripted in From Enterprise Manager it Precedes
Strings with an "N" however these scripts seem to still work if the N
is removed so I would assume that the "N" has something to do with
collation or the Encoding or something. I've tryed to find something
about it on the net but found nothing, can anyone tell me what it does?
Thanks in Advance.
Example :
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Options]') and OBJECTPROPERTY(id, N'IsUserTable') =
1) drop table [dbo].[Options]
GON'my string'
The above is a unicode string
'my string'
The above isn't unicode.
Unicode basically stores 2 bytes per character to allow for asian character
sets.
Tony.
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials
<cameron.waldron@.gmail.com> wrote in message
news:1145530123.392023.62250@.z34g2000cwc.googlegroups.com...
> When an Object is scripted in From Enterprise Manager it Precedes
> Strings with an "N" however these scripts seem to still work if the N
> is removed so I would assume that the "N" has something to do with
> collation or the Encoding or something. I've tryed to find something
> about it on the net but found nothing, can anyone tell me what it does?
> Thanks in Advance.
> Example :
> if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[Options]') and OBJECTPROPERTY(id, N'IsUserTable') =
> 1) drop table [dbo].[Options]
> GO
>

N - curious?

Looking at an if exists statement created by SQL Enterprise Manager such as:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure') =
1), what does the N do? I've seen cases where it is and isn't necessary, but
I cannot find documentation telling what it does. "N" is a very ineffective
search!!!The N represents a Unicode string.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"CR" <c@.home.com> wrote in message
news:%23DDNZixYGHA.4424@.TK2MSFTNGP05.phx.gbl...
Looking at an if exists statement created by SQL Enterprise Manager such as:
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure') =
1), what does the N do? I've seen cases where it is and isn't necessary, but
I cannot find documentation telling what it does. "N" is a very ineffective
search!!!|||See the Books Online topic 'Server-side Programming with Unicode'
(http://msdn2.microsoft.com/en-us/library/ms191313(SQL.90).aspx).
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"CR" <c@.home.com> wrote in message
news:%23DDNZixYGHA.4424@.TK2MSFTNGP05.phx.gbl...
> Looking at an if exists statement created by SQL Enterprise Manager such
> as: if exists (select * from dbo.sysobjects where id =
> object_id(N'[dbo].[DeleteAllData]') and OBJECTPROPERTY(id, N'IsProcedure')
> = 1), what does the N do? I've seen cases where it is and isn't necessary,
> but I cannot find documentation telling what it does. "N" is a very
> ineffective search!!!
>

My SSIS Presentation.

I was demonstrating some of SSIS's capabilities to our Software Development Manager and VP of IS. (We are deciding which ETL tool to use for our DW project. So goes this project goes the house).They liked what they saw and were crazy over Fuzzy lookup but commented that SSIS seems very much oriented toward the programmer side of the house. It was, maybe, not the best tool for the Business analysts who are working closely with us on this project.

Any comments on their comment?

I wonder if SSIS "data source views" (which I haven't looked at at all) address their concerns?

Barkingdog

SSIS is a programmer/developer tool. All ETL tools are programmer/developer tools.

Exactly what do they want for the business analysts? SSIS is a platform for providing the data that business analysts may use - it is NOT something to be used by business analysts themselves.

-Jamie

|||

I know the Analysts are looking for a design tool they can use to create a Logical model of the warehouse. Later on the developers will convert the logical into a physical model. Since the analysts have a great understanding of the business implications of our data they will also be the ones completing the "Description" field of each field in the Data dictionary. I guess the company is looking for one product that can do all of this. (logical modeling, data dicitonary, let analysts get involved in the process, satisfy developer needs. They seem to think that the Sunopsis product I mentioned has better coverage of all these areas.)

Barkingdog

|||

I see. I've never seen Sunopsis but would be surprised if it has a logical data modelling tool. But hey, that's good to know.

Personally I use ERWin for this sort of stuff. I like the seperation of data modelling from implementation. To me, design and implementation are different disciplines and should be treated as such. That's just my opinion of course.

In response to your earlier question DSVs are not, in my opinion, a tool for data modelling. DSVs are something you build AFTER the physical model has been implemented. And before you have the physical model you have to build the logical model.

-Jamie

|||

It's worth noting that SQL Server does have exactly the capabilities you are seeking, barking - perhaps not quite in the way you have currently thought.

Analysis Services is the market leading tool for OLAP - which is, of course, a high performance architecture for delivering business analytics to end users.

In Analysis Services it is possible to build a cube - an analytic model - in a logical mode, then generate the physical model from that. These are called top-down cubes.

See: http://msdn2.microsoft.com/en-us/library/ms174482.aspx and http://msdn2.microsoft.com/en-us/library/ms174883.aspx

hth

Donald

My Sql Instance is gone

Heeelllpp,
My Sql instance is gone from the SQL server manager. I think the problem came up after I installed Mc Afee Virus scan and updated microsoft patches (due to the problems that we have with worms recently).
After that I can't even invoke the service at all. I tried to restart everything (uninstalled the server and reinstall it again) but since the server couldn't be connected, the install process got terminated.
Can somebody help me with this?
thx
gue,
Please supply OS and SQL Server versions.
Is there SQL Server service still there in the Services applet in control
panel? Look for MSSQLServer. Installing McAfee should not remove SQL Server,
however there is the potential for virus scanners to cause problems
occasionally - but this is normally down to configuration issues, not with
the virus scanner per se.
When you say you "uninstalled the server" - what exactly do you mean? Did
you rebuild the OS, or just reinstall SQL Server? Also, what do you mean by
"the server couldn't be connected"?
It would also be very helpful if you could supply the EXACT error messages
you are getting.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"gue" <anonymous@.discussions.microsoft.com> wrote in message
news:96CF2A1A-923F-4A52-9A38-927FCFC13D28@.microsoft.com...
> Heeelllpp,
> My Sql instance is gone from the SQL server manager. I think the problem
came up after I installed Mc Afee Virus scan and updated microsoft patches
(due to the problems that we have with worms recently).
> After that I can't even invoke the service at all. I tried to restart
everything (uninstalled the server and reinstall it again) but since the
server couldn't be connected, the install process got terminated.
> Can somebody help me with this?
> thx

My Sql Instance is gone

Heeelllpp
My Sql instance is gone from the SQL server manager. I think the problem came up after I installed Mc Afee Virus scan and updated microsoft patches (due to the problems that we have with worms recently)
After that I can't even invoke the service at all. I tried to restart everything (uninstalled the server and reinstall it again) but since the server couldn't be connected, the install process got terminated
Can somebody help me with this
thxgue,
Please supply OS and SQL Server versions.
Is there SQL Server service still there in the Services applet in control
panel? Look for MSSQLServer. Installing McAfee should not remove SQL Server,
however there is the potential for virus scanners to cause problems
occasionally - but this is normally down to configuration issues, not with
the virus scanner per se.
When you say you "uninstalled the server" - what exactly do you mean? Did
you rebuild the OS, or just reinstall SQL Server? Also, what do you mean by
"the server couldn't be connected"?
It would also be very helpful if you could supply the EXACT error messages
you are getting.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"gue" <anonymous@.discussions.microsoft.com> wrote in message
news:96CF2A1A-923F-4A52-9A38-927FCFC13D28@.microsoft.com...
> Heeelllpp,
> My Sql instance is gone from the SQL server manager. I think the problem
came up after I installed Mc Afee Virus scan and updated microsoft patches
(due to the problems that we have with worms recently).
> After that I can't even invoke the service at all. I tried to restart
everything (uninstalled the server and reinstall it again) but since the
server couldn't be connected, the install process got terminated.
> Can somebody help me with this?
> thx

My Sql Instance is gone

Heeelllpp,
My Sql instance is gone from the SQL server manager. I think the problem cam
e up after I installed Mc Afee Virus scan and updated microsoft patches (due
to the problems that we have with worms recently).
After that I can't even invoke the service at all. I tried to restart everyt
hing (uninstalled the server and reinstall it again) but since the server co
uldn't be connected, the install process got terminated.
Can somebody help me with this?
thxgue,
Please supply OS and SQL Server versions.
Is there SQL Server service still there in the Services applet in control
panel? Look for MSSQLServer. Installing McAfee should not remove SQL Server,
however there is the potential for virus scanners to cause problems
occasionally - but this is normally down to configuration issues, not with
the virus scanner per se.
When you say you "uninstalled the server" - what exactly do you mean? Did
you rebuild the OS, or just reinstall SQL Server? Also, what do you mean by
"the server couldn't be connected"?
It would also be very helpful if you could supply the EXACT error messages
you are getting.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"gue" <anonymous@.discussions.microsoft.com> wrote in message
news:96CF2A1A-923F-4A52-9A38-927FCFC13D28@.microsoft.com...
> Heeelllpp,
> My Sql instance is gone from the SQL server manager. I think the problem
came up after I installed Mc Afee Virus scan and updated microsoft patches
(due to the problems that we have with worms recently).
> After that I can't even invoke the service at all. I tried to restart
everything (uninstalled the server and reinstall it again) but since the
server couldn't be connected, the install process got terminated.
> Can somebody help me with this?
> thx

My Site option

What permission is required to be able to go into the "My Site" settings in
the Report Manager? Is it looking for a specific permission in the
ReportServer database, config file, or some machine permission?Correction, I meant the "Site Setting" option. What permission is required
to be able to go into the "Site Setting" option?
"David" wrote:
> What permission is required to be able to go into the "My Site" settings in
> the Report Manager? Is it looking for a specific permission in the
> ReportServer database, config file, or some machine permission?|||Hello David,
You need to create a new server side role and grant proper server side
permission.
At least, you need to grant the following:
Execute Report Definitions
Manage report server properties
View report server properties
View shared schedules
Or any other Server Management permission like Manage report server
security,Manage roles, Manage shared schedules.
Once you grant one of these Server management permission to the Role and
assign a user to this Server Side Role, the user could see the 'Site
Setting' in the Report Manager.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

My reports folder

How to rename the "My reports" folder. My browser language is in french and
user are speaking french. The report manager only show "My reports" but I
want to see "Mes rapports"
I know that is the "listChildren" method that add My report. Is there a way
to change this?We simply made an .aspx (or it could even be an html) page as the
starting-page for the users with an url-link to their "my reports" content
"Francis Côté" wrote:
> How to rename the "My reports" folder. My browser language is in french and
> user are speaking french. The report manager only show "My reports" but I
> want to see "Mes rapports"
> I know that is the "listChildren" method that add My report. Is there a way
> to change this?
>
>|||Interestingly, this page seems to indicate either that you cannot localize
this, or that the localization should be automatic if the OS hosting the
report server is localized to French:
http://msdn2.microsoft.com/en-us/library/aa972255(SQL.80).aspx -- while this
page may be outdated, there is a similar set of paragraphs in BOL for 2005.
I quote:
A few items are always articulated in the language that corresponds to the
operating system language setting, regardless of client application locale.
The following table describes these items.
Predefined roles
Reporting Services installs with several predefined roles (Browser,
Publisher, Content Manager, My Reports, System Administrator, and System
User) that are articulated in the language resource of the operating system
that runs the report server.
Users folder, and My Reports folder
These folder names are reserved when the My Reports feature is enabled. This
feature requires a fixed folder structure. Because the report server manages
reserved names, reserved folder names are articulated in the language
resource of the operating system that runs the report server.
<<
So... what is the regional setting of the OS, in your case?
>L<
"Francis Côté" <francis.cote@.uqat.ca> wrote in message
news:u2seBrchHHA.4300@.TK2MSFTNGP05.phx.gbl...
> How to rename the "My reports" folder. My browser language is in french
> and user are speaking french. The report manager only show "My reports"
> but I want to see "Mes rapports"
> I know that is the "listChildren" method that add My report. Is there a
> way to change this?
>

My Report Manager is missing...Need help ASAP!

Cannot find the report manager. I tried starting the Report Manager from the
start menu on the server and received this error "Page cannot be displayed".
I then tried from the authoring comupter start menu and got the same message.
I then tried to deploy a report to the site and received and error "cannot
connect to the report server". I have never gotten these messages before.
There was some recent work on the server but that shouldn't affect RS should
it. Any ideas?
Thanks in advance.What version are you on?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
message news:380BDB1A-AAF2-43B3-BE79-E525E6D2E260@.microsoft.com...
> Cannot find the report manager. I tried starting the Report Manager from
> the
> start menu on the server and received this error "Page cannot be
> displayed".
> I then tried from the authoring comupter start menu and got the same
> message.
> I then tried to deploy a report to the site and received and error "cannot
> connect to the report server". I have never gotten these messages before.
> There was some recent work on the server but that shouldn't affect RS
> should
> it. Any ideas?
> Thanks in advance.|||I am using RS 2003. I retrieved this from the log files. How do I fix this.
Will reinstall fix it.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__10_18_2007_10_13_30.log</Path>
<SystemName>EAVARCHSQLR01</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!servicecontroller!50c!10/18/2007-10:13:30:: Service
controller exiting.
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO:
Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO: Exporting
public key
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO: Performing
sku validation
ReportingServicesService!crypto!bec!10/18/2007-10:13:30:: i INFO: Importing
existing encryption key
ReportingServicesService!library!bec!10/18/2007-10:13:30:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
ReportingServicesService!library!bec!10/18/2007-10:13:30:: Exception caught
while starting service. Error:
Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDisabledException:
The report server cannot decrypt the symmetric key used to access sensitive
or encrypted data in a report server database. You must either restore a
backup key or delete all encrypted content and then restart the service.
Check the documentation for more information. -->
System.Runtime.InteropServices.COMException (0x80090005): Bad Data.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ImportSymmetricKey(Byte[] pSymKeyBlob)
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
-- End of inner exception stack trace --
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!bec!10/18/2007-10:13:30:: Attempting to
start service again...
"Bruce L-C [MVP]" wrote:
> What version are you on?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "OriginalStealth" <OriginalStealth@.discussions.microsoft.com> wrote in
> message news:380BDB1A-AAF2-43B3-BE79-E525E6D2E260@.microsoft.com...
> > Cannot find the report manager. I tried starting the Report Manager from
> > the
> > start menu on the server and received this error "Page cannot be
> > displayed".
> > I then tried from the authoring comupter start menu and got the same
> > message.
> > I then tried to deploy a report to the site and received and error "cannot
> > connect to the report server". I have never gotten these messages before.
> > There was some recent work on the server but that shouldn't affect RS
> > should
> > it. Any ideas?
> >
> > Thanks in advance.
>
>|||Sounds like you restored your reporting services database to another
server!
If security was set up then you need the keys from the initial server.
Alternatively, do a clean install of reporting services and reload the
reports via visual studio...
This way is alot cleaner and simpler with the nice way one can
"deploy" reports.
Regards,
Tom Bizannes
Reporting Services Designer
Sydney, Australia

My Report Manager Broke "The underlying connection was closed"

Our company recently re-located the servers and somehow in the process of
disconnecting -> reconnecting the Report Server the Report Manager now cannot
be run. All we get is the error:
"The underlying connection was closed: Unable to connect to the remote
server."
Interestingly, this affects ONLY the Report Manager, the Report Service is
running OK and all reports run fine via our web application and in Visual
Studio IDE etc...
Any clues?Hi!
We had a similar problem and resolved it by correcting the Applications
Extensions Mapping for the ReportServer virtual directory. Information about
configuring Reporting Services' virtual directories is available here:
http://support.microsoft.com/Default.aspx?kbid=867872
Good luck,
Bob
"neokortex" wrote:
> Our company recently re-located the servers and somehow in the process of
> disconnecting -> reconnecting the Report Server the Report Manager now cannot
> be run. All we get is the error:
> "The underlying connection was closed: Unable to connect to the remote
> server."
> Interestingly, this affects ONLY the Report Manager, the Report Service is
> running OK and all reports run fine via our web application and in Visual
> Studio IDE etc...
> Any clues?|||thanks for the tip,
but Im not quite sure this will help me. I checked the extensions for our
ReportServer virtual directory and they are already mapped exactly as
specified in the Support article. Also, ReportServer is working fine in so
far as reports can still be run through it.
It is only the Report Manager Web UI that is flaking out.
"bobhug" wrote:
> Hi!
> We had a similar problem and resolved it by correcting the Applications
> Extensions Mapping for the ReportServer virtual directory. Information about
> configuring Reporting Services' virtual directories is available here:
> http://support.microsoft.com/Default.aspx?kbid=867872
> Good luck,
> Bob
> "neokortex" wrote:
> > Our company recently re-located the servers and somehow in the process of
> > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > be run. All we get is the error:
> >
> > "The underlying connection was closed: Unable to connect to the remote
> > server."
> >
> > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > running OK and all reports run fine via our web application and in Visual
> > Studio IDE etc...
> >
> > Any clues?|||I am having the exact same problem. ReportServer is working fine, but report
manager web interface gives The underlying connection was closed. was there a
resolution to this problem?
"neokortex" wrote:
> thanks for the tip,
> but Im not quite sure this will help me. I checked the extensions for our
> ReportServer virtual directory and they are already mapped exactly as
> specified in the Support article. Also, ReportServer is working fine in so
> far as reports can still be run through it.
> It is only the Report Manager Web UI that is flaking out.
> "bobhug" wrote:
> > Hi!
> > We had a similar problem and resolved it by correcting the Applications
> > Extensions Mapping for the ReportServer virtual directory. Information about
> > configuring Reporting Services' virtual directories is available here:
> > http://support.microsoft.com/Default.aspx?kbid=867872
> >
> > Good luck,
> > Bob
> >
> > "neokortex" wrote:
> >
> > > Our company recently re-located the servers and somehow in the process of
> > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > be run. All we get is the error:
> > >
> > > "The underlying connection was closed: Unable to connect to the remote
> > > server."
> > >
> > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > running OK and all reports run fine via our web application and in Visual
> > > Studio IDE etc...
> > >
> > > Any clues?|||No resolution yet. Since that was a test server and we were/are in the
process of migrating to a production server, it is not a emergency for us. I
do know this is a general web service error, not necessarily specfic to RS.
However if you find the answer please respond. I am curious.
"Paul" wrote:
> I am having the exact same problem. ReportServer is working fine, but report
> manager web interface gives The underlying connection was closed. was there a
> resolution to this problem?
> "neokortex" wrote:
> > thanks for the tip,
> >
> > but Im not quite sure this will help me. I checked the extensions for our
> > ReportServer virtual directory and they are already mapped exactly as
> > specified in the Support article. Also, ReportServer is working fine in so
> > far as reports can still be run through it.
> >
> > It is only the Report Manager Web UI that is flaking out.
> >
> > "bobhug" wrote:
> >
> > > Hi!
> > > We had a similar problem and resolved it by correcting the Applications
> > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > configuring Reporting Services' virtual directories is available here:
> > > http://support.microsoft.com/Default.aspx?kbid=867872
> > >
> > > Good luck,
> > > Bob
> > >
> > > "neokortex" wrote:
> > >
> > > > Our company recently re-located the servers and somehow in the process of
> > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > be run. All we get is the error:
> > > >
> > > > "The underlying connection was closed: Unable to connect to the remote
> > > > server."
> > > >
> > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > running OK and all reports run fine via our web application and in Visual
> > > > Studio IDE etc...
> > > >
> > > > Any clues?|||Hi ,
I figured out the solution to this problem. Follwoing 3 things should be
made sure of:
1. Never reinstall reporting services without first uninstalling it
completely... i.e first remove the registry entiries manually then only
reporting services uninstallation is complete.
2. In the RSWebApplication.Config file in Reports Manager , the
ReportServerURL key should have a value as https:/IP(of the report manager
virtual directory)/ReportServer . If in other Report Server and Report
manager .Config files, you find localhost... replace it with the IP of the
virtual directory where reports manager and report server are installed.
3. When you deploy the report, in the configuration properties for the
project .. in the deployment path, again specify the IP instaed of
localhost...
If all these 3 things are taken care of.. then this error will not occur...
When i fixed all these, it worked for me.
pmud
"neokortex" wrote:
> No resolution yet. Since that was a test server and we were/are in the
> process of migrating to a production server, it is not a emergency for us. I
> do know this is a general web service error, not necessarily specfic to RS.
> However if you find the answer please respond. I am curious.
> "Paul" wrote:
> > I am having the exact same problem. ReportServer is working fine, but report
> > manager web interface gives The underlying connection was closed. was there a
> > resolution to this problem?
> >
> > "neokortex" wrote:
> >
> > > thanks for the tip,
> > >
> > > but Im not quite sure this will help me. I checked the extensions for our
> > > ReportServer virtual directory and they are already mapped exactly as
> > > specified in the Support article. Also, ReportServer is working fine in so
> > > far as reports can still be run through it.
> > >
> > > It is only the Report Manager Web UI that is flaking out.
> > >
> > > "bobhug" wrote:
> > >
> > > > Hi!
> > > > We had a similar problem and resolved it by correcting the Applications
> > > > Extensions Mapping for the ReportServer virtual directory. Information about
> > > > configuring Reporting Services' virtual directories is available here:
> > > > http://support.microsoft.com/Default.aspx?kbid=867872
> > > >
> > > > Good luck,
> > > > Bob
> > > >
> > > > "neokortex" wrote:
> > > >
> > > > > Our company recently re-located the servers and somehow in the process of
> > > > > disconnecting -> reconnecting the Report Server the Report Manager now cannot
> > > > > be run. All we get is the error:
> > > > >
> > > > > "The underlying connection was closed: Unable to connect to the remote
> > > > > server."
> > > > >
> > > > > Interestingly, this affects ONLY the Report Manager, the Report Service is
> > > > > running OK and all reports run fine via our web application and in Visual
> > > > > Studio IDE etc...
> > > > >
> > > > > Any clues?