I just created an SQL Server database (on the server that's dedicated only to SQL Server databases). The web site that needs to use the database is located on its own server (web server dedicated only to web sites). I was wondering what the steps are for creating a DNS, so that I can use it in the connection string that will point the web pages to the SQL Server database.
Any ideas would be appreciated.