Showing posts with label install. Show all posts
Showing posts with label install. Show all posts

Monday, March 26, 2012

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:
> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
Q
Hi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:

> I install SQL Server 2005 Dev to my computer, when I try to run the Profiler,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK to
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Q

Error when running Profiler

I install SQL Server 2005 Dev to my computer, when I try to run the Profiler
,
I got the error message:
"The application failed to initialize properly (0xc0000005). Click on OK to
terminate the application."
How can I fix it so that I could run the Profiler on my machine?
Thanks in advance.
QHi
Error 0xc0000005 is usually an access violation. Does this occur for other
users? Can you run profiler on other machines?
John
"Q" wrote:

> I install SQL Server 2005 Dev to my computer, when I try to run the Profil
er,
> I got the error message:
> "The application failed to initialize properly (0xc0000005). Click on OK t
o
> terminate the application."
> How can I fix it so that I could run the Profiler on my machine?
> Thanks in advance.
> Qsql

error when rebooting

Hi,
I developp a C/S soft for a client with MSDE. I install it on its computer (Win2k) and it can not reboot.
list of errors :
error when calling Dllregisterserver in c:\ProgramFiles\CommonFiles\system\ADO\...
msado15.dll hresult 80070005
msador15.dll hresult 8002801C
msadrh15.dll hresult 80004005
msadomd.dll hresult 80020009
msadox.dll hresult 8002801C
msjro.dll hresult 80020009
(sorry it's french translation ;o))
There are no pb with my computer(and with all I test !!!) and I expect a pb of MDAC version (mine is 2.7 SP1 refresh).
Has somebody the same pb ?
JC
It does look like a problem with mdac. I suggest you update it.
http://microsoft.com/data
-oj
http://www.rac4sql.net
"jc" <jean-christophe.watelet@.hardis.fr> wrote in message
news:A1E4439A-A868-45D4-B665-A2ECBFAFF3A0@.microsoft.com...
> Hi,
> I developp a C/S soft for a client with MSDE. I install it on its computer
(Win2k) and it can not reboot.
> list of errors :
> error when calling Dllregisterserver in
c:\ProgramFiles\CommonFiles\system\ADO\...
> msado15.dll hresult 80070005
> msador15.dll hresult 8002801C
> msadrh15.dll hresult 80004005
> msadomd.dll hresult 80020009
> msadox.dll hresult 8002801C
> msjro.dll hresult 80020009
> (sorry it's french translation ;o))
> There are no pb with my computer(and with all I test !!!) and I expect a pb of
MDAC version (mine is 2.7 SP1 refresh).
> Has somebody the same pb ?
> JC
|||thanks...but...
I just have a phonecall with the informatic system manager.
It seems not to be a pb of MDAC version but a conflict with a Pocket PC and (for me) due to the install of MSDE, especially with the evolution of the MDAC. The local user settings are corrupt...not the local machine settings.
I suppose the MDAC 2.7 SP1 Refresh is not compatible with activesync 3.5...and I will look for known bugs on the web
Tch?
JC
|||Bonjour JC,
Like you I have just installed MSDE into Win2k and I get exactly the same error report as yourself at startup but with a different set of DLLs. msado15, msadox, mscidce, msadds, msdapfst, msdarem, msdfmap. I can get through the problem and login using my normal profile but problems like Windows Explorer not navigating correctly and locking up occur. Unlike you, I am no expert in this area, the machine is simply my own home setup.
Since you posted this problem, have you managed to learn anything more about a solution which may point me in the right direction?
Merci beaucoup,
AB

Friday, March 23, 2012

Error when installing SQL server 200 on SBS 2003 in Windows Small Business Server 2003

Hi,
I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own the SBS
2003 server Premium).
I installed the OS lately and made all the Microsoft update.
I am now trying to install the SQL 2000 server and get this error message:
(It is the english translation of what I get on my screen)
Error message: "A previous installation program created operation files
waiting for Installtion on your computer. You have to reboot it before
executing the installation."
Of course I rebooted my server, but nothing happened.
Any idea of what to do ?
Thank you for your help
Did you try installing again after the reboot? Was there an error code
listed?
From KB Article 257716:
Q. What should I do if the installation of SQL Server 2000 is unsuccessful?
A. If you have an unsuccessful installation, you can examine two files to
help determine what went wrong. The Sqlstp.log file, which is located in the
Windows directory, gives detailed information on what setup is doing and
contains all errors encountered during setup. Reviewing this file will give
you a better understanding of where setup fails and why.
During the configuration portion of setup, SQL Server setup runs an
application called Cnfgsvr.exe to configure the SQL Server. This application
starts SQL Server, connects to it, and then runs the initial installation
scripts. Any error encountered during this process is also written to the
Sqlstp.log file; however, you should also review the SQL Server error log,
named "Errorlog" with no file extension, located by default in the Program
Files\Microsoft SQL Server\Mssql\Log directory. This error log contains
errors that SQL Server encounters when setup attempts to start SQL Server,
which may provide further insight into the failure.
If you cannot determine the cause of the Setup failure, save the two files
just mentioned and call Microsoft Product Support Services (PSS) to speak to
a SQL Server Support Professional who will help you to resolve your problem.
Note that when the Setup application fails, it rolls back all changes to the
file system, which includes removing any copied files and changes that were
made to the registry.
HTH
Jerry
"Alambiki" <alambiki@.yahoo.com> wrote in message
news:dj5qnl$ok9$1@.reader1.imaginet.fr...
> Hi,
> I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own the
> SBS
> 2003 server Premium).
> I installed the OS lately and made all the Microsoft update.
> I am now trying to install the SQL 2000 server and get this error message:
> (It is the english translation of what I get on my screen)
> Error message: "A previous installation program created operation files
> waiting for Installtion on your computer. You have to reboot it before
> executing the installation."
> Of course I rebooted my server, but nothing happened.
> Any idea of what to do ?
> Thank you for your help
>
|||Yes I tried to reinstall after reboot.
I found the Sqlstp.log file, but am not able to understand it.
If someone has an idea...
"Jerry Spivey" <jspivey@.vestas-awt.com> a crit dans le message de news:
enXaUuM1FHA.1264@.tk2msftngp13.phx.gbl...
> Did you try installing again after the reboot? Was there an error code
> listed?
> From KB Article 257716:
> Q. What should I do if the installation of SQL Server 2000 is
> unsuccessful?
> A. If you have an unsuccessful installation, you can examine two files to
> help determine what went wrong. The Sqlstp.log file, which is located in
> the Windows directory, gives detailed information on what setup is doing
> and contains all errors encountered during setup. Reviewing this file will
> give you a better understanding of where setup fails and why.
> During the configuration portion of setup, SQL Server setup runs an
> application called Cnfgsvr.exe to configure the SQL Server. This
> application starts SQL Server, connects to it, and then runs the initial
> installation scripts. Any error encountered during this process is also
> written to the Sqlstp.log file; however, you should also review the SQL
> Server error log, named "Errorlog" with no file extension, located by
> default in the Program Files\Microsoft SQL Server\Mssql\Log directory.
> This error log contains errors that SQL Server encounters when setup
> attempts to start SQL Server, which may provide further insight into the
> failure.
> If you cannot determine the cause of the Setup failure, save the two files
> just mentioned and call Microsoft Product Support Services (PSS) to speak
> to a SQL Server Support Professional who will help you to resolve your
> problem. Note that when the Setup application fails, it rolls back all
> changes to the file system, which includes removing any copied files and
> changes that were made to the registry.
>
> HTH
> Jerry
> "Alambiki" <alambiki@.yahoo.com> wrote in message
> news:dj5qnl$ok9$1@.reader1.imaginet.fr...
>
|||What were the last few successful entries? Do you have an installation that
WAS successful that you can compare it to?
"aLAMBIKI" <alambiki@.yahoo.com> wrote in message
news:4356ae9a$0$4336$626a54ce@.news.free.fr...
> Yes I tried to reinstall after reboot.
> I found the Sqlstp.log file, but am not able to understand it.
> If someone has an idea...
> "Jerry Spivey" <jspivey@.vestas-awt.com> a crit dans le message de news:
> enXaUuM1FHA.1264@.tk2msftngp13.phx.gbl...
>
|||I already installed SBS + SQL on this server. It is the second time I
install it on this server. The only thing that changes is that I updated
with the latest ms update + installed symantec lifestate...
here is the log of SQLstp.log
19:00:30 Begin Setup
19:00:30 8.00.194
19:00:30 Mode = Normal
19:00:30 ModeType = NORMAL
19:00:30 GetDefinitionEx returned: 0, Extended: 0x0
19:00:30 ValueFTS returned: 1
19:00:30 ValuePID returned: 1
19:00:30 ValueLic returned: 1
19:00:30 System: Small Business Server
19:00:30 SQL Server ProductType: Standard Edition [0x2]
19:00:30 Begin Action: SetupInitialize
19:00:30 End Action SetupInitialize
19:00:30 Begin Action: SetupInstall
19:00:30 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
...
19:00:30 CommonFilesDir=C:\Program Files\Fichiers communs
19:00:30 Windows Directory=C:\WINDOWS\
19:00:30 Program Files=C:\Program Files\
19:00:30 TEMPDIR=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\
19:00:30 Begin Action: SetupInstall
19:00:30 Begin Action: CheckFixedRequirements
19:00:30 Platform ID: 0xf000
19:00:30 Version: 5.2.3790
19:00:30 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2523
19:00:31 End Action: CheckFixedRequirements
19:00:31 Begin Action: ShowDialogs
19:00:31 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
19:00:31 Begin Action ShowDialogsHlpr: 0x1
19:00:31 Begin Action: DialogShowSdWelcome
19:00:32 End Action DialogShowSdWelcome
19:00:32 Dialog 0x1 returned: 1
19:00:32 End Action ShowDialogsHlpr
19:00:32 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
19:00:32 Begin Action ShowDialogsHlpr: 0x2
19:00:32 Begin Action: DialogShowSdMachineName
19:01:07 ShowDlgMachine returned: -1
19:01:07 ShowDlgMachine: GetLastError returned: 0
19:01:07 Opration russie.
19:01:07 End Action DialogShowSdMachineName
19:01:07 End Action ShowDialogs
19:01:07 Action CleanUpInstall:
19:01:07 StatsGenerate returned: 2
19:01:07 StatsGenerate (0x0,0x0,0xf000,0x0,1036,0,0x0,0x0,0,0,0
19:01:07 StatsGenerate -1,)
19:01:07 Installation Failed.
"Jerry Spivey" <jspivey@.vestas-awt.com> a crit dans le message de news:
OdVtGSP1FHA.560@.TK2MSFTNGP12.phx.gbl...
> What were the last few successful entries? Do you have an installation
> that WAS successful that you can compare it to?
> "aLAMBIKI" <alambiki@.yahoo.com> wrote in message
> news:4356ae9a$0$4336$626a54ce@.news.free.fr...
>
|||I'm sure one of the MS guys will jump in here somewhere and give you more
than I can. Can you remove the Symantic product as a test?
HTH
Jerry
"aLAMBIKI" <alambiki@.yahoo.com> wrote in message
news:4356c190$1$4337$626a54ce@.news.free.fr...
>I already installed SBS + SQL on this server. It is the second time I
>install it on this server. The only thing that changes is that I updated
>with the latest ms update + installed symantec lifestate...
> here is the log of SQLstp.log
> 19:00:30 Begin Setup
> 19:00:30 8.00.194
> 19:00:30 Mode = Normal
> 19:00:30 ModeType = NORMAL
> 19:00:30 GetDefinitionEx returned: 0, Extended: 0x0
> 19:00:30 ValueFTS returned: 1
> 19:00:30 ValuePID returned: 1
> 19:00:30 ValueLic returned: 1
> 19:00:30 System: Small Business Server
> 19:00:30 SQL Server ProductType: Standard Edition [0x2]
> 19:00:30 Begin Action: SetupInitialize
> 19:00:30 End Action SetupInitialize
> 19:00:30 Begin Action: SetupInstall
> 19:00:30 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir
> ...
> 19:00:30 CommonFilesDir=C:\Program Files\Fichiers communs
> 19:00:30 Windows Directory=C:\WINDOWS\
> 19:00:30 Program Files=C:\Program Files\
> 19:00:30 TEMPDIR=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\
> 19:00:30 Begin Action: SetupInstall
> 19:00:30 Begin Action: CheckFixedRequirements
> 19:00:30 Platform ID: 0xf000
> 19:00:30 Version: 5.2.3790
> 19:00:30 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2523
> 19:00:31 End Action: CheckFixedRequirements
> 19:00:31 Begin Action: ShowDialogs
> 19:00:31 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
> 19:00:31 Begin Action ShowDialogsHlpr: 0x1
> 19:00:31 Begin Action: DialogShowSdWelcome
> 19:00:32 End Action DialogShowSdWelcome
> 19:00:32 Dialog 0x1 returned: 1
> 19:00:32 End Action ShowDialogsHlpr
> 19:00:32 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
> 19:00:32 Begin Action ShowDialogsHlpr: 0x2
> 19:00:32 Begin Action: DialogShowSdMachineName
> 19:01:07 ShowDlgMachine returned: -1
> 19:01:07 ShowDlgMachine: GetLastError returned: 0
> 19:01:07 Opration russie.
> 19:01:07 End Action DialogShowSdMachineName
> 19:01:07 End Action ShowDialogs
> 19:01:07 Action CleanUpInstall:
> 19:01:07 StatsGenerate returned: 2
> 19:01:07 StatsGenerate (0x0,0x0,0xf000,0x0,1036,0,0x0,0x0,0,0,0
> 19:01:07 StatsGenerate -1,)
> 19:01:07 Installation Failed.
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> a crit dans le message de news:
> OdVtGSP1FHA.560@.TK2MSFTNGP12.phx.gbl...
>

Error when installing SQL server 200 on SBS 2003 in Windows Small Business Server 2003

Hi,
I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own the SBS
2003 server Premium).
I installed the OS lately and made all the Microsoft update.
I am now trying to install the SQL 2000 server and get this error message:
(It is the english translation of what I get on my screen)
Error message: "A previous installation program created operation files
waiting for Installtion on your computer. You have to reboot it before
executing the installation."
Of course I rebooted my server, but nothing happened.
Any idea of what to do ?
Thank you for your helpDid you try installing again after the reboot? Was there an error code
listed?
From KB Article 257716:
Q. What should I do if the installation of SQL Server 2000 is unsuccessful?
A. If you have an unsuccessful installation, you can examine two files to
help determine what went wrong. The Sqlstp.log file, which is located in the
Windows directory, gives detailed information on what setup is doing and
contains all errors encountered during setup. Reviewing this file will give
you a better understanding of where setup fails and why.
During the configuration portion of setup, SQL Server setup runs an
application called Cnfgsvr.exe to configure the SQL Server. This application
starts SQL Server, connects to it, and then runs the initial installation
scripts. Any error encountered during this process is also written to the
Sqlstp.log file; however, you should also review the SQL Server error log,
named "Errorlog" with no file extension, located by default in the Program
Files\Microsoft SQL Server\Mssql\Log directory. This error log contains
errors that SQL Server encounters when setup attempts to start SQL Server,
which may provide further insight into the failure.
If you cannot determine the cause of the Setup failure, save the two files
just mentioned and call Microsoft Product Support Services (PSS) to speak to
a SQL Server Support Professional who will help you to resolve your problem.
Note that when the Setup application fails, it rolls back all changes to the
file system, which includes removing any copied files and changes that were
made to the registry.
HTH
Jerry
"Alambiki" <alambiki@.yahoo.com> wrote in message
news:dj5qnl$ok9$1@.reader1.imaginet.fr...
> Hi,
> I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own the
> SBS
> 2003 server Premium).
> I installed the OS lately and made all the Microsoft update.
> I am now trying to install the SQL 2000 server and get this error message:
> (It is the english translation of what I get on my screen)
> Error message: "A previous installation program created operation files
> waiting for Installtion on your computer. You have to reboot it before
> executing the installation."
> Of course I rebooted my server, but nothing happened.
> Any idea of what to do ?
> Thank you for your help
>|||Yes I tried to reinstall after reboot.
I found the Sqlstp.log file, but am not able to understand it.
If someone has an idea...
"Jerry Spivey" <jspivey@.vestas-awt.com> a crit dans le message de news:
enXaUuM1FHA.1264@.tk2msftngp13.phx.gbl...
> Did you try installing again after the reboot? Was there an error code
> listed?
> From KB Article 257716:
> Q. What should I do if the installation of SQL Server 2000 is
> unsuccessful?
> A. If you have an unsuccessful installation, you can examine two files to
> help determine what went wrong. The Sqlstp.log file, which is located in
> the Windows directory, gives detailed information on what setup is doing
> and contains all errors encountered during setup. Reviewing this file will
> give you a better understanding of where setup fails and why.
> During the configuration portion of setup, SQL Server setup runs an
> application called Cnfgsvr.exe to configure the SQL Server. This
> application starts SQL Server, connects to it, and then runs the initial
> installation scripts. Any error encountered during this process is also
> written to the Sqlstp.log file; however, you should also review the SQL
> Server error log, named "Errorlog" with no file extension, located by
> default in the Program Files\Microsoft SQL Server\Mssql\Log directory.
> This error log contains errors that SQL Server encounters when setup
> attempts to start SQL Server, which may provide further insight into the
> failure.
> If you cannot determine the cause of the Setup failure, save the two files
> just mentioned and call Microsoft Product Support Services (PSS) to speak
> to a SQL Server Support Professional who will help you to resolve your
> problem. Note that when the Setup application fails, it rolls back all
> changes to the file system, which includes removing any copied files and
> changes that were made to the registry.
>
> HTH
> Jerry
> "Alambiki" <alambiki@.yahoo.com> wrote in message
> news:dj5qnl$ok9$1@.reader1.imaginet.fr...
>|||What were the last few successful entries? Do you have an installation that
WAS successful that you can compare it to?
"aLAMBIKI" <alambiki@.yahoo.com> wrote in message
news:4356ae9a$0$4336$626a54ce@.news.free.fr...
> Yes I tried to reinstall after reboot.
> I found the Sqlstp.log file, but am not able to understand it.
> If someone has an idea...
> "Jerry Spivey" <jspivey@.vestas-awt.com> a crit dans le message de news:
> enXaUuM1FHA.1264@.tk2msftngp13.phx.gbl...
>|||I already installed SBS + SQL on this server. It is the second time I
install it on this server. The only thing that changes is that I updated
with the latest ms update + installed symantec lifestate...
here is the log of SQLstp.log
19:00:30 Begin Setup
19:00:30 8.00.194
19:00:30 Mode = Normal
19:00:30 ModeType = NORMAL
19:00:30 GetDefinitionEx returned: 0, Extended: 0x0
19:00:30 ValueFTS returned: 1
19:00:30 ValuePID returned: 1
19:00:30 ValueLic returned: 1
19:00:30 System: Small Business Server
19:00:30 SQL Server ProductType: Standard Edition [0x2]
19:00:30 Begin Action: SetupInitialize
19:00:30 End Action SetupInitialize
19:00:30 Begin Action: SetupInstall
19:00:30 Reading Software\Microsoft\Windows\CurrentVersio
n\CommonFilesDir
...
19:00:30 CommonFilesDir=C:\Program Files\Fichiers communs
19:00:30 Windows Directory=C:\WINDOWS\
19:00:30 Program Files=C:\Program Files\
19:00:30 TEMPDIR=C:\DOCUME~1\ADMINI~1\LOCALS~1\Te
mp\1\
19:00:30 Begin Action: SetupInstall
19:00:30 Begin Action: CheckFixedRequirements
19:00:30 Platform ID: 0xf000
19:00:30 Version: 5.2.3790
19:00:30 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2523
19:00:31 End Action: CheckFixedRequirements
19:00:31 Begin Action: ShowDialogs
19:00:31 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
19:00:31 Begin Action ShowDialogsHlpr: 0x1
19:00:31 Begin Action: DialogShowSdWelcome
19:00:32 End Action DialogShowSdWelcome
19:00:32 Dialog 0x1 returned: 1
19:00:32 End Action ShowDialogsHlpr
19:00:32 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
19:00:32 Begin Action ShowDialogsHlpr: 0x2
19:00:32 Begin Action: DialogShowSdMachineName
19:01:07 ShowDlgMachine returned: -1
19:01:07 ShowDlgMachine: GetLastError returned: 0
19:01:07 Opration russie.
19:01:07 End Action DialogShowSdMachineName
19:01:07 End Action ShowDialogs
19:01:07 Action CleanUpInstall:
19:01:07 StatsGenerate returned: 2
19:01:07 StatsGenerate (0x0,0x0,0xf000,0x0,1036,0,0x0,0x0,0,0,0
19:01:07 StatsGenerate -1,)
19:01:07 Installation Failed.
"Jerry Spivey" <jspivey@.vestas-awt.com> a crit dans le message de news:
OdVtGSP1FHA.560@.TK2MSFTNGP12.phx.gbl...
> What were the last few successful entries? Do you have an installation
> that WAS successful that you can compare it to?
> "aLAMBIKI" <alambiki@.yahoo.com> wrote in message
> news:4356ae9a$0$4336$626a54ce@.news.free.fr...
>|||I'm sure one of the MS guys will jump in here somewhere and give you more
than I can. Can you remove the Symantic product as a test?
HTH
Jerry
"aLAMBIKI" <alambiki@.yahoo.com> wrote in message
news:4356c190$1$4337$626a54ce@.news.free.fr...
>I already installed SBS + SQL on this server. It is the second time I
>install it on this server. The only thing that changes is that I updated
>with the latest ms update + installed symantec lifestate...
> here is the log of SQLstp.log
> 19:00:30 Begin Setup
> 19:00:30 8.00.194
> 19:00:30 Mode = Normal
> 19:00:30 ModeType = NORMAL
> 19:00:30 GetDefinitionEx returned: 0, Extended: 0x0
> 19:00:30 ValueFTS returned: 1
> 19:00:30 ValuePID returned: 1
> 19:00:30 ValueLic returned: 1
> 19:00:30 System: Small Business Server
> 19:00:30 SQL Server ProductType: Standard Edition [0x2]
> 19:00:30 Begin Action: SetupInitialize
> 19:00:30 End Action SetupInitialize
> 19:00:30 Begin Action: SetupInstall
> 19:00:30 Reading Software\Microsoft\Windows\CurrentVersio
n\CommonFilesDir
> ...
> 19:00:30 CommonFilesDir=C:\Program Files\Fichiers communs
> 19:00:30 Windows Directory=C:\WINDOWS\
> 19:00:30 Program Files=C:\Program Files\
> 19:00:30 TEMPDIR=C:\DOCUME~1\ADMINI~1\LOCALS~1\Te
mp\1\
> 19:00:30 Begin Action: SetupInstall
> 19:00:30 Begin Action: CheckFixedRequirements
> 19:00:30 Platform ID: 0xf000
> 19:00:30 Version: 5.2.3790
> 19:00:30 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2523
> 19:00:31 End Action: CheckFixedRequirements
> 19:00:31 Begin Action: ShowDialogs
> 19:00:31 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
> 19:00:31 Begin Action ShowDialogsHlpr: 0x1
> 19:00:31 Begin Action: DialogShowSdWelcome
> 19:00:32 End Action DialogShowSdWelcome
> 19:00:32 Dialog 0x1 returned: 1
> 19:00:32 End Action ShowDialogsHlpr
> 19:00:32 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
> 19:00:32 Begin Action ShowDialogsHlpr: 0x2
> 19:00:32 Begin Action: DialogShowSdMachineName
> 19:01:07 ShowDlgMachine returned: -1
> 19:01:07 ShowDlgMachine: GetLastError returned: 0
> 19:01:07 Opration russie.
> 19:01:07 End Action DialogShowSdMachineName
> 19:01:07 End Action ShowDialogs
> 19:01:07 Action CleanUpInstall:
> 19:01:07 StatsGenerate returned: 2
> 19:01:07 StatsGenerate (0x0,0x0,0xf000,0x0,1036,0,0x0,0x0,0,0,0
> 19:01:07 StatsGenerate -1,)
> 19:01:07 Installation Failed.
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> a crit dans le message de news:
> OdVtGSP1FHA.560@.TK2MSFTNGP12.phx.gbl...
>

