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 we modify the files path for the database in database engine?

Hi, all experts here,

Thank you very much for your kind attention.

I am trying to modify the files path (primary file, log file) of databases, but it looks like I am not able to mofidy their files path directly from the database property dialogue? Would please any experts here give me some ideas on what else can I try to figure it out? Thanks a lot in advance and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

I don't think it's possible to modify file paths when the database is active (read only)

I'd suggest DETACH, RE-ATTACH with different file path

should take < 1 minute

|||

You can not just change the path. You have to either detach and attach the database or backup and restore the database. Detach and attach will be faster and easier with less chance of data loss.

Both options are offline procedures.

|||

Hi, all,

Thanks a lot for your kind advices.

With best regards,

Yours sincerely,

|||Hi Helen,

You cant change the filepath when the database is in online. When sqlserver starts it will check for the path of database (from sysaltfiles tables) and it will start accessing the files. Once the database is online it will lock the file (you cant even copy the physical file through OS).

You can detach the db and move the physical file to the path you needed and the attach the db. It will work fine.

The above description is only for user dbs.|||

Hi, Sagar,

Thanks a lot for your very kind advices and help.

With best regards,

Yours sincerely,

How can we modify the files path for the database in database engine?

Hi, all experts here,

Thank you very much for your kind attention.

I am trying to modify the files path (primary file, log file) of databases, but it looks like I am not able to mofidy their files path directly from the database property dialogue? Would please any experts here give me some ideas on what else can I try to figure it out? Thanks a lot in advance and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

I don't think it's possible to modify file paths when the database is active (read only)

I'd suggest DETACH, RE-ATTACH with different file path

should take < 1 minute

|||

You can not just change the path. You have to either detach and attach the database or backup and restore the database. Detach and attach will be faster and easier with less chance of data loss.

Both options are offline procedures.

|||

Hi, all,

Thanks a lot for your kind advices.

With best regards,

Yours sincerely,

|||Hi Helen,

You cant change the filepath when the database is in online. When sqlserver starts it will check for the path of database (from sysaltfiles tables) and it will start accessing the files. Once the database is online it will lock the file (you cant even copy the physical file through OS).

You can detach the db and move the physical file to the path you needed and the attach the db. It will work fine.

The above description is only for user dbs.|||

Hi, Sagar,

Thanks a lot for your very kind advices and help.

With best regards,

Yours sincerely,