Error Reporting: Installation on SQL 2005 on x64

I installed SQL 2005 on x64 machine and notice that my Y: drive (data drive) has these additional directories (shown below). I know those files are components of “Microsoft Application Error Reporting”. They are shared among multiple applications, hence them being in “common files”. After disabling the error reporting using Microsoft SQL Server 2005->Configuration Tools->Error and Usage Reporting, can I get rid of those directories or specify which directory that it should go to? Has anyone seen this before? Thanks.

The following had been installed to the drive that we did not specify in the installation of SQL 2005. Is there any way to redirect these file back the window directory?

Volume in drive Y is New Volume
Volume Serial Number is 882B-9F43
NULL
Directory of y:\program files\common files\microsoft shared\dw
NULL
06/01/2006 11:26 AM <DIR> .
06/01/2006 11:26 AM <DIR> ..
06/01/2006 11:26 AM <DIR> 1028
06/01/2006 11:26 AM <DIR> 1031
06/01/2006 11:26 AM <DIR> 1033
06/01/2006 11:26 AM <DIR> 1036
06/01/2006 11:26 AM <DIR> 1040
06/01/2006 11:26 AM <DIR> 1041
06/01/2006 11:26 AM <DIR> 1042
06/01/2006 11:26 AM <DIR> 2052
06/01/2006 11:26 AM <DIR> 3082
04/25/2005 01:44 PM 1,030,336 DW20.EXE
04/25/2005 01:44 PM 496,328 DWDCW20.DLL
04/25/2005 01:44 PM 489,672 DWTRIG20.EXE
3 File(s) 2,016,336 bytes
11 Dir(s) 85,983,068,160 bytes free
NULL

I'm pretty sure this is a setup bug where some components are not defaulting to the system drive, or sql drive, but to the drive where you launched setup from. I'm guessing you launched setup from the Y: drive. Don't know if there's a simple way to move them, but you can always uninstall, then reinstall, but this time launch setup from the drive you want these components installed on.sql

Error processing events

Let me start by saying this is my first crack at NotificationServices. I installed a sample from "Microsoft SQL Server 2000 Notification Services" that processes stock events (I think it may be a copy of the one in the help file). I get the following error when I place a file in the EventsWatchDirectory. I have uninstalled and reinstalled SQLXML and MSXML3 (I already had MSXML4 sp2). Any help is appreciated.

<NotificationServicesEvent>

<Description>

The FileSystemWatcher event provider failed to submit events.

</Description>

<Context>

<EventParameters>

<ProviderName>StockEventProvider</ProviderName>

<EventFileName>C:\SQL-NS\Chapter03\Stock\EventsWatchDirectory\EventData.xml</EventFileName>

<EventClassName>StockPriceChange</EventClassName>

</EventParameters>

</Context>

<Description>

Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type 'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed with HRESULT: 0x80004002 (No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))).

</Description>

<Instance>Chapter03</Instance>

<ApplicationName>Stock</ApplicationName>

<Component>Event collection</Component>

<Thread>15</Thread>

</NotificationServicesEvent>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Also of note:

I can instantiate SQLXMLBulkLoad.SQLXMLBulkLoad but not SQLXMLBulkLoad.SQLXMLBulkLoadClass. The first sample VB Script from the SQLXML works fine to insert data into a table.|||Answer was in the old forums. I had .Net 2.0 Beta 2 installed. Uninstalled it and repaired XML4.0 and SQLXML3.0 and all was good. Thanks Shyam|||Larry,
What version of the .NET frameworks do you have on the machine. Notification Services in SQL 2000 requires the .NET Framework 1.1. If you have version 2.0 (only - without a side-by-side copy of version 1.1), you will see this problem. The reason is that one of the methods we call when loading the XML event loading components has been made obsolete in the 2.0 .NET Frameworks.

If you want to go with the .NET Frameworks 2.0, you should use the version of Notification SErvices in SQL Server 2005 - that version is designed to work on .NET 2.0.

THanks
-shyam
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.|||

Hello Shyam,

I have the exact same problem (I am also using your book code samples) the SQL-NS applications are compiling OK, and the service starts nicely, but when I try to trigger an event, I get the following error:

Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type 'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

the configuration of my development machine is the following:

Windows XP Pro SP2

SQL Server 2000 SP4

SQL Server 2000 Notification Services SP1

SQLXML 3.0 SP3

.NET Framework 1.1 (VS 2003)

.NET Framework 2.0 (VS 2005)

SQL Server 2005 Express (the edition that is installed with VS 2005)

Unfortunately I am developping with both versions of visual studio (2003 & 2005) so I need both frameworks.

We are using SQL server 2000 and are not ready to upgrade to SQL server 2005.

Is there any fix I could use?

Thanks for your help.

Henri PIQUET

Error processing events

Let me start by saying this is my first crack at NotificationServices. I installed a sample from "Microsoft SQL Server 2000 Notification Services" that processes stock events (I think it may be a copy of the one in the help file). I get the following error when I place a file in the EventsWatchDirectory. I have uninstalled and reinstalled SQLXML and MSXML3 (I already had MSXML4 sp2). Any help is appreciated.

<NotificationServicesEvent>

<Description>

The FileSystemWatcher event provider failed to submit events.

</Description>

<Context>

<EventParameters>

<ProviderName>StockEventProvider</ProviderName>

<EventFileName>C:\SQL-NS\Chapter03\Stock\EventsWatchDirectory\EventData.xml</EventFileName>

<EventClassName>StockPriceChange</EventClassName>

</EventParameters>

</Context>

<Description>

Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type 'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed with HRESULT: 0x80004002 (No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE))).

</Description>

<Instance>Chapter03</Instance>

<ApplicationName>Stock</ApplicationName>

<Component>Event collection</Component>

<Thread>15</Thread>

</NotificationServicesEvent>

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Also of note:

I can instantiate SQLXMLBulkLoad.SQLXMLBulkLoad but not SQLXMLBulkLoad.SQLXMLBulkLoadClass. The first sample VB Script from the SQLXML works fine to insert data into a table.|||Answer was in the old forums. I had .Net 2.0 Beta 2 installed. Uninstalled it and repaired XML4.0 and SQLXML3.0 and all was good. Thanks Shyam|||Larry,
What version of the .NET frameworks do you have on the machine. Notification Services in SQL 2000 requires the .NET Framework 1.1. If you have version 2.0 (only - without a side-by-side copy of version 1.1), you will see this problem. The reason is that one of the methods we call when loading the XML event loading components has been made obsolete in the 2.0 .NET Frameworks.

If you want to go with the .NET Frameworks 2.0, you should use the version of Notification SErvices in SQL Server 2005 - that version is designed to work on .NET 2.0.

THanks
-shyam
Learn more about SQL-NS:
http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.|||

Hello Shyam,

I have the exact same problem (I am also using your book code samples) the SQL-NS applications are compiling OK, and the service starts nicely, but when I try to trigger an event, I get the following error:

Unable to cast COM object of type 'SqlXmlBulkLoad.SQLXMLBulkLoadClass' to interface type 'SqlXmlBulkLoad.ISQLXMLBulkLoad'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{1380DD8D-DCB9-4A6E-9D53-EECDDF18DA85}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

the configuration of my development machine is the following:

Windows XP Pro SP2

SQL Server 2000 SP4

SQL Server 2000 Notification Services SP1

SQLXML 3.0 SP3

.NET Framework 1.1 (VS 2003)

.NET Framework 2.0 (VS 2005)

SQL Server 2005 Express (the edition that is installed with VS 2005)

Unfortunately I am developping with both versions of visual studio (2003 & 2005) so I need both frameworks.

We are using SQL server 2000 and are not ready to upgrade to SQL server 2005.

Is there any fix I could use?

Thanks for your help.

Henri PIQUET

error Openrowset on the provider

I am a newbie, and need all the help i can get!

I am using SQL Server 2000 Personal edition on a Windows XP Pro wkst. I have just installed it, so maybe I have not configured it properly, I just created 2 new databases, online and off. I am trying to import data from Paradox db. I am using the DTS Import/Export Wizard in Enterprise Manager.

I select the database I want to import, which I have copied onto my local hardrive,C: Databases\old.db.

Then when I go to select the destination,
Provider: MS OLE DB Provider for SQL,
Server:local server-(this is my wkst, right?),
Use windows authentication( I have it set to use both windows and sql in security settings)
Database: new (database i just created.)

Next under Select source tables and views it shows my source database: old.db and destination [new].[dbo].[old]

When I click on next I get the following error:
Error source: Microsoft JET Database Engine
Error descrip:Unexpected error from external database driver
Context: Error calling OpenRowset on the provider

What am i doing wrong?

Thanks for your help.Get latest drivers for Paradox.

Error on Query to Sys Views (e.g. sys.objects)

I've just installed SQL Server 2005 Developer Edition, upgraded from SQL Server 2000, and have encountered a problem in trying to query against the System Catalogs.

I've tried SELECT * FROM sys.objects in addition to SELECT suser_name( role_principal_id ) FROM sys.server_role_members. In both cases I receive the following error: Invalid object name 'sys.objects' or 'sys.server_role_members' in the second example.

I changed the properties of the registration for my local db instance to use SQL authentication in lieu of Windows authentication. I used the sa login account to see if that made a difference, no go.

Can someone *please* tell me what I'm doing wrong here?

I would also like to know if it's possible to run a query confirming the user account I'm logged in to the system as.

Thanks!

what i feel is you are still connecting to SQL Server 2000. post the result of

Select @.@.Version

run the above query in query anlyser from where you are getting this error and post the result

you might have only installed Tools...

Madhu

|||

That was it Madhu. Thanks for the prompt reply. I had assumed that in upgrading to Sql Server 2005 all databases were pushed to the 2005 engine. Is there a manual step I must complete in order to do just that?

In addition, can you tell me how to query the user account I'm logged in as?

Thanks again

|||

(a) install SQL Server 2005

(b) use backup/restore or detach /attach method to transfer the database

(c) make script of other server level objects like jobs etc and run it in sql server 2005 instance

To fine user account : SELECT SUSER_SNAME()

Madhu

|||Thanks again for the feedback!

Error on Query to Sys Views (e.g. sys.objects)

I've just installed SQL Server 2005 Developer Edition, upgraded from SQL Server 2000, and have encountered a problem in trying to query against the System Catalogs.

I've tried SELECT * FROM sys.objects in addition to SELECT suser_name( role_principal_id ) FROM sys.server_role_members. In both cases I receive the following error: Invalid object name 'sys.objects' or 'sys.server_role_members' in the second example.

I changed the properties of the registration for my local db instance to use SQL authentication in lieu of Windows authentication. I used the sa login account to see if that made a difference, no go.

Can someone *please* tell me what I'm doing wrong here?

I would also like to know if it's possible to run a query confirming the user account I'm logged in to the system as.

Thanks!

what i feel is you are still connecting to SQL Server 2000. post the result of

Select @.@.Version

run the above query in query anlyser from where you are getting this error and post the result

you might have only installed Tools...

Madhu

|||

That was it Madhu. Thanks for the prompt reply. I had assumed that in upgrading to Sql Server 2005 all databases were pushed to the 2005 engine. Is there a manual step I must complete in order to do just that?

In addition, can you tell me how to query the user account I'm logged in as?

Thanks again

|||

(a) install SQL Server 2005

(b) use backup/restore or detach /attach method to transfer the database

(c) make script of other server level objects like jobs etc and run it in sql server 2005 instance

To fine user account : SELECT SUSER_SNAME()

Madhu

|||Thanks again for the feedback!

error on Mining Accuracy Tab

Hi All
I have installed SP2 for SQL server 2005, i just want to try datamining like in the tutorial, i found error if i click "Mining Accuracy Chart" for comparing model with error

"TITLE: Microsoft Visual Studio
An error prevented the view from loading.
ADDITIONAL INFORMATION:
Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (System.Windows.Forms)
"
any body can help.

thanks

Hello,

Do you have visual studio installed in the system? Did your .NET framework installation was successfull? Check in your system if you have System.Windows.Forms.dll. If your Microsoft .NET framework / Microsoft Visual Studio installation is not successful you might hit this issue. Try installing the .NET framework and see if works.

Thanks

|||

Hi,

I have the same problem. Visual Studio 2005 is correctly installed on the machine. Notice that I have installed the framework 3.0. Could it be a reason ?

Philippe

error on Mining Accuracy Tab

Hi All
I have installed SP2 for SQL server 2005, i just want to try datamining like in the tutorial, i found error if i click "Mining Accuracy Chart" for comparing model with error

"TITLE: Microsoft Visual Studio
An error prevented the view from loading.
ADDITIONAL INFORMATION:
Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (System.Windows.Forms)
"
any body can help.

thanks

Hello,

Do you have visual studio installed in the system? Did your .NET framework installation was successfull? Check in your system if you have System.Windows.Forms.dll. If your Microsoft .NET framework / Microsoft Visual Studio installation is not successful you might hit this issue. Try installing the .NET framework and see if works.

Thanks

|||

Hi,

I have the same problem. Visual Studio 2005 is correctly installed on the machine. Notice that I have installed the framework 3.0. Could it be a reason ?

Philippe

error on installing sql express 2005

I'm having trouble loging into sql...then I remebered when I first installed it on my XP pro machine the system config check showed everything passed except the following:

System Configuration Check

-

- COM Plus Catalog Requirement (Warning)

Messages

COM Plus Catalog Requirement

If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.

- Can this be the reason I cannot log into sql ?

Did you resolve this issue?

error on installing sql express 2005

I'm having trouble loging into sql...then I remebered when I first installed it on my XP pro machine the system config check showed everything passed except the following:

System Configuration Check

-

- COM Plus Catalog Requirement (Warning)

Messages

COM Plus Catalog Requirement

If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.

- Can this be the reason I cannot log into sql ?

Did you resolve this issue?sql

error on DTS scheduling

I am pretty new to SQL server. I have setup a DTS package that would
delete and then copy data from SQL server to DB2 on mainframe. I
installed the Host Intergration Server 2000 client to get OLEDB for
Db2. The DTS is working fine, when I run it myself from the server.
But when I schedule it it get the following error:
Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
Error string: Internal NetLib Error Error source: Microsoft
DB2 OLE DB Provider Help file: Help context: 0 Error
Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
(0) Error string: Internal NetLib Error Error source:
Microsoft DB2 OLE DB Provider Help file: Help context: 0
DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
execution complete. Process Exit Code 1. The step failed.
I have been trying to solve this for the last couple of days, but not
getting anywhere...could somebody please help ?
Thanks
RogerThis is because (most probably) because when you schedule a package it runs on the server so everything you need must be on the
scheduling server. You probably have the drivers installed on your workstation which is why it works when you run it.
Have a look here
http://support.microsoft.com/?kbid=269074
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com
"sql rookie" <anytasks@.gmail.com> wrote in message news:1104952964.389735.87880@.z14g2000cwz.googlegroups.com...
>I am pretty new to SQL server. I have setup a DTS package that would
> delete and then copy data from SQL server to DB2 on mainframe. I
> installed the Host Intergration Server 2000 client to get OLEDB for
> Db2. The DTS is working fine, when I run it myself from the server.
> But when I schedule it it get the following error:
> Executed as user: LOMBARD\sqlexec. DTSRun: Loading... DTSRun:
> Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun
> OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147217900 (80040E14)
> Error string: Internal NetLib Error Error source: Microsoft
> DB2 OLE DB Provider Help file: Help context: 0 Error
> Detail Records: Error: -2147217900 (80040E14); Provider Error: 0
> (0) Error string: Internal NetLib Error Error source:
> Microsoft DB2 OLE DB Provider Help file: Help context: 0
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package
> execution complete. Process Exit Code 1. The step failed.
>
> I have been trying to solve this for the last couple of days, but not
> getting anywhere...could somebody please help ?
> Thanks
> Roger
>|||No , I executed the DTS on the server itself. I am using Terminal
server to login to the server. I can execute the DTS via EM and also
using DTSRUN on command line. But when I schedule it , it throws this
error.|||You,
it sounds to me like a problem with users.
My aasumption is that you installed drivers for DB2 logged-in as
Administrator.
So everything is working when you run the DTS package as Administrator.
But when the package runs as LOMBARD\sqlexec it cannot find the drivers.
Maybe you can try and install the drivers also logged-in as sqlexec.
Danijel
"sql rookie" <anytasks@.gmail.com> wrote in message
news:1104955716.152873.292710@.z14g2000cwz.googlegroups.com...
> No , I executed the DTS on the server itself. I am using Terminal
> server to login to the server. I can execute the DTS via EM and also
> using DTSRUN on command line. But when I schedule it , it throws this
> error.
>|||There is a new developement on this:
I tried to change the sqlserver and agent service account to Local
systems and then the scheduling was working fine. I created a new
domain account , added it to the admin group to the server, made that
domain user the service account for sqlserver and agent. Gave sysadmin
privelege to the domain user. Now when I schedule it , I doesn't work.
I gives the same error
Am I doing something wrong ?
Please help

Error on disk move while trying to add SP3a

I am trying to add sp3a to my Sql Server 2000 install.
I have already added sql2ksp3.exe and it installed fine. I get an error
trying to add sql2kasp3.exe. After unpacking and running setup.exe, I
get the error:
"An error occurred during the move process: -145"
There is plenty of room on my disk (about 300 MB).
I get the same error when I run it on different disks. The sql2ksp3.exe
is a much larger release and I had no problem with that one.
I looked on google for this error and I can pleny of docs with the same
error message (except for the -145).
Anyone know what the problem is?
Thanks,
Tom.
Why are you installing SP3a when you already have SP3? Did you read the
release notes?
Why are you installing sql2kasp3.exe? Do you actually have Analysis
Services installed and running? Or did you just grab every single
SP3-related file?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408F2721.4090004@.deltanet.com...
>I am trying to add sp3a to my Sql Server 2000 install.
> I have already added sql2ksp3.exe and it installed fine. I get an error
> trying to add sql2kasp3.exe. After unpacking and running setup.exe, I get
> the error:
> "An error occurred during the move process: -145"
> There is plenty of room on my disk (about 300 MB).
> I get the same error when I run it on different disks. The sql2ksp3.exe
> is a much larger release and I had no problem with that one.
> I looked on google for this error and I can pleny of docs with the same
> error message (except for the -145).
> Anyone know what the problem is?
> Thanks,
> Tom.
>
|||Aaron Bertrand [MVP] wrote:

> Why are you installing SP3a when you already have SP3? Did you read the
> release notes?
I didn't have SP3. I had just loaded 2000 on my machine and was just
loading SP3 to bring it up to the correct level.

> Why are you installing sql2kasp3.exe? Do you actually have Analysis
> Services installed and running? Or did you just grab every single
> SP3-related file?
No. I didn't load all the SPs. I didn't load the desktop one. I
loaded the other because the instructions say to use both. I assume I
have the analysis services on my machine as I loaded the full system.
Is this not the case? How do I tell?
Here is the instructions on the MS download page:
************************************************** *********************
Instructions
To install SP3a, follow the installation instructions below. Not all
steps are required, depending on which of the following SQL Server 2000
components or configurations to which the service pack is being applied.
Important: You must upgrade computers running Microsoft Windows XP
to Windows XP Service Pack 1 before applying SQL Server 2000 Service
Pack 3a.
Back up your SQL Server databases.
Back up your Analysis Services databases.
Make sure that the system databases have enough free space.
Minimum of 64 MB of RAM (128 MB or more recommended)
Install Database Components SP3a (SQL2KSP3.exe).
Install Analysis Services Components SP3a (SQL2KASP3.exe).
Restart services and applications.
More detailed instructions can be found at the Product Support Services
Readme .
************************************************** *********************

>
|||Analysis Services is separate. Hopefully, you would know if you installed
Analysis Services. It shouldn't be installed if you're not using it, never
mind if you don't know what it is...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408FFA85.2010208@.deltanet.com...
> Aaron Bertrand [MVP] wrote:
>
> I didn't have SP3. I had just loaded 2000 on my machine and was just
> loading SP3 to bring it up to the correct level.
>
> No. I didn't load all the SPs. I didn't load the desktop one. I
> loaded the other because the instructions say to use both. I assume I
> have the analysis services on my machine as I loaded the full system.
> Is this not the case? How do I tell?
> Here is the instructions on the MS download page:
> ************************************************** *********************
> Instructions
> To install SP3a, follow the installation instructions below. Not all
> steps are required, depending on which of the following SQL Server 2000
> components or configurations to which the service pack is being applied.
>
> Important: You must upgrade computers running Microsoft Windows XP
> to Windows XP Service Pack 1 before applying SQL Server 2000 Service
> Pack 3a.
>
> Back up your SQL Server databases.
> Back up your Analysis Services databases.
> Make sure that the system databases have enough free space.
> Minimum of 64 MB of RAM (128 MB or more recommended)
> Install Database Components SP3a (SQL2KSP3.exe).
> Install Analysis Services Components SP3a (SQL2KASP3.exe).
> Restart services and applications.
> More detailed instructions can be found at the Product Support Services
> Readme .
> ************************************************** *********************
>