Error when installing SQL server 200 on SBS 2003 in Windows Small Business Server 2003

Hi,
I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own the SBS
2003 server Premium).
I installed the OS lately and made all the Microsoft update.
I am now trying to install the SQL 2000 server and get this error message:
(It is the english translation of what I get on my screen)
Error message: "A previous installation program created operation files
waiting for Installtion on your computer. You have to reboot it before
executing the installation."
Of course I rebooted my server, but nothing happened.
Any idea of what to do ?
Thank you for your helpDid you try installing again after the reboot? Was there an error code
listed?
From KB Article 257716:
Q. What should I do if the installation of SQL Server 2000 is unsuccessful?
A. If you have an unsuccessful installation, you can examine two files to
help determine what went wrong. The Sqlstp.log file, which is located in the
Windows directory, gives detailed information on what setup is doing and
contains all errors encountered during setup. Reviewing this file will give
you a better understanding of where setup fails and why.
During the configuration portion of setup, SQL Server setup runs an
application called Cnfgsvr.exe to configure the SQL Server. This application
starts SQL Server, connects to it, and then runs the initial installation
scripts. Any error encountered during this process is also written to the
Sqlstp.log file; however, you should also review the SQL Server error log,
named "Errorlog" with no file extension, located by default in the Program
Files\Microsoft SQL Server\Mssql\Log directory. This error log contains
errors that SQL Server encounters when setup attempts to start SQL Server,
which may provide further insight into the failure.
If you cannot determine the cause of the Setup failure, save the two files
just mentioned and call Microsoft Product Support Services (PSS) to speak to
a SQL Server Support Professional who will help you to resolve your problem.
Note that when the Setup application fails, it rolls back all changes to the
file system, which includes removing any copied files and changes that were
made to the registry.
HTH
Jerry
"Alambiki" <alambiki@.yahoo.com> wrote in message
news:dj5qnl$ok9$1@.reader1.imaginet.fr...
> Hi,
> I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own the
> SBS
> 2003 server Premium).
> I installed the OS lately and made all the Microsoft update.
> I am now trying to install the SQL 2000 server and get this error message:
> (It is the english translation of what I get on my screen)
> Error message: "A previous installation program created operation files
> waiting for Installtion on your computer. You have to reboot it before
> executing the installation."
> Of course I rebooted my server, but nothing happened.
> Any idea of what to do ?
> Thank you for your help
>|||Yes I tried to reinstall after reboot.
I found the Sqlstp.log file, but am not able to understand it.
If someone has an idea...
"Jerry Spivey" <jspivey@.vestas-awt.com> a écrit dans le message de news:
enXaUuM1FHA.1264@.tk2msftngp13.phx.gbl...
> Did you try installing again after the reboot? Was there an error code
> listed?
> From KB Article 257716:
> Q. What should I do if the installation of SQL Server 2000 is
> unsuccessful?
> A. If you have an unsuccessful installation, you can examine two files to
> help determine what went wrong. The Sqlstp.log file, which is located in
> the Windows directory, gives detailed information on what setup is doing
> and contains all errors encountered during setup. Reviewing this file will
> give you a better understanding of where setup fails and why.
> During the configuration portion of setup, SQL Server setup runs an
> application called Cnfgsvr.exe to configure the SQL Server. This
> application starts SQL Server, connects to it, and then runs the initial
> installation scripts. Any error encountered during this process is also
> written to the Sqlstp.log file; however, you should also review the SQL
> Server error log, named "Errorlog" with no file extension, located by
> default in the Program Files\Microsoft SQL Server\Mssql\Log directory.
> This error log contains errors that SQL Server encounters when setup
> attempts to start SQL Server, which may provide further insight into the
> failure.
> If you cannot determine the cause of the Setup failure, save the two files
> just mentioned and call Microsoft Product Support Services (PSS) to speak
> to a SQL Server Support Professional who will help you to resolve your
> problem. Note that when the Setup application fails, it rolls back all
> changes to the file system, which includes removing any copied files and
> changes that were made to the registry.
>
> HTH
> Jerry
> "Alambiki" <alambiki@.yahoo.com> wrote in message
> news:dj5qnl$ok9$1@.reader1.imaginet.fr...
>> Hi,
>> I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own the
>> SBS
>> 2003 server Premium).
>> I installed the OS lately and made all the Microsoft update.
>> I am now trying to install the SQL 2000 server and get this error
>> message:
>> (It is the english translation of what I get on my screen)
>> Error message: "A previous installation program created operation files
>> waiting for Installtion on your computer. You have to reboot it before
>> executing the installation."
>> Of course I rebooted my server, but nothing happened.
>> Any idea of what to do ?
>> Thank you for your help
>|||What were the last few successful entries? Do you have an installation that
WAS successful that you can compare it to?
"aLAMBIKI" <alambiki@.yahoo.com> wrote in message
news:4356ae9a$0$4336$626a54ce@.news.free.fr...
> Yes I tried to reinstall after reboot.
> I found the Sqlstp.log file, but am not able to understand it.
> If someone has an idea...
> "Jerry Spivey" <jspivey@.vestas-awt.com> a écrit dans le message de news:
> enXaUuM1FHA.1264@.tk2msftngp13.phx.gbl...
>> Did you try installing again after the reboot? Was there an error code
>> listed?
>> From KB Article 257716:
>> Q. What should I do if the installation of SQL Server 2000 is
>> unsuccessful?
>> A. If you have an unsuccessful installation, you can examine two files to
>> help determine what went wrong. The Sqlstp.log file, which is located in
>> the Windows directory, gives detailed information on what setup is doing
>> and contains all errors encountered during setup. Reviewing this file
>> will give you a better understanding of where setup fails and why.
>> During the configuration portion of setup, SQL Server setup runs an
>> application called Cnfgsvr.exe to configure the SQL Server. This
>> application starts SQL Server, connects to it, and then runs the initial
>> installation scripts. Any error encountered during this process is also
>> written to the Sqlstp.log file; however, you should also review the SQL
>> Server error log, named "Errorlog" with no file extension, located by
>> default in the Program Files\Microsoft SQL Server\Mssql\Log directory.
>> This error log contains errors that SQL Server encounters when setup
>> attempts to start SQL Server, which may provide further insight into the
>> failure.
>> If you cannot determine the cause of the Setup failure, save the two
>> files just mentioned and call Microsoft Product Support Services (PSS) to
>> speak to a SQL Server Support Professional who will help you to resolve
>> your problem. Note that when the Setup application fails, it rolls back
>> all changes to the file system, which includes removing any copied files
>> and changes that were made to the registry.
>>
>> HTH
>> Jerry
>> "Alambiki" <alambiki@.yahoo.com> wrote in message
>> news:dj5qnl$ok9$1@.reader1.imaginet.fr...
>> Hi,
>> I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own the
>> SBS
>> 2003 server Premium).
>> I installed the OS lately and made all the Microsoft update.
>> I am now trying to install the SQL 2000 server and get this error
>> message:
>> (It is the english translation of what I get on my screen)
>> Error message: "A previous installation program created operation files
>> waiting for Installtion on your computer. You have to reboot it before
>> executing the installation."
>> Of course I rebooted my server, but nothing happened.
>> Any idea of what to do ?
>> Thank you for your help
>>
>|||I already installed SBS + SQL on this server. It is the second time I
install it on this server. The only thing that changes is that I updated
with the latest ms update + installed symantec lifestate...
here is the log of SQLstp.log
19:00:30 Begin Setup
19:00:30 8.00.194
19:00:30 Mode = Normal
19:00:30 ModeType = NORMAL
19:00:30 GetDefinitionEx returned: 0, Extended: 0x0
19:00:30 ValueFTS returned: 1
19:00:30 ValuePID returned: 1
19:00:30 ValueLic returned: 1
19:00:30 System: Small Business Server
19:00:30 SQL Server ProductType: Standard Edition [0x2]
19:00:30 Begin Action: SetupInitialize
19:00:30 End Action SetupInitialize
19:00:30 Begin Action: SetupInstall
19:00:30 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir
...
19:00:30 CommonFilesDir=C:\Program Files\Fichiers communs
19:00:30 Windows Directory=C:\WINDOWS\
19:00:30 Program Files=C:\Program Files\
19:00:30 TEMPDIR=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\
19:00:30 Begin Action: SetupInstall
19:00:30 Begin Action: CheckFixedRequirements
19:00:30 Platform ID: 0xf000
19:00:30 Version: 5.2.3790
19:00:30 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2523
19:00:31 End Action: CheckFixedRequirements
19:00:31 Begin Action: ShowDialogs
19:00:31 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
19:00:31 Begin Action ShowDialogsHlpr: 0x1
19:00:31 Begin Action: DialogShowSdWelcome
19:00:32 End Action DialogShowSdWelcome
19:00:32 Dialog 0x1 returned: 1
19:00:32 End Action ShowDialogsHlpr
19:00:32 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
19:00:32 Begin Action ShowDialogsHlpr: 0x2
19:00:32 Begin Action: DialogShowSdMachineName
19:01:07 ShowDlgMachine returned: -1
19:01:07 ShowDlgMachine: GetLastError returned: 0
19:01:07 Opération réussie.
19:01:07 End Action DialogShowSdMachineName
19:01:07 End Action ShowDialogs
19:01:07 Action CleanUpInstall:
19:01:07 StatsGenerate returned: 2
19:01:07 StatsGenerate (0x0,0x0,0xf000,0x0,1036,0,0x0,0x0,0,0,0
19:01:07 StatsGenerate -1,)
19:01:07 Installation Failed.
"Jerry Spivey" <jspivey@.vestas-awt.com> a écrit dans le message de news:
OdVtGSP1FHA.560@.TK2MSFTNGP12.phx.gbl...
> What were the last few successful entries? Do you have an installation
> that WAS successful that you can compare it to?
> "aLAMBIKI" <alambiki@.yahoo.com> wrote in message
> news:4356ae9a$0$4336$626a54ce@.news.free.fr...
>> Yes I tried to reinstall after reboot.
>> I found the Sqlstp.log file, but am not able to understand it.
>> If someone has an idea...
>> "Jerry Spivey" <jspivey@.vestas-awt.com> a écrit dans le message de news:
>> enXaUuM1FHA.1264@.tk2msftngp13.phx.gbl...
>> Did you try installing again after the reboot? Was there an error code
>> listed?
>> From KB Article 257716:
>> Q. What should I do if the installation of SQL Server 2000 is
>> unsuccessful?
>> A. If you have an unsuccessful installation, you can examine two files
>> to help determine what went wrong. The Sqlstp.log file, which is located
>> in the Windows directory, gives detailed information on what setup is
>> doing and contains all errors encountered during setup. Reviewing this
>> file will give you a better understanding of where setup fails and why.
>> During the configuration portion of setup, SQL Server setup runs an
>> application called Cnfgsvr.exe to configure the SQL Server. This
>> application starts SQL Server, connects to it, and then runs the initial
>> installation scripts. Any error encountered during this process is also
>> written to the Sqlstp.log file; however, you should also review the SQL
>> Server error log, named "Errorlog" with no file extension, located by
>> default in the Program Files\Microsoft SQL Server\Mssql\Log directory.
>> This error log contains errors that SQL Server encounters when setup
>> attempts to start SQL Server, which may provide further insight into the
>> failure.
>> If you cannot determine the cause of the Setup failure, save the two
>> files just mentioned and call Microsoft Product Support Services (PSS)
>> to speak to a SQL Server Support Professional who will help you to
>> resolve your problem. Note that when the Setup application fails, it
>> rolls back all changes to the file system, which includes removing any
>> copied files and changes that were made to the registry.
>>
>> HTH
>> Jerry
>> "Alambiki" <alambiki@.yahoo.com> wrote in message
>> news:dj5qnl$ok9$1@.reader1.imaginet.fr...
>> Hi,
>> I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own the
>> SBS
>> 2003 server Premium).
>> I installed the OS lately and made all the Microsoft update.
>> I am now trying to install the SQL 2000 server and get this error
>> message:
>> (It is the english translation of what I get on my screen)
>> Error message: "A previous installation program created operation files
>> waiting for Installtion on your computer. You have to reboot it before
>> executing the installation."
>> Of course I rebooted my server, but nothing happened.
>> Any idea of what to do ?
>> Thank you for your help
>>
>>
>|||I'm sure one of the MS guys will jump in here somewhere and give you more
than I can. Can you remove the Symantic product as a test?
HTH
Jerry
"aLAMBIKI" <alambiki@.yahoo.com> wrote in message
news:4356c190$1$4337$626a54ce@.news.free.fr...
>I already installed SBS + SQL on this server. It is the second time I
>install it on this server. The only thing that changes is that I updated
>with the latest ms update + installed symantec lifestate...
> here is the log of SQLstp.log
> 19:00:30 Begin Setup
> 19:00:30 8.00.194
> 19:00:30 Mode = Normal
> 19:00:30 ModeType = NORMAL
> 19:00:30 GetDefinitionEx returned: 0, Extended: 0x0
> 19:00:30 ValueFTS returned: 1
> 19:00:30 ValuePID returned: 1
> 19:00:30 ValueLic returned: 1
> 19:00:30 System: Small Business Server
> 19:00:30 SQL Server ProductType: Standard Edition [0x2]
> 19:00:30 Begin Action: SetupInitialize
> 19:00:30 End Action SetupInitialize
> 19:00:30 Begin Action: SetupInstall
> 19:00:30 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir
> ...
> 19:00:30 CommonFilesDir=C:\Program Files\Fichiers communs
> 19:00:30 Windows Directory=C:\WINDOWS\
> 19:00:30 Program Files=C:\Program Files\
> 19:00:30 TEMPDIR=C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\1\
> 19:00:30 Begin Action: SetupInstall
> 19:00:30 Begin Action: CheckFixedRequirements
> 19:00:30 Platform ID: 0xf000
> 19:00:30 Version: 5.2.3790
> 19:00:30 File Version - C:\WINDOWS\system32\shdocvw.dll: 6.0.3790.2523
> 19:00:31 End Action: CheckFixedRequirements
> 19:00:31 Begin Action: ShowDialogs
> 19:00:31 Initial Dialog Mask: 0x183000f7, Disable Back=0x1
> 19:00:31 Begin Action ShowDialogsHlpr: 0x1
> 19:00:31 Begin Action: DialogShowSdWelcome
> 19:00:32 End Action DialogShowSdWelcome
> 19:00:32 Dialog 0x1 returned: 1
> 19:00:32 End Action ShowDialogsHlpr
> 19:00:32 ShowDialogsGetDialog returned: nCurrent=0x2,index=1
> 19:00:32 Begin Action ShowDialogsHlpr: 0x2
> 19:00:32 Begin Action: DialogShowSdMachineName
> 19:01:07 ShowDlgMachine returned: -1
> 19:01:07 ShowDlgMachine: GetLastError returned: 0
> 19:01:07 Opération réussie.
> 19:01:07 End Action DialogShowSdMachineName
> 19:01:07 End Action ShowDialogs
> 19:01:07 Action CleanUpInstall:
> 19:01:07 StatsGenerate returned: 2
> 19:01:07 StatsGenerate (0x0,0x0,0xf000,0x0,1036,0,0x0,0x0,0,0,0
> 19:01:07 StatsGenerate -1,)
> 19:01:07 Installation Failed.
>
> "Jerry Spivey" <jspivey@.vestas-awt.com> a écrit dans le message de news:
> OdVtGSP1FHA.560@.TK2MSFTNGP12.phx.gbl...
>> What were the last few successful entries? Do you have an installation
>> that WAS successful that you can compare it to?
>> "aLAMBIKI" <alambiki@.yahoo.com> wrote in message
>> news:4356ae9a$0$4336$626a54ce@.news.free.fr...
>> Yes I tried to reinstall after reboot.
>> I found the Sqlstp.log file, but am not able to understand it.
>> If someone has an idea...
>> "Jerry Spivey" <jspivey@.vestas-awt.com> a écrit dans le message de news:
>> enXaUuM1FHA.1264@.tk2msftngp13.phx.gbl...
>> Did you try installing again after the reboot? Was there an error code
>> listed?
>> From KB Article 257716:
>> Q. What should I do if the installation of SQL Server 2000 is
>> unsuccessful?
>> A. If you have an unsuccessful installation, you can examine two files
>> to help determine what went wrong. The Sqlstp.log file, which is
>> located in the Windows directory, gives detailed information on what
>> setup is doing and contains all errors encountered during setup.
>> Reviewing this file will give you a better understanding of where setup
>> fails and why.
>> During the configuration portion of setup, SQL Server setup runs an
>> application called Cnfgsvr.exe to configure the SQL Server. This
>> application starts SQL Server, connects to it, and then runs the
>> initial installation scripts. Any error encountered during this process
>> is also written to the Sqlstp.log file; however, you should also review
>> the SQL Server error log, named "Errorlog" with no file extension,
>> located by default in the Program Files\Microsoft SQL Server\Mssql\Log
>> directory. This error log contains errors that SQL Server encounters
>> when setup attempts to start SQL Server, which may provide further
>> insight into the failure.
>> If you cannot determine the cause of the Setup failure, save the two
>> files just mentioned and call Microsoft Product Support Services (PSS)
>> to speak to a SQL Server Support Professional who will help you to
>> resolve your problem. Note that when the Setup application fails, it
>> rolls back all changes to the file system, which includes removing any
>> copied files and changes that were made to the registry.
>>
>> HTH
>> Jerry
>> "Alambiki" <alambiki@.yahoo.com> wrote in message
>> news:dj5qnl$ok9$1@.reader1.imaginet.fr...
>> Hi,
>> I am trying to install SQL 2000 sevrer on my SBS 2003 server (I own
>> the SBS
>> 2003 server Premium).
>> I installed the OS lately and made all the Microsoft update.
>> I am now trying to install the SQL 2000 server and get this error
>> message:
>> (It is the english translation of what I get on my screen)
>> Error message: "A previous installation program created operation
>> files
>> waiting for Installtion on your computer. You have to reboot it before
>> executing the installation."
>> Of course I rebooted my server, but nothing happened.
>> Any idea of what to do ?
>> Thank you for your help
>>
>>
>>
>sql

