"Report Manager Virtual Directory" link greyed out in config. tool

I've just installed SQL Server 2005 Reporting Services on our development
servers and the "Report Manager Virtual Directory" link is disabled in the
configuration tool. Does anyone know why it is disabled, and how do I enable
it?
Also, the Web Service Identity link displays the following error message
when I click on it:
"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."
I've verified that the "Windows Management Instrumentation" service is
running.
Background/current configuration:
- OS: Windows Server 2003 (Enterprise) SP1
- Web server separate from database server
- Reporting Svcs 2000 installed and working correctly
- Side-by-side installation of Reporting Svcs 2005 with 2000.
Any help would be greatly appreciated!
Thank you,
SanjayI am having the same issues on Server 2003 with SQL 2005.

"Replicating" SQL user accounts

Good day,
I am wanting to "replicate" user accounts between two SQL 2000 servers automatically. I.E. If I create a user on the first server, I want it automatically created on the second SQL server, if it doen't already exist.
Is there a quick and easy way to do this? If so how? I don't have to use replication, so if there is another way (I.E. DTS, etc) then that would also be great.
Thank you in advance,
Brian
no, you can't do this - the system tables can't be replicated only user
objects.
"Brian" <Brian.Louw@.sbs.siemens.co.za> wrote in message
news:17CDD729-D396-4FAC-80AB-FEE5555C530F@.microsoft.com...
> Good day,
> I am wanting to "replicate" user accounts between two SQL 2000 servers
automatically. I.E. If I create a user on the first server, I want it
automatically created on the second SQL server, if it doen't already exist.
> Is there a quick and easy way to do this? If so how? I don't have to use
replication, so if there is another way (I.E. DTS, etc) then that would also
be great.
> Thank you in advance,
> Brian
|||Brian,
there is no way to automatically do this; replication/triggers can't be used
on system tables, but you can use DTS transfer logins task, or you can
script out the logins using sp_help_revlogin (search for this proc on Google
to get info).
Regards,
Paul Ibison

"Planning" a database enviroment - a bit off topic

Hi
Hi
I'm about to plan a upgrade to our database enviroment.
We have 7 database servers running different kinds of SQL server (7.0,
2000, 2005) in an unmanaged enviroment,
The environment services wide range of business applikations and the demand
for availabilitiy and security is increasing and the environment should meet
the operational requirements led out from/required to ITIL best practice
principles.
What i'm looking for at resources including frameworks/toolkits,
guides/recommendations, consideration/decision for planning a database
enviroment that meets these requirements (i.e. the process upgrade/migrate
from A to B).
I've been searching the net for this but I can't seem to find any resources
that takes up this matter, so any help appriciated-
-KimKim,
Try:
http://support.microsoft.com/search...s=20&1033comm=1
and
http://www.microsoft.com/sql/soluti...de/default.mspx
HTH
Jerry
"Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
news:446d06c5$1@.news.carlbro.dk...
> Hi
> Hi
> I'm about to plan a upgrade to our database enviroment.
> We have 7 database servers running different kinds of SQL server (7.0,
> 2000, 2005) in an unmanaged enviroment,
> The environment services wide range of business applikations and the
> demand for availabilitiy and security is increasing and the environment
> should meet the operational requirements led out from/required to ITIL
> best practice principles.
> What i'm looking for at resources including frameworks/toolkits,
> guides/recommendations, consideration/decision for planning a database
> enviroment that meets these requirements (i.e. the process upgrade/migrate
> from A to B).
> I've been searching the net for this but I can't seem to find any
> resources that takes up this matter, so any help appriciated-
> -Kim
>|||Thanks, I found some good articles.
I still need some resources that takes a more holistic view of the process,
ie. not just how I plan to upgrade a certain databaseserver, but also how my
database environment should be build.
By environment I mean all the database servers and applications (and other
components) that communicate with the environment, that is, I need som
Architechtual design considerations for the _whole_ environment, including
operations, support etc. etc.
-Kim
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e66rzgseGHA.5040@.TK2MSFTNGP03.phx.gbl...
> Kim,
> Try:
> http://support.microsoft.com/search...s=20&1033comm=1
> and
> http://www.microsoft.com/sql/soluti...de/default.mspx
> HTH
> Jerry
> "Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
> news:446d06c5$1@.news.carlbro.dk...
>

