OK first of all please excuse my cross posting of this. I also posted this
in the SBS NG as I was unsure which would be the appropriate forum to ask
this. Considering it mainly concerns SQL but on SBS I thought I can sure
find some qualified and experienced SQL advice here.

I'm running SBS 2008 and want to verify and confirm the version of SQL 2005
Express. how can one tell if you have x86 or x64-bit versions? The SQL 2005
that was installed I'm sure is the default version used for the SBS
companyweb. When I go into the version properties it reads

"Microsoft SQL Server Express Edition with Advanced Services"

The root directory is "C:\Program Files (x86)\Microsoft SQL
Server\MSSQL.1\MSSQL". this is the confusing part for me as this is a x86
application directory. I know that I am runnng SBS 2008 x64 as that is the
only version available. The reason why I am asking is that I want to
re-install or upgrade MS SQL Server 2005 Express x64 so that I may create a
new instance for BCM. I also want to make sure that I don't lose the default
instance for companyweb (SBSMONITORING). I appreciate any and all input and
comments. Here is basically what I am asking.

1. Am I running MS SQL Server 2005 Express 64-bit version?
2. What does the "Advance Services" mean in "Microsoft SQL Server Express
Edition with Advanced Services"?
3. Can I re-install or upgrade to Microsoft SQL Server Express 64-bit and
not lose my companyweb (SBSMONITORING) instance?

Thanks in advance.

AllenM (NoReply (AT) NoEmail (DOT) com) writes:
"SELECT @@version" from a query window should settle it. For instance,
I see this on my machine:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)
Mar 29 2009 10:11:52
Copyright (c) 1988-2008 Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002:
Service Pack 2)

The important one is the first X64; the secone one refers to the OS.

But in fact, it's even simpler: you are running the 32-bit edition. There
wasn't any 64-bit version of SQL 2005 Express. There is of SQL 2008.

http://www.microsoft.com/Sqlserver/2...s/express.aspx

(The first hit I found on Google; I admit it.)

Upgrade from 32-bit to 64-bit is not supported. You would have to
uninstall the current instance, and then install a new instance with
the same name. You would then have to reattach the databases. And if
it's Express, it would have to be SQL 2008. I have no idea if SBS 2008
supports SQL 2008. (One hopes they should, but you never know.)


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thanks for taking the time to respond to my post as well as your input. Here
is what I see......

Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59
Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced
Services on Windows NT 6.0 (Build 6002: Service Pack 2)

So according to this I guess I am running SQL 2005 Express and others are
saying there is no 64-bit version of SQL 2005 Express. Let me ask you this
then. Is it ok for me to create a new DB under the default instance
SBSMONITORING?

The reason why this post started was that I read an article that in order to
install Outlook BCM on my SBS 2008 server I need to install SQL 2005 Express
64-bit version in order to create a new instance. Please refer to the below
link for that article. Thanks.

http://groups.google.com/group/micro...5+bcm+sbs+2008

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

AllenM (NoReply (AT) NoEmail (DOT) com) writes:
I cannot really answer that. That is, I don't see any problems with
adding a database to a server, but judging from the name, the instance
is part of this product SBS of which I have zero knowledge. I can't
say whether there any license or supportability issues with adding
more databases to that instance. You would have to ask in an SBS forum
about that.

And by the way, a default instance in SQL Server speak does not have
a name, and is referred to by server name only. Whereas a named
instance is referred to by SERVER\NAME. But it may be that SBS installs
an instance that by default is named SBSMONITORING. Just like an
installation of SQL Express on its own, by default creates a named
instance SQLEXPRESS.

There is no functional difference between 32-bit and 64-bit. Code that
runs on one platform, runs on the other and vice versa. There is one
qualification to this though: if there are dependency to external DLLs,
then you may only be able to run or the other. Examples of this is
extended stored procedures, OLE objects referred to through sp_OACreate
and OLE DB providers for linked servers.

Since Outlook BCM is another product that I have knowledge of, I cannot
comment. I have never heard of a situation where a 32-bit server won't do.
(But I know of situations where people run 32-bit instances of SQL Server
on a 64-bit operating system for precisely these reason.)




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx