SQL CE Tools 3.5 SP1 installation on SQL Server 2008 64 bit require replication component of SQL Server 2005 or 2008

I am trying to install SQL CE Server Tools 3.5 SP1 on a SQL Server SBS 2008 64 bit. In the beginning, there was SQL Server 2005 installed with an SBSMONIOTORING instance, and while I try to install SQL CE Tools, I got the error "replication component must be installed for SQL Server 2005 or 2008", and installation stopped.

I then completely removed the SQL Server 2005 from the server, and use SQL Server 2005 Express SP3 64 bit to reinstall a new instance. However, SQL CE Tools still got the same error and will not install.

Any idea how to fix this issue? Any help is appreciated.
LVL 1
wrxguruAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark WillsTopic AdvisorCommented:
OK, this is a popular "gotcha"

There is a KB article that describes it reasonably well - albeit for an earlier version : http://support.microsoft.com/kb/920700  it shows some of the issues and workarounds down toward the bottom.

See if that provides any more joy for you. If not, we will see what the next steps might be...

 

0
wrxguruAuthor Commented:
Thanks for your help mark wills. I would like to update what I have tried and come up with during the installation:

1. While I reinstalled the new SQL Server 2005 Express instance, I did install the replication components, as well as all the other Database Services and all the Client Components, but still could not install SQL CE Server Tools 3.5 SP1 after that.

2. I also tried to right click the cmd.exe, select "Run as administrator", and run the SSCEServerTools-ENU-x64.msi from the command line, but I got the same error during the installation.

3. I login to the server via Terminial Services, and I am not using Administrator but another user which has the type "User". Will this issue be caused by the insufficient privillege?

4. After I remove the old SQL Server 2005 Express, I did not completely delete the "Microsoft SQL Server" folder in C:\Program Files and C:\Program Files (x86). Is it possible that there are some files hanging over that stop the installation of SQL CE Server Tools? and they are still out there even after I reinstalled the SQL Server 2005 Express with replication components?

Thanks a lot.
0
Mark WillsTopic AdvisorCommented:
>> I login to the server via Terminial Services, and I am not using Administrator but another user which has the type "User". Will this issue be caused by the insufficient privillege?

Might be. It does definitely require a privileged (admin) account to install, and is most likely to be the problem.

>> I did not completely delete the "Microsoft SQL Server" folder in C:\Program Files and C:\Program Files (x86).

That should not be a problem. But can try it (dont think you will get any different results).

One thought... I am not sure that Express gives you the full replication facilities... do you have a full license anywhere ?
0
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

wrxguruAuthor Commented:
Thanks again mark wills.

I have tried to login as Administrator but same problem.

Then I tried to completely uninstall the SQL Server 2005 Express, and delete the Microsoft SQL Server folder in C:\Program Files and C:\Program Files (x86). There was a file instapi.dll in C:\Program Files\Microsoft SQL Server\90\Shared that required to restart the server to delete.

However, I found out there are still some dll (and a rll) files in C:\Windows\System32 directory: sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll, sqlsrv32.dll and sqlsrv32.rll; also in the registry, there is an key "REG_EXPAND_SZ C:\Windows\system32\SQLSRV32.dll" in: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\SQL Server.

Neither the dll files nor the key could be deleted.

Do they have anything to do with the SQL CE Server Tools install being failed?

I want to make sure they are fine to be there before I reinstall the SQL Server again.

Thanks.
0
Mark WillsTopic AdvisorCommented:
sqlcese30.dll is the SQl Server 2005 Mobile V3.0 engine...sqlceqp30.dll is the query processor...

Now that in itself shouldnt be a problem, but you tend not to have v3.0 and v3.5 on the same computer (well, I do, but doesnt cause a problem).

The other thing I did think of is that when I install SQL Compact, I do have Visual Studio, and that took care of the environment for me (just a thought I would share with you).

I will have a look around to see what else I can find.
0
TheMakCommented:
Hello Everyone and Sorry to trouble you as I was so confused last day and I made lots of wrong postings.
Sorry and next time  I will try to work according to the rules or I will not post. just sit and watch.
Regards,
0
wrxguruAuthor Commented:
Can someone please tell me definitively if SQl CE tools is support on Windows SBS server 2003 R2 and SBS server 2008 ..  I know it is on the full versions but will it install and is it supported on the SBS version ?
0
Mark WillsTopic AdvisorCommented:
Well, that is a good point. I have been assuming you have the Premium Edition - which essentially adds the full licence of SQL Server.

