Help With Scheduled Reports

When i set up a subscription i get the following error
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
I have found the following on MSDN
http://support.microsoft.com/default.aspx?scid=kb;en-us;842423
The above details fixes for 2000 and 2003 domains however we are on a NT
domain
When i change the account to a domain account (even administrator) when it
is time for the subscription to run it does not execute
does any body have any ideas on how to fix this
thanks
RegWe had the same issue awhile back. Make sure you're up to date on your
service packs. Also, you can check the log file (ReportServerService) for
more error messages and details.
"Reg Besseling" wrote:
> When i set up a subscription i get the following error
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files
> I have found the following on MSDN
> http://support.microsoft.com/default.aspx?scid=kb;en-us;842423
> The above details fixes for 2000 and 2003 domains however we are on a NT
> domain
> When i change the account to a domain account (even administrator) when it
> is time for the subscription to run it does not execute
> does any body have any ideas on how to fix this
> thanks
> Reg
>|||It appears that applying MS05-043 , MS05-038 and MS05-039 caused the issue
to start as all was working before
"daw" <daw@.discussions.microsoft.com> wrote in message
news:CA6823E7-640E-4E86-B59F-65049301D885@.microsoft.com...
> We had the same issue awhile back. Make sure you're up to date on your
> service packs. Also, you can check the log file (ReportServerService) for
> more error messages and details.
> "Reg Besseling" wrote:
>> When i set up a subscription i get the following error
>> Failure sending mail: The Report Server has encountered a configuration
>> error; more details in the log files
>> I have found the following on MSDN
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;842423
>> The above details fixes for 2000 and 2003 domains however we are on a NT
>> domain
>> When i change the account to a domain account (even administrator) when
>> it
>> is time for the subscription to run it does not execute
>> does any body have any ideas on how to fix this
>> thanks
>> Reg
>>

Help with installation of SQL Server 2000 SP4

Hi,

I was wondering if anyone might be able to help me here. To be honest, this is my first time i have encountered SQL Server 2000 SP4. I need some guidance as to how to install and set up the SQL Server 2000 SP4. I have done it with SQL Server 2005 Express Edition and it's (I think) a lot easier to install and get it going.

My computer runs on windows XP Pro (windows 32bit). I got confused when i got to the following microsoft webpage - http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en. I downloaded SQL2000-KB884525-SP4-x86-ENU.EXE. And when running the setup.bat, the message came up saying "SQL Server 2000 is not installed on this machine. setup will now exit". What do i need to have the SQL Server 2000 installed on my machine?

Thank you in advance

What you tried to download is just the service pack, if you want to use SQL Server 2000 you either have to buy an edition (the developer edition is quite cheap) or get the MSDE which is the equivalent to the SQL Server Express Edition. MSDE was not bundled with the service pack like Express is, so you first have to install the SQL Server MSDE and then afterwards the SP4. Hope thing are clearer now.

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

Thank you for your support.

I've downloaded MSDE2000A.exe package. I run the setup.exe by typing in the command line as follows

setup SAPWD=hello INSTANCENAME="InstanceName" TARGETDIR="C:\MyInstanceFolder"

setup /settings "MyParameters.ini" SAPWD=hello

I've got an error message saying "The instance name specified is invalid".

I thought i have specified it to be InstanceName.

Can you help please?

Thank you in advance

|||

Where are you getting the error information, at the first commandline call, or the second. If it is the second, send the ini file over.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de