Error when installing

Iv'e searched other forums and websites for this, but I cant solve it.

When I try to install SQL 2000 I get an error about Low Registry Quota.

Any idea on how to solve this?

Doing a quick search, I found this suggestion which helped a few people fix this problem. Can you check if this might be your problem?

Thanks,
Sam

<snip>

I have never ever had the following error message before during the
installation of SQL Server Developer Edition 2000 on a client running
Windows XP Pro SP2 using an account with administrator privileges:
"An error occurred while creating one or more registry entries. Please see
C:\Windows\sqlstp.log for details. The problem could be caused by a low
registry quota condition."

Looking on the internet I have only found several people who had the same
problem but nobody gave a solution. What I have done to find the cause for
this problem was to run the Registry Monitor tool which can be found on
sysinternals.com to monitor what was causing this "Registry error".

I saw that I got several access denies to the following registry key:
HKEY_CLASSES_ROOT\.col

In RegEdit I noticed that the permissions for this key were set to
read-only. I have changed this for the Administrator to full-control and the
installation of SQL Server worked fine.

</snip>

|||Yeah, Iv'e tried that one already. Ill try it again. Thanks :)|||Didnt work :'(

Error when installing

i'm trying to install MS server 2000 components and I continuously get the same error. "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup." I've rebooted 100 times, turned the machine on and off, installed other programs, etc. and stil I get the error ONLY when I try to install the components.

Please Help!!!!

Thanks.

Moved to the setup group for a better chance of a response.|||

try...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q290/9/91.asp&NoWebContent=1

|||

Hi, this should help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312995

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

sql

Error when installing

i'm trying to install MS server 2000 components and I continuously get the same error. "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup." I've rebooted 100 times, turned the machine on and off, installed other programs, etc. and stil I get the error ONLY when I try to install the components.

Please Help!!!!

Thanks.

Moved to the setup group for a better chance of a response.|||

try...

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q290/9/91.asp&NoWebContent=1

|||

Hi, this should help:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312995

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Thursday, March 22, 2012

ERROR WHEN I TRY TO EDIT A SCRIPT TASK

Today, I must to re-install VS2005 and SQL Server 2005 desktop tools in my computer, because I install SQL Server 2005 SP2 desktop tool for an special features that I need.

This caused that the edition of the Script Task gives to me the following error:

Cannot show the editor for this task

Additional information:

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa.DT)