You must have the SQL Server replication components, and the version "out of the SBS box" is very much a cut down version of SQL Server (basically for internal SBS use).

Have you checked the prerequisites agains the download site ? http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=b18327f3-96e1-415d-b037-9e0c46d49956
0
Mark WillsTopic AdvisorCommented:
0
wrxguruAuthor Commented:
I have checked but we have installed SQL Express before on SBS 2003 and were able to install tools no problems and it all worked frine.  This time however it is on a SBS 2008 server and I am just not clear at all.
0
wrxguruAuthor Commented:
Can a SQl expert answer this question re using sql ce tools and express on SBS 2008 ?
0
Mark WillsTopic AdvisorCommented:
Do you have Premium or not ?

Do you have a full license of SQL Server or not ?

SQL CE tools must have the replication components installed already. Did you check the prerequisites ?

Express cannot be a publisher for replication, so it will not cut it. Which version of Express are you using ?

In the meantime, I trust a real SQL expert might be able to answer your questions. You may want to "Request Attention" to see if you can summons some more help.
0
wrxguruAuthor Commented:
This particular site is using premium SBS and we are using SQL express.   I really need to understand what is possible/not possible here.  how do you request attention ?
0
Mark WillsTopic AdvisorCommented:
the "request attention" button is up the top in the question header.

premium SBS comes with SQL Server - why are you using Express ?
0
wrxguruAuthor Commented:
because our software has it sown install of a particular instance of sql we just have it bundled in out install.  we can manually use another but do not normally do this.
0
wrxguruAuthor Commented:
I knwo that sql express cannot be a published for replication but we are only using sql ce tools so our PDA application can use remote SQL.  we are not actualy using sql to do any replication.  I am just not sure whether you need the full sql to use these ce tools or not.
0
Mark WillsTopic AdvisorCommented:


Differences... SBS 2003 was pretty much all in a box. SBS 2008 sees SQL wanting to be on a seperate box. When installing the "full" SQL Server, it will install the replication components in IIS. Installing Express wont do that by default (I believe - might have something in the "with advanced services" edition).

You need to install on the server which has IIS running. Also, you will need to stop and start SQL Agent before those components are recognised (by SQL server) but probably not your problem being Express.

Have a look at : http://msdn.microsoft.com/en-us/library/ms172376.aspx to install just those components.

or

Have a look at : http://msdn.microsoft.com/en-us/library/ms345283(SQL.90).aspx to install the RMO objects that come with Express. They are NOT installed by default.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wrxguruAuthor Commented:
so you are saying you MUST have the full SQL for sqlce tools to work with IIS?
0
Mark WillsTopic AdvisorCommented:
No, just that the tools connection + RMO tools are installed automatically with full SQL.

You can install when you install Express, but is not standard install / not by default - you have to go in and tell it you want to. See that second link ?

What I was trying to say above is there are other factors that cause the difference in how you are now intalling... (compared with 2003 where it used to work)

0
wrxguruAuthor Commented:
yes i understand.  we have however done the step of installing the replication or at least trying tro.  this is the step that fails.
0
Mark WillsTopic AdvisorCommented:
Yes you did say so back in http:a#32351135 (I had not forgotten).
Might be best if you can find a real SQL expert.
There is something obviously amiss which requires the knowledge of 64bit SBS 2008 environment.
0
Glen KnightCommented:
I can probably help with the SBS side of things, someone want to give me a quick run down?
0
wrxguruAuthor Commented:
We have a software application for Windows Mobile/CE that utilises remote SQL.  Remote SQL of course needs IIS and requires the replication tools to be installed to work.  we do NOT use replication just remote sql.  In the past we have installed a seperate instance of SQl EXpress 2005 with replication onto Windows 2003 SBS servers and everything has been fine.  Now we are finding that this is no longer true with SB 2008 and we cannot installed the replication components no matter what we try.  
0
Glen KnightCommented:
Unlike SBS2003, SBS2008 is very heavily tied in with IIS and SQL Express for WSUS, Sharepoint & Exchange.  It was much easier to change IIS with SBS2003.

