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 executing Database Engine Tuning Advisor

We are trying to optimize one of our databases (SQL 2005) and we are running analysis on some of the stored procedures. However, the Database Engine Tuning Advisor is resulting in either

Event does not reference any tables.

Or

Statement does not reference any tables.

Anyone have any idea why this would happen?

PLease explain the process how you are trying analyze the SP using DTA?

ALso may try from another machine to see whether its a problem of tools on this machine.

|||Thanks for replying. Sorry I lost track of the thread. Essentially, all we are doing is executing a stored procedure in a query window and analyzing that directly.

Also, if we log the execution and use the trace log to do the analysis we get the same.

It has been tried in multiple machines. It is weird since there's no errors with the stored procedures. Thanks again.|||I have the same problem, a lot of those errors, plus after a while (from 25 to 60 minutes) the DTA exits with an "unexpected error".|||this happens against any stored procedure that DTA analyzes, why?

Problems executing Database Engine Tuning Advisor

We are trying to optimize one of our databases (SQL 2005) and we are running analysis on some of the stored procedures. However, the Database Engine Tuning Advisor is resulting in either

Event does not reference any tables.

Or

Statement does not reference any tables.

Anyone have any idea why this would happen?

PLease explain the process how you are trying analyze the SP using DTA?

ALso may try from another machine to see whether its a problem of tools on this machine.

|||Thanks for replying. Sorry I lost track of the thread. Essentially, all we are doing is executing a stored procedure in a query window and analyzing that directly.

Also, if we log the execution and use the trace log to do the analysis we get the same.

It has been tried in multiple machines. It is weird since there's no errors with the stored procedures. Thanks again.|||I have the same problem, a lot of those errors, plus after a while (from 25 to 60 minutes) the DTA exits with an "unexpected error".|||this happens against any stored procedure that DTA analyzes, why?

Problems executing Database Engine Tuning Advisor

We are trying to optimize one of our databases (SQL 2005) and we are running analysis on some of the stored procedures. However, the Database Engine Tuning Advisor is resulting in either

Event does not reference any tables.

Or

Statement does not reference any tables.

Anyone have any idea why this would happen?

PLease explain the process how you are trying analyze the SP using DTA?

ALso may try from another machine to see whether its a problem of tools on this machine.

|||Thanks for replying. Sorry I lost track of the thread. Essentially, all we are doing is executing a stored procedure in a query window and analyzing that directly.

Also, if we log the execution and use the trace log to do the analysis we get the same.

It has been tried in multiple machines. It is weird since there's no errors with the stored procedures. Thanks again.|||I have the same problem, a lot of those errors, plus after a while (from 25 to 60 minutes) the DTA exits with an "unexpected error".
|||this happens against any stored procedure that DTA analyzes, why?
sql

Problems during the installation of Integration Services

Trying to install SQL Server 2005 on my machine,I installed each part (engine, reporting services, integration services etc) seperately.

During the installation of Integration Services I got the following message

failed to install and configure assemblies D:\Microsoft SQL Server 90\90\DTS\Tasks\Microsoft.Sqlserver.MSMQTasks.dll in the COM+ catalog. Error: -2146233087

ErrorMessage: Unknown Error 0x80131501

ErrorDescription: You must have administrative credentials to perform this task. Contact your system administrator for assistance

I am administrator of my machine an i tried to install SQL usign this account.

I selected IGNORE and the installation continued. Will I have any problem with Integration Services in the future because of this error?

What is the source of this problem? How could I solve this problem?

Thank You Very Much

I had the same problem but i didnt find any solution.

Did you? Could you please post the solution when you find it?

Thank you

|||

I, too, am getting the same error under the same circumstances (logged in with admin priviledges). Using the help button on the error notification sent me to a web page to directs the user to confirm that the Distributed Transaction Coordinator service is logged in as "Network Service", which it is, so the help advice was useless.

Does anyone know the real source of this error?

Thanks

|||What OS?|||

I'm running XP Pro and Studio 2005 .NET. I found a different note that suggested uninstalling SQL Server, Studio and, .NET, and then reinstalling in that order. I'd really like to avoid uninstalling Studio if possible, though.

I did go back and uninstall all SQL servers (SQL Express was previously installed), and attempt the SQL 2005 install again and got the same error. I pressed "Ignore" and the complete install proceeded to the end without a problem. However, I suspect that MSMQTask.dll, the file that was causing the error, is going to needed at some point and I'll get failures.

Thanks

|||I'm getting the same problem with XP Pro.

I'm surprised it took 6 months for anybody showing interest in this problem. Usually this forum is awesome for solutions.

- Thanks.

Problems during the installation of Integration Services

Trying to install SQL Server 2005 on my machine,I installed each part (engine, reporting services, integration services etc) seperately.

During the installation of Integration Services I got the following message

failed to install and configure assemblies D:\Microsoft SQL Server 90\90\DTS\Tasks\Microsoft.Sqlserver.MSMQTasks.dll in the COM+ catalog. Error: -2146233087

ErrorMessage: Unknown Error 0x80131501

ErrorDescription: You must have administrative credentials to perform this task. Contact your system administrator for assistance

I am administrator of my machine an i tried to install SQL usign this account.

I selected IGNORE and the installation continued. Will I have any problem with Integration Services in the future because of this error?

What is the source of this problem? How could I solve this problem?

Thank You Very Much

I had the same problem but i didnt find any solution.

Did you? Could you please post the solution when you find it?

Thank you

|||

I, too, am getting the same error under the same circumstances (logged in with admin priviledges). Using the help button on the error notification sent me to a web page to directs the user to confirm that the Distributed Transaction Coordinator service is logged in as "Network Service", which it is, so the help advice was useless.

Does anyone know the real source of this error?

Thanks

|||What OS?|||

I'm running XP Pro and Studio 2005 .NET. I found a different note that suggested uninstalling SQL Server, Studio and, .NET, and then reinstalling in that order. I'd really like to avoid uninstalling Studio if possible, though.

I did go back and uninstall all SQL servers (SQL Express was previously installed), and attempt the SQL 2005 install again and got the same error. I pressed "Ignore" and the complete install proceeded to the end without a problem. However, I suspect that MSMQTask.dll, the file that was causing the error, is going to needed at some point and I'll get failures.

Thanks

|||I'm getting the same problem with XP Pro.

I'm surprised it took 6 months for anybody showing interest in this problem. Usually this forum is awesome for solutions.

- Thanks.

Problems converting varchar to smallmoney

Hi

My ticket engine stores values in varchar. The sql db-field that
corresponds was created as smallmoney.

The below statement works for conversion of "leavedays" if the given
value is entered without any decimal places (E.G. 4)

As soon as a user enters a value that includes decimal places (E.G.
4.5) the conversion will not work. In this case the value 4.5 is
rounded to 5.

What do i have to do to convert the value as it is entered by the user?

Thanks in advance

t.

Statement:

INSERT INTO leavereq (mitarbeiter, startdate, enddate, leavedays,
remainingdays, approvedby, approvedon) SELECT {0} , convert(datetime,
{1}) , convert(datetime, {2}), convert(numeric, {3}), convert(numeric,
{4}),{5}, getdate()

DDL for concerned database:

CREATE TABLE [dbo].[leavereq] (
[mitarbeiter] char(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[startdate] datetime NULL,
[enddate] datetime NULL,
[leavedays] smallmoney NULL,
[remainingdays] smallmoney NULL,
[approvedon] datetime NULL,
[approvedby] char(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
ON [PRIMARY]
GO

I am little confused. In your INSERT INTO statement, you are converting {3} and {4} to numeric, while the datatype for these two columns are smallmoney. Why don't you use smallmoney directly in the INSERT statement?

The reason it rounds up for you is that the default scale (max number of decimal digits) of numeric data type is 0. It would work fine if you use numeric(20, 2) for example. See "decimal and numeric (Transact-SQL)" in SQL Server Book Online for details.

|||

thx

seems to work now using smallmoney directly or numeric (20,2)

Problem with VPN connection on SQL server

> Provider=sqloledb;driver={SQL Server};Network=DBMSSOCN;uid=xxx;seagreen">
> server=evnapp;database=xxx and so on the local engine is connected ?
I think you mess ODBC and OLEDB connection strings here...
I think it must be
Provider=sqloledb;Data Source=123.123.123.123,1433;Network
Library=DBMSSOCN;Initial Catalog=yourdb;User ID=dbuser;Password=dbpass
Bojidar AlexandrovNo.
This connections string works fine. I do have it working with other
customers.
By the way it also works in the LAN enviroment.....
"Bojidar Alexandrov" <bojo@.kodar.net> schreef in bericht
news:uiFAzXFNEHA.2996@.TK2MSFTNGP12.phx.gbl...
> I think you mess ODBC and OLEDB connection strings here...
> I think it must be
> Provider=sqloledb;Data Source=123.123.123.123,1433;Network
> Library=DBMSSOCN;Initial Catalog=yourdb;User ID=dbuser;Password=dbpass
>
> Bojidar Alexandrov
>|||I do not say that it does not work, but that it is wrong. Please see
somewhere conenction string reference