Problems installing SP4 on MSDE 2000 (SP3)

Hi there,

I have some trouble installing SP4 onto an existing MSDE 2000 (with SP3).
I run setup like described in the readme: "setup /upgradesp sqlrun" => Setup starts and I get: "Product already installed ... "
Im using the MSDE version of the SP4 setup, the MSSQL version Im running is 8.00.760
Ive also tried to use the UPGRADEUSER and UPGRADEPWD arguments, but with the same results.

Any ideas?

Thank you

I guess you attempted couple of times SP4 install.

You need to modify following registry key and rerun setup.

after running successfull you need to change it back to original values.

Registry key is:

Local Machine\software\Microsoft\MSSQLServer\MSSqlServer\CurrentVersion

change 8.00.194 to something else [8.00.888]

change 8.00.761 to something else [8.00.999]

Thanks!

Problems installing MSDE

When a double click setup.exe, I get the following message:

"SQL Server 2000 Desktop Engine Setup

SQL Server 2000 Desktop Engine cannot be installed on thiscomputer. This product requires Microsoft Windows NT Version 4.0 Service Pack 5or higher. Please download the service pack fromwww.microsoft.com prior to installing."

My machine is running Windows 2000 5.00.2195 Service Pack 4.
Anyone knows how to solve this problem?

Part of the problems installing MSDE is trying to install the service pack before SQL Server, try the link below and download the eval edition good for 120 days and the developer edition is $30 or less on the web . Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx|||Thanks for your advice. I didn't write back earlier because I wanted to try our solution until I it was successful.
I tried what you suggested, but I was still getting the error message.I looked into the autorun.inf file. In it it had these lines
...
[servicepack]
NTVersion=4
...
I verified that I could run MSDE on my OS by reading the documentation.Then, I commented out the line, and the installation rancorrectly.

Problems configuring Reporting Service (Express Edt.)

Hello there.

First: The problems have their orinin in ExpressEdt.Installation of RS. The DefaultInstallation did not SetUp the ReportingServices, just installed the files. So I had to configure the ReportingServices on my own. I used the "Reporting Services Configuration Manager".

Now I've got some problems configuring the reporting services. First problems are the virtual directories.
I've tried some different users for authentification. I used a local user with lower rights, an admin-user, Network Service and IUSR_MachineName for directory security. Tried to use WindowsAuthentification and AnonymousAcces.
The AppPool-Identity runs with NeworkService rights.
When I browse the page i get an "You are not authorized to view this page..."-error.
The mentioned users have rights on the local folders and are in IIS_WPG-Group.
Whats the problem here?

Second thing I have to tell is that in "RS Config Manager" the "Initialization"-tab has a (X), so i cant get into this program-part.

Please help me....

tobiHello There.

I found out the problem is caused by the website where the virtual directories are in.

For

publishing the website I put an IP-adress in and made some host

header-entries. After deleting the host headers ReportManager und

ReportServer are working fine.

Whats the problem using RS and HostHeaders?
How do I config them right?
I get the error: "HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials"

Credentials AppPool: "Network Service"
Credential WebSite: Windows Auth.
Credential VirtDirect.: Windows Auth.

As Credential i us a local user. This user is in Adminstrator group.

Thanks in advance, Tobi

Problems configuring Reporting Service (Express Edt.)

Hello there.
First: The problems have their orinin in ExpressEdt.Installation of RS.
The DefaultInstallation did not SetUp the ReportingServices, just
installed the files. So I had to configure the ReportingServices on my
own. I used the "Reporting Services Configuration Manager".
Now I've got some problems configuring the reporting services. First
problems are the virtual directories.
I've tried some different users for authentification. I used a local
user with lower rights, an admin-user, Network Service and
IUSR_MachineName for directory security. Tried to use
WindowsAuthentification and AnonymousAcces.
The AppPool-Identity runs with NeworkService rights.
When I browse the page i get an "You are not authorized to view this
page..."-error.
The mentioned users have rights on the local folders and are in
IIS_WPG-Group.
Whats the problem here?
Second thing I have to tell is that in "RS Config Manager" the
"Initialization"-tab has a (X), so i cant get into this program-part.
Please help me...
tobiHello There.
I found out the problem is caused by the website where the virtual
directories are in.
For publishing the website I put an IP-adress in and made some host
header-entries. After deleting the host headers ReportManager und
ReportServer are working fine.
Whats the problem using RS and HostHeaders?
How do I config them right?
I get the error: "HTTP Error 401.1 - Unauthorized: Access is denied due
to invalid credentials"
Credentials AppPool: "Network Service"
Credential WebSite: Windows Auth.
Credential VirtDirect.: Windows Auth.
As Credential i us a local user. This user is in Adminstrator group.
Thanks in advance, Tobisql

Problems Configuring HTTP Access to SQL Server 2005 Analysis Serveices on Windows XP

I tried to setup HTTP access to SQL Server 2005 Analysis Services on Windows XP, based on the technet article of the same name.

On setting up the virtual directory properties step, I could not add the msmdpump.dll in the Add/Edit Application Extension Mapping as the OK button is greyed out. What needs to be done to enable adding msmdpump.dll?

