I downloaded the new SQL Express SP2 CTP, then ran the SQLEXPR.exe.  Chose
my instance and specified "SQL Server Authentication", supplied 'sa' and my
password.  I get the messsage:
"SQL Server Setup cannot upgrade the specified instance by using SQL Server

here's one I haven't seen anyone talk about yet.  It's happening on my test
machine running Windows XP SP2.  I'm trying to install the SQL 2005 Backward
compatibility MSI so I can continue to use DMO in our VB6 application.  The
MSI is embedded in a WiSE installation.  When it ...

After rebuilding the node and attaching it to the SQL Cluster, Do I need to
reinstall the service pack for the database enging?  I'm using SQL 2005 SP 1
Thanks,
Steven

I have sucessfully created a trusted connection between MS SQL 2000 Standard and IIS, by creating a new SQL login user called IISSERVER$ and giving access to the database.
Is there a way to create a new login in MS SQL Express 2005 ?
thanks,

we distribute the backward compatibility components to our customers so they
can get the latest DMO and DTS setup.
In most cases it works just fine, but we have had several customers complain
that one workstation isn't functioning properly.

I have 2 development machines connected into LAN. I have SQL Server 2000
installed on both of them. I had server1(machine2) registered in
server2(machine2). Recently something happened and I cannot connect to
server1 from server2 anymore. I get a message saying "SQL Server ...

On SQL Server 2000 I can configure my maintenance plans to delete backup
files older than a user specified period.
I am not seeing that option on SQL Server 2005.  Am I missing something?

I see in SQL Server 2005 Books Online the general information on how to
upgrade SQL Server 2000 to 2005.
But, aside from the requirements and all of the considerations, is the
general idea of upgrading SQL to simply install 2005 on the server and just

I am getting a tough lesson in remote Web Server administration. We had
asked the hosting company to install SQL Server 2005 Standard on our
dedicated Windows 2003 ENT Web server when they built it from scratch.
Unfortunately communications between Sales and Tech failed, such ...

Does Windows 2003 server support SQL Server 2000?
Thanks.

I've build a web application on a Windows XP computer that has SQL Server
Express edition installed on it.  I then copied the web application to a
Windows 2003 Server box.  When trying to run the application an error occurs:
provider: SQL Network Interfaces, error: 26 - Error ...

I have a new install of Windows Server 2003 SP1 and SQL 2005 SP1 on a new CPQ
ML 370 G4 server. The server has an internal HP DAT 40 tape drive. The drive
is recognized by Server 2003 system and NTBACKUP can use it just fine. I have
installed newest HP drivers and firmware but ...

I am installing 2 new SQL Server 2000 databases (test and production) for
eRoom.  In the past, our servers and databases were just set up for English.  
Now my company includes China, Japan, Germany, France and USA.  I want to
make sure the new database will support all of these ...

We have upgraded a couple of customers from MSDE to SQL-Server 2005 Express.
At the same time we upgraded our app to use .NET Framework 2.0. Our app is
C++ MFC based using ADO.NET with all data access going through stored
procedures. The app is now compiled with VS 2005. Else ...

I am trying to upgrade from Sql 7.0 to Sql 2000 and am having problems with
the vswitch.exe file. I cannot upgrade the error message is:
The specified file cannot be opened as write. Ensure that the file is not in
use and restart setup.