After the reinstalación, the error continues appearing, and I do not know that to do so that it works fine again.

Can any help me with this?

Thanks.

Alejandro

Are you on Vista?

http://blogs.msdn.com/mattm/archive/2007/03/09/sp2-vista-and-script-tasks.aspx|||No. I′m in XP SP2|||

Take a look at this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1270413&SiteID=1

sql

Wednesday, March 21, 2012

Error when I try to add Output Column in in Data Conversion

Here is what I get. Is this an install problem or is this how this software works?

===================================

Error at Data Flow Task [Data Conversion [720]]: An output cannot be added to the outputs collection.

(Microsoft Visual Studio)

===================================

Exception from HRESULT: 0xC020800F (Microsoft.SqlServer.DTSPipelineWrap)

Program Location:

at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.InsertOutput(DTSInsertPlacement eInsertPlacement, Int32 lOutputID)
at Microsoft.DataTransformationServices.Design.Controls.ComponentMetaDataTreeView.AddOutput()

What did you do to cause the error?

-Jamie

|||When in a package I added a data flow object then drilled into to add data source etc.

One of the items in the tool bar is Data Conversion. I whent to Advance edit on DataConversion on the last tab there was a button to "Add Output"

The result was the error above|||

PeterFreeb wrote:

When in a package I added a data flow object then drilled into to add data source etc.

