components installation

I am just a novice, and am curious.I

I was trying subscription, but an error occured: "Microsoft Server Management Studio is un able to accessreplication components because replication is not installed on this instance.

I went to change, located my setup exe, installed. but at the end, I get this message: No selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine......

I downloaded the Express edition via MSDN download.

May somebody please help? What wrong did I do? What did I miss to do?

SQL Server 2005 Express does not include Microsoft SQL Server Management Studio. But SQL Server 2005 SQLEXPRCOMP does.|||There is also a separate download for the Management Express Studio. See this link here for more details:

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Compatiblity of SQLDMO and SQLSMO with respect to scripting via COM

Hi all,

I need your help:

Context:
I have developed since long an installation with InstallShield's InstallScript language. This installation "talks" to SQLServer2000 in order to install, upgrade, backup and restore the application's database. All this is done in the InstallScript code using SQLDMO currently, using the COM interface as if using VB script.

Problem:
Now as we are preparing to support installation on SQL2005, I am investigating the usage of SQLSMO, as SQLDMO cannot be excepted on all target systems (SQLExpress must be supported, too).

I looked in the SMO namespace and recognized, that the contained classes are registered as COM objects, too. Due to this I have no problem creating a Microsoft.SqlServer.Management.Smo.Server object from my scripting code.
But - opposed to SQLDMO the SMO server object does not have a Connect() method.

Looking further I found the Microsoft.SqlServer.Management.Common.ServerConnection object which seems to have the functionality I need - but this object is not registered as a COM object and as such is not scriptable - I am stuck :-(

Generally it seems, that SQLSMO is by far not a replacement or enhancement to SQLDMO. So - how to solve tasks which where using SQLDMO up to now?

Please - give advice!

Thanks,
Jo

Sorry, Jo, you're correct with respect to COM support for SMO - it's not there. It's not hard to build a VB console application to do what you're attempting, though, and then you can connect to the server either through the Connect() method or by setting arguments in the ServerConnection object. I've used both successfully.

There's a lot of argument in this forum whether or not SMO is an enhancement to DMO, and while some have had some performance issues with SMO, I feel that the object model is much more straightforward and easy to use than its predecessor. We just have to approach things differently.

Compatibility between installation of MSDE 2000 and SQLServer 7

I want to install MSDE 2000 rel A on a Windows Server 2000 where SQLServer 7
is installed.
CAn I do it? Can MSDE and SQLServer live together?
Must I do any action before to install MSDE?
Thank you in advance
enzo giurleo
hi Enzo,
Enzo Giurleo wrote:
> I want to install MSDE 2000 rel A on a Windows Server 2000 where
> SQLServer 7 is installed.
> CAn I do it? Can MSDE and SQLServer live together?
> Must I do any action before to install MSDE?
> Thank you in advance
> enzo giurleo
you can install MSDE 2000 on a pc already hosting SQL Server 7.0..
SQL Server 7.0 will be the default instance, as it does not support multiple
instances, while MSDE will become a named instance you have to connect to
using the <computername>\<instancename> syntax but...
but...
MSDE 2000 will install and register it's own part of the shared component,
such as SQL-DMO and so on, and it does not contain the full client tools
like Enterprise Manager, Query Analyzer, Profiler and so on, so you loose
the possibility to administer your SQL Server 7.0 with your original 7.0
tools...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply