How come I dont see Database Engine under MSSQLSERVER

in Surface Area Configuration for Features.
What the problem is?
Thanks in advance.No problem, works fine on my machines ... i just tell it what i want and it does it.

Operator error?|||What did you mean? I try to set up the database mail. According to ms document I have to enable it from surface area configuration. But I don't see it from that area at all.

No problem, works fine on my machines ... i just tell it what i want and it does it.

Operator error?|||There is no problem.

Your first post was very ambiguous, so you received a general response.

Under Surface Area Configuration (SAM), I change to the 2005 server where I want to allow Databasemail, click the box to enable the feature and click the OK button.

If you are not a sysadmin, you cannot do this. If you do not change to the proper instance, you cannot do this.|||How do you attach the file. I want to show you what I have here.|||OK, I found how to attach the file now. Here is what I see on my local box. And I am the member of sysadmin.

There is no problem.

Your first post was very ambiguous, so you received a general response.

Under Surface Area Configuration (SAM), I change to the 2005 server where I want to allow Databasemail, click the box to enable the feature and click the OK button.

If you are not a sysadmin, you cannot do this. If you do not change to the proper instance, you cannot do this.|||By default surface area configuration will open for localhost database server. If u want to coneect to another server, u need to do the following things:

When u open the surface area configuration, in main window, at the bottom u will see "Configure surface area for locahost [Change computer]" option.
Please click on change computer option and type ur server name. it will open the typed surver.
There u can set database mail option. Let me know if u find any issue.|||I want to set up the database mail on my localhost server.|||I checked ur attached doc, u are using different window.
When u open the surface area configuration, in main window, please click on "Surface are configuration for features" option. This will open the window which will have all the instance names wich installed on ur system.
and make sure ur service is running.|||i have one quetion, is ur local instance is present in sql 2005? because sql 2000 instance names won't come in surface area configuration.|||and I still don't see the database engine. see attachment.

I checked ur attached doc, u are using different window.
When u open the surface area configuration, in main window, please click on "Surface are configuration for features" option. This will open the window which will have all the instance names wich installed on ur system.
and make sure ur service is running.|||i have one quetion, is ur local instance is present in sql 2005? because sql 2000 instance names won't come in surface area configuration.

Yes, it is sql 2005.|||The only service that is disabled is SQL Server Active Directory Helper. See my attachment.

Thank you for your help. I really appreciate it.

I checked ur attached doc, u are using different window.
When u open the surface area configuration, in main window, please click on "Surface are configuration for features" option. This will open the window which will have all the instance names wich installed on ur system.
and make sure ur service is running.

How can you enable remote connections using TSQL?

I know how to enable remote connections using the Surface Area Configuration tool.
Seems there would also be a way to configure it using a TSQL command/procedure call.
thanks,
- Paul -
You can use sp_configure to enable the features exposed by Surface Area Configuration tool. To see the options, run following first:
exec sp_configure 'show advanced options', 1;
reconfigure with override;
Please take a look at topic below in Books Online for more details.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/scsql9/html/f741169c-1453-4ad2-830b-bf2be27d712f.htm
For remote connections, you have to use SMO to do it. Doing it from TSQL directly is not possible since it requires manipulation of registry values and please don't use the undocumented XPs for registry manipulation.

How can Replicate Between Ms SQL 2005 to MYSQL

Hi;

I have sql 2005 server in my local area and mysql server on internet..

How can replicate Ms SQL 2005 to MYSQL ? is that possible ? or any possible version this server ?

I try sql 2000 server for replication; publishing starting but then ? take "invalid cursor state " message. ? delete tables msrep7 in mysql then replication starts but if replication stop for any reason , ? must delete table again again...

is this bug in sql 2000 ? how can fix that ?

Thanks...

MYSQL isn't a supported subscriber, so it may not work.