Error on disk move while trying to add SP3a

I am trying to add sp3a to my Sql Server 2000 install.
I have already added sql2ksp3.exe and it installed fine. I get an error
trying to add sql2kasp3.exe. After unpacking and running setup.exe, I
get the error:
"An error occurred during the move process: -145"
There is plenty of room on my disk (about 300 MB).
I get the same error when I run it on different disks. The sql2ksp3.exe
is a much larger release and I had no problem with that one.
I looked on google for this error and I can pleny of docs with the same
error message (except for the -145).
Anyone know what the problem is?
Thanks,
Tom.Why are you installing SP3a when you already have SP3? Did you read the
release notes?
Why are you installing sql2kasp3.exe? Do you actually have Analysis
Services installed and running? Or did you just grab every single
SP3-related file?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408F2721.4090004@.deltanet.com...
>I am trying to add sp3a to my Sql Server 2000 install.
> I have already added sql2ksp3.exe and it installed fine. I get an error
> trying to add sql2kasp3.exe. After unpacking and running setup.exe, I get
> the error:
> "An error occurred during the move process: -145"
> There is plenty of room on my disk (about 300 MB).
> I get the same error when I run it on different disks. The sql2ksp3.exe
> is a much larger release and I had no problem with that one.
> I looked on google for this error and I can pleny of docs with the same
> error message (except for the -145).
> Anyone know what the problem is?
> Thanks,
> Tom.
>|||Aaron Bertrand [MVP] wrote:
> Why are you installing SP3a when you already have SP3? Did you read the
> release notes?
I didn't have SP3. I had just loaded 2000 on my machine and was just
loading SP3 to bring it up to the correct level.
> Why are you installing sql2kasp3.exe? Do you actually have Analysis
> Services installed and running? Or did you just grab every single
> SP3-related file?
No. I didn't load all the SPs. I didn't load the desktop one. I
loaded the other because the instructions say to use both. I assume I
have the analysis services on my machine as I loaded the full system.
Is this not the case? How do I tell?
Here is the instructions on the MS download page:
***********************************************************************
Instructions
To install SP3a, follow the installation instructions below. Not all
steps are required, depending on which of the following SQL Server 2000
components or configurations to which the service pack is being applied.
Important: You must upgrade computers running Microsoft® Windows® XP
to Windows XP Service Pack 1 before applying SQL Server 2000 Service
Pack 3a.
Back up your SQL Server databases.
Back up your Analysis Services databases.
Make sure that the system databases have enough free space.
Minimum of 64 MB of RAM (128 MB or more recommended)
Install Database Components SP3a (SQL2KSP3.exe).
Install Analysis Services Components SP3a (SQL2KASP3.exe).
Restart services and applications.
More detailed instructions can be found at the Product Support Services
Readme .
***********************************************************************
>|||Analysis Services is separate. Hopefully, you would know if you installed
Analysis Services. It shouldn't be installed if you're not using it, never
mind if you don't know what it is...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408FFA85.2010208@.deltanet.com...
> Aaron Bertrand [MVP] wrote:
> > Why are you installing SP3a when you already have SP3? Did you read the
> > release notes?
>
> I didn't have SP3. I had just loaded 2000 on my machine and was just
> loading SP3 to bring it up to the correct level.
> >
> > Why are you installing sql2kasp3.exe? Do you actually have Analysis
> > Services installed and running? Or did you just grab every single
> > SP3-related file?
>
> No. I didn't load all the SPs. I didn't load the desktop one. I
> loaded the other because the instructions say to use both. I assume I
> have the analysis services on my machine as I loaded the full system.
> Is this not the case? How do I tell?
> Here is the instructions on the MS download page:
> ***********************************************************************
> Instructions
> To install SP3a, follow the installation instructions below. Not all
> steps are required, depending on which of the following SQL Server 2000
> components or configurations to which the service pack is being applied.
>
> Important: You must upgrade computers running Microsoft® Windows® XP
> to Windows XP Service Pack 1 before applying SQL Server 2000 Service
> Pack 3a.
>
> Back up your SQL Server databases.
> Back up your Analysis Services databases.
> Make sure that the system databases have enough free space.
> Minimum of 64 MB of RAM (128 MB or more recommended)
> Install Database Components SP3a (SQL2KSP3.exe).
> Install Analysis Services Components SP3a (SQL2KASP3.exe).
> Restart services and applications.
> More detailed instructions can be found at the Product Support Services
> Readme .
> ***********************************************************************
> >
> >
>

Error on disk move while trying to add SP3a

I am trying to add sp3a to my Sql Server 2000 install.
I have already added sql2ksp3.exe and it installed fine. I get an error
trying to add sql2kasp3.exe. After unpacking and running setup.exe, I
get the error:
"An error occurred during the move process: -145"
There is plenty of room on my disk (about 300 MB).
I get the same error when I run it on different disks. The sql2ksp3.exe
is a much larger release and I had no problem with that one.
I looked on google for this error and I can pleny of docs with the same
error message (except for the -145).
Anyone know what the problem is?
Thanks,
Tom.Why are you installing SP3a when you already have SP3? Did you read the
release notes?
Why are you installing sql2kasp3.exe? Do you actually have Analysis
Services installed and running? Or did you just grab every single
SP3-related file?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408F2721.4090004@.deltanet.com...
>I am trying to add sp3a to my Sql Server 2000 install.
> I have already added sql2ksp3.exe and it installed fine. I get an error
> trying to add sql2kasp3.exe. After unpacking and running setup.exe, I get
> the error:
> "An error occurred during the move process: -145"
> There is plenty of room on my disk (about 300 MB).
> I get the same error when I run it on different disks. The sql2ksp3.exe
> is a much larger release and I had no problem with that one.
> I looked on google for this error and I can pleny of docs with the same
> error message (except for the -145).
> Anyone know what the problem is?
> Thanks,
> Tom.
>|||Aaron Bertrand [MVP] wrote:

> Why are you installing SP3a when you already have SP3? Did you read the
> release notes?
I didn't have SP3. I had just loaded 2000 on my machine and was just
loading SP3 to bring it up to the correct level.

> Why are you installing sql2kasp3.exe? Do you actually have Analysis
> Services installed and running? Or did you just grab every single
> SP3-related file?
No. I didn't load all the SPs. I didn't load the desktop one. I
loaded the other because the instructions say to use both. I assume I
have the analysis services on my machine as I loaded the full system.
Is this not the case? How do I tell?
Here is the instructions on the MS download page:
****************************************
*******************************
Instructions
To install SP3a, follow the installation instructions below. Not all
steps are required, depending on which of the following SQL Server 2000
components or configurations to which the service pack is being applied.
Important: You must upgrade computers running Microsoft Windows XP
to Windows XP Service Pack 1 before applying SQL Server 2000 Service
Pack 3a.
Back up your SQL Server databases.
Back up your Analysis Services databases.
Make sure that the system databases have enough free space.
Minimum of 64 MB of RAM (128 MB or more recommended)
Install Database Components SP3a (SQL2KSP3.exe).
Install Analysis Services Components SP3a (SQL2KASP3.exe).
Restart services and applications.
More detailed instructions can be found at the Product Support Services
Readme .
****************************************
*******************************

>|||Analysis Services is separate. Hopefully, you would know if you installed
Analysis Services. It shouldn't be installed if you're not using it, never
mind if you don't know what it is...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:408FFA85.2010208@.deltanet.com...
> Aaron Bertrand [MVP] wrote:
>
>
> I didn't have SP3. I had just loaded 2000 on my machine and was just
> loading SP3 to bring it up to the correct level.
>
>
> No. I didn't load all the SPs. I didn't load the desktop one. I
> loaded the other because the instructions say to use both. I assume I
> have the analysis services on my machine as I loaded the full system.
> Is this not the case? How do I tell?
> Here is the instructions on the MS download page:
> ****************************************
*******************************
> Instructions
> To install SP3a, follow the installation instructions below. Not all
> steps are required, depending on which of the following SQL Server 2000
> components or configurations to which the service pack is being applied.
>
> Important: You must upgrade computers running Microsoft Windows XP
> to Windows XP Service Pack 1 before applying SQL Server 2000 Service
> Pack 3a.
>
> Back up your SQL Server databases.
> Back up your Analysis Services databases.
> Make sure that the system databases have enough free space.
> Minimum of 64 MB of RAM (128 MB or more recommended)
> Install Database Components SP3a (SQL2KSP3.exe).
> Install Analysis Services Components SP3a (SQL2KASP3.exe).
> Restart services and applications.
> More detailed instructions can be found at the Product Support Services
> Readme .
> ****************************************
*******************************
>
>

Error Number : 29503 The SQL Server service failed to start.

Is there a trick to getting this installed correctly? Everything works great until it gets up to starting the service. Here is the complete section of my setup log file.

SQL 2005 Standard.

Machine : KINGSERVER550
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--
Machine : KINGSERVER550
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_KINGSERVER550_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503

I searched a previous thread dealing with this error, but seems like nobody has found a solution.

--Tony

Did you look in this log file

Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_KINGSERVER550_SQL.log

|||

Well, I took a look at the log file you specified and there is a small section that contains the same information and informs me to look in the SQL Server Books Online.

Here is an excerpt from the log file. It is also on my server accessible through the following link.

http://www.kingenterprises.dynu.com/SQLSetup0003_KINGSERVER550_SQL.log

- Context --

Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$KINGSQL

Error Code: 1067
MSI (s) (5C!6C) [14:50:06:117]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly..Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

The error is (1067) The process terminated unexpectedly..<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Wed Mar 29 14:50:06 2006
Service MSSQL$KINGSQL with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Wed Mar 29 14:50:06 2006 Service failed unexpectedly (1067) Error Code: 0x8007042b (1067)
Windows Error Text: The process terminated unexpectedly. Source File Name: sqlsetuplib\service.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: sqls::Service::Start
Source Line Number: 301

- Context --

Setting status of unmanaged components and removing unmanaged resources
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$KINGSQL
Do_sqlScript
SqlScriptHlpr
Start service MSSQL$KINGSQL

Error Code: 1067 MSI (s) (5C!6C) [14:50:12:937]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly..

Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.

|||

Correction on the website...

http://www.kingenterprises.dynu.com/SQLSetup0003_KINGSERVER550_SQL.log.txt

It seems IIS will not serve a "log" file extension.

|||

You might check the SQL engine log file, located somewhere like this: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG. If the engine tried to start and failed, the reason will be in there.

|||

FOUND MY PROBLEM!!

FOUND MY PROBLEM!!

The error relates to the type of processor used on the machine that is loading SQL 2005 (Std, Devoper, Enterprise, etc...)

Take a look at this post on the following website.

http://www.sqljunkies.com/Forums/ShowPost.aspx?PostID=167

Apparently the SQL 2005 family does not support AMD K6-2 processors. Anyone else have this problem?

In specific, my processor is: AMD K6-2 550 MHz

x86 Family 5 Model 8 Stepping 12, AuthenticAMD

Problem solved!! Upgrade my damn 'puter.

Thanks anyway everyone!

Tony

error- microsoft ODBC sql server driver - timeout expired

Hi everyone

I have installed SQL server on my server machine. using localsystem and mixmode option.
It is working fine.

I installed sql server with connectivity tools only option on my client computer.

now, When i try to connect to server using data source from control panel --> Administrative tools --> Data source(ODBC).

but I cant connect.It gives me error as below.

Connection Failed:
SQLState:'HYT00'
Sql Server Error:0
[Microsoft][ODBC SQL Server Driver] Timeout Expired.

I uninstalled sql server from my client and server computer. and installed again.

I tried to ping from client computer to server computer it is working.

even i tried telnet sqlservername 1433

this on is also ok.

even thiough i m facing.

But same error facing

Please help me out.

Regards,
ASIF

Check your SQL Server alias. This is sometimes causing errors as your client is having difficulty mapping names to IP addresses. If you are using ODBC DSN, in the Which SQL Server do you want to connect to ? drop down, type the IP Address of your SQL Server box instead of the alias.

Error message when trying to do a maintenance plan

Hi all,

As far as I can tell I have installed all features of SQL2005 but when I try to setup a maintenance plan I am receiving this message:

TITLE: Microsoft SQL Server Management Studio

The action you attempted to perform on a remote instance of SQL Server has failed because the action requires a SQL Server component that is not installed on the remote computer. To proceed, install SQL Server 2005 Management Tools on the remote computer, and then try again. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)

For help, click: http://go.microsoft.com/fwlink/?LinkID=57083

BUTTONS:

OK

Any ideas on why this is happening?

first of all you must apply sp2 of Mar

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19624

There are many problems related to MP solved in this version. Check whether you have installed Integration services and the services is running

Madhu

|||

First things first, have you applied any service pack after you have installed the SQL 2005 components on thsi machine?

If not try as suggested to take care of such issues with maintenance plans.

Error Message when accessing Report Manager

Whenever I try to access Report Manager, I get this message. I don't know what caused it. I recently installed Crystal Reports v11 & Oracle 10gEX evaluation apps. Could they have caused this? How do I fix this?

Product:SQL Server Reporting ServicesEvent ID:rsReportServerDisabledSource:Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.StringsVersion:8.00Message:Unable to encrypt or decrypt data managed by the Report Server instance. Please refer to the Reporting Services online help for guidance in enabling this functionality.

Explanation

A symmetric key is a single key used to encrypt and decrypt data. Reporting Services encrypts the symmetric key itself, using the public key of a specific user account on a specific computer. This error occurs when the public key that the user account provides does not match the public key that report server is expecting. Conditions that cause this error to occur include changing the name of a report server instance, moving the report server instance to a different computer, or changing the account under which the Report Server service runs.

User Action

A system administrator on the computer running the report server service can use a backup copy of the public key to get the report server running again. Use the rskeymgmt utility to apply the backup key set. If you do not have backup of the key, you must run the rskeymgmt utility to delete all of the encrypted content, run the rsconfig utility to respecify the encrypted connection values used to connect to the report server database, restart the service, and retype stored credentials for all reports that use stored credentials. For more information this utility, search Books Online.

---

The encryption keys are tied to the service account user. If any of those programs reset the ASP.Net account, it would cause this error.

Have you tried following the steps listed under "User Action"? Depending on which accounts were reset, you might be able to use rsactivate -r if you do not have a backup key.|||Brian:

Pardon my lack of knowledge but exactly how does one access the "rsactivate -r". Do I type this into the "run" text block?

I have found the rskeymgmnt.exe & rsconfig.exe files. Rvery time I click the executable the command window pops open & immediately closes.

I apologize for asking such elementary questions but it is difficult to get answers outside of the expert forums.

Thanks, Jack|||Brian:

Can you tell me how to retrieve a backup key? I default installed SQL Server 2000 and later Reporting Services. I do not recall setting up a backup key. Can I use rekeymgmt -e to extract a key to a text file? Can I use rekeymgmt -a to apply it before I try to get into Report Manager?

When you say "any of those programs reset the ASP.Net account", I assume you are referring to either Oracle Express or Crystal Reports?

Do I type rsactivate -r into the "run" text box? Do I type any other characters with it? Do i need to type a specific account name with the reset commandor will a generic "rsactivate -r" reset all.

