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.

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

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, check the effect. Hope this helps. Rock Wang TechNet Subscriber Support in forum If you have any feedback on our support, please contact tngfb@microsoft.comRegards, Rock Wang Microsoft Online Community Support

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.comRegards, Rock Wang Microsoft Online Community Support

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

Hi Rock Wang, Is that same on what people call it use SQL Alias name?

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...