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 programmatically.
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.ServerInstances("SQLEXPRESS").ServerProtocols(" Tcp").IsEnabled = true;
mc.Services("MSSQL$SQLEXPRESS").Stop()
mc.Services("MSSQL$SQLEXPRESS").Start()
For using SQL Server Smo, you need to add the references:
Microsoft.SqlServer.Smo
Microsoft.SqlServer.SmoEnum
Microsoft.SqlServer.SqlEnum
Microsoft.SqlServer.ConnectionInfo
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.
================================================== ====