Creating multiple databases running off the same Data Engine

Hi, I have looked and loked for the answer to this question and made no progress.
I want to install MSDE on one of our servers, however, when I went to install it, I found that there was another MSDE already installed and running (it was an agent running with our backup software Veritas). Is it alright to create another database and have 2 running simultaneous on the same data engine? Is there any type of limitations that I sould know about - such as number of allowed accesses at one time? Any help is greatly appreicated.You can create another database with the existing MSDE but if you are on a large network I would install another instance and get the Developer edition to manage them that way you will avoid the risk of running your application on MSDE that is already used to the max in system resources. I have seen SQL Server running without databases because it is used to run xp_cmdshell to move data from DB2 AS400 to live SQL Server on the web about four hours a day. Try the link below to buy the Developer edition. When you have installed the Developer edition you right click at the top of Enterprise manager and register both. Hope this helps.
http://www.provantage.com/buy-22053391-microsoft-backoffice-sql-server-2000-developer-edition-shopping.htm

Creating Management plan failed using Management Plan Wizard

Hi

Creating Management plan failed using Management Plan Wizard

Maintenance Plan Wizard Progress

- Creating maintenance plan "MaintenancePlan" (Error)

Messages

Create maintenance plan failed.

ADDITIONAL INFORMATION:

The connection type "ADO.NETQL" specified for connection manager "{ACD31AA3-7242-4CAB-A5ED-2239C4A6A2B5}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
(MaintenancePlan)

The connection type "ADO.NETQL" specified for connection manager "{ACD31AA3-7242-4CAB-A5ED-2239C4A6A2B5}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
(MaintenancePlan)

- Adding tasks to the maintenance plan (Stopped)

- Adding scheduling options (Stopped)

- Adding reporting options (Stopped)

- Saving maintenance plan "MaintenancePlan" (Stopped)

Can Any body help to resolve this?

Thanks In Advance.

post back the Edition and Service pack of your box.

SP2 will solve 99% of issues related to MP. If its not applied pse install SP2 and try.

Madhu

|||

I did the same. I got it worked.

Thanks