Hey,
I have following problem :
When is make a query in the enterprice manager I receive all numbers in an
european way (decimal = , no thousand separator is shown ex 1000,52).
When I make the same query in the query analyser i receive the output as
follows 1000.5200
I want it in an european format : 1000,52.
Is there a way to declare this in the query (like you can do with the
datatimes : set dateformat dmy).
I have the same problem when I export the data via a DTS. Can I not say to
him that he have to export numbers in a european format?
Thanks in advance
jacJac,
Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
regional options when displaying currency, numbers, dates, and times."
The display in Query Analyzer will then conform to the Control Panel
settings for Regional display options.
Steve Kass
Drew University
jac wrote:
>Hey,
>I have following problem :
>When is make a query in the enterprice manager I receive all numbers in an
>european way (decimal = , no thousand separator is shown ex 1000,52).
>When I make the same query in the query analyser i receive the output as
>follows 1000.5200
>I want it in an european format : 1000,52.
>Is there a way to declare this in the query (like you can do with the
>datatimes : set dateformat dmy).
>I have the same problem when I export the data via a DTS. Can I not say to
>him that he have to export numbers in a european format?
>Thanks in advance
>jac
>|||Thanks Steve.
But how I say to my DTS (makes a query select * from XXX and export it in a
textfile) that he has to use the regional settings?
Thanks
"Steve Kass" wrote:
> Jac,
> Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
> regional options when displaying currency, numbers, dates, and times."
> The display in Query Analyzer will then conform to the Control Panel
> settings for Regional display options.
> Steve Kass
> Drew University
> jac wrote:
>
>
Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts
Wednesday, March 28, 2012
Numeric format - International settings
Hey,
I have following problem :
When is make a query in the enterprice manager I receive all numbers in an
european way (decimal = , no thousand separator is shown ex 1000,52).
When I make the same query in the query analyser i receive the output as
follows 1000.5200
I want it in an european format : 1000,52.
Is there a way to declare this in the query (like you can do with the
datatimes : set dateformat dmy).
I have the same problem when I export the data via a DTS. Can I not say to
him that he have to export numbers in a european format?
Thanks in advance
jacJac,
Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
regional options when displaying currency, numbers, dates, and times."
The display in Query Analyzer will then conform to the Control Panel
settings for Regional display options.
Steve Kass
Drew University
jac wrote:
>Hey,
>I have following problem :
>When is make a query in the enterprice manager I receive all numbers in an
>european way (decimal = , no thousand separator is shown ex 1000,52).
>When I make the same query in the query analyser i receive the output as
>follows 1000.5200
>I want it in an european format : 1000,52.
>Is there a way to declare this in the query (like you can do with the
>datatimes : set dateformat dmy).
>I have the same problem when I export the data via a DTS. Can I not say to
>him that he have to export numbers in a european format?
>Thanks in advance
>jac
>|||Thanks Steve.
But how I say to my DTS (makes a query select * from XXX and export it in a
textfile) that he has to use the regional settings?
Thanks
"Steve Kass" wrote:
> Jac,
> Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
> regional options when displaying currency, numbers, dates, and times."
> The display in Query Analyzer will then conform to the Control Panel
> settings for Regional display options.
> Steve Kass
> Drew University
> jac wrote:
> >Hey,
> >
> >I have following problem :
> >When is make a query in the enterprice manager I receive all numbers in an
> >european way (decimal = , no thousand separator is shown ex 1000,52).
> >
> >When I make the same query in the query analyser i receive the output as
> >follows 1000.5200
> >I want it in an european format : 1000,52.
> >
> >Is there a way to declare this in the query (like you can do with the
> >datatimes : set dateformat dmy).
> >
> >I have the same problem when I export the data via a DTS. Can I not say to
> >him that he have to export numbers in a european format?
> >
> >Thanks in advance
> >jac
> >
> >
>
I have following problem :
When is make a query in the enterprice manager I receive all numbers in an
european way (decimal = , no thousand separator is shown ex 1000,52).
When I make the same query in the query analyser i receive the output as
follows 1000.5200
I want it in an european format : 1000,52.
Is there a way to declare this in the query (like you can do with the
datatimes : set dateformat dmy).
I have the same problem when I export the data via a DTS. Can I not say to
him that he have to export numbers in a european format?
Thanks in advance
jacJac,
Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
regional options when displaying currency, numbers, dates, and times."
The display in Query Analyzer will then conform to the Control Panel
settings for Regional display options.
Steve Kass
Drew University
jac wrote:
>Hey,
>I have following problem :
>When is make a query in the enterprice manager I receive all numbers in an
>european way (decimal = , no thousand separator is shown ex 1000,52).
>When I make the same query in the query analyser i receive the output as
>follows 1000.5200
>I want it in an european format : 1000,52.
>Is there a way to declare this in the query (like you can do with the
>datatimes : set dateformat dmy).
>I have the same problem when I export the data via a DTS. Can I not say to
>him that he have to export numbers in a european format?
>Thanks in advance
>jac
>|||Thanks Steve.
But how I say to my DTS (makes a query select * from XXX and export it in a
textfile) that he has to use the regional settings?
Thanks
"Steve Kass" wrote:
> Jac,
> Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
> regional options when displaying currency, numbers, dates, and times."
> The display in Query Analyzer will then conform to the Control Panel
> settings for Regional display options.
> Steve Kass
> Drew University
> jac wrote:
> >Hey,
> >
> >I have following problem :
> >When is make a query in the enterprice manager I receive all numbers in an
> >european way (decimal = , no thousand separator is shown ex 1000,52).
> >
> >When I make the same query in the query analyser i receive the output as
> >follows 1000.5200
> >I want it in an european format : 1000,52.
> >
> >Is there a way to declare this in the query (like you can do with the
> >datatimes : set dateformat dmy).
> >
> >I have the same problem when I export the data via a DTS. Can I not say to
> >him that he have to export numbers in a european format?
> >
> >Thanks in advance
> >jac
> >
> >
>
Numeric format - International settings
Hey,
I have following problem :
When is make a query in the enterprice manager I receive all numbers in an
european way (decimal = , no thousand separator is shown ex 1000,52).
When I make the same query in the query analyser i receive the output as
follows 1000.5200
I want it in an european format : 1000,52.
Is there a way to declare this in the query (like you can do with the
datatimes : set dateformat dmy).
I have the same problem when I export the data via a DTS. Can I not say to
him that he have to export numbers in a european format?
Thanks in advance
jac
Jac,
Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
regional options when displaying currency, numbers, dates, and times."
The display in Query Analyzer will then conform to the Control Panel
settings for Regional display options.
Steve Kass
Drew University
jac wrote:
>Hey,
>I have following problem :
>When is make a query in the enterprice manager I receive all numbers in an
>european way (decimal = , no thousand separator is shown ex 1000,52).
>When I make the same query in the query analyser i receive the output as
>follows 1000.5200
>I want it in an european format : 1000,52.
>Is there a way to declare this in the query (like you can do with the
>datatimes : set dateformat dmy).
>I have the same problem when I export the data via a DTS. Can I not say to
>him that he have to export numbers in a european format?
>Thanks in advance
>jac
>
|||Thanks Steve.
But how I say to my DTS (makes a query select * from XXX and export it in a
textfile) that he has to use the regional settings?
Thanks
"Steve Kass" wrote:
> Jac,
> Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
> regional options when displaying currency, numbers, dates, and times."
> The display in Query Analyzer will then conform to the Control Panel
> settings for Regional display options.
> Steve Kass
> Drew University
> jac wrote:
>
sql
I have following problem :
When is make a query in the enterprice manager I receive all numbers in an
european way (decimal = , no thousand separator is shown ex 1000,52).
When I make the same query in the query analyser i receive the output as
follows 1000.5200
I want it in an european format : 1000,52.
Is there a way to declare this in the query (like you can do with the
datatimes : set dateformat dmy).
I have the same problem when I export the data via a DTS. Can I not say to
him that he have to export numbers in a european format?
Thanks in advance
jac
Jac,
Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
regional options when displaying currency, numbers, dates, and times."
The display in Query Analyzer will then conform to the Control Panel
settings for Regional display options.
Steve Kass
Drew University
jac wrote:
>Hey,
>I have following problem :
>When is make a query in the enterprice manager I receive all numbers in an
>european way (decimal = , no thousand separator is shown ex 1000,52).
>When I make the same query in the query analyser i receive the output as
>follows 1000.5200
>I want it in an european format : 1000,52.
>Is there a way to declare this in the query (like you can do with the
>datatimes : set dateformat dmy).
>I have the same problem when I export the data via a DTS. Can I not say to
>him that he have to export numbers in a european format?
>Thanks in advance
>jac
>
|||Thanks Steve.
But how I say to my DTS (makes a query select * from XXX and export it in a
textfile) that he has to use the regional settings?
Thanks
"Steve Kass" wrote:
> Jac,
> Try the Query Analyzer setting Tools|Options|Connections Tab|"Use
> regional options when displaying currency, numbers, dates, and times."
> The display in Query Analyzer will then conform to the Control Panel
> settings for Regional display options.
> Steve Kass
> Drew University
> jac wrote:
>
sql
Monday, March 12, 2012
Nulls vs Blanks
Until yesterday it was imposible to delete a field that did not allow nulls
in Enterprise manager (SQL2000) the InfoPath Clients connected to such tables
saw red asterisks in all the required fields according to the information
provided by the SQL schema.
This has now changed on all instances and all servers without apparant
reason. now I can delete a field that does not allow nulls and it is
registered as a blank. Infopath clients are not forced to include all
required fields prior to submitting.
What could have changed?
Thanks
IT PHYTOSANThis is a multi-part message in MIME format.
--080302080803080309060001
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
This might be better off posted to an InfoPath newsgroup (like
microsoft.public.infopath).
--
*mike hodgson*
http://sqlnerd.blogspot.com
IT PHYTOSAN wrote:
>Until yesterday it was imposible to delete a field that did not allow nulls
>in Enterprise manager (SQL2000) the InfoPath Clients connected to such tables
>saw red asterisks in all the required fields according to the information
>provided by the SQL schema.
>This has now changed on all instances and all servers without apparant
>reason. now I can delete a field that does not allow nulls and it is
>registered as a blank. Infopath clients are not forced to include all
>required fields prior to submitting.
>What could have changed?
>Thanks
>IT PHYTOSAN
>
--080302080803080309060001
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>This might be better off posted to an InfoPath newsgroup (like
microsoft.public.infopath).</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
IT PHYTOSAN wrote:
<blockquote cite="mid6513D024-96EB-4CF5-82B8-7134F4812D09@.microsoft.com"
type="cite">
<pre wrap="">Until yesterday it was imposible to delete a field that did not allow nulls
in Enterprise manager (SQL2000) the InfoPath Clients connected to such tables
saw red asterisks in all the required fields according to the information
provided by the SQL schema.
This has now changed on all instances and all servers without apparant
reason. now I can delete a field that does not allow nulls and it is
registered as a blank. Infopath clients are not forced to include all
required fields prior to submitting.
What could have changed?
Thanks
IT PHYTOSAN
</pre>
</blockquote>
</body>
</html>
--080302080803080309060001--
in Enterprise manager (SQL2000) the InfoPath Clients connected to such tables
saw red asterisks in all the required fields according to the information
provided by the SQL schema.
This has now changed on all instances and all servers without apparant
reason. now I can delete a field that does not allow nulls and it is
registered as a blank. Infopath clients are not forced to include all
required fields prior to submitting.
What could have changed?
Thanks
IT PHYTOSANThis is a multi-part message in MIME format.
--080302080803080309060001
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
This might be better off posted to an InfoPath newsgroup (like
microsoft.public.infopath).
--
*mike hodgson*
http://sqlnerd.blogspot.com
IT PHYTOSAN wrote:
>Until yesterday it was imposible to delete a field that did not allow nulls
>in Enterprise manager (SQL2000) the InfoPath Clients connected to such tables
>saw red asterisks in all the required fields according to the information
>provided by the SQL schema.
>This has now changed on all instances and all servers without apparant
>reason. now I can delete a field that does not allow nulls and it is
>registered as a blank. Infopath clients are not forced to include all
>required fields prior to submitting.
>What could have changed?
>Thanks
>IT PHYTOSAN
>
--080302080803080309060001
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>This might be better off posted to an InfoPath newsgroup (like
microsoft.public.infopath).</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
IT PHYTOSAN wrote:
<blockquote cite="mid6513D024-96EB-4CF5-82B8-7134F4812D09@.microsoft.com"
type="cite">
<pre wrap="">Until yesterday it was imposible to delete a field that did not allow nulls
in Enterprise manager (SQL2000) the InfoPath Clients connected to such tables
saw red asterisks in all the required fields according to the information
provided by the SQL schema.
This has now changed on all instances and all servers without apparant
reason. now I can delete a field that does not allow nulls and it is
registered as a blank. Infopath clients are not forced to include all
required fields prior to submitting.
What could have changed?
Thanks
IT PHYTOSAN
</pre>
</blockquote>
</body>
</html>
--080302080803080309060001--
Nulls vs Blanks
Until yesterday it was imposible to delete a field that did not allow nulls
in Enterprise manager (SQL2000) the InfoPath Clients connected to such table
s
saw red asterisks in all the required fields according to the information
provided by the SQL schema.
This has now changed on all instances and all servers without apparant
reason. now I can delete a field that does not allow nulls and it is
registered as a blank. Infopath clients are not forced to include all
required fields prior to submitting.
What could have changed?
Thanks
IT PHYTOSANThis might be better off posted to an InfoPath newsgroup (like
microsoft.public.infopath).
*mike hodgson*
http://sqlnerd.blogspot.com
IT PHYTOSAN wrote:
>Until yesterday it was imposible to delete a field that did not allow nulls
>in Enterprise manager (SQL2000) the InfoPath Clients connected to such tabl
es
>saw red asterisks in all the required fields according to the information
>provided by the SQL schema.
>This has now changed on all instances and all servers without apparant
>reason. now I can delete a field that does not allow nulls and it is
>registered as a blank. Infopath clients are not forced to include all
>required fields prior to submitting.
>What could have changed?
>Thanks
>IT PHYTOSAN
>
in Enterprise manager (SQL2000) the InfoPath Clients connected to such table
s
saw red asterisks in all the required fields according to the information
provided by the SQL schema.
This has now changed on all instances and all servers without apparant
reason. now I can delete a field that does not allow nulls and it is
registered as a blank. Infopath clients are not forced to include all
required fields prior to submitting.
What could have changed?
Thanks
IT PHYTOSANThis might be better off posted to an InfoPath newsgroup (like
microsoft.public.infopath).
*mike hodgson*
http://sqlnerd.blogspot.com
IT PHYTOSAN wrote:
>Until yesterday it was imposible to delete a field that did not allow nulls
>in Enterprise manager (SQL2000) the InfoPath Clients connected to such tabl
es
>saw red asterisks in all the required fields according to the information
>provided by the SQL schema.
>This has now changed on all instances and all servers without apparant
>reason. now I can delete a field that does not allow nulls and it is
>registered as a blank. Infopath clients are not forced to include all
>required fields prior to submitting.
>What could have changed?
>Thanks
>IT PHYTOSAN
>
Friday, March 9, 2012
NULL/Blank Collation after DB restore
If a database's collation is blank under enterprise manager and NULL with SELECT DATABASEPROPERTYEX('<Database_Name>', 'Collation') does this mean it has the same collation as the server?
The reason I ask is that I restored a database with a different collation to my server and so I expected the different collation name to show up.
Its showing as blank though...
I thought databases kept their original collation even if restored to another server.
(The database was restored as a new database).The collation showed up after closing enterprise manager and then going back in.
The reason I ask is that I restored a database with a different collation to my server and so I expected the different collation name to show up.
Its showing as blank though...
I thought databases kept their original collation even if restored to another server.
(The database was restored as a new database).The collation showed up after closing enterprise manager and then going back in.
Monday, February 20, 2012
NULL Exception Configuring SRS 2005
We just installed SQL Server 2005 w/SRS on a Windows 2003 box. I fired up
the Report Server Configuration Manager to, well, configure things. The
server status was green. When to the "Report Server Virtual Directory" and
clicked "New". It seemed to do it's thing, then all of a sudden the tool
just exited without any messages.
Now when we go back into the tool, the Report Server Virtual Directory icon
is green, but when we try to go to that tab, we get the following error:
There was an error while switching panels. The most likely cause is an
error retrieving WMI properties. The exception details are:
Object reference not set to an instance of an object.
We have several web sites defined in IIS (including having SBS installed
w/Sharepoint). I was unable to find the ReportServer virtual directory
created in any of them. Nor where the SRS app pools created. The Report
Server Virtual Directory icon is grayed out.
Any suggestions on how to proceed to resolve this error?
Thanks,
ChrisOn Feb 16, 7:11 am, "Chris Walls" <chwal...@.community.nospam> wrote:
> We just installed SQL Server 2005 w/SRS on a Windows 2003 box. I fired up
> the Report Server Configuration Manager to, well, configure things. The
> server status was green. When to the "Report Server Virtual Directory" and
> clicked "New". It seemed to do it's thing, then all of a sudden the tool
> just exited without any messages.
> Now when we go back into the tool, the Report Server Virtual Directory icon
> is green, but when we try to go to that tab, we get the following error:
> There was an error while switching panels. The most likely cause is an
> error retrieving WMI properties. The exception details are:
> Object reference not set to an instance of an object.
> We have several web sites defined in IIS (including having SBS installed
> w/Sharepoint). I was unable to find the ReportServer virtual directory
> created in any of them. Nor where the SRS app pools created. The Report
> Server Virtual Directory icon is grayed out.
> Any suggestions on how to proceed to resolve this error?
> Thanks,
> Chris
One thought would be to check the EventViewer for SSRS/IIS-related
errors. They might lead you to a more informative error. Also, you
might check the SSRS log files, if SSRS was installed to that point.
They are usually located in this path: C:\Program Files\Microsoft SQL
Server\<MSSQL.2 -or- MSSQL.3>\Reporting Services\LogFiles. As a last
resort, you could try uninstalling and reinstalling SSRS/SQL Server.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Chris,
I don't know if this is related to your issue, but I just ran into the same
problem in Reporting Services Configuration Manager.
After Setting up SharePoint Integration the Report Manager section is grayed
out because Report Manager isn't needed in SharePoint integrated mode. When
I clicked on that section I saw a message saying that it's not supported and
that I should uninstall it to reduce the security footprint of the server.
It sounded like a good idea so I uninstalled the Report Manager portion of
SRS. Well that lead to the error you're seeing.
I reinstalled Report Manager and now I can get back into the Report Server
Virtual Directory section.
Seems like a bug to me.
Is Report Manager installed on this machine, and can you get into that
section of the Configuration Manager?
-Alex
"Chris Walls" wrote:
> We just installed SQL Server 2005 w/SRS on a Windows 2003 box. I fired up
> the Report Server Configuration Manager to, well, configure things. The
> server status was green. When to the "Report Server Virtual Directory" and
> clicked "New". It seemed to do it's thing, then all of a sudden the tool
> just exited without any messages.
> Now when we go back into the tool, the Report Server Virtual Directory icon
> is green, but when we try to go to that tab, we get the following error:
> There was an error while switching panels. The most likely cause is an
> error retrieving WMI properties. The exception details are:
> Object reference not set to an instance of an object.
> We have several web sites defined in IIS (including having SBS installed
> w/Sharepoint). I was unable to find the ReportServer virtual directory
> created in any of them. Nor where the SRS app pools created. The Report
> Server Virtual Directory icon is grayed out.
> Any suggestions on how to proceed to resolve this error?
> Thanks,
> Chris
>
>
the Report Server Configuration Manager to, well, configure things. The
server status was green. When to the "Report Server Virtual Directory" and
clicked "New". It seemed to do it's thing, then all of a sudden the tool
just exited without any messages.
Now when we go back into the tool, the Report Server Virtual Directory icon
is green, but when we try to go to that tab, we get the following error:
There was an error while switching panels. The most likely cause is an
error retrieving WMI properties. The exception details are:
Object reference not set to an instance of an object.
We have several web sites defined in IIS (including having SBS installed
w/Sharepoint). I was unable to find the ReportServer virtual directory
created in any of them. Nor where the SRS app pools created. The Report
Server Virtual Directory icon is grayed out.
Any suggestions on how to proceed to resolve this error?
Thanks,
ChrisOn Feb 16, 7:11 am, "Chris Walls" <chwal...@.community.nospam> wrote:
> We just installed SQL Server 2005 w/SRS on a Windows 2003 box. I fired up
> the Report Server Configuration Manager to, well, configure things. The
> server status was green. When to the "Report Server Virtual Directory" and
> clicked "New". It seemed to do it's thing, then all of a sudden the tool
> just exited without any messages.
> Now when we go back into the tool, the Report Server Virtual Directory icon
> is green, but when we try to go to that tab, we get the following error:
> There was an error while switching panels. The most likely cause is an
> error retrieving WMI properties. The exception details are:
> Object reference not set to an instance of an object.
> We have several web sites defined in IIS (including having SBS installed
> w/Sharepoint). I was unable to find the ReportServer virtual directory
> created in any of them. Nor where the SRS app pools created. The Report
> Server Virtual Directory icon is grayed out.
> Any suggestions on how to proceed to resolve this error?
> Thanks,
> Chris
One thought would be to check the EventViewer for SSRS/IIS-related
errors. They might lead you to a more informative error. Also, you
might check the SSRS log files, if SSRS was installed to that point.
They are usually located in this path: C:\Program Files\Microsoft SQL
Server\<MSSQL.2 -or- MSSQL.3>\Reporting Services\LogFiles. As a last
resort, you could try uninstalling and reinstalling SSRS/SQL Server.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Chris,
I don't know if this is related to your issue, but I just ran into the same
problem in Reporting Services Configuration Manager.
After Setting up SharePoint Integration the Report Manager section is grayed
out because Report Manager isn't needed in SharePoint integrated mode. When
I clicked on that section I saw a message saying that it's not supported and
that I should uninstall it to reduce the security footprint of the server.
It sounded like a good idea so I uninstalled the Report Manager portion of
SRS. Well that lead to the error you're seeing.
I reinstalled Report Manager and now I can get back into the Report Server
Virtual Directory section.
Seems like a bug to me.
Is Report Manager installed on this machine, and can you get into that
section of the Configuration Manager?
-Alex
"Chris Walls" wrote:
> We just installed SQL Server 2005 w/SRS on a Windows 2003 box. I fired up
> the Report Server Configuration Manager to, well, configure things. The
> server status was green. When to the "Report Server Virtual Directory" and
> clicked "New". It seemed to do it's thing, then all of a sudden the tool
> just exited without any messages.
> Now when we go back into the tool, the Report Server Virtual Directory icon
> is green, but when we try to go to that tab, we get the following error:
> There was an error while switching panels. The most likely cause is an
> error retrieving WMI properties. The exception details are:
> Object reference not set to an instance of an object.
> We have several web sites defined in IIS (including having SBS installed
> w/Sharepoint). I was unable to find the ReportServer virtual directory
> created in any of them. Nor where the SRS app pools created. The Report
> Server Virtual Directory icon is grayed out.
> Any suggestions on how to proceed to resolve this error?
> Thanks,
> Chris
>
>
Subscribe to:
Posts (Atom)