Any help would be appreciated!

Make sure that ".dll" is in the extension box (don't forget the period). And if the path to msmdpump.dll has an ellipse in the middle of it (...) after you browse to it and select it, click in the path text. The ellipse will go away and the ok button will become active. I had the same problem...|||

Ahha. The dot in front the dll did the trick.

Thank you very much!

problem with xml parsing in enqueue

We are trying to setup simple queue where we are trying to insert(enqueue) record ,it's inserted successfully .

But while retrive records from queues it shows the following err

XML parsing: line 0, character 0, unrecognized input signature

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: XML parsing: line 0, character 0, unrecognized input signature

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

when we use ths following query we r getting records properly

(select * from sys.transmission_queue )

For solving this we have used following commands

USE master ;

GO

ALTER DATABASE database name SET ENABLE_BROKER ;

alter ENDPOINT BrokerEndpoint
STATE = STARTED
AS TCP ( LISTENER_PORT = 4037 )
FOR SERVICE_BROKER ( AUTHENTICATION = WINDOWS ) ;
GO
--
SELECT is_broker_enabled FROM sys.databases WHERE name = 'dbname'

use dbname
select * from sys.transmission_queue order by enqueue_time desc

create master key encryption by password = 'pass@.word1';

alter AUTHORIZATION ON DATABASE::[dbname] TO [sa];

but unable to solve it.

In a sample example we can dequeue the element which can be removed but we can't enqueue the element, we can send you sample if you need.

Regards,

Ali

The error you show is a client side error (ADO.Net error), not a server error. It seems that you're trying to read a column that is not XML type through an SqlXml datatype. In adition it seems that you're using a Web Service (HTTP endpoint?) to access the server. Is this true?

BTW, messages should be dequeue using RECEIVE from the target service's queue, not select from sys.transmission_queue

|||

Thanx for giving right solution.

Ofcourse its problem with column size.

i resolved it.

Thanx..

Ali

problem with xml parsing in enqueue

We are trying to setup simple queue where we are trying to insert(enqueue) record ,it's inserted successfully .

But while retrive records from queues it shows the following err

XML parsing: line 0, character 0, unrecognized input signature

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: XML parsing: line 0, character 0, unrecognized input signature

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

when we use ths following query we r getting records properly

(select * from sys.transmission_queue )

For solving this we have used following commands

USE master ;

GO

ALTER DATABASE database name SET ENABLE_BROKER ;

alter ENDPOINT BrokerEndpoint
STATE = STARTED
AS TCP ( LISTENER_PORT = 4037 )
FOR SERVICE_BROKER ( AUTHENTICATION = WINDOWS ) ;
GO
--
SELECT is_broker_enabled FROM sys.databases WHERE name = 'dbname'

use dbname
select * from sys.transmission_queue order by enqueue_time desc

create master key encryption by password = 'pass@.word1';

alter AUTHORIZATION ON DATABASE::[dbname] TO [sa];

but unable to solve it.

In a sample example we can dequeue the element which can be removed but we can't enqueue the element, we can send you sample if you need.

Regards,

Ali

The error you show is a client side error (ADO.Net error), not a server error. It seems that you're trying to read a column that is not XML type through an SqlXml datatype. In adition it seems that you're using a Web Service (HTTP endpoint?) to access the server. Is this true?

BTW, messages should be dequeue using RECEIVE from the target service's queue, not select from sys.transmission_queue

|||

Thanx for giving right solution.

Ofcourse its problem with column size.

i resolved it.

Thanx..

Ali

problem with xml parsing in enqueue

We are trying to setup simple queue where we are trying to insert(enqueue) record ,it's inserted successfully .

But while retrive records from queues it shows the following err

XML parsing: line 0, character 0, unrecognized input signature

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: XML parsing: line 0, character 0, unrecognized input signature

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

when we use ths following query we r getting records properly

(select * from sys.transmission_queue )

For solving this we have used following commands

USE master ;

GO

ALTER DATABASE database name SET ENABLE_BROKER ;

alter ENDPOINT BrokerEndpoint
STATE = STARTED
AS TCP ( LISTENER_PORT = 4037 )
FOR SERVICE_BROKER ( AUTHENTICATION = WINDOWS ) ;
GO
--
SELECT is_broker_enabled FROM sys.databases WHERE name = 'dbname'

use dbname
select * from sys.transmission_queue order by enqueue_time desc

create master key encryption by password = 'pass@.word1';

alter AUTHORIZATION ON DATABASE::[dbname] TO [sa];

but unable to solve it.

In a sample example we can dequeue the element which can be removed but we can't enqueue the element, we can send you sample if you need.

Regards,

Ali

The error you show is a client side error (ADO.Net error), not a server error. It seems that you're trying to read a column that is not XML type through an SqlXml datatype. In adition it seems that you're using a Web Service (HTTP endpoint?) to access the server. Is this true?

BTW, messages should be dequeue using RECEIVE from the target service's queue, not select from sys.transmission_queue

|||

Thanx for giving right solution.

Ofcourse its problem with column size.

i resolved it.

Thanx..

Ali