I have done a freresh install of Windows 2003, patches and now trying to
install MSDE RelA.
I use the command line "SETUP SAPWD="Password"" and it appears to install
successfully. I restart. When I try to install an application that uses
MSDE it claims there is no database.
I do a "netstat -an" and do not see anything listening on port 1433. I've
uninstalled and reinstalled with no change. What am I doing wrong?
Hi
In Control Panel > Services, Is the MSDE service there and running?
Regards
Mike
"Brian" wrote:
> I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||I do "Net Start" and MSSQLSERVER is listed. It is also displayed in the gui
as automatic and running.
"Mike Epprecht (SQL MVP)" wrote:
[vbcol=seagreen]
> Hi
> In Control Panel > Services, Is the MSDE service there and running?
> Regards
> Mike
> "Brian" wrote:
|||MSDE installs by default with Windows Security only. Setting an sa password
doesn't influence that. You also have to add SECURITYMODE=SQL to your setup
script if you want to use SQL Security.
You can change an MSDE installation to use SQL Security after it has been
installed by changing the registry key
HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Lo ginMode to 2.
See:
http://support.microsoft.com/default...b;en-us;285097
for extensive info.
Jacco Schalkwijk
SQL Server MVP
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
|||Brian,
By default MSDE RelA installs with TCP protocol turned off for security
reasons. Use svrnetcn.exe in the Binn folder to enable protocols and
configure ports.
Ron Allen
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:7B17BA79-2F77-47D2-AAB1-99C3495885EC@.microsoft.com...
>I have done a freresh install of Windows 2003, patches and now trying to
> install MSDE RelA.
> I use the command line "SETUP SAPWD="Password"" and it appears to install
> successfully. I restart. When I try to install an application that uses
> MSDE it claims there is no database.
> I do a "netstat -an" and do not see anything listening on port 1433. I've
> uninstalled and reinstalled with no change. What am I doing wrong?
Showing posts with label setup. Show all posts
Showing posts with label setup. Show all posts
Friday, March 30, 2012
installing MSDE?
Hello!
In the setup of MSDE I need to edit the ini file. Well when I do it looks as if the installation was complete, but there is no MSDE services application and the actual services are on the box(I can start/stop them). Could someone show me what the edited ini file needs to have to be sure the install is complete? Or maybe there's something else that I need to do and just don't know about.
Many thanks.Not sure I understand what the problem is.
Is it MSDE 1.0 or MSDE 2000?
Is the OS NT or Win2k or 9x/ME?
Can you see if the MSSQLSERVER service is running?
You can check this easily by running sqlmangr.exe
In the setup of MSDE I need to edit the ini file. Well when I do it looks as if the installation was complete, but there is no MSDE services application and the actual services are on the box(I can start/stop them). Could someone show me what the edited ini file needs to have to be sure the install is complete? Or maybe there's something else that I need to do and just don't know about.
Many thanks.Not sure I understand what the problem is.
Is it MSDE 1.0 or MSDE 2000?
Is the OS NT or Win2k or 9x/ME?
Can you see if the MSSQLSERVER service is running?
You can check this easily by running sqlmangr.exe
installing MSDE without sa password
Hello friends,
I am a beginer installing MSDE in a W98 system. The setup file request me a
secure password "sa".
I don't know what must I do now?
How can I define a secure password in W98?
Thanks a lot.
Lorka
On Tue, 15 Jun 2004 16:58:27 +0200, Lorka wrote:
>Hello friends,
>I am a beginer installing MSDE in a W98 system. The setup file request me a
>secure password "sa".
>I don't know what must I do now?
>How can I define a secure password in W98?
>Thanks a lot.
>Lorka
Hi Lorka,
Make up a password that's hard to guess (*). Write it down somewhere safe,
unless you have perfect recall. Never give it out to anyone.
(*) A hard to guess password uses both upper- and lowercase letters, at
least one digit and at least one special character. Of coourse, there is
no relation between the password and your username, your real name or the
names of anyone you love. Steer clear from English words as well (or if
you do include them, make sure you misspell them - as in pas5w0Rd)
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||I understand the problem - Win98 has no passwords. You must install MSDE and the use the "osql.exe" utility via DOS window commands. Look this up in the MS SQL Server 2000 Books Online (Jan 2004 version is the most recent) Its free and must be installed o
n your system. Look for sp_password as the stored procedure to set the sa password under osql.
Good luck.
Mark Ferguson
"Lorka" wrote:
> Hello friends,
> I am a beginer installing MSDE in a W98 system. The setup file request me a
> secure password "sa".
> I don't know what must I do now?
> How can I define a secure password in W98?
> Thanks a lot.
> Lorka
>
>
|||PS: Although Win98 has no passwords, SQL Server uses SQL or Mixed Mode security under Win98. Look for their descriptions in the SQL Server Books Online.
For Win98, you will have to define a user name and password in SQL Server for each user, and assign them to a SQL Server Role. Thereafter, when they attempt to access SQL Server, they will have to log into it using these names and passwords. by default on
ly the "sa" username is defined and it has no default password (i think). So the reaosn for the strong password at install time is to avoid people from just nonchalantly logging in under the "sa" user name. If anyone else knows this to be wrong, please re
ply with corrections.
Seems to me that Win98 may pose another problem. I dont think it has named pipes - an alternative method to TCP/IP by which SQLServer and applications communicate - but I am not sure about this. Again, check the SQL Server Books Online.
Mark Ferguson
I am a beginer installing MSDE in a W98 system. The setup file request me a
secure password "sa".
I don't know what must I do now?
How can I define a secure password in W98?
Thanks a lot.
Lorka
On Tue, 15 Jun 2004 16:58:27 +0200, Lorka wrote:
>Hello friends,
>I am a beginer installing MSDE in a W98 system. The setup file request me a
>secure password "sa".
>I don't know what must I do now?
>How can I define a secure password in W98?
>Thanks a lot.
>Lorka
Hi Lorka,
Make up a password that's hard to guess (*). Write it down somewhere safe,
unless you have perfect recall. Never give it out to anyone.
(*) A hard to guess password uses both upper- and lowercase letters, at
least one digit and at least one special character. Of coourse, there is
no relation between the password and your username, your real name or the
names of anyone you love. Steer clear from English words as well (or if
you do include them, make sure you misspell them - as in pas5w0Rd)
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||I understand the problem - Win98 has no passwords. You must install MSDE and the use the "osql.exe" utility via DOS window commands. Look this up in the MS SQL Server 2000 Books Online (Jan 2004 version is the most recent) Its free and must be installed o
n your system. Look for sp_password as the stored procedure to set the sa password under osql.
Good luck.
Mark Ferguson
"Lorka" wrote:
> Hello friends,
> I am a beginer installing MSDE in a W98 system. The setup file request me a
> secure password "sa".
> I don't know what must I do now?
> How can I define a secure password in W98?
> Thanks a lot.
> Lorka
>
>
|||PS: Although Win98 has no passwords, SQL Server uses SQL or Mixed Mode security under Win98. Look for their descriptions in the SQL Server Books Online.
For Win98, you will have to define a user name and password in SQL Server for each user, and assign them to a SQL Server Role. Thereafter, when they attempt to access SQL Server, they will have to log into it using these names and passwords. by default on
ly the "sa" username is defined and it has no default password (i think). So the reaosn for the strong password at install time is to avoid people from just nonchalantly logging in under the "sa" user name. If anyone else knows this to be wrong, please re
ply with corrections.
Seems to me that Win98 may pose another problem. I dont think it has named pipes - an alternative method to TCP/IP by which SQLServer and applications communicate - but I am not sure about this. Again, check the SQL Server Books Online.
Mark Ferguson
Installing MSDE using VS.NET
Hi all,
I want to create setup/Installer project in Visual
Studio.NET 2003 that will detect MSDE. If MSDE already
installed then setup will not install MSDE , If not then
setup will install MSDE.
So please tell me have will i installed MSDE
using /Installer project in Visual Studio.NET 2003.
Thx in Advance
Amit
Hi Amit,
You can download MSDE toolkit, that is a plug-in to Microsoft Visual Studio
that automates the process of creating an integrated package with both the
application and the MSDE database, from
http://www.microsoft.com/downloads/d...403-c4ba-4d98-
bb0b-2c9d6414071f&DisplayLang=en
This toolkit will help you in customizing and designing a setup for MSDE
that can be integrated with your application.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thank you ashish great link. I installed on my system
working fine
.
My next question is how i can add my database file in MSDE
using same VS.Net installer.
Amit
>--Original Message--
>Hi Amit,
>You can download MSDE toolkit, that is a plug-in to
Microsoft Visual Studio
>that automates the process of creating an integrated
package with both the
>application and the MSDE database, from
>http://www.microsoft.com/downloads/details.aspx?
FamilyID=6e9a7403-c4ba-4d98-
>bb0b-2c9d6414071f&DisplayLang=en
>
>This toolkit will help you in customizing and designing a
setup for MSDE
>that can be integrated with your application.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
You can go through the following technical article that helps in designing
classes for MSDE installation.
http://msdn.microsoft.com/library/de...us/dnmsde/html
/msdedepl.asp
According to that you can use the "AfterInstall" event to add the database
to the MSDE server.
According to my understanding, you will have to include the database files
in your setup and extract it to the desired location, and then execute the
"attachdb" function or the sp_attach_db stored procedure from the object.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Ashish,
Thank you my installation nightmare is over.
But i have still one problem.
I am using trusted connection to connect my web site with
MSDE database.
In command line i use
osql -S myserver\Instancename -E connected successfully.
while connecting with my website it will give following
error.
"Login failed for user "servername\ASPNET"
i also use SQL connection in which i provide user id and
password but the result is same an error occurs.
"Login failed for user "sa". Reason: Not associated with
trusted SQL server Connection"
please tell me where i am wrong.
Thanks
Amit
>--Original Message--
>Hi Amit,
>You can go through the following technical article that
helps in designing
>classes for MSDE installation.
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnmsde/html
>/msdedepl.asp
>
>According to that you can use the "AfterInstall" event to
add the database
>to the MSDE server.
>According to my understanding, you will have to include
the database files
>in your setup and extract it to the desired location, and
then execute the
>"attachdb" function or the sp_attach_db stored procedure
from the object.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
The user servername\ASPNET is the default user name that the ASP.NET process
runs as within the operating system. It is configured in the machine.config
file. By default, it has no access to your databases.
You have three basic options:
1. Grant appropriate database access to the ASPNET user.
2. Use impersonation on the site - configured in your web.config file (ie
impersonate the windows user that the end user is connecting as - not great
for public sites of any type)
3. Have your application log on as a specific user and grant that user
access to the database.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Amit" <anonymous@.discussions.microsoft.com> wrote in message
news:213c01c42794$69f54020$a101280a@.phx.gbl...[vbcol=seagreen]
> Hi Ashish,
> Thank you my installation nightmare is over.
> But i have still one problem.
> I am using trusted connection to connect my web site with
> MSDE database.
> In command line i use
> osql -S myserver\Instancename -E connected successfully.
> while connecting with my website it will give following
> error.
> "Login failed for user "servername\ASPNET"
> i also use SQL connection in which i provide user id and
> password but the result is same an error occurs.
> "Login failed for user "sa". Reason: Not associated with
> trusted SQL server Connection"
>
> please tell me where i am wrong.
>
> Thanks
> Amit
>
> helps in designing
> url=/library/en-us/dnmsde/html
> add the database
> the database files
> then execute the
> from the object.
> confers no rights.
sql
I want to create setup/Installer project in Visual
Studio.NET 2003 that will detect MSDE. If MSDE already
installed then setup will not install MSDE , If not then
setup will install MSDE.
So please tell me have will i installed MSDE
using /Installer project in Visual Studio.NET 2003.
Thx in Advance
Amit
Hi Amit,
You can download MSDE toolkit, that is a plug-in to Microsoft Visual Studio
that automates the process of creating an integrated package with both the
application and the MSDE database, from
http://www.microsoft.com/downloads/d...403-c4ba-4d98-
bb0b-2c9d6414071f&DisplayLang=en
This toolkit will help you in customizing and designing a setup for MSDE
that can be integrated with your application.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thank you ashish great link. I installed on my system
working fine
.My next question is how i can add my database file in MSDE
using same VS.Net installer.
Amit
>--Original Message--
>Hi Amit,
>You can download MSDE toolkit, that is a plug-in to
Microsoft Visual Studio
>that automates the process of creating an integrated
package with both the
>application and the MSDE database, from
>http://www.microsoft.com/downloads/details.aspx?
FamilyID=6e9a7403-c4ba-4d98-
>bb0b-2c9d6414071f&DisplayLang=en
>
>This toolkit will help you in customizing and designing a
setup for MSDE
>that can be integrated with your application.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
You can go through the following technical article that helps in designing
classes for MSDE installation.
http://msdn.microsoft.com/library/de...us/dnmsde/html
/msdedepl.asp
According to that you can use the "AfterInstall" event to add the database
to the MSDE server.
According to my understanding, you will have to include the database files
in your setup and extract it to the desired location, and then execute the
"attachdb" function or the sp_attach_db stored procedure from the object.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Ashish,
Thank you my installation nightmare is over.
But i have still one problem.
I am using trusted connection to connect my web site with
MSDE database.
In command line i use
osql -S myserver\Instancename -E connected successfully.
while connecting with my website it will give following
error.
"Login failed for user "servername\ASPNET"
i also use SQL connection in which i provide user id and
password but the result is same an error occurs.
"Login failed for user "sa". Reason: Not associated with
trusted SQL server Connection"
please tell me where i am wrong.
Thanks
Amit
>--Original Message--
>Hi Amit,
>You can go through the following technical article that
helps in designing
>classes for MSDE installation.
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnmsde/html
>/msdedepl.asp
>
>According to that you can use the "AfterInstall" event to
add the database
>to the MSDE server.
>According to my understanding, you will have to include
the database files
>in your setup and extract it to the desired location, and
then execute the
>"attachdb" function or the sp_attach_db stored procedure
from the object.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
The user servername\ASPNET is the default user name that the ASP.NET process
runs as within the operating system. It is configured in the machine.config
file. By default, it has no access to your databases.
You have three basic options:
1. Grant appropriate database access to the ASPNET user.
2. Use impersonation on the site - configured in your web.config file (ie
impersonate the windows user that the end user is connecting as - not great
for public sites of any type)
3. Have your application log on as a specific user and grant that user
access to the database.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Amit" <anonymous@.discussions.microsoft.com> wrote in message
news:213c01c42794$69f54020$a101280a@.phx.gbl...[vbcol=seagreen]
> Hi Ashish,
> Thank you my installation nightmare is over.
> But i have still one problem.
> I am using trusted connection to connect my web site with
> MSDE database.
> In command line i use
> osql -S myserver\Instancename -E connected successfully.
> while connecting with my website it will give following
> error.
> "Login failed for user "servername\ASPNET"
> i also use SQL connection in which i provide user id and
> password but the result is same an error occurs.
> "Login failed for user "sa". Reason: Not associated with
> trusted SQL server Connection"
>
> please tell me where i am wrong.
>
> Thanks
> Amit
>
> helps in designing
> url=/library/en-us/dnmsde/html
> add the database
> the database files
> then execute the
> from the object.
> confers no rights.
sql
Installing MSDE SA password error.
I've been trying to install MSDE so i could run ASP.Net Forums. But whenever i run the setup.exe file, it gives me a pop up message with the following message:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to the readme for more details. Set up will now Exit."
Could any body please tell me what to do??...
Yes. I'm stupid. And please excuse my ignoracne.Go to run and type the following replace path and password optionally you can specify authentication mode (default is windows) SECURITYMODE=SQL.
f:\sql2ksp3\MSDE\setup.exe sapwd="password"
Hope this helps
Regards
S(:
Installing MSDE 2000 Rel A
Hi all,
I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
time without any indication of why. I had an earlier installation of MSDE
which I removed manually following the instructions in the Knowledge Base
article. I installed MSDE on a Windows 2000 Pro machine using the same
procedure without any problems.
The command line syntax I'm using is: setup sapwd="[mypassword]"
SECURITYMODE=SQL
Can anyone help?
Thanks.
When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
SQL Server" key needs to be removed. Also remove the entire directory tree
under c:\program files\Microsoft SQL Server. Also, reboot the machine after
doing the manual uninstall.
Jim
"Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
> Hi all,
> I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
> time without any indication of why. I had an earlier installation of MSDE
> which I removed manually following the instructions in the Knowledge Base
> article. I installed MSDE on a Windows 2000 Pro machine using the same
> procedure without any problems.
> The command line syntax I'm using is: setup sapwd="[mypassword]"
> SECURITYMODE=SQL
> Can anyone help?
> Thanks.
|||Hi Jim,
I did delete those keys from the registry with no luck.
In a separate post, I uploaded part of the install log what appears to point
to the problem . Searching for "return value 3" I found the following:
"Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 11:32:55: InstallFinalize. Return value 3."
According to a Knowledge Base article, the only solution to this involves
some advanced level tinkering with the registry, which I don't feel
comfortable undertaking. Is there any other way?
Thanks for your reply.
sb
"Jim Young" wrote:
> When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
> under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
> SQL Server" key needs to be removed. Also remove the entire directory tree
> under c:\program files\Microsoft SQL Server. Also, reboot the machine after
> doing the manual uninstall.
> Jim
> "Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
> news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
>
>
sql
I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
time without any indication of why. I had an earlier installation of MSDE
which I removed manually following the instructions in the Knowledge Base
article. I installed MSDE on a Windows 2000 Pro machine using the same
procedure without any problems.
The command line syntax I'm using is: setup sapwd="[mypassword]"
SECURITYMODE=SQL
Can anyone help?
Thanks.
When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
SQL Server" key needs to be removed. Also remove the entire directory tree
under c:\program files\Microsoft SQL Server. Also, reboot the machine after
doing the manual uninstall.
Jim
"Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
> Hi all,
> I am unable to install MSDE on Window XP pro, SP2. Setup rolls back every
> time without any indication of why. I had an earlier installation of MSDE
> which I removed manually following the instructions in the Knowledge Base
> article. I installed MSDE on a Windows 2000 Pro machine using the same
> procedure without any problems.
> The command line syntax I'm using is: setup sapwd="[mypassword]"
> SECURITYMODE=SQL
> Can anyone help?
> Thanks.
|||Hi Jim,
I did delete those keys from the registry with no luck.
In a separate post, I uploaded part of the install log what appears to point
to the problem . Searching for "return value 3" I found the following:
"Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 6
Action ended 11:32:55: InstallFinalize. Return value 3."
According to a Knowledge Base article, the only solution to this involves
some advanced level tinkering with the registry, which I don't feel
comfortable undertaking. Is there any other way?
Thanks for your reply.
sb
"Jim Young" wrote:
> When you manually uninstalled MSDE did you also remove the "MSSQLServer" key
> under HKEY_LOCAL_MACHINE\Software\Microsoft ? That key and the "Microsoft
> SQL Server" key needs to be removed. Also remove the entire directory tree
> under c:\program files\Microsoft SQL Server. Also, reboot the machine after
> doing the manual uninstall.
> Jim
> "Stephen Bishop" <Stephen Bishop@.discussions.microsoft.com> wrote in message
> news:1E567705-A87F-4B8D-8DF5-202D934D5263@.microsoft.com...
>
>
sql
Installing MSDE 2000 on a system with SQL Express 2005
I noticed that when I install an app that uses MSDE 2000 on my system (which
has SQL Express 2005 installed) the MSDE setup will load and hang at "11
minutes" remaining. I can't cancel it, clicking Cancel switches the dialog
to say "Cancelling" but nothing ever happens.
Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a system?
If yes, how?
Thanks for your help!
hi Pyil,
Phil Palios wrote:
> I noticed that when I install an app that uses MSDE 2000 on my system
> (which has SQL Express 2005 installed) the MSDE setup will load and
> hang at "11 minutes" remaining. I can't cancel it, clicking Cancel
> switches the dialog to say "Cancelling" but nothing ever happens.
> Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a
> system? If yes, how?
yes it should be ... do not know if MSDE 2000 should be previously installed
than SQLExpress, but should be..
please provide the
/L*v "c:\MsdeLot.txt"
parameter to the setup.exe boostrap installer in order to allow verbose
logging of the installation process.. this will result in an about
2mb(succesfull installation) text file you can inspect for
RETURN VALUE 3
entries... about 10/15 lines before each entry, some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
I opened up the MSDE log and there are no lines that contain "value 3" my
guess for this is that since setup hung it never was able to log a value 3
and exit gracefully.
The last two lines in the log are:
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
So it appears that sqlredis.exe may be what is hanging, and the MSDE install
is not hearing back so it hangs. Any ideas on what is going on and how it
may be fixed?
Thanks so much!
-Phil
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3t11onFprggaU1@.individual.net...
> hi Pyil,
> Phil Palios wrote:
> yes it should be ... do not know if MSDE 2000 should be previously
> installed than SQLExpress, but should be..
> please provide the
> /L*v "c:\MsdeLot.txt"
> parameter to the setup.exe boostrap installer in order to allow verbose
> logging of the installation process.. this will result in an about
> 2mb(succesfull installation) text file you can inspect for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry, some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Phil,
Phil Palios wrote:
> Hi Andrea,
> I opened up the MSDE log and there are no lines that contain "value
> 3" my guess for this is that since setup hung it never was able to
> log a value 3 and exit gracefully.
> The last two lines in the log are:
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> So it appears that sqlredis.exe may be what is hanging, and the MSDE
> install is not hearing back so it hangs. Any ideas on what is going
> on and how it may be fixed?
>
you can not fix this, as this problem is raised by MDAC setup itself... but
you can hack it... it's not supported but you can do it...
first install the latest MDAC stack manually, then run MSDE setup.exe
boostrap installer...
when MSDE setup hangs, kill setupre.exe process via Task Manager, then the
setup will proceed and complete successfully...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
has SQL Express 2005 installed) the MSDE setup will load and hang at "11
minutes" remaining. I can't cancel it, clicking Cancel switches the dialog
to say "Cancelling" but nothing ever happens.
Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a system?
If yes, how?
Thanks for your help!
hi Pyil,
Phil Palios wrote:
> I noticed that when I install an app that uses MSDE 2000 on my system
> (which has SQL Express 2005 installed) the MSDE setup will load and
> hang at "11 minutes" remaining. I can't cancel it, clicking Cancel
> switches the dialog to say "Cancelling" but nothing ever happens.
> Is it possible for MSDE 2000 to co-exist with SQL Express 2005 on a
> system? If yes, how?
yes it should be ... do not know if MSDE 2000 should be previously installed
than SQLExpress, but should be..
please provide the
/L*v "c:\MsdeLot.txt"
parameter to the setup.exe boostrap installer in order to allow verbose
logging of the installation process.. this will result in an about
2mb(succesfull installation) text file you can inspect for
RETURN VALUE 3
entries... about 10/15 lines before each entry, some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
I opened up the MSDE log and there are no lines that contain "value 3" my
guess for this is that since setup hung it never was able to log a value 3
and exit gracefully.
The last two lines in the log are:
Starting custom action InstallSqlRedis
Executing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlredis.exe
/q:a"
So it appears that sqlredis.exe may be what is hanging, and the MSDE install
is not hearing back so it hangs. Any ideas on what is going on and how it
may be fixed?
Thanks so much!
-Phil
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3t11onFprggaU1@.individual.net...
> hi Pyil,
> Phil Palios wrote:
> yes it should be ... do not know if MSDE 2000 should be previously
> installed than SQLExpress, but should be..
> please provide the
> /L*v "c:\MsdeLot.txt"
> parameter to the setup.exe boostrap installer in order to allow verbose
> logging of the installation process.. this will result in an about
> 2mb(succesfull installation) text file you can inspect for
> RETURN VALUE 3
> entries... about 10/15 lines before each entry, some (sometime cryptic)
> description of the problem will be reported..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Phil,
Phil Palios wrote:
> Hi Andrea,
> I opened up the MSDE log and there are no lines that contain "value
> 3" my guess for this is that since setup hung it never was able to
> log a value 3 and exit gracefully.
> The last two lines in the log are:
> Starting custom action InstallSqlRedis
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlredis.exe /q:a"
> So it appears that sqlredis.exe may be what is hanging, and the MSDE
> install is not hearing back so it hangs. Any ideas on what is going
> on and how it may be fixed?
>
you can not fix this, as this problem is raised by MDAC setup itself... but
you can hack it... it's not supported but you can do it...
first install the latest MDAC stack manually, then run MSDE setup.exe
boostrap installer...
when MSDE setup hangs, kill setupre.exe process via Task Manager, then the
setup will proceed and complete successfully...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Installing MSDE
I've downloaded sql2ksp3. After I have extracted the file, I found MSDE folder and I ran the setup.exe. Halfway through the installation, it says the instance name specified is invalid.
Does anyone know how to fix this? Thanks.Take a look atKB article 810826 and specify an INSTANCENAME parameters to the command.
Wednesday, March 28, 2012
Installing MS SQL Server Engine
Hi everybody.
I was trying to install MS SQL Server Engine this morning. At the command prompt I typed setup SAPWD=password SECURITYMODE=SQL (where password was my password). After running the MSI I got the following error:
For reference, here are the installation instructions for MSDE:Installing Desktop Engine.sql
I was trying to install MS SQL Server Engine this morning. At the command prompt I typed setup SAPWD=password SECURITYMODE=SQL (where password was my password). After running the MSI I got the following error:
Product: Microsoft SQL Server Desktop Engine -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
The Event ID is 1013.
Can anybody tell me how to install this program. Thanks in advance for any help.
> setup.exeSAPWD=password SECURITYMODE=SQL /L*v C:\MSDE_setup.log
For reference, here are the installation instructions for MSDE:Installing Desktop Engine.sql
Installing Inventor10
Hello,
I have a problem installing Autodesk Inventor 10 on my
WK SP4 OS system on XP SP2 system it works fine.
Event log during setup Inventor 10 Pro.
Source Loadperf
Category (none)
Event ID 2000
No object list was found in the installation file.
Adding an object list to the installation file will improve
performance of the system when measuring performance counters.
Source Loadperf
Category (none)
Event ID 1000
Performance counters for the MSSQL$INVENTORCONTENT service were loaded
successfully.
The Record Data contains the new index values assigned to this service.
Source MSSQL$INVENTORCONTENT
Category (8)
Event ID 19011
The description for Event ID ( 19011 ) in Source ( MSSQL$INVENTORCONTENT
) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer.
The following information is part of the event: (SpnRegister) : Error 1355.
Source MsiInstaller
Category (none)
Event ID 1013
Product: Microsoft SQL Server Desktop Engine --
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
Source MsiInstaller
Category (none)
Event ID 11708
Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
Source MsiInstaller
Category (none)
Event ID 11722
Product: Autodesk Inventor Professional 10 -- Error 1722.
There is a problem with this Windows Installer package.
A program run as part of the setup did not finish as expected.
Contact your support personnel or package vendor.
Action InstallMSDE, location:
F:\inv1_pro10\bin\acadfeui\support\msde\setup.exe, command:
SAPWD="AutodeskVault" INSTANCENAME="INVENTORCONTENT" SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=1 /L*v
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og /qb
REBOOT=ReallySuppress
Kind Regards
hi,
Smeusje wrote:
> Hello,
> I have a problem installing Autodesk Inventor 10 on my
> WK SP4 OS system on XP SP2 system it works fine.
> Event log during setup Inventor 10 Pro.
try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
for
RETURN VALUE 3
entries..
about 10 lines before each entry some (sometime cryptic) description of the
problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I have two of them
************************************************** ************************************************** ********************
Starting custom action SkuIt
MSI (s) (30:D4) [13:57:35:890]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (30:18) [13:57:35:921]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI47.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
MSI (s) (30:D4) [13:58:06:968]: Executing op:
ActionStart(Name=RegSQLWithMDAC.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "INVENTORCONTENT" -Q
"SQL_Latin1_General_CP1_CI_AS""
MSI (s) (30:D4) [13:58:06:968]: Executing op:
CustomActionSchedule(Action=RegSQLWithMDAC.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=RegSQLWithMDAC,)
MSI (s) (30:18) [13:58:06:984]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI48.tmp, Entrypoint: RegSQLWithMDAC
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action RegSqlWithMdac
MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
Engine -- An error has occurred registering this installation of SQL
Server Desktop Engine with MDAC.
MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback' is 0
MSI (s) (30:D4) [13:58:12:812]: Machine policy value 'DisableRollback' is 0
Action ended 13:58:12: InstallFinalize. Return value 3.
************************************************** ************************************************** *******************
MSI (s) (30:D4) [13:58:19:078]: Executing op:
ActionStart(Name=RollbackStreamSupportFiles.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:078]: Executing op:
CustomActionRollback(Action=RollbackStreamSupportF iles.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionTy pe=1281,Source=BinaryData,Target=RemoveSupportFile s,)
MSI (s) (30:94) [13:58:19:078]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4B.tmp, Entrypoint: RemoveSupportFiles
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
MSI (s) (30:D4) [13:58:19:203]: Executing op:
ActionStart(Name=RollbackDeferProperties.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:203]: Executing op:
CustomActionRollback(Action=RollbackDeferPropertie s.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType= 1281,Source=BinaryData,Target=DeferProperties,)
MSI (s) (30:94) [13:58:19:203]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4C.tmp, Entrypoint: DeferProperties
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
MSI (s) (30:D4) [13:58:19:421]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return: 5
Defer Properties returns: 0
MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 13:58:19: INSTALL. Return value 3.
************************************************** ************************************************** **********************
I already changed from "Not difined" to "silently succeed" as
mentionned in the MSDE 2000 Release A guide
Unsigned driver installation behavior.
Unsigned non-driver installation behavior
Extract guide
A MSDE 2000 Release A installation will fail if either of the following
security policies has been set to Do not allow installation:
* The Devices: Unsigned driver installation behavior local security
policy for Windows XP.
* The Unsigned non-driver installation behavior local security
policy for Windows 2000.
If you use the Do not allow installation setting, you must change it to
Silently succeed before installing MSDE 2000 Release A. If necessary,
you can return the policy to its previous setting after the installation
is complete.
Note Do not allow installation is not the default setting for these
security policies.
To set these policies:
1. In Control Panel, double-click Administrative Tools.
2. Double-click Local Security Policy.
3. Expand Local Policies.
4. Select Security Options.
5. Ensure that the following option in the right pane is set to
Silently Succeed before installing MSDE 2000 Release A:
* On Windows XP and Windows 2003: Devices: Unsigned driver
installation behavior.
* On Windows 2000: Unsigned non-driver installation behavior.
Still doesn't work
Kind regards
Andrea Montanari wrote:
>hi,
>Smeusje wrote:
>
>try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
>for
>RETURN VALUE 3
>entries..
>about 10 lines before each entry some (sometime cryptic) description of the
>problem will be reported..
>
|||hi,
Smeusje wrote:
> I have two of them
> ************************************************** ************************************************** ********************
> MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
> Engine -- An error has occurred registering this installation of SQL
> Server Desktop Engine with MDAC.
> MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> An error has occurred registering this installation of SQL Server
> Desktop Engine with MDAC.
> MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback'
> is 0 MSI (s) (30:D4) [13:58:12:812]: Machine policy value
> 'DisableRollback' is 0 Action ended 13:58:12: InstallFinalize. Return
> value 3.
> ************************************************** ************************************************** *******************
>...
> MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return:
> 5 Defer Properties returns: 0
> MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
> MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting
> UpdateStarted property. Its current value is '1'.
> Action ended 13:58:19: INSTALL. Return value 3.
> ************************************************** ************************************************** **********************
the first one indicates a problem "installing" MDAC... actually it should
not as it only has to check for the correct MDAC stack... on WinXP sp2 and
Win2003 MDAC 2.8 of the service pack 4 will not be installed becouse of the
"superior" level of the installed component, perfomed only via Windows
Update...
for the 2nd one I really have no clues...
I do think all this is dependent of a embedded installation of MSDE... can
you please try downloading and executing the original setup.exe boostrapper
installer of MSDE?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I have a problem installing Autodesk Inventor 10 on my
WK SP4 OS system on XP SP2 system it works fine.
Event log during setup Inventor 10 Pro.
Source Loadperf
Category (none)
Event ID 2000
No object list was found in the installation file.
Adding an object list to the installation file will improve
performance of the system when measuring performance counters.
Source Loadperf
Category (none)
Event ID 1000
Performance counters for the MSSQL$INVENTORCONTENT service were loaded
successfully.
The Record Data contains the new index values assigned to this service.
Source MSSQL$INVENTORCONTENT
Category (8)
Event ID 19011
The description for Event ID ( 19011 ) in Source ( MSSQL$INVENTORCONTENT
) cannot be found.
The local computer may not have the necessary registry information or
message DLL files to display messages from a remote computer.
The following information is part of the event: (SpnRegister) : Error 1355.
Source MsiInstaller
Category (none)
Event ID 1013
Product: Microsoft SQL Server Desktop Engine --
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
Source MsiInstaller
Category (none)
Event ID 11708
Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
Source MsiInstaller
Category (none)
Event ID 11722
Product: Autodesk Inventor Professional 10 -- Error 1722.
There is a problem with this Windows Installer package.
A program run as part of the setup did not finish as expected.
Contact your support personnel or package vendor.
Action InstallMSDE, location:
F:\inv1_pro10\bin\acadfeui\support\msde\setup.exe, command:
SAPWD="AutodeskVault" INSTANCENAME="INVENTORCONTENT" SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=1 /L*v
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og /qb
REBOOT=ReallySuppress
Kind Regards
hi,
Smeusje wrote:
> Hello,
> I have a problem installing Autodesk Inventor 10 on my
> WK SP4 OS system on XP SP2 system it works fine.
> Event log during setup Inventor 10 Pro.
try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
for
RETURN VALUE 3
entries..
about 10 lines before each entry some (sometime cryptic) description of the
problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I have two of them
************************************************** ************************************************** ********************
Starting custom action SkuIt
MSI (s) (30:D4) [13:57:35:890]: Executing op:
CustomActionSchedule(Action=ConfigServer.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B...
MSI (s) (30:18) [13:57:35:921]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI47.tmp, Entrypoint: ConfigServer
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action ConfigServer
MSI (s) (30:D4) [13:58:06:968]: Executing op:
ActionStart(Name=RegSQLWithMDAC.2D02443E_7002_4C0B _ABC9_EAB2C064397B,,)
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "INVENTORCONTENT" -Q
"SQL_Latin1_General_CP1_CI_AS""
MSI (s) (30:D4) [13:58:06:968]: Executing op:
CustomActionSchedule(Action=RegSQLWithMDAC.2D02443 E_7002_4C0B_ABC9_EAB2C064397B,ActionType=1025,Sour ce=BinaryData,Target=RegSQLWithMDAC,)
MSI (s) (30:18) [13:58:06:984]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI48.tmp, Entrypoint: RegSQLWithMDAC
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action RegSqlWithMdac
MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
Engine -- An error has occurred registering this installation of SQL
Server Desktop Engine with MDAC.
MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
An error has occurred registering this installation of SQL Server
Desktop Engine with MDAC.
MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback' is 0
MSI (s) (30:D4) [13:58:12:812]: Machine policy value 'DisableRollback' is 0
Action ended 13:58:12: InstallFinalize. Return value 3.
************************************************** ************************************************** *******************
MSI (s) (30:D4) [13:58:19:078]: Executing op:
ActionStart(Name=RollbackStreamSupportFiles.2D0244 3E_7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:078]: Executing op:
CustomActionRollback(Action=RollbackStreamSupportF iles.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionTy pe=1281,Source=BinaryData,Target=RemoveSupportFile s,)
MSI (s) (30:94) [13:58:19:078]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4B.tmp, Entrypoint: RemoveSupportFiles
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
MSI (s) (30:D4) [13:58:19:203]: Executing op:
ActionStart(Name=RollbackDeferProperties.2D02443E_ 7002_4C0B_ABC9_EAB2C064397B,,)
MSI (s) (30:D4) [13:58:19:203]: Executing op:
CustomActionRollback(Action=RollbackDeferPropertie s.2D02443E_7002_4C0B_ABC9_EAB2C064397B,ActionType= 1281,Source=BinaryData,Target=DeferProperties,)
MSI (s) (30:94) [13:58:19:203]: Invoking remote custom action. DLL:
C:\WINNT\Installer\MSI4C.tmp, Entrypoint: DeferProperties
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
MSI (s) (30:D4) [13:58:19:421]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return: 5
Defer Properties returns: 0
MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 13:58:19: INSTALL. Return value 3.
************************************************** ************************************************** **********************
I already changed from "Not difined" to "silently succeed" as
mentionned in the MSDE 2000 Release A guide
Unsigned driver installation behavior.
Unsigned non-driver installation behavior
Extract guide
A MSDE 2000 Release A installation will fail if either of the following
security policies has been set to Do not allow installation:
* The Devices: Unsigned driver installation behavior local security
policy for Windows XP.
* The Unsigned non-driver installation behavior local security
policy for Windows 2000.
If you use the Do not allow installation setting, you must change it to
Silently succeed before installing MSDE 2000 Release A. If necessary,
you can return the policy to its previous setting after the installation
is complete.
Note Do not allow installation is not the default setting for these
security policies.
To set these policies:
1. In Control Panel, double-click Administrative Tools.
2. Double-click Local Security Policy.
3. Expand Local Policies.
4. Select Security Options.
5. Ensure that the following option in the right pane is set to
Silently Succeed before installing MSDE 2000 Release A:
* On Windows XP and Windows 2003: Devices: Unsigned driver
installation behavior.
* On Windows 2000: Unsigned non-driver installation behavior.
Still doesn't work
Kind regards
Andrea Montanari wrote:
>hi,
>Smeusje wrote:
>
>try inspecting C:\DOCUME~1\FRANCK~1\LOCALS~1\Temp\MSDE_CC_setup.l og
>for
>RETURN VALUE 3
>entries..
>about 10 lines before each entry some (sometime cryptic) description of the
>problem will be reported..
>
|||hi,
Smeusje wrote:
> I have two of them
> ************************************************** ************************************************** ********************
> MSI (s) (30!00) [13:58:12:796]: Product: Microsoft SQL Server Desktop
> Engine -- An error has occurred registering this installation of SQL
> Server Desktop Engine with MDAC.
> MSI (c) (60:90) [13:58:07:109]: Font created. Charset: Req=0, Ret=0,
> Font: Req=MS Shell Dlg, Ret=MS Shell Dlg
> An error has occurred registering this installation of SQL Server
> Desktop Engine with MDAC.
> MSI (s) (30:D4) [13:58:12:812]: User policy value 'DisableRollback'
> is 0 MSI (s) (30:D4) [13:58:12:812]: Machine policy value
> 'DisableRollback' is 0 Action ended 13:58:12: InstallFinalize. Return
> value 3.
> ************************************************** ************************************************** *******************
>...
> MSI (s) (30:D4) [13:58:19:421]: Error in rollback skipped. Return:
> 5 Defer Properties returns: 0
> MSI (s) (30:D4) [13:58:19:437]: Unlocking Server
> MSI (s) (30:D4) [13:58:19:437]: PROPERTY CHANGE: Deleting
> UpdateStarted property. Its current value is '1'.
> Action ended 13:58:19: INSTALL. Return value 3.
> ************************************************** ************************************************** **********************
the first one indicates a problem "installing" MDAC... actually it should
not as it only has to check for the correct MDAC stack... on WinXP sp2 and
Win2003 MDAC 2.8 of the service pack 4 will not be installed becouse of the
"superior" level of the installed component, perfomed only via Windows
Update...
for the 2nd one I really have no clues...
I do think all this is dependent of a embedded installation of MSDE... can
you please try downloading and executing the original setup.exe boostrapper
installer of MSDE?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Installing feature Pack components with an Application
Hi,
I have developed an application the uses SMO and RMO, now it is time to write the setup for it.
For the setup experience I want to be able to install my application on a clean copy of XP SP2 which has dotnet 2.0 already installed. As such I have downloaded the following from the Feature Pack for Sql 2005 (http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en):
msxml6.msi
sqlncli.msi
sqlserver2005_xmo.msi
Now I'm thinking that I need to launch these msi's from within my own application msi, however, I don't want any UI displayed and I want my own msi to include these msi's when it's calculating the cost of the install.
Is this the correct way to go about getting these components on to a clients machine, i.e. nested msi install, or is there a better way?
Does anyone know what command line args (msiexec) or other options I need to provide for a UI less install of the above?
FYI I'm using VS 2005 to author the install.
Thanks for your help
Graham
Infact, why aren't msm (merge modules) given anymore?
Graham
|||To get a silent install, use the "\qn" flag for MSIExec. In order to 'chain' MSI installations, you'll need to create a setup.exe wrapper that will launch the MSIs in series.
Here's an example from VS.Net: http://www.microsoft.com/downloads/details.aspx?FamilyId=BF253CFD-1EFC-4FC5-BA7E-6A6F21403495&displaylang=en that installs the .NET Framework (hardcoded) then installs your MSI using a settings.ini file. It'll need to be changed to remove the hardcoded installation and then to perhaps iterate through the .ini file to install multiple MSIs.
In response to why we don't ship MSMs any more, it is because we can't service them. If we discover a security (or other) problem with one of the files in the redist packages, we can't issue a QFE for MSMs, but we can issue a QFE for the MSIs that we send out. So it's a servicibility issue.
Monday, March 26, 2012
Installing Express2005 SQL
I am trying to setup a new server for a non-profit i donate my services to.
I want to have SQL for an intranet based program that will be converted from a currently used Access database.
I can not get Express (any version to install). Below are the specs of the server and the log from the install.
Any suggestions and thanks in advance,
Lynn
32 kilobyte primary memory cache
512 kilobyte secondary memory cache
23.01 Gigabytes Hard Drive Free Space
COMPAQ CDR-8435 [CD-ROM drive]
3.5" format removeable media [Floppy drive]
Compaq DDS3 12/24 GB DAT Drive [Tape drive]
IBM DCAS-34330W SCSI Disk Device (4.33 GB) -- drive 1
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 2
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 3
IBM-PSG ST318404LW !# SCSI Disk Device (18.19 GB) -- drive 0
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Mon Nov 06 15:22:52 2006
MAPSERV : The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
MAPSERV : The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
Time : Mon Nov 06 15:23:26 2006
Your hardware fails by just a few Mhz of CPU speed. From BOL for SQL Express:
Pentium III-compatible processor or higher required
Minimum: 600 MHz
Recommended: 1 GHz or higher
Minimum: 192 MB
Recommended: 512 MB or more
Maximum: OS maximum
--
SvenC
The failure is that your OS does not have the proper version of MDAC installed. I believe the minimum required is MDAC 2.6 SP1, but there shouldn't be an issue with installing a more recent version.
Once you take care of that, you should be able to attempt another Express install again.
|||Thanks for all your help.
You were correct about needing the updated MDAC. I searched the MDAC 2.6 SP1 and found a 2.8 SP1. I installed the latest version and re-started the install with success.
Thanks for your keen eye R. Green
|||hi
if i want install Express2005 SQL on windows vista (ultimate) , what is the requriments that must be avaliable ?
Installing Express2005 SQL
I am trying to setup a new server for a non-profit i donate my services to.
I want to have SQL for an intranet based program that will be converted from a currently used Access database.
I can not get Express (any version to install). Below are the specs of the server and the log from the install.
Any suggestions and thanks in advance,
Lynn
32 kilobyte primary memory cache
512 kilobyte secondary memory cache
23.01 Gigabytes Hard Drive Free Space
COMPAQ CDR-8435 [CD-ROM drive]
3.5" format removeable media [Floppy drive]
Compaq DDS3 12/24 GB DAT Drive [Tape drive]
IBM DCAS-34330W SCSI Disk Device (4.33 GB) -- drive 1
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 2
IBM DDRS-34560D SCSI Disk Device (4.57 GB) -- drive 3
IBM-PSG ST318404LW !# SCSI Disk Device (18.19 GB) -- drive 0
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Mon Nov 06 15:22:52 2006
MAPSERV : The current system does not meet minimum hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
MAPSERV : The system does not have the required version of Microsoft Data Access Components (MDAC) for this SQL Server release. For details, see Hardware and Software Requirements for Installing SQL Server 2005 in Microsoft SQL Server Books Online.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
Time : Mon Nov 06 15:23:26 2006
Your hardware fails by just a few Mhz of CPU speed. From BOL for SQL Express:
Pentium III-compatible processor or higher required
Minimum: 600 MHz
Recommended: 1 GHz or higher
Minimum: 192 MB
Recommended: 512 MB or more
Maximum: OS maximum
--
SvenC
The failure is that your OS does not have the proper version of MDAC installed. I believe the minimum required is MDAC 2.6 SP1, but there shouldn't be an issue with installing a more recent version.
Once you take care of that, you should be able to attempt another Express install again.
|||Thanks for all your help.
You were correct about needing the updated MDAC. I searched the MDAC 2.6 SP1 and found a 2.8 SP1. I installed the latest version and re-started the install with success.
Thanks for your keen eye R. Green
|||hi
if i want install Express2005 SQL on windows vista (ultimate) , what is the requriments that must be avaliable ?
Installing error for SQL Server 2000 SP4
I am installing SQL 2000 SP-4 & at one point after clicking next,
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.
<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegr oups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
sql
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.
<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegr oups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
sql
Installing error for SQL Server 2000 SP4
I am installing SQL 2000 SP-4 & at one point after clicking next,
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegroups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegroups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Installing error for SQL Server 2000 SP4
I am installing SQL 2000 SP-4 & at one point after clicking next,
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegroups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
next
i am getting this error message "Setup requires an additional 3072kb
free space on E:" Where this Drive E: is on SAN Storage & as 13GB
free
space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
&
rebooted server to rule out all possibilities & after reboot i
started
setup process again came to the same error message that is mentioned
earlier. even though i have 13GB free space i don't know where the
problem is. any help is appreciated. thanking in advance.<myrights99@.gmail.com> wrote in message
news:1175623943.799477.108990@.d57g2000hsg.googlegroups.com...
>I am installing SQL 2000 SP-4 & at one point after clicking next,
> next
> i am getting this error message "Setup requires an additional 3072kb
> free space on E:" Where this Drive E: is on SAN Storage & as 13GB
> free
> space, i tried "Retry" 3-4 times & getting same error. So i "CANCEL"
> &
> rebooted server to rule out all possibilities & after reboot i
> started
> setup process again came to the same error message that is mentioned
> earlier. even though i have 13GB free space i don't know where the
> problem is. any help is appreciated. thanking in advance.
>
Sounds like a permissions issue.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Friday, March 23, 2012
Installing a Second Instance
Hi,
I'm trying to install a 2nd instance on a cluster.
We've setup two cluster groups C101TC001 and C101TC002, one for each instance.
I've stopped all the services and managed to get the installation to run,
but it won't allow me to apply the Service Pack (3a).
It reports an error
An error has occurred while creating virtual resources for clustering. Can
not create a file when that file already exists.
This then invalidates the instance.
Can anyone assist?
Thanks
Bev
After this I'm unable to get the instance registered or even started.
The error message that you got can be due to various reasons. Here is one Microsoft Knowledge base articles that has the same error (but as I said you may be having a
different issue)
BUG: The Setup program of SQL Server 2000 Service Pack 2 or a later version may stop responding in a Windows clustering environment if there is an offline database
http://support.microsoft.com/default...B;EN-US;320524
This KB says the cause is "This problem occurs because Setup program cannot access the database.
During installation in a Windows Clustering environment, Setup program must query the user databases to make sure that all the database files are on disk resources that
have the correct dependencies and the virtual SQL Server resource. The virtual SQL Server resource is required for the failover support. When a database is offline, Setup
program cannot access the database. "
I understand you are installing SP3a and the above KB is for SP2 but one can still get similar error message.
You last point stated that "After this I'm unable to get the instance registered or even started." I think you will need to first concentrate on why this instance is not starting.
Anyways to be able to apply SP3a, the sql instance needs to be running. So, need to troubleshoot why this instance is not coming online. See what errors you get when
you try to being this SQL Server resource online. Try starting it from command promt and see if that works outside the cluster. The errors in SQL Errorlog, NT App, System
logs and cluster.log should be helpful to troubleshoot this further.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sql
I'm trying to install a 2nd instance on a cluster.
We've setup two cluster groups C101TC001 and C101TC002, one for each instance.
I've stopped all the services and managed to get the installation to run,
but it won't allow me to apply the Service Pack (3a).
It reports an error
An error has occurred while creating virtual resources for clustering. Can
not create a file when that file already exists.
This then invalidates the instance.
Can anyone assist?
Thanks
Bev
After this I'm unable to get the instance registered or even started.
The error message that you got can be due to various reasons. Here is one Microsoft Knowledge base articles that has the same error (but as I said you may be having a
different issue)
BUG: The Setup program of SQL Server 2000 Service Pack 2 or a later version may stop responding in a Windows clustering environment if there is an offline database
http://support.microsoft.com/default...B;EN-US;320524
This KB says the cause is "This problem occurs because Setup program cannot access the database.
During installation in a Windows Clustering environment, Setup program must query the user databases to make sure that all the database files are on disk resources that
have the correct dependencies and the virtual SQL Server resource. The virtual SQL Server resource is required for the failover support. When a database is offline, Setup
program cannot access the database. "
I understand you are installing SP3a and the above KB is for SP2 but one can still get similar error message.
You last point stated that "After this I'm unable to get the instance registered or even started." I think you will need to first concentrate on why this instance is not starting.
Anyways to be able to apply SP3a, the sql instance needs to be running. So, need to troubleshoot why this instance is not coming online. See what errors you get when
you try to being this SQL Server resource online. Try starting it from command promt and see if that works outside the cluster. The errors in SQL Errorlog, NT App, System
logs and cluster.log should be helpful to troubleshoot this further.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way
to do this is to visit the following websites: http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
sql
Wednesday, March 21, 2012
Installed SQLServer 2005 TrialEdition
Hi Fellows,
I am really in a fix.I have downloaded the trial version from MIcrosoft site and run setup with named instance. But I cannot find my management console link anywhere. Can anyone help me here .
My site is : Windows XP Professional SP2
Installed : SQLServer 2005 180Day Trial Pack downloaded from Microsoft Network.
I ran setup from : server directory and also from tools directory.
In my programes menu I can only see Configuration Toolsunder which there are three options :
1) SQL Server Configuration Tool
2) SQL Server Surface Configuration Tool and
3) SQL Server Error and Usage Reporting
Is it SQL Server 2005 Enterprise edition? XP SP2 does not support Enterprise edition. You need server operating systems to support Enterprise edition such as W2K SP4, W2K3 EE SP2, Longhorn Server.
|||I dont know . I just downloaded the server from MSDN site it was an x86 executable file . My PC is a Win XP Professional on our internal Domain .
|||What does the Splash screen tell you ? After calling the installer you should get the splah screen showing the dition type you are trying to install.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
Hi
I just uninstalled everything and run the installer again . It says SQL 2005 Server but does not give anytype of edition. However now I find that the Management Console is appearing in the program menu.
Thanks to all . But I am still mystified as to why it should do like this .
Regards
|||Strange thing, I just started my ISO and it directly gives me the edition type as of [1][1] http://www.sqlserver2005.de/SharedFiles/SplashScreen.jpg
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||Two questions:
1/How did you uninstall everything? I uninstalled in the wrong order from add/remove programs now I am in three quarters installed limbo. [Ghosting the machine seems the simplest way out].
2/I did not get the tools setup to work, or the sample database install in the server directory, the error message was (in both cases)
"The following components that you chose to install are already installed on the machine. To view a report of available options and alternatives click on Details."
Clicking on details was unhelpful (said to maintain components from add/remove programs)
[The components that were already installed did not mention the sample databases]
This is on Windows 2000 SP4, with sqlserver 2005 evaluation edition.
Thank you for your time,
Turloch|||
Hi
I simply went to the Add/remove programs and selected the Microsoft SQL Server 2005 , clicked remove . It asked and it simply removed it clean including the native client etc. Although the Add/Remove page still shows the name it has actually removed the product. To remove the name from the list you will have to select them one by one and click remove. It will prompt you with something like 'This program can only be used for removing installed options' Just click Ok and the entry will go away .
For the tools setup to work when you install you will get a page after the SQL support files and Native client are installed wherein you are asked to choose what you wish to install . Select both the SQL database services as well as the Client tools ( Last option on the page ) then click next .
Regards
|||Thanks...I went add/remove [the wrong sql server component first] and the computer removed the entry in add/remove programs but left the program (mostly) intact [I had to repair .net from the add/remove programs section]
>For
the tools setup to work when you install you will get a page after the
SQL support files and Native client are installed wherein you are asked
to choose what you wish to install . Select both the SQL database
services as well as the Client tools ( Last option on the page ) then
click next .
I still get the error/warning:
"The following
components that you chose to install are already installed on the
machine. To view a report of available options and alternatives click
on Details."
[Component is:
Workstation components, Books Online and development tools 9:00.1399.06]
Maybe I was just unlucky not to choose the databases on my first install.
I can install the sample databases that have there own msi, I suppose I can create a test
database and or try to attach those database files for now, thanks.
Thank you for your time,
Turloch
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
Yes I managed to resolve the problem . Here is what I did
1) Went to Add/Remove programs
2) Select MS SQL Server 2005
3) Clicked on Remove ( It asked me what components I want to remove so I checked Both Database Server and Workgroup Client )
4) Then removed everything else that was MS SQL
5) Re-ran the setup file
Wala .. I had the SQL Server Management Console in the Program List.
Thanks all
Regards
installed sp3a but @@version still says sp2
Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
installed on F:\ (NOT C:). I choose default on the
installation because that is all it gave me, could not
type in. The installation went through and restarted
machine. MDAC got updated, but @.@.version in sql still
gives me 8.00.534.
Looks like databases have a updated modified date on them
bu they all say old version. Where did my update go? Any
files I can check for? Did it install it on C:'
Please help!Look for *.out files. If there are none, run the installation again with
the verbose logging option on (see the readme file for running setup from a
command line to change switches.)
"Kada" <kadahoffman@.hotmail.com> wrote in message
news:01a901c37faa$e952c730$a301280a@.phx.gbl...
> Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
> installed on F:\ (NOT C:). I choose default on the
> installation because that is all it gave me, could not
> type in. The installation went through and restarted
> machine. MDAC got updated, but @.@.version in sql still
> gives me 8.00.534.
> Looks like databases have a updated modified date on them
> bu they all say old version. Where did my update go? Any
> files I can check for? Did it install it on C:'
> Please help!|||Do you mean if I do not see something called sp3_repl.out
and sp3_serv_uni.out? Or what Out files should I see?
Thanks!
>--Original Message--
>Look for *.out files. If there are none, run the
installation again with
>the verbose logging option on (see the readme file for
running setup from a
>command line to change switches.)
>
>
>"Kada" <kadahoffman@.hotmail.com> wrote in message
>news:01a901c37faa$e952c730$a301280a@.phx.gbl...
>> Ran the sp3a (setup.bat) on server from G:\ then MSSQL
is
>> installed on F:\ (NOT C:). I choose default on the
>> installation because that is all it gave me, could not
>> type in. The installation went through and restarted
>> machine. MDAC got updated, but @.@.version in sql still
>> gives me 8.00.534.
>> Looks like databases have a updated modified date on
them
>> bu they all say old version. Where did my update go?
Any
>> files I can check for? Did it install it on C:'
>> Please help!
>
>.
>
installed on F:\ (NOT C:). I choose default on the
installation because that is all it gave me, could not
type in. The installation went through and restarted
machine. MDAC got updated, but @.@.version in sql still
gives me 8.00.534.
Looks like databases have a updated modified date on them
bu they all say old version. Where did my update go? Any
files I can check for? Did it install it on C:'
Please help!Look for *.out files. If there are none, run the installation again with
the verbose logging option on (see the readme file for running setup from a
command line to change switches.)
"Kada" <kadahoffman@.hotmail.com> wrote in message
news:01a901c37faa$e952c730$a301280a@.phx.gbl...
> Ran the sp3a (setup.bat) on server from G:\ then MSSQL is
> installed on F:\ (NOT C:). I choose default on the
> installation because that is all it gave me, could not
> type in. The installation went through and restarted
> machine. MDAC got updated, but @.@.version in sql still
> gives me 8.00.534.
> Looks like databases have a updated modified date on them
> bu they all say old version. Where did my update go? Any
> files I can check for? Did it install it on C:'
> Please help!|||Do you mean if I do not see something called sp3_repl.out
and sp3_serv_uni.out? Or what Out files should I see?
Thanks!
>--Original Message--
>Look for *.out files. If there are none, run the
installation again with
>the verbose logging option on (see the readme file for
running setup from a
>command line to change switches.)
>
>
>"Kada" <kadahoffman@.hotmail.com> wrote in message
>news:01a901c37faa$e952c730$a301280a@.phx.gbl...
>> Ran the sp3a (setup.bat) on server from G:\ then MSSQL
is
>> installed on F:\ (NOT C:). I choose default on the
>> installation because that is all it gave me, could not
>> type in. The installation went through and restarted
>> machine. MDAC got updated, but @.@.version in sql still
>> gives me 8.00.534.
>> Looks like databases have a updated modified date on
them
>> bu they all say old version. Where did my update go?
Any
>> files I can check for? Did it install it on C:'
>> Please help!
>
>.
>
Monday, March 12, 2012
Installation Problems - sqlspars.dll
I'm trying to install Reporting Services onto a Win2k3 SBS from the MSDN CD
pack and cannot get past the initial Setup application.
Looking in the event log, I see the following error:
Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I just install the app onto a different SBS last week without any issues. I
just updated the machine with the latest Hotfixes from Windows Update.
Any info or troubleshooting suggestions would be appreciated.For those who are interested, a solution was found...
Article #840219 - connecting to SQL Server running on Win2k3
"Kevin D" <kevin@.threeriverstech.com> wrote in message
news:%23l$g442TFHA.584@.TK2MSFTNGP15.phx.gbl...
> I'm trying to install Reporting Services onto a Win2k3 SBS from the MSDN
CD
> pack and cannot get past the initial Setup application.
> Looking in the event log, I see the following error:
> Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> I just install the app onto a different SBS last week without any issues.
I
> just updated the machine with the latest Hotfixes from Windows Update.
> Any info or troubleshooting suggestions would be appreciated.
>
pack and cannot get past the initial Setup application.
Looking in the event log, I see the following error:
Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
I just install the app onto a different SBS last week without any issues. I
just updated the machine with the latest Hotfixes from Windows Update.
Any info or troubleshooting suggestions would be appreciated.For those who are interested, a solution was found...
Article #840219 - connecting to SQL Server running on Win2k3
"Kevin D" <kevin@.threeriverstech.com> wrote in message
news:%23l$g442TFHA.584@.TK2MSFTNGP15.phx.gbl...
> I'm trying to install Reporting Services onto a Win2k3 SBS from the MSDN
CD
> pack and cannot get past the initial Setup application.
> Looking in the event log, I see the following error:
> Faulting application SETUP.EXE, version 2000.80.743.0, faulting module
> sqlspars.dll, version 2000.80.743.0, fault address 0x00059cf8.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> I just install the app onto a different SBS last week without any issues.
I
> just updated the machine with the latest Hotfixes from Windows Update.
> Any info or troubleshooting suggestions would be appreciated.
>
Subscribe to:
Posts (Atom)