I have a mssql connection resource file as belows:
<% Set Conn01 = Server.CreateObject ("ADODB.Connection") Conn01.Open "PROVIDER=SQLOLEDB; Data Source=forum;UID=forumuser;PWD=forumpass;APP=;Initial Catalog=forumdb" %>
The webserver can interact with the database server when an user logs into the forum BUT I can't ping "forum" machine from the webserver machine. It says "host doesn't resolve." So how am I supposed to know the IP of the database server? There is only a name called "forum" but it doesn't resolve to anything when I attempted pinging the machine.
I need to know the IP address of this data source.