Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 164
  • Last Modified:

Changing SQL Server Settings in code

Hi,

Has anybody written code or know of a way of changing SQL server settings . Of particualr importance are the sql server protacols (named pipes and TCP/IP) . Also port numbers.

Thanks for clicking, reading and if you can help, look foward to your reply.
0
KBanner
Asked:
KBanner
  • 3
2 Solutions
 
Kevin CrossChief Technology OfficerCommented:
I haven't done this myself, but you can take a look at using the WMI providers from Microsoft:
http://msdn.microsoft.com/en-us/library/ms180606.aspx

If you follow some links through, you will eventually find this:
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.wmi.managedcomputer(SQL.90).aspx

Per this document, client protocols and connection settings are in the list of WMI accessible items.
0
 
Kevin CrossChief Technology OfficerCommented:
Here is an example of reading port number value:
http://msdn.microsoft.com/en-us/library/ms179354(SQL.90).aspx
0
 
KBannerAuthor Commented:
My apologies for late points allocation
0
 
Kevin CrossChief Technology OfficerCommented:
Not a problem.  Glad that helped!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now