I just installed MSDE (got successful install msg in Log) but now cannot logon.
I get 'Connection failed SQL State 08001 Error 17
I'm using the SA userid and password I entered upon installing
I'm attempting this via Visual Studio 2003
What could the problem be?
-David
hi David,
mscertified wrote:
> I just installed MSDE (got successful install msg in Log) but now
> cannot logon. I get 'Connection failed SQL State 08001 Error 17
> I'm using the SA userid and password I entered upon installing
> I'm attempting this via Visual Studio 2003
> What could the problem be?
is this a local or remote connection?
try connecting via oSql.exe and verify the full exception you are prompted
with
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Showing posts with label failed. Show all posts
Showing posts with label failed. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
installation steps
hi !!!
i try to connect to my sql server local instance but it is always failed .... can you please tell me the step by steps and options to use to install sql server on my machine and i think i need to use he personal copy rather than the standard as it will be on my machne not in the server? please helpThe way I install SQL Server and any other database on Windows, I don't answer questions Windows ask me during installation because Windows does not know RDBMS and all your installation will complete. So you answer one or two relevant questions and you can install even Oracle. Hope this helps|||
fadil, whichs the OS on which ur trying to install the sql server?
just go thru this ,
http://www.functionx.com/sql/Lesson01.htm
hope this works..
all the best
i try to connect to my sql server local instance but it is always failed .... can you please tell me the step by steps and options to use to install sql server on my machine and i think i need to use he personal copy rather than the standard as it will be on my machne not in the server? please helpThe way I install SQL Server and any other database on Windows, I don't answer questions Windows ask me during installation because Windows does not know RDBMS and all your installation will complete. So you answer one or two relevant questions and you can install even Oracle. Hope this helps|||
thanks for reply .... but there is a reply to those questions in choosing options.... can you tell me in each step what shal i choose ?
|||When you are asked what option don't choose custom and the only other question that is relevant to you is the account to use to install and being a developer use the local system account and you can install the personal in less than five minutes. When you answer questions Windows checks those against what is in its database and end your installation. Hope this helps.|||let me expalin toyou the problem...i have machine at work i installed sql server before it was fine ...i did the same thing in my machine at home it does not work ..i can nto connect to the database.... can you please help i try connectionstrings.com and i tried different things still does not work .. please help !!|||In Visual Studio use the datalink property and use integrated security, all the answers I have been giving you are to install the database. And post your error so it can be investigated. Hope this helps.|||Hi,
fadil, whichs the OS on which ur trying to install the sql server?
just go thru this ,
http://www.functionx.com/sql/Lesson01.htm
hope this works..
all the best
Installation SQL-Cluster failed
Hi,
we are trying to install "SQL-Server Version 8.00.780 SP3" on a Win2003
2-node Cluster. The Installation breaks, and in the sqlstp.log we find the
Message "remsetup.exe not find". In the Knowledge Base we find problems with
Terminal Service (no TS installed) and with special character in connection
names (the names are public and private). We have log in as a domain admin
and the sql engine and the agent are started with a domain admin.
1.copyexe=cnvsvc1.exe
08:28:41 Setup is performing required operations on cluster nodes. This may
take a few minutes...
08:28:41 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
08:30:14 Process Exit Code: (2) The system cannot find the file specified.
08:30:14 Begin Action : GetRemsetupRetCode
08:30:14 Installation return status on OBELIX : 2
08:30:14 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 05/14/04 08:28:41 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x74] created for execution.
CThread::Process [0x74]
CThreadPool::RunUntilCompleteHlpr start thread [0x74],index=0
Script file copied to '\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss' successfully.
Installing remote service (OBELIX)...
Running '\\ASTERIX\Z$\x86\setup\setupsql.exe k=ClSec k=Rm k=Cl -SMS -s -f
"\\ASTERIX\Z$\x86\setup\setup.ins" -f1
\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss -f2 "\\OBELIX\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (OBELIX) ...
CRemoteProcess::RunUntilComplete [0x74] exit code: 2
Remote process exit code was '2' (OBELIX).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x74]
Thread [0x74] exit code: [0x2]
CThreadPool::RunUntilComplete returned 2
CThreadPool::RunUntilComplete execution level=1, need execution: 0
One or more errors occurred while running the remote/unattended setups.
Disconnecting from remote machine (OBELIX)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 05/14/04 08:30:14 ####
08:30:14 End Action : Run setup on cluster nodes
08:30:14 One or more errors occurred while running remote setup on the
clustered machines.
08:30:28 Setup failed to perform required operations on the cluster nodes.
08:30:28 Begin Action : ClusterErrorCleanup
08:30:28 End Action : ClusterErrorCleanup
08:30:28 End Action : ClusterSetupHelper
Thank you for help.
Sound to me like your MS cluster isn't installed correctly.
Have you carried out the tests suggested in the Cluster checklist?
If you are happy with the installation try copying the remsetup.ini file from the user dir as mentioned in KB301520.
|||Try these steps to see if you can resolve the problem:
1) Check and see if the machine is configured to disallow 8.3 name creation
by
checking the following registry key:
HKLM\SYSTEM\CURRENTCONTROLSET\CONTROL\FileSystem\N tfsDisable8dot3NameCreatio
n
A value of 1 means this is disabled and hence change it back to 0. This
requires a
reboot for it to take effect
OR
2) Change the TEMP and TMP User Environment Variables to a path that does
not have
spaces in them. For example: c:\temp. Use the SET command to verify the new
TEMP
location is in effect. This does not require a reboot
Rand
This posting is provided "as is" with no warranties and confers no rights.
we are trying to install "SQL-Server Version 8.00.780 SP3" on a Win2003
2-node Cluster. The Installation breaks, and in the sqlstp.log we find the
Message "remsetup.exe not find". In the Knowledge Base we find problems with
Terminal Service (no TS installed) and with special character in connection
names (the names are public and private). We have log in as a domain admin
and the sql engine and the agent are started with a domain admin.
1.copyexe=cnvsvc1.exe
08:28:41 Setup is performing required operations on cluster nodes. This may
take a few minutes...
08:28:41 C:\WINDOWS\TEMP\SqlSetup\Bin\remsetup.exe C:\WINDOWS\remsetup.ini
08:30:14 Process Exit Code: (2) The system cannot find the file specified.
08:30:14 Begin Action : GetRemsetupRetCode
08:30:14 Installation return status on OBELIX : 2
08:30:14 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 05/14/04 08:28:41 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x74] created for execution.
CThread::Process [0x74]
CThreadPool::RunUntilCompleteHlpr start thread [0x74],index=0
Script file copied to '\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss' successfully.
Installing remote service (OBELIX)...
Running '\\ASTERIX\Z$\x86\setup\setupsql.exe k=ClSec k=Rm k=Cl -SMS -s -f
"\\ASTERIX\Z$\x86\setup\setup.ins" -f1
\\OBELIX\ADMIN$\OBELIX_MSSQLSERVER.iss -f2 "\\OBELIX\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (OBELIX) ...
CRemoteProcess::RunUntilComplete [0x74] exit code: 2
Remote process exit code was '2' (OBELIX).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x74]
Thread [0x74] exit code: [0x2]
CThreadPool::RunUntilComplete returned 2
CThreadPool::RunUntilComplete execution level=1, need execution: 0
One or more errors occurred while running the remote/unattended setups.
Disconnecting from remote machine (OBELIX)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 05/14/04 08:30:14 ####
08:30:14 End Action : Run setup on cluster nodes
08:30:14 One or more errors occurred while running remote setup on the
clustered machines.
08:30:28 Setup failed to perform required operations on the cluster nodes.
08:30:28 Begin Action : ClusterErrorCleanup
08:30:28 End Action : ClusterErrorCleanup
08:30:28 End Action : ClusterSetupHelper
Thank you for help.
Sound to me like your MS cluster isn't installed correctly.
Have you carried out the tests suggested in the Cluster checklist?
If you are happy with the installation try copying the remsetup.ini file from the user dir as mentioned in KB301520.
|||Try these steps to see if you can resolve the problem:
1) Check and see if the machine is configured to disallow 8.3 name creation
by
checking the following registry key:
HKLM\SYSTEM\CURRENTCONTROLSET\CONTROL\FileSystem\N tfsDisable8dot3NameCreatio
n
A value of 1 means this is disabled and hence change it back to 0. This
requires a
reboot for it to take effect
OR
2) Change the TEMP and TMP User Environment Variables to a path that does
not have
spaces in them. For example: c:\temp. Use the SET command to verify the new
TEMP
location is in effect. This does not require a reboot
Rand
This posting is provided "as is" with no warranties and confers no rights.
Installation SQL Server 2k Cluster on Windows 2003 failed. Please help.
Hello group,
today we tried to install a SQL 2k cluster very unsuccessfully. Would
need your support.
What we have:
2 Server (node 1, node 2) with external storage installed as a cluster
(MSCS). Partitions are C (for node 1 and 2), e and q (quorum db) - both
on the external storage.
OS is Windows 2003 Enterprise
We copied the installfiles to C:\temp on node1 and made a share. Node2
can access this share.
Antivirus was disabled.
We started the installation with a domainaccount that has local
administrative rights on both nodes and can be started as a service.
As installation target for the program we chosed C:... and the data
should be stored on e:...
Installation started - we gave the virtual server a different name than
the cluster and a free ip adress. Both nodes were seen during the next
steps and we gave an instancename like "DECGNWSSQL20007". Licensing was
choosen as 2CPU.
When the server should start the installation, it immediately stopped
with the message: Setup failed to perform required operations on the
cluster nodes.
We don=B4t have any clue how to continue. Could need your help.
Thanks in advance
Stefan
The error message "Setup failed to perform required operations on the cluster nodes." is a generic message. To understand where the setup failed, one has to review the sqlstp.log (search for this on the node
where you ran the setup). Based on this file, you will know where the error occurred and then accordingly you may need to review additional logs like sqlstpN.log (where N is an integer) on one/both nodes,
sqlclstr.log, cluster.log.
For detailed information on troubleshooting setup failures on cluster, please review
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
The above webcast may not give you the solution but will give you steps that you can use to troubleshoot and find the solution using Microsoft Knowledge Base articles.
Also, make sure that you have all the pre-reqs of installing SQL 2K on Win2K3. A list of pre-reqs and other related info can be found at
TechNet Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
If you need more help, feel free to post your questions.
HTH,
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
|||Hi,
what IU inbetween found out is that the installed Terminal Server caused
the problems. Now the installation starts fine, runs and finishes with
the message that the "Virtual server cannot go online". Then the
uninstall started automatically. Do you know more about this problem? Is
it why we try to install SP2 first and then to update to SP3?
Thanks in advance
Stefan
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You cannot run a SQL Cluster and Terminal Server on the same system.
SQL Server 2000 cluster does not install on Windows Server 2003-based
computers where Terminal Services is installed
http://support.microsoft.com/default...b;en-us;301520
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Stefan Gsundbrunn" <info@.gsundbrunn.de> wrote in message
news:uPYXood7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Hi,
> what IU inbetween found out is that the installed Terminal Server caused
> the problems. Now the installation starts fine, runs and finishes with
> the message that the "Virtual server cannot go online". Then the
> uninstall started automatically. Do you know more about this problem? Is
> it why we try to install SP2 first and then to update to SP3?
> Thanks in advance
> Stefan
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi,
> You cannot run a SQL Cluster and Terminal Server on the same system.
Yes, as mentioned I deinstalled Terminal Server and then the installation
started. But: At the end of the installation the message appeared like
"Virtual server cannot go online" and automatically the desintallation
starts. I don′t have any clue for the reason. Does anybody know how to fix?
Thanks in advance!
Stefan
> SQL Server 2000 cluster does not install on Windows Server 2003-based
> computers where Terminal Services is installed
> http://support.microsoft.com/default...b;en-us;301520
>
--
Stefan Gsundbrunn
Project Design - Software Design - Brain Design
http://www.gsundbrunn.de
Cell: +49.173.3426906
|||Stefan,
Looks like the unattended installation on all cluster nodes succeeded and failed during the virtual resources creation step. Ofcourse check sqlstp.log to find out where exactly the issue is. If indeed it failed during the
virtual server resources section then you will need to review sqlclstr.log and cluster.log to get to the root cause.
Additional Information
=====================
TechNet Support WebCast:
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
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
today we tried to install a SQL 2k cluster very unsuccessfully. Would
need your support.
What we have:
2 Server (node 1, node 2) with external storage installed as a cluster
(MSCS). Partitions are C (for node 1 and 2), e and q (quorum db) - both
on the external storage.
OS is Windows 2003 Enterprise
We copied the installfiles to C:\temp on node1 and made a share. Node2
can access this share.
Antivirus was disabled.
We started the installation with a domainaccount that has local
administrative rights on both nodes and can be started as a service.
As installation target for the program we chosed C:... and the data
should be stored on e:...
Installation started - we gave the virtual server a different name than
the cluster and a free ip adress. Both nodes were seen during the next
steps and we gave an instancename like "DECGNWSSQL20007". Licensing was
choosen as 2CPU.
When the server should start the installation, it immediately stopped
with the message: Setup failed to perform required operations on the
cluster nodes.
We don=B4t have any clue how to continue. Could need your help.
Thanks in advance
Stefan
The error message "Setup failed to perform required operations on the cluster nodes." is a generic message. To understand where the setup failed, one has to review the sqlstp.log (search for this on the node
where you ran the setup). Based on this file, you will know where the error occurred and then accordingly you may need to review additional logs like sqlstpN.log (where N is an integer) on one/both nodes,
sqlclstr.log, cluster.log.
For detailed information on troubleshooting setup failures on cluster, please review
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
The above webcast may not give you the solution but will give you steps that you can use to troubleshoot and find the solution using Microsoft Knowledge Base articles.
Also, make sure that you have all the pre-reqs of installing SQL 2K on Win2K3. A list of pre-reqs and other related info can be found at
TechNet Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
If you need more help, feel free to post your questions.
HTH,
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
|||Hi,
what IU inbetween found out is that the installed Terminal Server caused
the problems. Now the installation starts fine, runs and finishes with
the message that the "Virtual server cannot go online". Then the
uninstall started automatically. Do you know more about this problem? Is
it why we try to install SP2 first and then to update to SP3?
Thanks in advance
Stefan
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||You cannot run a SQL Cluster and Terminal Server on the same system.
SQL Server 2000 cluster does not install on Windows Server 2003-based
computers where Terminal Services is installed
http://support.microsoft.com/default...b;en-us;301520
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Stefan Gsundbrunn" <info@.gsundbrunn.de> wrote in message
news:uPYXood7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Hi,
> what IU inbetween found out is that the installed Terminal Server caused
> the problems. Now the installation starts fine, runs and finishes with
> the message that the "Virtual server cannot go online". Then the
> uninstall started automatically. Do you know more about this problem? Is
> it why we try to install SP2 first and then to update to SP3?
> Thanks in advance
> Stefan
>
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Hi,
> You cannot run a SQL Cluster and Terminal Server on the same system.
Yes, as mentioned I deinstalled Terminal Server and then the installation
started. But: At the end of the installation the message appeared like
"Virtual server cannot go online" and automatically the desintallation
starts. I don′t have any clue for the reason. Does anybody know how to fix?
Thanks in advance!
Stefan
> SQL Server 2000 cluster does not install on Windows Server 2003-based
> computers where Terminal Services is installed
> http://support.microsoft.com/default...b;en-us;301520
>
--
Stefan Gsundbrunn
Project Design - Software Design - Brain Design
http://www.gsundbrunn.de
Cell: +49.173.3426906
|||Stefan,
Looks like the unattended installation on all cluster nodes succeeded and failed during the virtual resources creation step. Ofcourse check sqlstp.log to find out where exactly the issue is. If indeed it failed during the
virtual server resources section then you will need to review sqlclstr.log and cluster.log to get to the root cause.
Additional Information
=====================
TechNet Support WebCast:
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
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
Installation SQL Server 2005 Express Edition
My Installation failed for the SQL Server. Is it true that the SQL Server is running only in Windows XP Prof with Service Pack 2.
Thanks!
Hi,That is correct. The software requirements have been explicitly mentioned as Windows XP Service Pack 2 on the download page here.
Regards,
Vikram
Monday, March 12, 2012
Installation problem
I have tried several times to install SQL Exress and get the same failure all the time. The first time it failed was when I was trying to install the VB Express Edition. Recently I downloaded the VB Express 2008 edition, which installed without any problems. When SQL Express tried to install it failed with an error that just says 'SQL Server setup unexpectedly failed, review the summary.txt in the setup log'. I went to that file and below is what it says.
SQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Wed Jun 27 01:18:21 2007
This is the only thing in the summar.txt file. It is in /program files/Microsoft SQL Server/90/Setup Bootstrap/summary.txt .
Is there any way to get this program to instll?
Thanks,
Fred
Are there any files located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files?
Mike
|||There are .cab files from each time that I tried to install and then in a folder 'files', there are a series of .xml files that all start with "SQLSetup0023_MRHOME_Datastore.XML", it is a 4kb file that I can't open to view. The only difference is the series of numbers, I guess for each attempt in setup. There is also a "SQLSetup0023_MRHOME_Core.log" that is empty
Thanks,
Fred
|||Open the most recent cab file and see if there is anything inside other than what you've already seen. You're looking for more detailed log files for the various components that tried to install.
Have you tried to install SQL Express in any way other than through Visual Studio? They are using the exact same bits that can be downloaded from the web, but if you haven't tried, it might be worth installing SQL Expres using the setup UI rather than from the command line as VS is doing. You can download the package from http://msdn.microsoft.com/vstudio/express/sql/downloads.
Mike
|||SQLSetUp0023.cab holdsSQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
My installation tries recently have been with the downloaded SQLEXPR.exe that was downloaded from Microsoft. It creates the same error.
Is there anyway I can send you the .XML file for you to examine?
Sorry for the delay in response, but the forums would not let me respond for the last 2 days.
Any idea what is happening?
Thanks,
Fred Blar|||
Hi Fred,
The XML file doesn't contain any information that would be of value so there isn't any point in sending it in. This one is kind of a stumper since setup is not even getting to a point where it's creating logs to indicate what is wrong. Do you get any error message during setup when the failure happens? If so, could you respond with the exact and full text of the error message?
Also, what step of setup are you on when the failure happens.
Mike
|||The steps are hard to see, they go so fast. It is extracting files from Setup/Program Files/Microsoft SQL and putting them into a temp file on the C drive; it is C: and then a lot of letters and numbers.
Then it just stops with the error message below.
"SQL Server Setup" unexpectedly failed. For more information, review the Setup Summary Log in %Program Files%\Microsoft SQL Server\90\Setup\Bootstrap\LOF\summary.txt "
The summary.txt is the file that I placed in the original question. It only shows what program was running, no extra data.
I there another version of the Express product on the near horizon? I had a similar problem with the VB Express installation, it would not install the 'templates'. Everything looked like it ran completely, but the templates were not there when I wanted to start a new project.
I downloaded the 'Orcas' version and everything installed fine with the 2008 version.
Thanks,
Fred
Installation problem
I have tried several times to install SQL Exress and get the same failure all the time. The first time it failed was when I was trying to install the VB Express Edition. Recently I downloaded the VB Express 2008 edition, which installed without any problems. When SQL Express tried to install it failed with an error that just says 'SQL Server setup unexpectedly failed, review the summary.txt in the setup log'. I went to that file and below is what it says.
SQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Wed Jun 27 01:18:21 2007
This is the only thing in the summar.txt file. It is in /program files/Microsoft SQL Server/90/Setup Bootstrap/summary.txt .
Is there any way to get this program to instll?
Thanks,
Fred
Are there any files located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files?
Mike
|||There are .cab files from each time that I tried to install and then in a folder 'files', there are a series of .xml files that all start with "SQLSetup0023_MRHOME_Datastore.XML", it is a 4kb file that I can't open to view. The only difference is the series of numbers, I guess for each attempt in setup. There is also a "SQLSetup0023_MRHOME_Core.log" that is empty
Thanks,
Fred
|||Open the most recent cab file and see if there is anything inside other than what you've already seen. You're looking for more detailed log files for the various components that tried to install.
Have you tried to install SQL Express in any way other than through Visual Studio? They are using the exact same bits that can be downloaded from the web, but if you haven't tried, it might be worth installing SQL Expres using the setup UI rather than from the command line as VS is doing. You can download the package from http://msdn.microsoft.com/vstudio/express/sql/downloads.
Mike
|||SQLSetUp0023.cab holdsSQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
My installation tries recently have been with the downloaded SQLEXPR.exe that was downloaded from Microsoft. It creates the same error.
Is there anyway I can send you the .XML file for you to examine?
Sorry for the delay in response, but the forums would not let me respond for the last 2 days.
Any idea what is happening?
Thanks,
Fred Blar|||
Hi Fred,
The XML file doesn't contain any information that would be of value so there isn't any point in sending it in. This one is kind of a stumper since setup is not even getting to a point where it's creating logs to indicate what is wrong. Do you get any error message during setup when the failure happens? If so, could you respond with the exact and full text of the error message?
Also, what step of setup are you on when the failure happens.
Mike
|||The steps are hard to see, they go so fast. It is extracting files from Setup/Program Files/Microsoft SQL and putting them into a temp file on the C drive; it is C: and then a lot of letters and numbers.
Then it just stops with the error message below.
"SQL Server Setup" unexpectedly failed. For more information, review the Setup Summary Log in %Program Files%\Microsoft SQL Server\90\Setup\Bootstrap\LOF\summary.txt "
The summary.txt is the file that I placed in the original question. It only shows what program was running, no extra data.
I there another version of the Express product on the near horizon? I had a similar problem with the VB Express installation, it would not install the 'templates'. Everything looked like it ran completely, but the templates were not there when I wanted to start a new project.
I downloaded the 'Orcas' version and everything installed fine with the 2008 version.
Thanks,
Fred
Installation problem
I have tried several times to install SQL Exress and get the same failure all the time. The first time it failed was when I was trying to install the VB Express Edition. Recently I downloaded the VB Express 2008 edition, which installed without any problems. When SQL Express tried to install it failed with an error that just says 'SQL Server setup unexpectedly failed, review the summary.txt in the setup log'. I went to that file and below is what it says.
SQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Wed Jun 27 01:18:21 2007
This is the only thing in the summar.txt file. It is in /program files/Microsoft SQL Server/90/Setup Bootstrap/summary.txt .
Is there any way to get this program to instll?
Thanks,
Fred
Are there any files located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files?
Mike
|||There are .cab files from each time that I tried to install and then in a folder 'files', there are a series of .xml files that all start with "SQLSetup0023_MRHOME_Datastore.XML", it is a 4kb file that I can't open to view. The only difference is the series of numbers, I guess for each attempt in setup. There is also a "SQLSetup0023_MRHOME_Core.log" that is empty
Thanks,
Fred
|||Open the most recent cab file and see if there is anything inside other than what you've already seen. You're looking for more detailed log files for the various components that tried to install.
Have you tried to install SQL Express in any way other than through Visual Studio? They are using the exact same bits that can be downloaded from the web, but if you haven't tried, it might be worth installing SQL Expres using the setup UI rather than from the command line as VS is doing. You can download the package from http://msdn.microsoft.com/vstudio/express/sql/downloads.
Mike
|||SQLSetUp0023.cab holdsSQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
My installation tries recently have been with the downloaded SQLEXPR.exe that was downloaded from Microsoft. It creates the same error.
Is there anyway I can send you the .XML file for you to examine?
Sorry for the delay in response, but the forums would not let me respond for the last 2 days.
Any idea what is happening?
Thanks,
Fred Blar|||
Hi Fred,
The XML file doesn't contain any information that would be of value so there isn't any point in sending it in. This one is kind of a stumper since setup is not even getting to a point where it's creating logs to indicate what is wrong. Do you get any error message during setup when the failure happens? If so, could you respond with the exact and full text of the error message?
Also, what step of setup are you on when the failure happens.
Mike
|||The steps are hard to see, they go so fast. It is extracting files from Setup/Program Files/Microsoft SQL and putting them into a temp file on the C drive; it is C: and then a lot of letters and numbers.
Then it just stops with the error message below.
"SQL Server Setup" unexpectedly failed. For more information, review the Setup Summary Log in %Program Files%\Microsoft SQL Server\90\Setup\Bootstrap\LOF\summary.txt "
The summary.txt is the file that I placed in the original question. It only shows what program was running, no extra data.
I there another version of the Express product on the near horizon? I had a similar problem with the VB Express installation, it would not install the 'templates'. Everything looked like it ran completely, but the templates were not there when I wanted to start a new project.
I downloaded the 'Orcas' version and everything installed fine with the 2008 version.
Thanks,
Fred
Installation problem
I have tried several times to install SQL Exress and get the same failure all the time. The first time it failed was when I was trying to install the VB Express Edition. Recently I downloaded the VB Express 2008 edition, which installed without any problems. When SQL Express tried to install it failed with an error that just says 'SQL Server setup unexpectedly failed, review the summary.txt in the setup log'. I went to that file and below is what it says.
SQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Wed Jun 27 01:18:21 2007
This is the only thing in the summar.txt file. It is in /program files/Microsoft SQL Server/90/Setup Bootstrap/summary.txt .
Is there any way to get this program to instll?
Thanks,
Fred
Are there any files located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files?
Mike
|||There are .cab files from each time that I tried to install and then in a folder 'files', there are a series of .xml files that all start with "SQLSetup0023_MRHOME_Datastore.XML", it is a 4kb file that I can't open to view. The only difference is the series of numbers, I guess for each attempt in setup. There is also a "SQLSetup0023_MRHOME_Core.log" that is empty
Thanks,
Fred
|||Open the most recent cab file and see if there is anything inside other than what you've already seen. You're looking for more detailed log files for the various components that tried to install.
Have you tried to install SQL Express in any way other than through Visual Studio? They are using the exact same bits that can be downloaded from the web, but if you haven't tried, it might be worth installing SQL Expres using the setup UI rather than from the command line as VS is doing. You can download the package from http://msdn.microsoft.com/vstudio/express/sql/downloads.
Mike
|||SQLSetUp0023.cab holdsSQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
My installation tries recently have been with the downloaded SQLEXPR.exe that was downloaded from Microsoft. It creates the same error.
Is there anyway I can send you the .XML file for you to examine?
Sorry for the delay in response, but the forums would not let me respond for the last 2 days.
Any idea what is happening?
Thanks,
Fred Blar|||
Hi Fred,
The XML file doesn't contain any information that would be of value so there isn't any point in sending it in. This one is kind of a stumper since setup is not even getting to a point where it's creating logs to indicate what is wrong. Do you get any error message during setup when the failure happens? If so, could you respond with the exact and full text of the error message?
Also, what step of setup are you on when the failure happens.
Mike
|||The steps are hard to see, they go so fast. It is extracting files from Setup/Program Files/Microsoft SQL and putting them into a temp file on the C drive; it is C: and then a lot of letters and numbers.
Then it just stops with the error message below.
"SQL Server Setup" unexpectedly failed. For more information, review the Setup Summary Log in %Program Files%\Microsoft SQL Server\90\Setup\Bootstrap\LOF\summary.txt "
The summary.txt is the file that I placed in the original question. It only shows what program was running, no extra data.
I there another version of the Express product on the near horizon? I had a similar problem with the VB Express installation, it would not install the 'templates'. Everything looked like it ran completely, but the templates were not there when I wanted to start a new project.
I downloaded the 'Orcas' version and everything installed fine with the 2008 version.
Thanks,
Fred
Installation problem
I have tried several times to install SQL Exress and get the same failure all the time. The first time it failed was when I was trying to install the VB Express Edition. Recently I downloaded the VB Express 2008 edition, which installed without any problems. When SQL Express tried to install it failed with an error that just says 'SQL Server setup unexpectedly failed, review the summary.txt in the setup log'. I went to that file and below is what it says.
SQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Wed Jun 27 01:18:21 2007
This is the only thing in the summar.txt file. It is in /program files/Microsoft SQL Server/90/Setup Bootstrap/summary.txt .
Is there any way to get this program to instll?
Thanks,
Fred
Are there any files located in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files?
Mike
|||There are .cab files from each time that I tried to install and then in a folder 'files', there are a series of .xml files that all start with "SQLSetup0023_MRHOME_Datastore.XML", it is a 4kb file that I can't open to view. The only difference is the series of numbers, I guess for each attempt in setup. There is also a "SQLSetup0023_MRHOME_Core.log" that is empty
Thanks,
Fred
|||Open the most recent cab file and see if there is anything inside other than what you've already seen. You're looking for more detailed log files for the various components that tried to install.
Have you tried to install SQL Express in any way other than through Visual Studio? They are using the exact same bits that can be downloaded from the web, but if you haven't tried, it might be worth installing SQL Expres using the setup UI rather than from the command line as VS is doing. You can download the package from http://msdn.microsoft.com/vstudio/express/sql/downloads.
Mike
|||SQLSetUp0023.cab holdsSQLSetUp0023_MRHOME_Datastore.XML and a SQLSetUp0023_MRHOME_Core.log .
The '.log' file is empty and I can't open the XML file.
My installation tries recently have been with the downloaded SQLEXPR.exe that was downloaded from Microsoft. It creates the same error.
Is there anyway I can send you the .XML file for you to examine?
Sorry for the delay in response, but the forums would not let me respond for the last 2 days.
Any idea what is happening?
Thanks,
Fred Blar|||
Hi Fred,
The XML file doesn't contain any information that would be of value so there isn't any point in sending it in. This one is kind of a stumper since setup is not even getting to a point where it's creating logs to indicate what is wrong. Do you get any error message during setup when the failure happens? If so, could you respond with the exact and full text of the error message?
Also, what step of setup are you on when the failure happens.
Mike
|||The steps are hard to see, they go so fast. It is extracting files from Setup/Program Files/Microsoft SQL and putting them into a temp file on the C drive; it is C: and then a lot of letters and numbers.
Then it just stops with the error message below.
"SQL Server Setup" unexpectedly failed. For more information, review the Setup Summary Log in %Program Files%\Microsoft SQL Server\90\Setup\Bootstrap\LOF\summary.txt "
The summary.txt is the file that I placed in the original question. It only shows what program was running, no extra data.
I there another version of the Express product on the near horizon? I had a similar problem with the VB Express installation, it would not install the 'templates'. Everything looked like it ran completely, but the templates were not there when I wanted to start a new project.
I downloaded the 'Orcas' version and everything installed fine with the 2008 version.
Thanks,
Fred
Wednesday, March 7, 2012
Installation of MS SQL SP3 failed
Hello,
We have a problem installing SP3 on some machines. We get
the following error:
"There is not enough space on drive C:\ to extract this
package. Please free up 109.41 MB and click Retry."
We found a Microsoft Knowledge Base Article - No. 301913
on this problem, but it gives a workaround that is not
helpfull for us:
"To work around this problem, add or delete files on your
computer so that the free disk space is not a multiple of
4-gigabytes."
Is there another solution/workaround for this problem?
The link for the articale is:
http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/Q3
01/9/13.ASP&NoWebContent=1
Thanks,
ShiriSP3a fixes problems with the installation of SP3. Suggest going straight to
SP3a
--
HTH
Ryan Waight, MCDBA, MCSE
<Shiri.Tzuk@.verint.com> wrote in message
news:093201c3a7a0$bd103db0$a501280a@.phx.gbl...
> Hello,
> We have a problem installing SP3 on some machines. We get
> the following error:
> "There is not enough space on drive C:\ to extract this
> package. Please free up 109.41 MB and click Retry."
> We found a Microsoft Knowledge Base Article - No. 301913
> on this problem, but it gives a workaround that is not
> helpfull for us:
> "To work around this problem, add or delete files on your
> computer so that the free disk space is not a multiple of
> 4-gigabytes."
> Is there another solution/workaround for this problem?
> The link for the articale is:
> http://support.microsoft.com/default.aspx?
> scid=http://support.microsoft.com:80/support/kb/articles/Q3
> 01/9/13.ASP&NoWebContent=1
> Thanks,
> Shiri
>|||Shiri - why can you not manually use some space up?
> We have a problem installing SP3 on some machines. We get
> the following error:
> "There is not enough space on drive C:\ to extract this
> package. Please free up 109.41 MB and click Retry."
> We found a Microsoft Knowledge Base Article - No. 301913
> on this problem, but it gives a workaround that is not
> helpfull for us:
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
We have a problem installing SP3 on some machines. We get
the following error:
"There is not enough space on drive C:\ to extract this
package. Please free up 109.41 MB and click Retry."
We found a Microsoft Knowledge Base Article - No. 301913
on this problem, but it gives a workaround that is not
helpfull for us:
"To work around this problem, add or delete files on your
computer so that the free disk space is not a multiple of
4-gigabytes."
Is there another solution/workaround for this problem?
The link for the articale is:
http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:80/support/kb/articles/Q3
01/9/13.ASP&NoWebContent=1
Thanks,
ShiriSP3a fixes problems with the installation of SP3. Suggest going straight to
SP3a
--
HTH
Ryan Waight, MCDBA, MCSE
<Shiri.Tzuk@.verint.com> wrote in message
news:093201c3a7a0$bd103db0$a501280a@.phx.gbl...
> Hello,
> We have a problem installing SP3 on some machines. We get
> the following error:
> "There is not enough space on drive C:\ to extract this
> package. Please free up 109.41 MB and click Retry."
> We found a Microsoft Knowledge Base Article - No. 301913
> on this problem, but it gives a workaround that is not
> helpfull for us:
> "To work around this problem, add or delete files on your
> computer so that the free disk space is not a multiple of
> 4-gigabytes."
> Is there another solution/workaround for this problem?
> The link for the articale is:
> http://support.microsoft.com/default.aspx?
> scid=http://support.microsoft.com:80/support/kb/articles/Q3
> 01/9/13.ASP&NoWebContent=1
> Thanks,
> Shiri
>|||Shiri - why can you not manually use some space up?
> We have a problem installing SP3 on some machines. We get
> the following error:
> "There is not enough space on drive C:\ to extract this
> package. Please free up 109.41 MB and click Retry."
> We found a Microsoft Knowledge Base Article - No. 301913
> on this problem, but it gives a workaround that is not
> helpfull for us:
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
Friday, February 24, 2012
installation fails on xp home - failed to configure server
Hi,
First I attemtped to upgrade MSDE to sp4, and I got the error
"This product is not installed",
So I removed the installation of MSDE and just installed sp4 directly. But
when I do, I get the error
"Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (A4!4C) [12:01:18:241]: Product: Microsoft SQL Server Desktop Engine
(VLM) -- Setup failed to configure the server. Refer to the server error
logs and setup error logs for more information."
The only other line in the log that metions a failure is
Setting SqlEdition property failed
The installer then backs everthing out and removes the service. The service
was already installed and running at that point.
I am using SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE to install,
Thanks,
Brian
hi Brian,
msnews.microsoft.com wrote:
> Hi,
> First I attemtped to upgrade MSDE to sp4, and I got the error
> "This product is not installed",
> So I removed the installation of MSDE and just installed sp4
> directly. But when I do, I get the error
> "Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> MSI (s) (A4!4C) [12:01:18:241]: Product: Microsoft SQL Server Desktop
> Engine (VLM) -- Setup failed to configure the server. Refer to the
> server error logs and setup error logs for more information."
> The only other line in the log that metions a failure is
> Setting SqlEdition property failed
> The installer then backs everthing out and removes the service. The
> service was already installed and running at that point.
> I am using SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE to install,
this usually means you did not comletely uninstall MSDE (not your fault,
just MSDE fault :D)
I succesfully cleared my registry and file system following
http://support.microsoft.com/default...b;en-us;290991 KB article
adiveces but the Windows Installer entries, that can be cleared using the
Windows Installer SDK tool Msizap.exe as per
http://support.microsoft.com/default...b;en-us;320873 (never tried)
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
|||Got it fixed.
To get it to work I did the following:
1. Intalled a default instance. I had removed it as well. That worked.
2. re-registering sqldmo.dll. I did this because DbaMgr got an automation
error when connecting to the default instance
3. Installed the named instance I wanted. This time it worked.
Notes:
The error I was getting was
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
Things learned along the way:
1. If the install fails, then enable verbose logging with /L*v
C:\MSDELog.log. Look in the log when its finished for what failed. When you
get the error message box, LEAVE IT THERE, and go look at the log. The last
thing it did is the last line.
2. If you get the error "Unable to configure server", then look in the file
cnfgsvr.out. It will be in C:\Program files\Microsoft SQL
Server\MSSQL$<instancename>\Inatall (assuming drive c)
3. To clean manully to get the installer to resintall completely if a
partial install is left on the system:
- Run Windows Installer SDK tool Msizap.exe as per
http://support.microsoft.com/default...b;en-us;320873
The command is MSIZAP.EXE" T {product code}. The product code can be
found in the install log (C:\MSDELog.log in the example above). The product
code for MDSE service pack 4 was
{E09B48B5-E141-427A-AB0C-D3605127224A} so I ran
MSIZAP.EXE" T {E09B48B5-E141-427A-AB0C-D3605127224A}
- Manually delete the folder C:\Program Files\Microsoft SQL Server\MSSQL
or C:\Program Files\Microsoft SQL Server\MSSQL$<instancename>. Make sure you
look at cnfgsvr.out first if you need too!
Brian
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3s9k91Fn804jU1@.individual.net...
> hi Brian,
> msnews.microsoft.com wrote:
> this usually means you did not comletely uninstall MSDE (not your fault,
> just MSDE fault :D)
> I succesfully cleared my registry and file system following
> http://support.microsoft.com/default...b;en-us;290991 KB article
> adiveces but the Windows Installer entries, that can be cleared using the
> Windows Installer SDK tool Msizap.exe as per
> http://support.microsoft.com/default...b;en-us;320873 (never
> tried)
> --
> 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
>
First I attemtped to upgrade MSDE to sp4, and I got the error
"This product is not installed",
So I removed the installation of MSDE and just installed sp4 directly. But
when I do, I get the error
"Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
MSI (s) (A4!4C) [12:01:18:241]: Product: Microsoft SQL Server Desktop Engine
(VLM) -- Setup failed to configure the server. Refer to the server error
logs and setup error logs for more information."
The only other line in the log that metions a failure is
Setting SqlEdition property failed
The installer then backs everthing out and removes the service. The service
was already installed and running at that point.
I am using SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE to install,
Thanks,
Brian
hi Brian,
msnews.microsoft.com wrote:
> Hi,
> First I attemtped to upgrade MSDE to sp4, and I got the error
> "This product is not installed",
> So I removed the installation of MSDE and just installed sp4
> directly. But when I do, I get the error
> "Setup failed to configure the server. Refer to the server error logs
> and setup error logs for more information.
> MSI (s) (A4!4C) [12:01:18:241]: Product: Microsoft SQL Server Desktop
> Engine (VLM) -- Setup failed to configure the server. Refer to the
> server error logs and setup error logs for more information."
> The only other line in the log that metions a failure is
> Setting SqlEdition property failed
> The installer then backs everthing out and removes the service. The
> service was already installed and running at that point.
> I am using SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE to install,
this usually means you did not comletely uninstall MSDE (not your fault,
just MSDE fault :D)
I succesfully cleared my registry and file system following
http://support.microsoft.com/default...b;en-us;290991 KB article
adiveces but the Windows Installer entries, that can be cleared using the
Windows Installer SDK tool Msizap.exe as per
http://support.microsoft.com/default...b;en-us;320873 (never tried)
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
|||Got it fixed.
To get it to work I did the following:
1. Intalled a default instance. I had removed it as well. That worked.
2. re-registering sqldmo.dll. I did this because DbaMgr got an automation
error when connecting to the default instance
3. Installed the named instance I wanted. This time it worked.
Notes:
The error I was getting was
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
Things learned along the way:
1. If the install fails, then enable verbose logging with /L*v
C:\MSDELog.log. Look in the log when its finished for what failed. When you
get the error message box, LEAVE IT THERE, and go look at the log. The last
thing it did is the last line.
2. If you get the error "Unable to configure server", then look in the file
cnfgsvr.out. It will be in C:\Program files\Microsoft SQL
Server\MSSQL$<instancename>\Inatall (assuming drive c)
3. To clean manully to get the installer to resintall completely if a
partial install is left on the system:
- Run Windows Installer SDK tool Msizap.exe as per
http://support.microsoft.com/default...b;en-us;320873
The command is MSIZAP.EXE" T {product code}. The product code can be
found in the install log (C:\MSDELog.log in the example above). The product
code for MDSE service pack 4 was
{E09B48B5-E141-427A-AB0C-D3605127224A} so I ran
MSIZAP.EXE" T {E09B48B5-E141-427A-AB0C-D3605127224A}
- Manually delete the folder C:\Program Files\Microsoft SQL Server\MSSQL
or C:\Program Files\Microsoft SQL Server\MSSQL$<instancename>. Make sure you
look at cnfgsvr.out first if you need too!
Brian
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3s9k91Fn804jU1@.individual.net...
> hi Brian,
> msnews.microsoft.com wrote:
> this usually means you did not comletely uninstall MSDE (not your fault,
> just MSDE fault :D)
> I succesfully cleared my registry and file system following
> http://support.microsoft.com/default...b;en-us;290991 KB article
> adiveces but the Windows Installer entries, that can be cleared using the
> Windows Installer SDK tool Msizap.exe as per
> http://support.microsoft.com/default...b;en-us;320873 (never
> tried)
> --
> 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
>
Sunday, February 19, 2012
Installation failed: error 0x6DDE
Hello
I can't install Sql Server Express with Analysys Service SP2 (KB 921896) from Windows Update because, after the download, the installation couldn't be completed.
The error code is: 0x6DDE.
Could you help me?
Thanks.
Paolo
When are you seeing this error? Are you manually installing or it WU running the install? Is it WU or SQL Server that is giving you this error?Thanks,
Sam Lester (MSFT)|||
SQL Express does not contain Analysis Services. Are you sure you get the correct SP2 to apply on SQL Express?
installation failed on XP pro
Hi,
I am trying to install sql server 2000 on a XP m/c and get the following error at the end:
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
The log file has the following:
13:19:05 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 787004 -U sa -P
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=LAPJD;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=LAPJD;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=LAPJD;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
################################################## #############################
13:19:33 Process Exit Code: (-1)
13:19:36 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
13:19:36 Action CleanUpInstall:
13:19:36 C:\DOCUME~1\jd_deepa\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
13:19:36 Process Exit Code: (1060) The specified service does not exist as an installed service.
13:19:36 C:\DOCUME~1\jd_deepa\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1 -Action 4 -Service MSSQLSERVER
13:19:36 Process Exit Code: (0)
13:19:36 StatsGenerate returned: 2
13:19:36 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
13:19:36 StatsGenerate -1,jd_deepa)
13:19:36 Installation Failed.
Any help will be greatly appreciated.
Thanks a lot in advance,
JaidevThe error reflects missing .dll files on the machine, uninstall and reinstall again.
BTW< what is the service pack level on OS?|||Thanks a lot guys. The problem was that for whatever weird reason, there was no entry in the registry for the sql server driver under HKLM\SOFTWARE\ODBC. I created the entry manually and then reinstalled SQL server successfully.
Any idea why the installer did not create these entries?
Actually, I could create a new instance successfully. But my default instance seems to be screwed. I cannot uninstall the default instance nor does reinstalling works. So on a different note, Any idea how I can uninstall this (manually) default instance ?
Thanks,
Jaidev
I am trying to install sql server 2000 on a XP m/c and get the following error at the end:
Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
The log file has the following:
13:19:05 C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -F "C:\WINDOWS\sqlstp.log" -I MSSQLSERVER -V 1 -M 0 -Q "SQL_Latin1_General_CP1_CI_AS" -H 787004 -U sa -P
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=LAPJD;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=LAPJD;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
driver={sql server};server=LAPJD;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
################################################## #############################
13:19:33 Process Exit Code: (-1)
13:19:36 Setup failed to configure the server. Refer to the server error logs and C:\WINDOWS\sqlstp.log for more information.
13:19:36 Action CleanUpInstall:
13:19:36 C:\DOCUME~1\jd_deepa\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT
13:19:36 Process Exit Code: (1060) The specified service does not exist as an installed service.
13:19:36 C:\DOCUME~1\jd_deepa\LOCALS~1\Temp\SqlSetup\Bin\sc m.exe -Silent 1 -Action 4 -Service MSSQLSERVER
13:19:36 Process Exit Code: (0)
13:19:36 StatsGenerate returned: 2
13:19:36 StatsGenerate (0x0,0x1,0xf000000,0x100,1033,303,0x0,0x1,0,0,0
13:19:36 StatsGenerate -1,jd_deepa)
13:19:36 Installation Failed.
Any help will be greatly appreciated.
Thanks a lot in advance,
JaidevThe error reflects missing .dll files on the machine, uninstall and reinstall again.
BTW< what is the service pack level on OS?|||Thanks a lot guys. The problem was that for whatever weird reason, there was no entry in the registry for the sql server driver under HKLM\SOFTWARE\ODBC. I created the entry manually and then reinstalled SQL server successfully.
Any idea why the installer did not create these entries?
Actually, I could create a new instance successfully. But my default instance seems to be screwed. I cannot uninstall the default instance nor does reinstalling works. So on a different note, Any idea how I can uninstall this (manually) default instance ?
Thanks,
Jaidev
Installation error: "Login failed for user 'sa'."
Hi everyone, I need some help.
I am trying to install a clean copy of SQL 2005 onto this server. It goes along fine until installing the "SQL Server Database Services" when I then get:
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server] Login failed for user 'sa'. Refer to server logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
There did used to be SQL installed on this server, but we un-installed it. What do I need to do now to install a fresh copy of SQL?
Thanks!
-tim
Have you tried installing a named instance? Try that rather than the default instance to see if it works. If it does, then you likely have some issue with the old installation.
Tim
Installation Error
Help Please!
When installing SQL 7.0 on W2K Server, I receive an error stating:
Setup Failed to configure server, view errogs etc. for more info.
Below is the error:
__________________________________________________ __
Starting Service ...
Connecting to Server ...
driver={sql server};server=.;UID=sa;PWD=;database=master
Remapping Server Databases ...
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'model'.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'model'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'msdb'.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'msdb'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'pubs'.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'pubs'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'Northwind'.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'Northwind'.
Disconnecting from Server ...
Stopping Service ...
Starting Service ...
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
__________________________________________________ _______
Any Suggestions would be appreciated!!!!Try to update the MDAC version to 2.7 or higher.
I;m not sure whether you're using TS to install, if so http://support.microsoft.com/default.aspx?scid=kb;en-us;246694 KBA suggests workaround.
When installing SQL 7.0 on W2K Server, I receive an error stating:
Setup Failed to configure server, view errogs etc. for more info.
Below is the error:
__________________________________________________ __
Starting Service ...
Connecting to Server ...
driver={sql server};server=.;UID=sa;PWD=;database=master
Remapping Server Databases ...
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'model'.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'model'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'msdb'.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'msdb'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'pubs'.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'pubs'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully detached database 'Northwind'.
[Microsoft][ODBC SQL Server Driver][SQL Server]DBCC execution completed. If DBCC printed error messages, contact your system administrator.
[Microsoft][ODBC SQL Server Driver][SQL Server]Successfully attached database 'Northwind'.
Disconnecting from Server ...
Stopping Service ...
Starting Service ...
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
__________________________________________________ _______
Any Suggestions would be appreciated!!!!Try to update the MDAC version to 2.7 or higher.
I;m not sure whether you're using TS to install, if so http://support.microsoft.com/default.aspx?scid=kb;en-us;246694 KBA suggests workaround.
Subscribe to:
Posts (Atom)