SharePoint server information in SQL script
hi
Without accessing the WSS web front server - Central administration , Is there a sql script to find out the server name, port number in SSMS. I am trying to query all my sharepoint content database (WSS 3.0) - where they reside and live.
Only have access in SSMS.
thanks
November 30th, 2010 3:29pm
Hi Irene,
Thanks to share your post in this forum.
For the issue you have encountered, if you want to find out the server name, please check the followed link:
http://answers.yahoo.com/question/index?qid=20100107004712AA35tdO.
And to find the port number:
http://decipherinfosys.wordpress.com/2008/01/02/finding-the-port-number-for-a-particular-sql-server-instance/.
Hope this could help you!
Leo
Free Windows Admin Tool Kit Click here and download it now
December 3rd, 2010 1:47am