One of the items in the tool bar is Data Conversion. I whent to Advance edit on DataConversion on the last tab there was a button to "Add Output"

The result was the error above

This is completely correct. it is not possible to add an output to the Data Conversion component. It only has one output and that exists as soon as you drag it onto the design surface.

What exactly are you attempting to do?

-Jamie

|||I have a unicode field in SQL and am trying to go non unicode or VARCHAR2 in Oracle.|||

PeterFreeb wrote:

I have a unicode field in SQL and am trying to go non unicode or VARCHAR2 in Oracle.

OK, well you have no need to go anywhere near the Advanced Editor. Just open the component up by double-clicking on it and add your data conversion in the GUI.

-Jamie

|||OK thanks I have a more involved question for Jamie or whoever knows...

I need to do an update or insert - I could do this easyly in SQL am not sure how to accomplish this in SSIS.

1. Check if the record is in the destination
2. If true -> Update
3. Else ->Insert|||

PeterFreeb wrote:

OK thanks I have a more involved question for Jamie or whoever knows...

I need to do an update or insert - I could do this easyly in SQL am not sure how to accomplish this in SSIS.

1. Check if the record is in the destination
2. If true -> Update
3. Else ->Insert

All documented here Peter:

Checking if a row exists and if it does, has it changed?
(http://blogs.conchango.com/jamiethomson/archive/2006/09/12/SSIS_3A00_-Checking-if-a-row-exists-and-if-it-does_2C00_-has-it-changed.aspx)

-Jamie

Monday, March 12, 2012

error when connect to sqlserver from another machine

hi ..

i install sqlserver and make app with vb6 using ADO to connect to the database and successfully

i put that application on another pc on the network
when i open it it says "can't login computername\guest" ?!!

any help

thanks in advance.any answers|||Are both of your pcs on a domain or a workgroup? If it's not domain, you need to create a same account/password pair on both machines and use that account to login.|||thanks

Xinwei Hong for reply

the two machines on a workgroup so .. could you explain pcs under domain in few lines ?
now i will create two users on the two machines and tell you later

thanks in advance.
|||By "pcs under domain", I mean whether your PC is under a domain which is usually used in median/large company. In this case, domain controller will help you do a lot of things.|||thanks for reply

you says i can do a lot of things if i'm under domain like what ?and what is the domain controler ? could you explain ?

and if you have short time i can talk to you in messanger it will be kind from you

thanks|||i make 2 users with same name but ..
the same problem occurs ?|||It's hard to describe "domain controller" and related stuff in short words. I recommend you find some documents related to Windows Networks to read.

Are you sure your client is running under the user account you created and you used that account to login to the server? It means you may need to login the client Windows system and run your client app under that account. If you user Administrator or even logon the computer without a user/password, it won't work.|||is this means that i need a password for administrator user to login to the database server ?|||Not necessary. SQL server runs as a service under various account(e.g. network service, local system, administrator account, etc.).

Error when browsing data

Hi Guys,
I am novice to AS. I install the Analysis Services to my Windows 2000 Professional. But in the places where to display or browsing data, it always encounters an Unspecific Error. For example:
a) In a cube - HR, if i select Browsing Data menu, the error 'Unspecific Error' displayed.
b) In a Dimensions, select Brows Dimensions Data, the error message in the windows said: Unable to brows the Dimension '*******', Unspecific Error.