That said you should be able to install a seperate SQL Express Instance you just need to be aware of the ports already in use with SBS2008 when configuring the IIS side of things.

Ports already in use on IIS with SBS2008 are: 80, 443, 987, 4721, 8530 & 8531
0
Mark WillsTopic AdvisorCommented:
ummmmm....

I thought you could install replications and connectivity options from Express Install, but, when you go to install CE Tools it then complains that it cannot find the replication components.

Because you have SBS premium you also have a full license of SQL Server. Has it been installed, and where ?
0
wrxguruAuthor Commented:
I am going to duoble check which site had standard and which had SBS.  However one thing someone in AUS has told me is that sql express is not support on SBS is that true ?
0
Glen KnightCommented:
Not that I am aware of, if you think Backup Exec and other 3rd party tools use SQL Express on SBS2008
0
Mark WillsTopic AdvisorCommented:

Of course Express DOES NOT set up any remote comms if you install seperately. Not sure if you are at that point just yet... And because you do this successfully on SBS 2003, expect you already know... See : http://support.microsoft.com/kb/914277

If you have premium, I know SBS does expect to use the full version, and with 2008 onwards it is also looking to install on a seperate machine.

I have not heard anywhere that Express CANNOT be installed on a SBS 2008 machine.

SBS does of course come with 2005 Express for its own monitoring and an embedded version for sharepoint services - you should NOT uninstall or play with either of those - they cannot be readily migrated, and there is a specific process needed to migrate across to standard versions.

There is quite a bit of doco that you can follow..... http://technet.microsoft.com/en-us/library/cc794697(WS.10).aspx
0
wrxguruAuthor Commented:
Another thing worth mentioning is that we do not have this problem on the full windows 2008 server ONLY on the SBS versions.
0
Glen KnightCommented:
If it's only in SBS I would suggest it's a conflict between the SQL Express that is already installed.
0
wrxguruAuthor Commented:
yes, this seems to be the case as its the installation of the replication components that fail.  this indicates the existing SBS monitoring instance may be causing this problem.
0
Glen KnightCommented:
Yes, as I said SBS2008 is quite heavily tied in to SQL Express, the SBSConsole etc.  Unfortunately there is not much chance of getting around this
0
wrxguruAuthor Commented:
but can u use the full version of sql 2005 on a standard SBS server to install replicaiton components or must u use SBS premium (which i think has the problem as well)
0
Glen KnightCommented:
SBS Premium comes with an additional Windows 2008 Standard license for installin SQL server on to.  You don't install SQL onto the SBS Server.
0
Mark WillsTopic AdvisorCommented:
Bit confused... you said some time back that you were able to install replication and connectivity components, and really should be using CE Tools SP2 (link provided earlier)...

If you installed the full version of SQL Server (that comes with SBS premium) then the link above shows you how to install seperately.
0
Mark WillsTopic AdvisorCommented:
Demazter,

yes you can install on the server - it is just not recommended...

Have a quick look at that link  http://technet.microsoft.com/en-us/library/cc794697(WS.10).aspx

0
Glen KnightCommented:
Thanks Mark_wills, yes you can but as you said it's not recommended, I said "You don't install SQL onto the SBS Server" as in don't do it. :)
0
Mark WillsTopic AdvisorCommented:
*laughing* must be that accent :)
0
wrxguruAuthor Commented:
Still unclear as to whether sql express and replication components whicih will allow sql ce tools to work can be installedon SBS or SBS premium.  Doesn't anyone actually know the answer even microsoft ?
0
Mark WillsTopic AdvisorCommented:
Have not heard of an issue on SBS or SBS premium specifically, think it is your combination that means you have to get it perfect.

There is a problem installing with IIS7 on a 64 bt machine - maybe that is an issue for you : http://support.microsoft.com/?kbid=955966

0
wrxguruAuthor Commented:
I have now been able to test installing the full SQl standard onto the SBS server standard machine and in this combination we can get sql ce tools working.  Seems like in SBS standard 2008 now microsoft have taken something out of the SQL that gets installed so SQL express is no longer enough to install sql ce tools
0
Glen KnightCommented:
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.