locked
change WSS 3.0 sql server from machine name to DNS name RRS feed

  • Question

  • We are running a WSS 3.0 server and a SQL 2005 server in a two server farm.  The sharepoint system points to the databases on the SQL server using the SQL server machine name and I need to change the machine name to a DNS name, not moving anything at this time, we just need to stop using the machine name and start using DNS and i am having trouble figuring out a procedure for this. Thanks in advanced for any advice.

     

    Thursday, December 9, 2010 12:47 AM

Answers

  • Hi Robert-SysAdmin,

     

    Thanks for your question.

     

    From your description, you want to add a DNS name for your WSS 3.0 SQL server, and use the DNS name to connect to the SQL server. If I misunderstand your question, please let me know.

     

    You can add a DNS record to point to the IP address of the SQL server, then make sure your WSS 3.0 server can resolve the DNS name. Finally, rerun the SharePoint configuration wizard, check the effect.

     

    Note: Please do the above steps in a lab environment before doing it in the product environment. Or back up your database before do it.

     

    Hope this helps.

     

    Rock Wang

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com

     


    Regards, Rock Wang Microsoft Online Community Support
    Thursday, December 9, 2010 3:29 AM
  • You should consider setting up SQL aliases. They offer various benefits. Todd Carter's blog has a walkthrough: http://todd-carter.com/post/2010/12/03/Done28099t-Tell-SharePoint-The-Name-of-Your-SQL-Server.aspx

     


    Living the SharePoint dream...
    Wednesday, December 15, 2010 2:23 PM

All replies

  • Hi Robert-SysAdmin,

     

    Thanks for your question.

     

    From your description, you want to add a DNS name for your WSS 3.0 SQL server, and use the DNS name to connect to the SQL server. If I misunderstand your question, please let me know.

     

    You can add a DNS record to point to the IP address of the SQL server, then make sure your WSS 3.0 server can resolve the DNS name. Finally, rerun the SharePoint configuration wizard, check the effect.

     

    Note: Please do the above steps in a lab environment before doing it in the product environment. Or back up your database before do it.

     

    Hope this helps.

     

    Rock Wang

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com

     


    Regards, Rock Wang Microsoft Online Community Support
    Thursday, December 9, 2010 3:29 AM
  • Hi Robert-SysAdmin,

    Have you solved your problem yet? If anything is unclear, please feel free to ask me.

    Rock Wang

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com


    Regards, Rock Wang Microsoft Online Community Support
    Monday, December 13, 2010 2:24 AM
  • Hi Robert-SysAdmin,

    Did you have questions? If anything is unclear, please feel free to ask me.

    I'm looking forward to hearing from you.

    Rock Wang

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com


    Regards, Rock Wang Microsoft Online Community Support
    Wednesday, December 15, 2010 2:06 AM
  • Hi Rock Wang,

    Is that same on what people call it use SQL Alias name?

    Wednesday, December 15, 2010 2:45 AM
  • You should consider setting up SQL aliases. They offer various benefits. Todd Carter's blog has a walkthrough: http://todd-carter.com/post/2010/12/03/Done28099t-Tell-SharePoint-The-Name-of-Your-SQL-Server.aspx

     


    Living the SharePoint dream...
    Wednesday, December 15, 2010 2:23 PM