TCP protocol in the SQL instance SQLEXPRESS is not valid

Quite a lot of time has passed since the previous issue...am on the same computer but having a new problem that may be related to the old one. Several times a day, this computer locks up...have to turn off system to reboot... I noticed an error in Administrative Tools/Event Viewer/Applications... Warning/Source: SQL Browser/Properties: The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid.

This coincides with the lock-up...any ideas????

Sonja:confused

 

What OS version is running on this PC

XP Service pack 3

does it have a software firewall installed?

No...have BitDefender AV 2009 running, but have had it for months and the problem for only 2 weeks.


Is this standalone machine or part of a larger network?

stand alone

and as I do use SQL but have experts in work to deal with issues arrising from it, they did link me to this that maybe the fix for you http://social.technet.microsoft.com/...4-f1862969d938

am going there now...

more so post from Ian_E and below, other than that maybe we have a SQL expert here that has come across this.

thank you!!

Sonja

 

The link you provided brings up a "Bad Request" page... any other ideas???

Sonja

 

Halo's link (expands &) works!! Yours does not.!!

Cheers...

 

Halo... I tried everything on the link you supplied...except for the reg edit... not sure if that is a safe thing for me to be doing...please advise as to the safety of the posted reg edit for this issue:


** 32bit ** HKLM\SOFTWARE \ Microsoft \ Microsoft SQL Server \ MSSQL.1 \ MSSQLServer \ SuperSocketNetLib \ AdminConnection \ Tcp

These registry edit works BEST as the following:
Name: DisplayName
Type: REG_SZ
Data: TCP/IP (if you have to key this in, make sure your slash is going the right way)

Name: TcpDynamicPorts
Type: REG_SZ
Data: 1434 (although 1 is valid, I ended up with future errors that appeared unrelated.)

But also, the following seem to need to be changed as well:
** 64bit ** HKLM\SOFTWARE\ Wow6432Node \ Microsoft \ Microsoft SQL Server \ MSSQL.1 \ MSSQLServer \ SuperSocketNetLib \ Tcp \
** 32bit ** HKLM\SOFTWARE\ Microsoft \ Microsoft SQL Server \ MSSQL.1 \ MSSQLServer \ SuperSocketNetLib \ Tcp \

Each "IP"# folder up to and including IPAll:
Name: TcpDynamicPorts
Type: REG_SZ
Data: (should be empty)

Name: TcpPort
Type: REG_SZ
Data: 1433


Thanx Sonja