MS SQL 2K server on windows 2K

Hello,
what is the advantages running MS SQL 2k on window 2000 verse windown NT?

thanks"reneecccwest" <reneecccwest@.hotmail.com> wrote in message
news:c1c86eae.0404060820.14b42f22@.posting.google.c om...
> Hello,
> what is the advantages running MS SQL 2k on window 2000 verse windown NT?
> thanks

Well apart from the extra functionality in Windows 2000, NT4 is not
supported after 1 Jan 2005, so I guess your organization will want to
upgrade anyway.

http://www.microsoft.com/ntserver/P...ty/Retiring.asp

Simon

Ms SQL 2005 express edition connectivity problem

Hi, i just currently install the MS SQL 2005 express edition in my Window XP home edition and the problem is, when i netstat in the command prompt, i couldnt find any port listening to port:1433

i have an application wanting to connect to the MS SQL but it came out:

Error connecting to database using: "jdbc:jtds:sqlserver://localhost:1433"

i dunnu what the problem is but im suspecting it is not listening to port:1433

anyone can help me please....

MS SQL 2005 express only allow local connection by default. No TCP. You need to enable TCP. One mean is to use sql server configuration manager.

For general sql express troubleshooting,

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

ms sql 2005 developer edition

is it possible to install ms sql 2005 developer edition databse server
on window XP professional version 2002 with SP2 or just allows install
client version?On Oct 3, 10:39 am, HandersonVA <handerso...@.hotmail.comwrote:

Quote:

Originally Posted by

is it possible to install ms sql 2005 developer edition databse server
on window XP professional version 2002 with SP2 or just allows install
client version?

Of course you can - the only version you can't install on a client
machine is the SQL Server Enterprise Edition!

JC
xSQL Software
http://www.xsqlsoftware.com|||On Oct 3, 12:23 pm, xman <x...@.xsqlsoftware.comwrote:

Quote:

Originally Posted by

On Oct 3, 10:39 am, HandersonVA <handerso...@.hotmail.comwrote:
>

Quote:

Originally Posted by

is it possible to install ms sql 2005 developer edition databse server
on window XP professional version 2002 with SP2 or just allows install
client version?

>
Of course you can - the only version you can't install on a client
machine is the SQL Server Enterprise Edition!
>
JC
xSQL Softwarehttp://www.xsqlsoftware.com

thank you for your comments!
I just tried to install ms sql 2005 developer edition on my home
computer which has win XP professional, but it says I can only install
the client version to connect the database server. It does not allow
me to install whole database server.|||HandersonVA (handersonva@.hotmail.com) writes:

Quote:

Originally Posted by

I just tried to install ms sql 2005 developer edition on my home
computer which has win XP professional, but it says I can only install
the client version to connect the database server. It does not allow
me to install whole database server.

Then I would guess you need to look twice on the CD/DVD. It sounds as
if you have a copy of Enterprise Edition.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx