Manage SQL 2000 services/network settings

Is there any way to manage services and network settings for SQL Server 2000 by SMO?

I need to start/stop services , change logon account, manage network protocols.

For SQL 2005 it can be easily done by using classes from SMO.Wmi namespace, as far as I see.

So what about 2000? Should I use DMO libraries and if so, how can I perform that tasks?

Alexander, SQL 2000 uses the Service Manager for setting the login account and start/stop services, so I'd think the same WMI functionality that allows you to manage services will work for the SQL 2000 service. As far as managing SQL Server 2000, it's fully supported in SMO.|||

As far as I see, sql 2000 instances cannot be managed by using Wmi provider.

For example,

(new ManagedComputer("myCompName")).Services

collection will not contain SQL 2000 services.

That's why I'm asking.)

Making SQL 2005 Developer accept the connection string for SQL express edition

Hi, I have installed on my laptop SQL server 2005 Developer edition, I can change ANY of the settings of the SQL server and OS.

I am writing code with a team using continuous integration where the connection string is the following:
"Provider=SQLNCLI;Server=.\SQLEXPRESS;Database=Secret;Trusted_Connection=Yes;"

is there a way (create an alias,rename server, other?) to make my local dev SQL server accept the connection string above, as at the moment I have to rename the connection string every time before checking in code and after downloading the latest version from the code repository.

any advice or tips will be greatly appreciated

Thanks

JW.Hi,

setup an alias using the SQL Server Configuration manager. Configure a new alias to listen to .\sqlexpress and redirect to the installed dev server.

HTH; Jens K. Suessmeyer.

http://www.sqlserver2005.de