"Planning" a database enviroment - a bit off topic

Hi
Hi
I'm about to plan a upgrade to our database enviroment.
We have 7 database servers running different kinds of SQL server (7.0,
2000, 2005) in an unmanaged enviroment,
The environment services wide range of business applikations and the demand
for availabilitiy and security is increasing and the environment should meet
the operational requirements led out from/required to ITIL best practice
principles.
What i'm looking for at resources including frameworks/toolkits,
guides/recommendations, consideration/decision for planning a database
enviroment that meets these requirements (i.e. the process upgrade/migrate
from A to B).
I've been searching the net for this but I can't seem to find any resources
that takes up this matter, so any help appriciated-
-KimKim,
Try:
http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&spid=2852&query=INF+upgrade&adv=&ast=1%2C2%2C3&mode=a&cat=False&kt=ALL&title=false&mdt=&pwt=False&res=20&1033comm=1
and
http://www.microsoft.com/sql/solutions/upgrade/default.mspx
HTH
Jerry
"Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
news:446d06c5$1@.news.carlbro.dk...
> Hi
> Hi
> I'm about to plan a upgrade to our database enviroment.
> We have 7 database servers running different kinds of SQL server (7.0,
> 2000, 2005) in an unmanaged enviroment,
> The environment services wide range of business applikations and the
> demand for availabilitiy and security is increasing and the environment
> should meet the operational requirements led out from/required to ITIL
> best practice principles.
> What i'm looking for at resources including frameworks/toolkits,
> guides/recommendations, consideration/decision for planning a database
> enviroment that meets these requirements (i.e. the process upgrade/migrate
> from A to B).
> I've been searching the net for this but I can't seem to find any
> resources that takes up this matter, so any help appriciated-
> -Kim
>|||Thanks, I found some good articles.
I still need some resources that takes a more holistic view of the process,
ie. not just how I plan to upgrade a certain databaseserver, but also how my
database environment should be build.
By environment I mean all the database servers and applications (and other
components) that communicate with the environment, that is, I need som
Architechtual design considerations for the _whole_ environment, including
operations, support etc. etc.
-Kim
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:e66rzgseGHA.5040@.TK2MSFTNGP03.phx.gbl...
> Kim,
> Try:
> http://support.microsoft.com/search/default.aspx?catalog=LCID%3D1033&spid=2852&query=INF+upgrade&adv=&ast=1%2C2%2C3&mode=a&cat=False&kt=ALL&title=false&mdt=&pwt=False&res=20&1033comm=1
> and
> http://www.microsoft.com/sql/solutions/upgrade/default.mspx
> HTH
> Jerry
> "Kim" <webdrift_nospam_@.carlbro.dk> wrote in message
> news:446d06c5$1@.news.carlbro.dk...
>> Hi
>> Hi
>> I'm about to plan a upgrade to our database enviroment.
>> We have 7 database servers running different kinds of SQL server (7.0,
>> 2000, 2005) in an unmanaged enviroment,
>> The environment services wide range of business applikations and the
>> demand for availabilitiy and security is increasing and the environment
>> should meet the operational requirements led out from/required to ITIL
>> best practice principles.
>> What i'm looking for at resources including frameworks/toolkits,
>> guides/recommendations, consideration/decision for planning a database
>> enviroment that meets these requirements (i.e. the process
>> upgrade/migrate from A to B).
>> I've been searching the net for this but I can't seem to find any
>> resources that takes up this matter, so any help appriciated-
>> -Kim
>>
>

"Microsoft SQL Servers" not showing in Computer Management.

Hi there,

Got a small tech support problem. We gave our manual writer an installer
that should install SQL Server (MSDE) and our software. Over the phone I've
managed to ascertain that SQL Server is installed (it is running as a
service, along with SQL Server Agent), but it does not show up in "Computer
Management -> Services and Applications". I need to set the permissions for
this user (over the phone!) in order to get our test software to work and
yet it does not show here. What am I doing wrong? (and/or why would the
MSDE instance not show up here?).

Thanks,

RobinI sorted it :)

"Robin Tucker" <idontwanttobespammedanymore@.reallyidont.com> wrote in
message news:cq6ak0$fkg$1$8300dec7@.news.demon.co.uk...
> Hi there,
>
> Got a small tech support problem. We gave our manual writer an installer
> that should install SQL Server (MSDE) and our software. Over the phone
> I've managed to ascertain that SQL Server is installed (it is running as a
> service, along with SQL Server Agent), but it does not show up in
> "Computer Management -> Services and Applications". I need to set the
> permissions for this user (over the phone!) in order to get our test
> software to work and yet it does not show here. What am I doing wrong?
> (and/or why would the MSDE instance not show up here?).
> Thanks,
>
> Robin

"Design Storage and Process the Cube" issue

To anyone who can help,
I am reviewing the processes in the Analysis Manager, and I am going
through the sample exercises offered by SQL Server's Analysis Manager Help.
So far, every step has been successful, but now I am running into a
problem. If you have the Analysis Manager installed, you should be able to
follow this directory to see the instructions I am following.
C:\Program Files\Microsoft Analysis
Services\Help80\Tutorial\design_stor_proc.htm
When I attempt to process the design storage to set the aggregations, it
is failing. I get the following error for why the process has failed:
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified;IM002; Time:8/26/2004 5:25:00 PM
If you understand why this is happening, I would appreciate any tips. If I
go to redo the process it does show that I already have aggregates for the
cube. Does that mean it actually worked, or am I correct in my assumption
that the error is pointing to a problem that I need to resolve. Thanks for
any information!
Courtney
Hi
Did u manage 2 fix the problem?
Udi
"Courtney Fay" wrote:

> To anyone who can help,
> I am reviewing the processes in the Analysis Manager, and I am going
> through the sample exercises offered by SQL Server's Analysis Manager Help.
> So far, every step has been successful, but now I am running into a
> problem. If you have the Analysis Manager installed, you should be able to
> follow this directory to see the instructions I am following.
> C:\Program Files\Microsoft Analysis
> Services\Help80\Tutorial\design_stor_proc.htm
> When I attempt to process the design storage to set the aggregations, it
> is failing. I get the following error for why the process has failed:
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified;IM002; Time:8/26/2004 5:25:00 PM
> If you understand why this is happening, I would appreciate any tips. If I
> go to redo the process it does show that I already have aggregates for the
> cube. Does that mean it actually worked, or am I correct in my assumption
> that the error is pointing to a problem that I need to resolve. Thanks for
> any information!
> Courtney
>
>

"...remote name could not be resolved" when using custom Web App

Hi all,
I'm getting a headache trying to figure out what is going on here. I've set
up Reporting Services on 1 dev machine and 2 servers and using a Web
Application that I am developing to access Reporting Services to generate a
report for me. Everything works fine on both my development machine and one
of the servers, but the other server keeps on producing this error:
"The underlying connection was closed: The remote name could not be resolved."
As far as I can remember, every instance of RS was installed identically.
Also, I can use the Report Manager from the server and from networked
computers to generate reports with no issues. Its only upon my Web Apps
access to the RS that I get this error. Is this similar to the SSL issues a
lot of people have been discussing? I'm still quite a newbie when it comes to
sql server and iis, so if this has been answered elsewhere already, I'd
appreciate a link :)
AndreAfter a bit of debugging I found that the problem was actually just that a
static web refference to the report server was being used, and that was
pointing at the other server still.
All works fine now.