Please help me to fix this problem
Thanks
PatrickMore info.:
The error happens at first time on clicking the data tab, the error message said:
'Provider cannot be found. It may not be properly installed'
I am not sure which Provider should i install?
Thanks|||Bug Fixed by installing the SQL Service SP

Sunday, March 11, 2012

Error when attempting to upgrade MSDE to Express using command line /UPGRADE

When attemping to install SQL 2005 Express using the following command line arguments

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE

or

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD

the following error occurs.

Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

The following version and editions have been verified.

1. .NET 2.0 installed

2. Windows XP SP2

3. MSDE 8.00.2039(SP4)

4. all MSDE databases are owned by sa

5. Instance and SQLAgent running under user that is member of Administrators

What are the possible reasons this error is occurring?

Hi gafrank,

Did you ever resolve this issue?

Mike

|||Yes. Thank you.

Error when attempting to upgrade MSDE to Express using command line /UPGRADE

When attemping to install SQL 2005 Express using the following command line arguments

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE

or

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD

the following error occurs.

Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

The following version and editions have been verified.

1. .NET 2.0 installed

2. Windows XP SP2

3. MSDE 8.00.2039(SP4)

4. all MSDE databases are owned by sa

5. Instance and SQLAgent running under user that is member of Administrators

What are the possible reasons this error is occurring?

Hi gafrank,

Did you ever resolve this issue?

Mike

|||Yes. Thank you.

Friday, March 9, 2012

Error When Attaching Database

Hello Everyone,

I am very new to SQL and just completed an install of SQL 2005 Express. After install, I downloaded the Adventure Works database and attempted to attach through both the Object Browser (right-click 'Databases'>'Attach') and by running the script that is located on the SQL download page where I got the Adventure Works db.

Here's the error that I get:

"Could not find row in sysindexes for database ID 8, object ID 1, Index ID 1. Run DBCC CHECKTABLE on sysindexes."

I have attempted to go through the help files, but unfortunately the above message is too cryptic for me and I have no idea what it's telling me.

Can someone help?

Thanks!!

YOu can either use the attach method OR create the database with the scripts. There is no need to execute both, as they will end up both with a working Adventureworks database. I always prefer to execute the script as I am able to have a hand on the scripts first :-)

HTH, Jens K. Suessmeyer.

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

Thank you for the help, Jens.

For what it's worth, I mentioned in my post that I tried both methods of attaching the database because neither of them worked. However, I have discovered why they didn't work:

When I went the Visual Studio page earlier this evening, I chose to install the SQL Server Express Tools thinking that this would give me the total installation including the SQL database engine. Apparently I was wrong. When choosing this option, what I got was the Management Studio and the Business Intelligence Development Studio. I was further led into thinking that I had everything I needed because I currently have the trial edition of SQL Server 2000 Enterprise Edition installed (the books I use in my SQL class are written in ANSI 92 so we only use 2000)...i'm sure you can imagine what happened after opening Management Studio for the first time - I get a connection to my SQL 2000 server complete with all of the databases I had installed over there. VERY CONFUSING if I do say so myself.

What I ultimately had to do was go back to the Visual Studio Express site and download the SQL 2005 Express engine and then install a new named instance. After I did this, I was able to then download the Adventure Works database and attach it successfully.

Not bad for a newbie, eh?!

I have always found SQL confusing which is why I saved it for last in my studies. This is my opinion here so take it for what it's worth - but if Microsoft wants more hobbyists and folks who are curious about IT to download SQL Express, then they need to better clarify and explain the difference between the various download options and the absolute importance of installing the SQL Express engine first. I can just imagine some people out there getting very frustrated and giving up completely.

I hope this helps some folks.

Thanks!!

|||

Hi Dear,

I got the same problem while attaching my database. Actully I received mdf and ldf file which was created in sql 2005. But I was not aware of that. Reading your post help me.

Thanks a lot.

Error When Attaching Adventure Works Database

Hello Everyone,

I am very new to SQL and just completed an install of SQL 2005 Express. After install, I downloaded the Adventure Works database and attempted to attach through both the Object Browser (right-click 'Databases'>'Attach') and by running the script that is located on the SQL download page where I got the Adventure Works db.

