Installed, but can't ping 1433

Any and all help is appreciated as project deadline is approaching...

Background:
- Two servers, 1 running WinXP with all updates and 1 running Win2K3 Standard with all updates.
- Both have SQL Express 2005 June CTP installed
- Both have Visual Studio 2005 Express installed.
- Installation finished w/o any errors.
- Services are running (browser and database)
- TCP/IP and named pipes are enabled

Issue:
Can't ping 127.0.0.1:1433.
OSQL times out without being able to establish a connection
Windows Firewall is OFF.

Seems to be a connectivity issue, but I'm a newbie and can't figure out why I can't talk to the database.

As I said, any and all help is appreciated. Thanks to all in advance.

PM

Due to the length of time since this issue was posted, I'm marking it as resolved. If you're still in need of help, please respond here.

Paul

Installed, but can't ping 1433

Any and all help is appreciated as project deadline is approaching...

Background:
- Two servers, 1 running WinXP with all updates and 1 running Win2K3 Standard with all updates.
- Both have SQL Express 2005 June CTP installed
- Both have Visual Studio 2005 Express installed.
- Installation finished w/o any errors.
- Services are running (browser and database)
- TCP/IP and named pipes are enabled

Issue:
Can't ping 127.0.0.1:1433.
OSQL times out without being able to establish a connection
Windows Firewall is OFF.

Seems to be a connectivity issue, but I'm a newbie and can't figure out why I can't talk to the database.

As I said, any and all help is appreciated. Thanks to all in advance.

PM

Due to the length of time since this issue was posted, I'm marking it as resolved. If you're still in need of help, please respond here.

Paul

sql

Installation Problems - need help..

Hi Everyone,

I need help in installing my SQL Server Express 2005, any help would be appreciated. I already installed the SQL Server Express 2005 in my pc but i had a hard time configuring it so i decided to reinstall it just certain reasons. So i started reinstalling it, removing all SQL Server 2005 - related program in the add/remove software in the control panel. Then here is the problem now, i tried reinstalling it again but it doesnt work, everything is ok until i reach the screen after they let you choose the Instance Name. I having problem with the Existing Component Screen, it tells me that:

"The following components that you chose to install are already installed on the machine. To view a report of available options and alternates click on Details"

Then below that is the component that they claim is already installed in my pc which is the "SQL Server Database Service 9.1.2047.00" which i cannot check the checkbox. When i push the "Details" button it shows me this message:

"Name: Microsoft SQL Server 2005 (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs"

And when i click the next button, its pops up a message saying:

"None of the selected feautures can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel."

and thats it, i cannot moved on from there. I have tried deleting all files left undeleted by uninstalling the SQL SERVER 2005 but still doesnt work. I just want to install it in my pc again and doesnt know how. Thank you so much in advance, any help would really really be appreciated.

Stanley

When you go to Add/Remove Programs, do you see an entry for SQL 2005? It sounds like you have some SQL components on the machine (with the default instance name of SQLEXPRESS), so when you try to do a fresh install using this instance name, it detects an already existing instance.

For starters, go to ARP and click on the report for any SQL entries that exist and post back with what edition/version you see.

Thanks,
Sam Lester (MSFT)

|||

Thanks Sam. That did it. I was too stupid not to think that i cant use the same named instance twice. Thank you so much! I really appreciate it.

Thanks,
Stanley

Installation of UPS Worldship 9.0 Fails

