Problem installing SQL 2k 32bit on Windows 2003 64bit x86 SP1

I've been having no luck trying to install SQL 2k 32bit on Windows 2003 64bit x86 SP1 - I've found several articles regarding needing to put SP4 on the 64bit OS, but my problem is the SQL 2k 32bit ",,\x86\setup\setupsql" won't run.

I consistantly receive a "...(localuserdir)\Local.ins. Unable to load installaion instructions. Error 703."

And of course, the SP4 setup won't run because there is not an existing SQL Service to upgrade.

Anyone come up against a similar problem?

Thanks!

Are we talking about an X64 machine here? You cant install 32-bit on IA64.

Problem installing sql 2005 express cannot start service etc.... :(

2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation.

2006-03-26 20:33:09.42 Server All rights reserved.

2006-03-26 20:33:09.42 Server Server process ID is 2068.

2006-03-26 20:33:09.42 Server Logging SQL Server messages in file 'd:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2006-03-26 20:33:09.42 Server This instance of SQL Server last reported using a process ID of 1624 at 3/26/2006 8:32:45 PM (local) 3/26/2006 12:32:45 PM (UTC). This is an informational message only; no user action is required.

2006-03-26 20:33:09.42 Server Registry startup parameters:

2006-03-26 20:33:09.42 Server -d d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\master.mdf

2006-03-26 20:33:09.43 Server -e d:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG

2006-03-26 20:33:09.43 Server -l d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\mastlog.ldf

2006-03-26 20:33:09.43 Server Command Line Startup Parameters:

2006-03-26 20:33:09.43 Server -m SqlSetup

2006-03-26 20:33:09.43 Server SqlSetup

2006-03-26 20:33:09.43 Server -Q

2006-03-26 20:33:09.43 Server -q SQL_Latin1_General_CP1_CI_AS

2006-03-26 20:33:09.43 Server -T 4022

2006-03-26 20:33:09.43 Server -T 3659

2006-03-26 20:33:09.43 Server -T 3610

2006-03-26 20:33:09.43 Server -T 4010

2006-03-26 20:33:09.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2006-03-26 20:33:09.43 Server Detected 1 CPUs. This is an informational message; no user action is required.

2006-03-26 20:33:09.51 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2006-03-26 20:33:09.53 Server Database Mirroring Transport is disabled in the endpoint configuration.

2006-03-26 20:33:09.53 spid5s Warning ******************

2006-03-26 20:33:09.53 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.

2006-03-26 20:33:09.53 spid5s Starting up database 'master'.

2006-03-26 20:33:09.60 spid5s SQL Trace ID 1 was started by login "sa".

2006-03-26 20:33:09.64 spid5s Starting up database 'mssqlsystemresource'.

2006-03-26 20:33:09.78 spid7s Starting up database 'model'.

2006-03-26 20:33:09.84 spid5s Server name is 'XYZ-FNB5RZRU9ZP'. This is an informational message only. No user action is required.

2006-03-26 20:33:09.84 spid5s Starting up database 'msdb'.

2006-03-26 20:33:09.98 Server A self-generated certificate was successfully loaded for encryption.

2006-03-26 20:33:09.99 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].

2006-03-26 20:33:09.99 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.

2006-03-26 20:33:09.99 Server Error: 17826, Severity: 18, State: 3.

2006-03-26 20:33:09.99 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2006-03-26 20:33:09.99 Server Error: 17120, Severity: 16, State: 1.

2006-03-26 20:33:09.99 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

the two main errors in my event log

1.
Event Source: MSSQL$SQLEXPRESS
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2.

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

|||

when i click SQL server 2005 surface area configuration, it says "computer localhost does not exist on the network or the computer cannot be configured remotely. Verify that the remote computer has required WMI components and then try again"

when i click Surface Area Configuraion for Features, it says "An exception occurred in SMO while trying to manage a service (Microsoft.SqlServer.Smo)

-Additional info: failed to retrieve data for thsi request , Provider failure (System.Management)

I install VS 2005 enterprise on my PC and try to install SQL 2005 express it failed. Then I install Visual Web Develoepr express. It tryed to install SQL 2005 express but it say error starting the SQL Server service and it rolled back the installation.

What should I do? I am running on windows 2000 SP4.

|||I used windows authetication, disable vines network protocol and the sg agent still failed to start....Going to adminstrative tools and starting the sgql agent manually also doesnt work....someone got any clues?|||anyone can help?|||

problem solved. :) hippie...

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

Problem installing sql 2005 express cannot start service etc.... :(

2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation.

2006-03-26 20:33:09.42 Server All rights reserved.

2006-03-26 20:33:09.42 Server Server process ID is 2068.

2006-03-26 20:33:09.42 Server Logging SQL Server messages in file 'd:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2006-03-26 20:33:09.42 Server This instance of SQL Server last reported using a process ID of 1624 at 3/26/2006 8:32:45 PM (local) 3/26/2006 12:32:45 PM (UTC). This is an informational message only; no user action is required.

2006-03-26 20:33:09.42 Server Registry startup parameters:

2006-03-26 20:33:09.42 Server -d d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\master.mdf

2006-03-26 20:33:09.43 Server -e d:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG

2006-03-26 20:33:09.43 Server -l d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\mastlog.ldf

2006-03-26 20:33:09.43 Server Command Line Startup Parameters:

2006-03-26 20:33:09.43 Server -m SqlSetup

2006-03-26 20:33:09.43 Server SqlSetup

2006-03-26 20:33:09.43 Server -Q

2006-03-26 20:33:09.43 Server -q SQL_Latin1_General_CP1_CI_AS

2006-03-26 20:33:09.43 Server -T 4022

2006-03-26 20:33:09.43 Server -T 3659

2006-03-26 20:33:09.43 Server -T 3610

2006-03-26 20:33:09.43 Server -T 4010

2006-03-26 20:33:09.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2006-03-26 20:33:09.43 Server Detected 1 CPUs. This is an informational message; no user action is required.

2006-03-26 20:33:09.51 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2006-03-26 20:33:09.53 Server Database Mirroring Transport is disabled in the endpoint configuration.

2006-03-26 20:33:09.53 spid5s Warning ******************

2006-03-26 20:33:09.53 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.

2006-03-26 20:33:09.53 spid5s Starting up database 'master'.

2006-03-26 20:33:09.60 spid5s SQL Trace ID 1 was started by login "sa".

2006-03-26 20:33:09.64 spid5s Starting up database 'mssqlsystemresource'.

2006-03-26 20:33:09.78 spid7s Starting up database 'model'.

2006-03-26 20:33:09.84 spid5s Server name is 'XYZ-FNB5RZRU9ZP'. This is an informational message only. No user action is required.

2006-03-26 20:33:09.84 spid5s Starting up database 'msdb'.

2006-03-26 20:33:09.98 Server A self-generated certificate was successfully loaded for encryption.

2006-03-26 20:33:09.99 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].

2006-03-26 20:33:09.99 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.

2006-03-26 20:33:09.99 Server Error: 17826, Severity: 18, State: 3.

2006-03-26 20:33:09.99 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2006-03-26 20:33:09.99 Server Error: 17120, Severity: 16, State: 1.

2006-03-26 20:33:09.99 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

the two main errors in my event log

1.
Event Source: MSSQL$SQLEXPRESS
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2.

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

|||

when i click SQL server 2005 surface area configuration, it says "computer localhost does not exist on the network or the computer cannot be configured remotely. Verify that the remote computer has required WMI components and then try again"

when i click Surface Area Configuraion for Features, it says "An exception occurred in SMO while trying to manage a service (Microsoft.SqlServer.Smo)

-Additional info: failed to retrieve data for thsi request , Provider failure (System.Management)

I install VS 2005 enterprise on my PC and try to install SQL 2005 express it failed. Then I install Visual Web Develoepr express. It tryed to install SQL 2005 express but it say error starting the SQL Server service and it rolled back the installation.

What should I do? I am running on windows 2000 SP4.

|||I used windows authetication, disable vines network protocol and the sg agent still failed to start....Going to adminstrative tools and starting the sgql agent manually also doesnt work....someone got any clues?|||anyone can help?|||

problem solved. :) hippie...

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

Problem installing sql 2005 express cannot start service .... :(

2006-03-26 20:33:09.42 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

Oct 14 2005 00:33:37

Copyright (c) 1988-2005 Microsoft Corporation

Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2006-03-26 20:33:09.42 Server (c) 2005 Microsoft Corporation.

2006-03-26 20:33:09.42 Server All rights reserved.

2006-03-26 20:33:09.42 Server Server process ID is 2068.

2006-03-26 20:33:09.42 Server Logging SQL Server messages in file 'd:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG'.

2006-03-26 20:33:09.42 Server This instance of SQL Server last reported using a process ID of 1624 at 3/26/2006 8:32:45 PM (local) 3/26/2006 12:32:45 PM (UTC). This is an informational message only; no user action is required.

2006-03-26 20:33:09.42 Server Registry startup parameters:

2006-03-26 20:33:09.42 Server -d d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\master.mdf

2006-03-26 20:33:09.43 Server -e d:\SQL Server 2005\MSSQL.1\MSSQL\LOG\ERRORLOG

2006-03-26 20:33:09.43 Server -l d:\SQL Server 2005\MSSQL.1\MSSQL\DATA\mastlog.ldf

2006-03-26 20:33:09.43 Server Command Line Startup Parameters:

2006-03-26 20:33:09.43 Server -m SqlSetup

2006-03-26 20:33:09.43 Server SqlSetup

2006-03-26 20:33:09.43 Server -Q

2006-03-26 20:33:09.43 Server -q SQL_Latin1_General_CP1_CI_AS

2006-03-26 20:33:09.43 Server -T 4022

2006-03-26 20:33:09.43 Server -T 3659

2006-03-26 20:33:09.43 Server -T 3610

2006-03-26 20:33:09.43 Server -T 4010

2006-03-26 20:33:09.43 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

2006-03-26 20:33:09.43 Server Detected 1 CPUs. This is an informational message; no user action is required.

2006-03-26 20:33:09.51 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

2006-03-26 20:33:09.53 Server Database Mirroring Transport is disabled in the endpoint configuration.

2006-03-26 20:33:09.53 spid5s Warning ******************

2006-03-26 20:33:09.53 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.

2006-03-26 20:33:09.53 spid5s Starting up database 'master'.

2006-03-26 20:33:09.60 spid5s SQL Trace ID 1 was started by login "sa".

2006-03-26 20:33:09.64 spid5s Starting up database 'mssqlsystemresource'.

2006-03-26 20:33:09.78 spid7s Starting up database 'model'.

2006-03-26 20:33:09.84 spid5s Server name is 'XYZ-FNB5RZRU9ZP'. This is an informational message only. No user action is required.

2006-03-26 20:33:09.84 spid5s Starting up database 'msdb'.

2006-03-26 20:33:09.98 Server A self-generated certificate was successfully loaded for encryption.

2006-03-26 20:33:09.99 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].

2006-03-26 20:33:09.99 Server Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.

2006-03-26 20:33:09.99 Server Error: 17826, Severity: 18, State: 3.

2006-03-26 20:33:09.99 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2006-03-26 20:33:09.99 Server Error: 17120, Severity: 16, State: 1.

2006-03-26 20:33:09.99 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

the two main errors in my event log

1.
Event Source: MSSQL$SQLEXPRESS
Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

2.

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

|||

when i click SQL server 2005 surface area configuration, it says "computer localhost does not exist on the network or the computer cannot be configured remotely. Verify that the remote computer has required WMI components and then try again"

when i click Surface Area Configuraion for Features, it says "An exception occurred in SMO while trying to manage a service (Microsoft.SqlServer.Smo)

-Additional info: failed to retrieve data for thsi request , Provider failure (System.Management)

I install VS 2005 enterprise on my PC and try to install SQL 2005 express it failed. Then I install Visual Web Develoepr express. It tryed to install SQL 2005 express but it say error starting the SQL Server service and it rolled back the installation.

What should I do? I am running on windows 2000 SP4.

|||I used windows authetication, disable vines network protocol and the sg agent still failed to start....Going to adminstrative tools and starting the sgql agent manually also doesnt work....someone got any clues?|||anyone can help?|||

problem solved. :) hippie...

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

Problem Installing FTS

Hi there,
I have SQL Server SP3 (DEV Ed) Installed on my machine.
Select @.@.Version:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)
I have popped in the SQL Server CD and ticked the FTS box and installed FTS.
After install i started the search service but FTS is still not enabled in
EM. I looked under Support Services in EM but FTS is not listed there.
Have I missed something? Do I need to re-install SP3 after I installed FTS
from the original SQL Server CD?
Cheers
Ash Moollan
www.moollan.net
what happens when you issue a select serverproperty('isfulltextinstalled')
If 1 is returned, SQL FTS is installed.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ash Moollan" <ashraf@.moollan.net> wrote in message
news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
> Hi there,
> I have SQL Server SP3 (DEV Ed) Installed on my machine.
> Select @.@.Version:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows
> NT 5.1 (Build 2600: Service Pack 2)
> I have popped in the SQL Server CD and ticked the FTS box and installed
FTS.
> After install i started the search service but FTS is still not enabled in
> EM. I looked under Support Services in EM but FTS is not listed there.
> Have I missed something? Do I need to re-install SP3 after I installed FTS
> from the original SQL Server CD?
> Cheers
> Ash Moollan
> www.moollan.net
>
|||Hi Hilary,
Thanks for prompt reply.
Statement returns 0 (zero).
However the SQL Server CD shows the full text search as ticked (installed).
Thanks
Ash Moollan
www.moollan.net
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ObOlu85zFHA.736@.tk2msftngp13.phx.gbl...
> what happens when you issue a select serverproperty('isfulltextinstalled')
> If 1 is returned, SQL FTS is installed.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Ash Moollan" <ashraf*NOSPAM@.moollan.net> wrote in message
> news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
> Windows
> FTS.
>
|||Ash,
Under what account do you have the SQL Server (MSSQLServer) service started
& running? The "system account" (LocalSystem), a DOMAIN\Account or a "Local
Windows account"? If the latter, you may want to review this KB article:
Q270671 (Q270671) PRB: Full Text Search Menus Are Not Enabled for Local
Windows NT Accounts
http://support.microsoft.com/default...;en-us;q270671
Also, confirm that the FTS components are installed via the following sql
code (1 = installed)
SELECT FullTextServiceProperty('IsFulltextInstalled')
Finally, if you installed the FTS components AFTER you applied SP3, then yes
you should re-apply SP3 to get the SP3 fixes for the FTS and MSSearch
components.
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Ash Moollan" <ashraf@.moollan.net> wrote in message
news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
> Hi there,
> I have SQL Server SP3 (DEV Ed) Installed on my machine.
> Select @.@.Version:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> Windows NT 5.1 (Build 2600: Service Pack 2)
> I have popped in the SQL Server CD and ticked the FTS box and installed
> FTS. After install i started the search service but FTS is still not
> enabled in EM. I looked under Support Services in EM but FTS is not listed
> there.
> Have I missed something? Do I need to re-install SP3 after I installed FTS
> from the original SQL Server CD?
> Cheers
> Ash Moollan
> www.moollan.net
>
|||Ash,
You can remove (or un-tick) the checkmark via deleting or renaming this
registry key (remove <Instance_Name>, if this is not an named instance
installation of SQL Server 2000)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\<Instance_Name>\Tracking\
{E07FDDA7-5A21-11d2-9DAD-00C04F79D434}
Regards,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Ash Moollan" <ashraf@.moollan.net> wrote in message
news:unQVhB6zFHA.3780@.TK2MSFTNGP12.phx.gbl...
> Hi Hilary,
> Thanks for prompt reply.
> Statement returns 0 (zero).
> However the SQL Server CD shows the full text search as ticked
> (installed).
> Thanks
> Ash Moollan
> www.moollan.net
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:ObOlu85zFHA.736@.tk2msftngp13.phx.gbl...
>
|||John,
Worked Great!
Thanks
Ash Moollan
www.moollan.net
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OgaJFF6zFHA.2880@.TK2MSFTNGP12.phx.gbl...
> Ash,
> Under what account do you have the SQL Server (MSSQLServer) service
> started & running? The "system account" (LocalSystem), a DOMAIN\Account or
> a "Local Windows account"? If the latter, you may want to review this KB
> article:
> Q270671 (Q270671) PRB: Full Text Search Menus Are Not Enabled for Local
> Windows NT Accounts
> http://support.microsoft.com/default...;en-us;q270671
> Also, confirm that the FTS components are installed via the following sql
> code (1 = installed)
> SELECT FullTextServiceProperty('IsFulltextInstalled')
> Finally, if you installed the FTS components AFTER you applied SP3, then
> yes you should re-apply SP3 to get the SP3 fixes for the FTS and MSSearch
> components.
> Hope that helps!
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Ash Moollan" <ashraf@.moollan.net> wrote in message
> news:efMqGi4zFHA.2960@.tk2msftngp13.phx.gbl...
>