Re: SSEnterprise looking like Express

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


I think you are confused about this "SQL Server instance" concept.

Maybe. It shouldn't take a rocket scientist to grok this, so we'll have
to keep exploring.

You can install one or more instances of SQL Server

Is another 'instance' another name for another 'install'? Or is it
another name for another 'named instance' (two names pointing to the same
installation)?

It looks like your server architecture is x64
and you installed your first instance of SQL Server as a 32Bit
version.

Presumably I installed the 64-bit version of SSExpress. At least, that's
what I downloaded.

As I told you before, a database in SQL Server can be attached only to
one SQL Server instance. While that instance' s service running, you
can not attach that database to another instance of SQL Server.
You say that you open SSMSE and connect to your both instances.

Yes, I would have to detach a database from one instance before attaching
it to another So, do I have to stop both services in order to detach and
re-attach a database? I think I didn't have to stop any service when I
attached Adventureworks to SSE on a development server.

We talked before how to determine an instance' s edition.

In the SQL Server Configuration Manager, right-clicking on the listed SQL
Server line items and getting it's properties, I see that each
(SQLExpress and SQL2005ENT) 'point' to the correct installation.

So, I stopped the SQL2005ENT service (red square on the server box) in
the Configuration Manager. Lo, and Behold, I can still connect to that
'instance' (or 'named instance') in Management Studio Express.

.

Relevant Pages

  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: installing help for sql 2005
    ... you have database users that are not mapped correctly to logins. ... SQL Server Documentation Team ... installation help with snap shots because i installed the sql server ... remote connections are disabled by default. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL SERVER 2008 Express + SP1
    ... I installed the SQLXPR_X64, and before I attempted the SP1, SQLEXPRESS database was 64bit for the configuration, better yet the repair do work anymore because SP1 changed them somehow to 32 and the original install was 64 ... If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. ... And regarding your sql server installation, ...
    (microsoft.public.sqlserver.setup)
  • Re: End User Requirements
    ... running MS-Access and not needing the full access installation, ... you are considering running a local copy of SQL server database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Cluster will not fail over.
    ... As far as the TCP/IP issue goes, you had to rebuild the cluster and were not ... able to restore the master database. ... the entire installation configuration just as if nothing was running on it. ... > This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)