I am obviously a beginner. I would appreciate the help.|||Rsactivate and rskeymgmt are command line tools. You will want to open a command window and run the programs from there. You can run rsactivate /? and rskeymgmt /? to get more help on other flags you will need. Also see the MSDN documentation at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_6yqq.asp and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_29ly.asp for example usage and a description of what the various flags do.

Error message trying to log into Report Manager

I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
Standard or whatever comes with SBS Premium.
I installed SQL as a named instance (SERVER\MSGPSBM) and also installed
Reporting Services in this instance using the default config during the
installation.
When I try to connect to Reporting Services with SSMS on the local
machine using Windows Authentication logged in as Administrator I get
the following error:
Cannot connect to SERVER\MSGPSBM
Additional Information:
Unable to connect to the remote server (System)
No connection could be made because the target machine actively refused
it (System)
When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
Error Unable to connect to the remote server. message
I can log into the database engine just fine.
What am I doing wrong?
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/20/2007 10:45:44 AMHello,
When you use SQL Server Reporting Services Configuration Manager can you log
to SSRS service?
If so check which of the points are marked on red. All of them should be
green or blue (if no active).
This is the first step to recognize where is the problem.
I suppose it could be a problem with accounts (Windows Services Account or
IIS Application Pool Account)
Best Regards,
Radoslaw Lebkowski
Uzytkownik "Japheth Nolt" <japheth.remove@.landiscomputer.com> napisal w
wiadomosci news:xn0ff611k1lg3ln001@.msnews.microsoft.com...
>I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
> Standard or whatever comes with SBS Premium.
> I installed SQL as a named instance (SERVER\MSGPSBM) and also installed
> Reporting Services in this instance using the default config during the
> installation.
> When I try to connect to Reporting Services with SSMS on the local
> machine using Windows Authentication logged in as Administrator I get
> the following error:
> Cannot connect to SERVER\MSGPSBM
> Additional Information:
> Unable to connect to the remote server (System)
> No connection could be made because the target machine actively refused
> it (System)
> When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
> Error Unable to connect to the remote server. message
> I can log into the database engine just fine.
> What am I doing wrong?
> --
> Japheth Nolt
> Microsoft SBF Specialist
> Landis Computer
> www.landiscomputer.com
> 12/20/2007 10:45:44 AM|||All are green except:
Encryption Keys - Blue
Initialization - gray
Email Settings - yellow
Execution Account - yellow
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/24/2007 8:37:59 AM
Radoslaw Lebkowski wrote:
> Hello,
> When you use SQL Server Reporting Services Configuration Manager can
> you log to SSRS service?
> If so check which of the points are marked on red. All of them should
> be green or blue (if no active).
> This is the first step to recognize where is the problem.
> I suppose it could be a problem with accounts (Windows Services
> Account or IIS Application Pool Account)
> Best Regards,
> Radoslaw Lebkowski
>
>
> Uzytkownik "Japheth Nolt" <japheth.remove@.landiscomputer.com> napisal
> w wiadomosci news:xn0ff611k1lg3ln001@.msnews.microsoft.com...
> > I have SQL 2005 installed on SBS 2003 SP2. I think it's SQL Server
> > Standard or whatever comes with SBS Premium.
> >
> > I installed SQL as a named instance (SERVER\MSGPSBM) and also
> > installed Reporting Services in this instance using the default
> > config during the installation.
> >
> > When I try to connect to Reporting Services with SSMS on the local
> > machine using Windows Authentication logged in as Administrator I
> > get the following error:
> >
> > Cannot connect to SERVER\MSGPSBM
> > Additional Information:
> > Unable to connect to the remote server (System)
> > No connection could be made because the target machine actively
> > refused it (System)
> >
> > When I use IE to browse to http://server/reports$MSGPSBM I get a (X)
> > Error Unable to connect to the remote server. message
> >
> > I can log into the database engine just fine.
> >
> > What am I doing wrong?
> > -- Japheth Nolt
> > Microsoft SBF Specialist
> > Landis Computer
> > www.landiscomputer.com
> > 12/20/2007 10:45:44 AM|||I'm still learning.
My Report Server had been configured to use SSL. I turned that off and
now it works.
--
Japheth Nolt
Microsoft SBF Specialist
Landis Computer
www.landiscomputer.com
12/24/2007 9:17:34 AM
Japheth Nolt wrote:
> All are green except:
> Encryption Keys - Blue
> Initialization - gray
> Email Settings - yellow
> Execution Account - yellow

Error message SQL server

I have recently installed SQL server and keep getting this
error message. Error #-2147467256 (Description: connection
failure) (Source: Microsift OLE DB Provider for SQL Server)
(Module: basEH.bas)(Procedure:
General_EHProcessContinuousEVENTS)
Can anyone spread a bit of light on what to do?
Thanks,
MikeHi:
It does not seems that it is a error of SQL or OLEDB, I guest it is
caused by (Module: basEH.bas)(Procedure:
General_EHProcessContinuousEVENTS).
According the Error #-2147467256, I look up KB and get the article list
below.
http://support.microsoft.com/defaul...KB;en-us;270061
It says thet this error caused by
"The callee (server [not server application]) is not available and
disappeared; all connections are invalid. The call did not execute. "
So I suggest you check thw connect string and see if it work.
Best Wishes
Wei Ci Zhou