Hi,
Thanks for using Microsoft Online Managed Newsgroup.
From your description, I understand that:
You wanted to enable TCP/IP protocol of your MSDE instance programmaticall y.
If I have misunderstood, please let me know.
I believe this article is your want:
How to configure the SQL Server Network Libraries by using SQL-DMO
http://support.microsoft.com/default...b;EN-US;822642
If your SQL Server instance were SQL Server 2005 Express, you can use SQL
SMO to manage the protocol and it seems easier:
Dim mc As New ManagedComputer ()
mc.ServerInstan ces("SQLEXPRESS ").ServerProtoc ols("Tcp").IsEn abled = true;
mc.Services("MS SQL$SQLEXPRESS" ).Stop()
mc.Services("MS SQL$SQLEXPRESS" ).Start()
For using SQL Server Smo, you need to add the references:
Microsoft.SqlSe rver.Smo
Microsoft.SqlSe rver.SmoEnum
Microsoft.SqlSe rver.SqlEnum
Microsoft.SqlSe rver.Connection Info
Hope this helpful!
Please feel free to let me know if you have any other questions or
concerns. It is my pleasure to be of assistance.
Charles Wang
Microsoft Online Community Support
=============== =============== =============== =========
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
=============== =============== =============== =========
This posting is provided "AS IS" with no warranties, and confers no rights.
=============== =============== =============== =========