Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
I'm not an expert on ADODB, but is it possible that 'forum' is an ODBC connection? Might be worth checking under the ODBC administration settings. –  Andy Smith Dec 1 '11 at 18:50

2 Answers 2

up vote 0 down vote accepted

As Andy stated, open the Data Sources Administrative Tool and find the "forum" connection either under User DSN or System DSN tab. CLick Configure and look at the name of the server at the bottom. Ping the server from the webserver to resolve its IP.

share|improve this answer

There could be an ODBC alias configured as well. On the server's console run cliconfg and look at the Alias tab (I'm that the web server is Windows) for an entry called forum. That will tell you what server the database is actually on.

That or run "sqlcmd -S forum" (give it username and password as well) and run "SELECT @@SERVERNAME" (or just have your web app connect and disabled the results from "SELECT @@SERVERNAME").

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.