Here's the error that I get:

"Could not find row in sysindexes for database ID 8, object ID 1, Index ID 1. Run DBCC CHECKTABLE on sysindexes."

I have attempted to go through the help files, but unfortunately the above message is too cryptic for me and I have no idea what it's telling me.

Can someone help?

Thanks!!

YOu can either use the attach method OR create the database with the scripts. There is no need to execute both, as they will end up both with a working Adventureworks database. I always prefer to execute the script as I am able to have a hand on the scripts first :-)

HTH, Jens K. Suessmeyer.

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

Thank you for the help, Jens.

For what it's worth, I mentioned in my post that I tried both methods of attaching the database because neither of them worked. However, I have discovered why they didn't work:

When I went the Visual Studio page earlier this evening, I chose to install the SQL Server Express Tools thinking that this would give me the total installation including the SQL database engine. Apparently I was wrong. When choosing this option, what I got was the Management Studio and the Business Intelligence Development Studio. I was further led into thinking that I had everything I needed because I currently have the trial edition of SQL Server 2000 Enterprise Edition installed (the books I use in my SQL class are written in ANSI 92 so we only use 2000)...i'm sure you can imagine what happened after opening Management Studio for the first time - I get a connection to my SQL 2000 server complete with all of the databases I had installed over there. VERY CONFUSING if I do say so myself.

What I ultimately had to do was go back to the Visual Studio Express site and download the SQL 2005 Express engine and then install a new named instance. After I did this, I was able to then download the Adventure Works database and attach it successfully.

Not bad for a newbie, eh?!

I have always found SQL confusing which is why I saved it for last in my studies. This is my opinion here so take it for what it's worth - but if Microsoft wants more hobbyists and folks who are curious about IT to download SQL Express, then they need to better clarify and explain the difference between the various download options and the absolute importance of installing the SQL Express engine first. I can just imagine some people out there getting very frustrated and giving up completely.

I hope this helps some folks.

Thanks!!

|||

Hi Dear,

I got the same problem while attaching my database. Actully I received mdf and ldf file which was created in sql 2005. But I was not aware of that. Reading your post help me.

Thanks a lot.

Friday, February 24, 2012

Error trying to install reporting services

I have verified that iwam_computer is enabled and in sync.
error mesage -
Internet Information Services 5.0 (IIS) or later is either not installed, or
it is configured in a way that is incompatible with a Reporting Services
installation.
log -
Microsoft SQL Server 2000 Reporting Services Setup beginning at Mon Jan 24
09:22:42 2005
<Func Name='UpdateComponents'>
SCU_SetupMgr::InitComponents()
<Func Name='WindowsInstallerComp::Init'>
<Func Name='WindowsInstallerComp::IsRequired'>
<Func Name='DotNetFxComp::Init'>
<Func Name='DotNetFxComp::IsRequired'>
<EndFunc Name='DotNetFxComp::IsRequired' Return='F' GetLastError='0'>
SCU_SetupMgr::svc() state=SS_INIT_DONE, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:414}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
<Func Name='SqlSetupFilesComp::Install'>
<Func Name='BootstrapPackageLogic'>
<Func Name='InstallBootstrapPackage'>
/I "E:\SQLRSEVAL\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033" /qn
<EndFunc Name='InstallBootstrapPackage' Return='0' GetLastError='183'>
<EndFunc Name='BootstrapPackageLogic' Return='0' GetLastError='183'>
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
SCU_SetupMgr::InstallComponent state=INSTALL, cancel_state=0, is_done=0,
ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:292}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
SCU_SetupMgr::svc() finished. SetupMgr: state=FINISHED, cancel_state=0,
is_done=1, ActionRequired=1, NeedReboot=0, custom_props={AutoStart=true
HandleReboots=false
ModuleDir=E:\SQLRSEVAL
QuietMode=false
Unattended=false
WorkDir=E:\SQLRSEVAL
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:420}
<EndFunc Name='UpdateComponents' Return='0' GetLastError='183'>
<Func Name='DwLaunchMsiExec'>
<Func Name='PerformDetections'>
0
<EndFunc Name='PerformDetections' Return='0' GetLastError='0'>
Machine = ISOVDEVWAC8, Article = IIS, Result = 0 (0x0)
<Prerequisite Name="IsVS71Installed" Checked="Registry"
Item="HKLM\SOFTWARE\Microsoft\VisualStudio\7.1" Found="Can not open key"
Expected="No error" Result="Fail" />
Machine = ISOVDEVWAC8, Article = VSNET, Result = 60351 (0xebbf)
Machine = ISOVDEVWAC8, Article = ASPNET, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = MDAC, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = DTC, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = SERVEROS, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = SHAREPOINT, Result = 0 (0x0)
Machine = ISOVDEVWAC8, Article = AUTHZ, Result = 0 (0x0)
<Prerequisite Name="AreRSAccountsValidInstalled" Checked="User accounts"
Item="IWAM_machineName" Found="Not exist or not enable" Expected="Exist and
enabled" Result="Fail" />
Machine = ISOVDEVWAC8, Article = RSACCOUNTS, Result = 60357 (0xebc5)
**************
ISOVDEVWAC8
**************
Report Designer component requirement
<B>Explanation:</B> Visual Studio .NET 2003 is not installed.
<B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to
install Report Designer. Or, continue Setup to complete the installation
without Report Designer.
Report Server component requirement
<B>Explanation:</B> Internet Information Services 5.0 (IIS) or later is
either not installed, or it is configured in a way that is incompatible with
a Reporting Services installation.
<B>Action:</B> To install the Report Server and Report Manager components,
you must first install Internet Information Services 5.0 (IIS) or later, and
then verify that the Web server configuration requirements are compatible
with Setup. Check the Setup documentation for more information about Web
server configuration requirements.
Report size = 1050
<Func Name='FSetupLogging'>
<Func Name='CreateSetupLogCabs'>
Creating Setup Logs Cab "C:\Program Files\Microsoft SQL Server\80\RS Setup
Bootstrap\LOG\RSStp_.cab"seems error comes from these line
> <Func Name='InstallBootstrapPackage'
> /I "E:\SQLRSEVAL\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033
/q
> <EndFunc Name='InstallBootstrapPackage' Return='0
GetLastError='183'
> <EndFunc Name='BootstrapPackageLogic' Return='0
GetLastError='183'
>
Did you find how to solve it ? i got the same problem..
Thank|||o
in my case i used to install it with the command line options wher
some errors are but if you used the response file it's the same
For example do not use REINSTALL=All; it just failed, us
REINSTALLMODE=omus or amus (omus works
Also RS_BooksOnline_EN is not a valid entry even you see it everywher
on Ms Docs (bull...
use RS_BooksOnline and not RS_BooksOnline_EN
Hope it will hav helped yo

Sunday, February 19, 2012

Error to install the SQL server Database services

Hay,

I have a problem to in stall my SQL database services.

I use the Microsoft SQL server 2005 on a Microsoft small business server 2003 system.

My system configuration check is oke and i have no problems to install the other services(Analysis,Reporting,Notification and Intergration).

When i install the SQL database services i have this error:

(Error attempting to read from the source install database,

d:\windows\install\7b027f.msi).

thanks

If you scan your install log files you may find more information to help track down the problem. Here's a brief description of where to look and what to look for, copied from Jeffrey Baker's blog but I would look for more anomalies than just "ue 3":

Please look at the file "%ProgramFiles%\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Summary.txt" which should contain a summary of the
installation and what, if any errors there were. If you see an error,
please copy that section back to this thread. Then open up the Log File for
that failure and do a search for "ue 3" and copy a block of text from 10
lines above "ue 3" to 10 lines below "ue 3" back to this thread.