PDC - SQLServer Reporting Services Beta Install

I am having difficulty installing the server components of the SQLServer
Reporting Services Beta copy I received at the PDC. My server is the domain
controller for a small home network, and I received the following error:
An error occurred while applying security settings. <machineName>\ASPNET is
not a valid user or group.
This could be a problem with the package, or a problem connecting to a
domain controller on the
network. Check your network connection and click Retry, or Cancel to end
the install.
I have verified that the ASPNET machine account exists - but I suspect a
recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
error. I would like to try changing the account that the Report Server Web
Service runs as, but I don't see an option to accomodate thisoption.
Does anyone have any suggestions?
I have the following installed:
Recently upgraded .NET Framework from 1.0 to 1.1
Windows 2000 Server
SQLServer Standard Edition, SP3a
Thanks in advance,
RobYou might have more luck posting this message on the RS newsgroup.
It's :- microsoft.beta.reporting.services.general
--
HTH
Ryan Waight, MCDBA, MCSE
"Rob Patterson" <rpatterson@.ztr.com> wrote in message
news:uRRZqKGpDHA.384@.tk2msftngp13.phx.gbl...
> I am having difficulty installing the server components of the SQLServer
> Reporting Services Beta copy I received at the PDC. My server is the
domain
> controller for a small home network, and I received the following error:
> An error occurred while applying security settings. <machineName>\ASPNET
is
> not a valid user or group.
> This could be a problem with the package, or a problem connecting to a
> domain controller on the
> network. Check your network connection and click Retry, or Cancel to end
> the install.
> I have verified that the ASPNET machine account exists - but I suspect a
> recent upgrade from .NET framework 1.0 to 1.1 may have influenced this
> error. I would like to try changing the account that the Report Server
Web
> Service runs as, but I don't see an option to accomodate thisoption.
> Does anyone have any suggestions?
> I have the following installed:
> Recently upgraded .NET Framework from 1.0 to 1.1
> Windows 2000 Server
> SQLServer Standard Edition, SP3a
> Thanks in advance,
> Rob
>|||How do I subscribe to microsoft.beta.reporting.services.general
I have a similar problem, but I am unable to subscribe.
Thanks,
Hanna

patch management

Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:

> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it wa
s
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+
)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
>

patch management

Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:
> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:
> > Hi experts!
> >
> > Our domain has about 50+ sql servers most of them dedicated and some are
> > multi-instance
> > I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> > still scanning but output file was with 0 size and I
> > canselled the scan. What is the reason for this behavior?
> > Tried with ip ranges and it works fine
> > How to scan all domain and avoid using ip ranges bc they are so many (100+)
> > and it will be hard work.
> > Please share your experiense updating sql servers with sp and security
> > patches. Is there a useful tools for scanning and patching domain with big
> > number sql machines.
> > Thanks in advance.
> >

patch management

Hi experts!
Our domain has about 50+ sql servers most of them dedicated and some are
multi-instance
I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
still scanning but output file was with 0 size and I
canselled the scan. What is the reason for this behavior?
Tried with ip ranges and it works fine
How to scan all domain and avoid using ip ranges bc they are so many (100+)
and it will be hard work.
Please share your experiense updating sql servers with sp and security
patches. Is there a useful tools for scanning and patching domain with big
number sql machines.
Thanks in advance.
use ldp to search domain where serviceprincipalname=MSSQLSvc/*
This is list "all" sql servers registered in your domain
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Eli Milkova" wrote:

> Hi experts!
> Our domain has about 50+ sql servers most of them dedicated and some are
> multi-instance
> I am scanning with sqlscan -c -d <domain> >output.txt After 24 hours it was
> still scanning but output file was with 0 size and I
> canselled the scan. What is the reason for this behavior?
> Tried with ip ranges and it works fine
> How to scan all domain and avoid using ip ranges bc they are so many (100+)
> and it will be hard work.
> Please share your experiense updating sql servers with sp and security
> patches. Is there a useful tools for scanning and patching domain with big
> number sql machines.
> Thanks in advance.
>
|||Registered means sql server 2000...what about sql server 7 and MSDE, used as
a local datastore?
"Aleksandar Grbic" wrote:
[vbcol=seagreen]
> use ldp to search domain where serviceprincipalname=MSSQLSvc/*
> This is list "all" sql servers registered in your domain
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "Eli Milkova" wrote:

password for the domain user

My SQL Server is running as a Domain user account and it asked me to enter the password for thr Domain user account when I was changing the Startup account from Local to Domain user.
My QUESTION here is:
Is there a way or command for me to change the password automatically on the Services account, if I change the password for the Domain User account/.None that I know of. I have to track manually wherever I use a domain account, and when I change the password I have to hunt them down and change them (one by one).

-PatP|||you can go directly to the user account in active directory users an computers set the service account's "Password Never Expires" property to true and it will never ask you to change it...

[Windows Support Center (windows Help)]: User and Computer Accounts

Password never expires Prevents a user password from expiring. It is recommended that Service accounts should have this option enabled and should use strong passwords. For more information about strong passwords, see Strong passwords.|||Password never expires is already set but I'm more concerned about the Security of the SQL Servers. What happens if somebody knows the domain user password and now you want to change it. There has to be a simple way.|||Originally posted by sqlserver2k
Password never expires is already set but I'm more concerned about the Security of the SQL Servers. What happens if somebody knows the domain user password and now you want to change it. There has to be a simple way. If you find it, please let me know!

-PatP|||wmi scripting will hook you up....

Set objUser = GetObject _
("LDAP://cn=myerken,ou=management,dc=fabrikam,dc=com")
objUser.ChangePassword "i5A2sj*!", "jl3R86df"


you could set this up as an MSX Job
create it run it then delete it

THIS (http://www.microsoft.com/technet/community/scriptcenter/default.mspx) is one of the best site for WMI Admin Scripts