i have installed windows server 2003, its windows installer version is
2.0.3790.0. although the microsoft site claims that windows server 2003
has built in windows installer 3.1. i ran the update for windows
installer 3.1(WindowsInstaller-KB893803-v2-x86.exe), it prompts "the

KB article 304261 says you can use a non-local (network) drive (NAS, SAN)
with SQL server 2000.  I've got Trace flag 1807 set on (as per article) but
it fails with error 5105 (not 5110 as per article).  Has anyone done this
successfully?

Can anyone confirm they are having a similar issue.  Are there any
resolutions?  Please refer below.
The version of the report server database is either in a format that is not
valid, or it cannot be read.  The found version is 'Unknown'.  The expected

How do I change the default Service in SQL Server Service manager?
I have SQL Server 2000 and SQL Server 2005 loaded on my computer.  The
Service for "my computer name" loads at startup and is disabled.  How do I
change the default service to the SQL database on the server?

I have succeeded in getting SQL Server 2005 Express running on my
laptop. Now I would like to connect to it with SQL Server Enterpise
Manager (2002) on my desktop pc.  When I use SQL Sever Mgt Studio
Express I always use Sever name THINKPAD\SQLEXPRESS and Authentication

I currently have a 64bit hardware server running a 32 bit version of W2K and
a 32 bit version of SQL Server 2000 Developers Edition.  I want to upgare
this box to W2K3 64 bit and SQL to 2005 enterprise edition 64 bit.  Is this
an upgradable path?

While I know you can specify the directory that you want to install your
database files to during setup, is there any way to specify specifically
where to store your .mdf and .ldf files during setup(i.e., all .ldf files go
to d:\sql while all .mdf files go to e:\sql)? If not, ...

i posted a related question a few days ago and have since upgraded my
hardware- im hoping to set up my server with the optimal RAID configuration
for our limited means- we have a shiny-new dell poweredge 2950 server with
four, 400GB SATA drives.  it is running windows server 2003 ...

I am working on an installation that we would like to make SMS compatible and
which also includes SQL 2005 Express.
Everything that I have read so far seems to indicate that SQL 2005 Express
cannot ever be pushed out using SMS or ActiveDirectory.

I get the following process occurring every time I open a DTS package.
-------------------------------
Microsoft SQL Server Desktop Engine
-------------------------------

I am using the Autogrowth option for my database.
If I had to choose between growing more often and small amounts or growing
less often but bigger amounts, which is the better option?
Is there a maximum % threshhold of how much I should set my database to grow

we have to redistribute SQL Server 2005.
Is there a problem, to change the productcode of the msi-files with
tools like orca?
Or is this not supported by microsoft?

I uninstalled all the modules of ss2k5 via the Control Panel 'Add Remove
Programs' .
The modules are no longer listed in the AddRemove Programs list ... however
they are still listed in the 'All Programs' window .... and I can open

hi... casnt install sql 2005 express edtion on my xp sp2 pc
it gives me a permission denied messagw whilst instlalling.. Im an
administrator od the pc.
evet viewer shows this ... event id 11304

I used SQL Server Express 2005 on my pc for a few months over a year
ago.  That project was dropped and I moved on to non-database projects
for awhile.  Then I had to connect to the company's SQL Server 2000
server and they installed Enterprise Manager for it on my pc.  Now