Hello Did anyone ever get the SQL2000 server or MSDE to work on an XP Pro
computer, with a static IP address? If so how is this done? I’ve done the
following:
1)    setup router to forward to a port 5000

We are using SBS2000 Server and on the initial installation we did not
installed SQL Server 2000. Now we need SQL Server 2000 installed. How
do we do this from the original CDs --which CD is it on?
Thanks!

Recruiter here.  In any case I am on the lookout for folks who happen
to have skills with MS reporting services for the past year or so. Tey
also need to have a bunch of other Datamart | Datawarehouse type
skills.

My company have a server with single database and many applications that are
working well with it. Now my data and items(tables) is growing and my server
can't handle it. I think there is two way
1-add a new server and move some items(tables) to it, then change my

I've noticed on our SBS 2003 premium server that the sqlservr.exe process
never lessens it's memory usage but instead continually adds to it.  
Currently it is at 1,451,184k!!  
How do I correct this?  

Hi, I have install 2003 SBS (5 CDs) On new server,include SQL 2000.
The problem is how to set up SQL server for client PC ocnnect??
How to setup client connection in PC??
Thanks!

I need a way to install express 2005 to xp clients with group policy. With
msde2000 one could just deploy the msi, but this doesn't seem to work with
2005 ...
Any suggestions ?

morning Guys,
anyone experienced a problem installing SQL 2005 on a 2003 cluster.
Error I'm getting is from installer, failing to execute remote task on
second cluster member.

I used to be a happy person...  Then SQL entered my life.
Windows 2003 Server with a HelpDesk application running on it, as well as
SQLEXPRESS.  Things work well when REMOTE DESKTOPPING on the server.  
Browser, TCP/IP, named pipes, etc., all enabled on server.  Loaded SQL client

Hi, can someone please advise what would be the disadvantages of using SQL
Server 2000 Standard edition, on a new Windows 2003 platform, using a Pentium
D chip, compared to the latest MS SQL Server? The reason for this is
obviously because the company this is for, already has a ...

Can the SQL Server 2005 Express be installed on a machine with 2 processors?
Does the license allow that?

My question is, how do you automatically generate an answer file for
Sql 2005, so that I can install it silently? I know that I can generate
an ini file myself, but I would like it to be generated automatically.
In SQL 2000, there was an option to automatically generate the answer

How do I find out what licensing mode my sql 2005 server is currently running
(per processor / per cal)?.....and is it possible to change modes after
install?

I am installing a fresh copy of SQL Server Std Edition x64 on a new Win 2003
Std x64 server. Reporting Services will run on the same machine.
Is there any reason not to use the "Application Server Role" to set up the
necessary services before SQL Server installation? I have been ...

Is it possible to take the MSDB database bakup file from a SQL2000 SP3
server and convert it to SP4 so it can be restored to an SP4 server, without
updating the SP3 server to SP4??