Greetings, if anyone has advice or can point me in the right direction
it would be appreciated. Been a week now, and I just can not make
progress on this issue. Machine is windows xp sp2
UPS Application Error Message:
"Installation failure during Step 7 of 27:
MSDEInstaller:PostInstallationSteps:DBSupportEngin e.ConfigureServer
Failed to install UPS Database Server"
UPS Error Log
------
7/18/2007 11:45:17 PM: Fresh MSDE install
7/18/2007 11:45:17 PM: Preparing to copy watch and Kill program to
local Target Directory
7/18/2007 11:45:17 PM: Successfully copied WaitAndKill.exe
7/18/2007 11:45:17 PM: Preparing Execution of C:\UPS\WSTD
\WaitAndKill.exe
7/18/2007 11:45:17 PM: Fresh MSDE install
7/18/2007 11:45:17 PM: Calling MSDE Setup.exe
7/18/2007 11:45:17 PM: MSDE Setup Command Line = C:\Documents and
Settings\Administrator\Desktop\ups\MSDE\English\Se tup.exe /qn /L*v "C:
\UPS\WSTD\Install\msde_install.log" INSTANCENAME="UPSWSDBSERVER"
SAPWD="****" TARGETDIR="C:\UPS\WSTD\" DISABLENETWORKPROTOCOLS=1
COLLATION=SQL_Latin1_General_Cp1_CI_AS SECURITYMODE=SQL
7/18/2007 11:48:48 PM: StandardError
7/18/2007 11:48:48 PM: Completed execution of C:\Documents and
Settings\Administrator\Desktop\ups\MSDE\English\Se tup.exe/qn /L*v "C:
\UPS\WSTD\Install\msde_install.log" INSTANCENAME="UPSWSDBSERVER"
SAPWD="****" TARGETDIR="C:\UPS\WSTD\" DISABLENETWORKPROTOCOLS=1
COLLATION=SQL_Latin1_General_Cp1_CI_AS SECURITYMODE=SQL
7/18/2007 11:48:48 PM: C:\Documents and Settings\Administrator
\Desktop\ups\MSDE\English\Setup.exe/qn /L*v "C:\UPS\WSTD\Install
\msde_install.log" INSTANCENAME="UPSWSDBSERVER" SAPWD="****"
TARGETDIR="C:\UPS\WSTD\" DISABLENETWORKPROTOCOLS=1
COLLATION=SQL_Latin1_General_Cp1_CI_AS SECURITYMODE=SQL completed
with a code of 1603
7/18/2007 11:48:48 PM: *******!!!!!!!!!!!! ATTENTION!!!! MSDE INSTALL
DID NOT RETURN SUCCESS. THE RETURN CODE IS 1603
7/18/2007 11:48:48 PM: PLEASE CONSULT MICROSOFT ARTICLE
http://support.microsoft.com/kb/290158 FOR ERROR CODES
MSDE INSTALL LOG
------
Settings\Administrator\Desktop\ups\MSDE\English\Se tup\
Property(S): SourcedirProduct = {E09B48B5-E141-427A-AB0C-D3605127224A}
Property(S): ProductToBeRegistered = 1
MSI (s) (04:94) [23:48:48:343]: Note: 1: 1708
MSI (s) (04:94) [23:48:48:343]: Product: Microsoft SQL Server Desktop
Engine (UPSWSDBSERVER) -- Installation operation failed.
MSI (s) (04:94) [23:48:48:343]: Cleaning up uninstalled install
packages, if any exist
MSI (s) (04:94) [23:48:48:343]: MainEngineThread is returning 1603
Would be more then happy to supply additional information, if the
above information is not sufficient to resolve this issue. Thank you
in advance.
- Eric
Eric,
http://support.microsoft.com/kb/925209 says that this is the result if a
partially removed previous install. This message is in the context of Small
Business Server, but http://support.microsoft.com/kb/897877/ includes
instruction on cleaning up the MSDE installation.
RLF
<info@.supernoc.com> wrote in message
news:1184821105.524742.222300@.x35g2000prf.googlegr oups.com...
> Greetings, if anyone has advice or can point me in the right direction
> it would be appreciated. Been a week now, and I just can not make
> progress on this issue. Machine is windows xp sp2
> UPS Application Error Message:
> "Installation failure during Step 7 of 27:
> MSDEInstaller:PostInstallationSteps:DBSupportEngin e.ConfigureServer
> Failed to install UPS Database Server"
> UPS Error Log
> ------
> 7/18/2007 11:45:17 PM: Fresh MSDE install
> 7/18/2007 11:45:17 PM: Preparing to copy watch and Kill program to
> local Target Directory
> 7/18/2007 11:45:17 PM: Successfully copied WaitAndKill.exe
> 7/18/2007 11:45:17 PM: Preparing Execution of C:\UPS\WSTD
> \WaitAndKill.exe
> 7/18/2007 11:45:17 PM: Fresh MSDE install
> 7/18/2007 11:45:17 PM: Calling MSDE Setup.exe
> 7/18/2007 11:45:17 PM: MSDE Setup Command Line = C:\Documents and
> Settings\Administrator\Desktop\ups\MSDE\English\Se tup.exe /qn /L*v "C:
> \UPS\WSTD\Install\msde_install.log" INSTANCENAME="UPSWSDBSERVER"
> SAPWD="****" TARGETDIR="C:\UPS\WSTD\" DISABLENETWORKPROTOCOLS=1
> COLLATION=SQL_Latin1_General_Cp1_CI_AS SECURITYMODE=SQL
> 7/18/2007 11:48:48 PM: StandardError
> 7/18/2007 11:48:48 PM: Completed execution of C:\Documents and
> Settings\Administrator\Desktop\ups\MSDE\English\Se tup.exe/qn /L*v "C:
> \UPS\WSTD\Install\msde_install.log" INSTANCENAME="UPSWSDBSERVER"
> SAPWD="****" TARGETDIR="C:\UPS\WSTD\" DISABLENETWORKPROTOCOLS=1
> COLLATION=SQL_Latin1_General_Cp1_CI_AS SECURITYMODE=SQL
> 7/18/2007 11:48:48 PM: C:\Documents and Settings\Administrator
> \Desktop\ups\MSDE\English\Setup.exe/qn /L*v "C:\UPS\WSTD\Install
> \msde_install.log" INSTANCENAME="UPSWSDBSERVER" SAPWD="****"
> TARGETDIR="C:\UPS\WSTD\" DISABLENETWORKPROTOCOLS=1
> COLLATION=SQL_Latin1_General_Cp1_CI_AS SECURITYMODE=SQL completed
> with a code of 1603
> 7/18/2007 11:48:48 PM: *******!!!!!!!!!!!! ATTENTION!!!! MSDE INSTALL
> DID NOT RETURN SUCCESS. THE RETURN CODE IS 1603
> 7/18/2007 11:48:48 PM: PLEASE CONSULT MICROSOFT ARTICLE
> http://support.microsoft.com/kb/290158 FOR ERROR CODES
>
> MSDE INSTALL LOG
> ------
> Settings\Administrator\Desktop\ups\MSDE\English\Se tup\
> Property(S): SourcedirProduct = {E09B48B5-E141-427A-AB0C-D3605127224A}
> Property(S): ProductToBeRegistered = 1
> MSI (s) (04:94) [23:48:48:343]: Note: 1: 1708
> MSI (s) (04:94) [23:48:48:343]: Product: Microsoft SQL Server Desktop
> Engine (UPSWSDBSERVER) -- Installation operation failed.
> MSI (s) (04:94) [23:48:48:343]: Cleaning up uninstalled install
> packages, if any exist
> MSI (s) (04:94) [23:48:48:343]: MainEngineThread is returning 1603
>
> Would be more then happy to supply additional information, if the
> above information is not sufficient to resolve this issue. Thank you
> in advance.
> - Eric
>