Running SQL Server 6.5 on Win2K Server??

[cdavis10717]

Is anyone here successfully running SQL Server 6.5 in a Windows 2000
Server??
We tried to and had some runtime problems relative to tempdb.

[Erland Sommarskog]

(cd*********@comcast.net) writes:

Is anyone here successfully running SQL Server 6.5 in a Windows 2000
Server??
We tried to and had some runtime problems relative to tempdb.

I seem to recall that it is supported, provided that you have SP5a of
SQL 6.5.

But I have to admit that I once attempted to install SQL 6.5 on Win 2000
Pro, and I wasn't successful. When you say it, it might have been an
issue with tempdb. In my case, the problems occurred already during
installation.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[cdavis10717]

Erland Sommarskog wrote:

(cd*********@comcast.net) writes:

Is anyone here successfully running SQL Server 6.5 in a Windows 2000 Server??
We tried to and had some runtime problems relative to tempdb.
I seem to recall that it is supported, provided that you have SP5a of
SQL 6.5.

But I have to admit that I once attempted to install SQL 6.5 on Win

2000 Pro, and I wasn't successful. When you say it, it might have been an
issue with tempdb. In my case, the problems occurred already during
installation.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Thank you. Yes, the running SQL Server 6.5 choked on tempdb. And even
starting sql server in minimal mode failed since tempdb would not
allocate in RAM. Oh, well, we are going back to SQL 6.5 on NT until we
can determine the databases that must be upgraded or dropped.
thank you again.

[Erland Sommarskog]

(cd*********@comcast.net) writes:

Thank you. Yes, the running SQL Server 6.5 choked on tempdb. And even
starting sql server in minimal mode failed since tempdb would not
allocate in RAM. Oh, well, we are going back to SQL 6.5 on NT until we
can determine the databases that must be upgraded or dropped.
thank you again.

Allocating tempdb in RAM? Do you have that feature on? Or is that something
which happens when you start in single-user mode? I'm not using 6.5
much these days...

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp