SQL Express SP2 Upgrade Possibility

Sep 4, 2007

I am planning to create an application in SQL Express Advanced SP2, and later upgrading to Standard Edition. The Express SP2 Readme states somewhat unclearly that this might not be possible, that upgrading must be done prior to installing SP2, and then SP2 can be applied. I'm confused about my options.

Right now, I need to use Express Advanced for the reporting capabilities, etc., but the only available download I can find is Express Advanced SP2. If I install and use this, will I later be able to upgrade "seamlessly" to Standard Edition? Or should I install an earlier version of Express Advanced? Also, I haven't seen a lot of advice about the "seamless" upgrade from Express to other editions. If any help can be provided to answer the first question and/or point me toward upgrade documentation, it would be appreciated.

View 3 Replies

Error When Attempting To Upgrade MSDE To Express Using Command Line /UPGRADE

Nov 29, 2006

When attemping to install SQL 2005 Express using the following command line arguments

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE

or

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD

the following error occurs.

Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

The following version and editions have been verified.

1. .NET 2.0 installed

2. Windows XP SP2

3. MSDE 8.00.2039(SP4)

4. all MSDE databases are owned by sa

5. Instance and SQLAgent running under user that is member of Administrators

What are the possible reasons this error is occurring?

View 4 Replies View Related

Full-Text Search Problem When I Upgrade From SQL 2005 Express To Express Advanced Services

Mar 1, 2007

Hi. I'm trying to get full-text search working on my SQL 2005 Express with Advanced Services and am having problems. I thought that I installed it correctly, and when I look in the services running, I see it SQL Server Fulltext Search(MSSQLSERVER). Also note that I have SQL Server 2005 Standard installed on this same laptop. I don't know if that Full text Search applies to the Standard, Express or both.

What I do see is that if I connect to the database engine named <mylaptop>, I can see the version is 9.0.1399 and I can see the check box to enable full-text indexing in a particular databases properties. When I run SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'), I get a 1.

However, when I connect to the engine name <mylaptop>SQLExpress, I se the version is 9.0.3042, and I don't see the same check-box to enable full-text indexing. When I run SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'), I get a 0.

I've never tried this before so I know I'm probably missing something basic. But, I have searched quite a bit and not found my answer. So, I'm looking to you for help.

Thanks in advance.

John.

View 3 Replies View Related

Possibility In Enterprise Manager

Jun 15, 2004

Hi,

I'm using enterprise manager to remotely connect to a MS SQL Server for one of my client's websites. The problem I'm having is that the connection times out when I try to expand the "Databases" folder. The reason that it's timing out is because the company that hosts the DB has hundreds of other clients who all share the same IP, but each with their own seperate login/password/database, but even though I don't have access to all the rest of the DBs on the server, it still wants to list them all for me. What I'm wondering is is there a way to set EM to ignore all of the databases on the server that cannot be accessed with my credentials? So basically when I expand the Databases folder all that appears is the one that I can access?

Thanks,
Dante