use the client configuration manager to create a "friendly" servername for your sql server.
type cliconfg in the run box on the start menu. Under the alias tab, create a new alias pointing to the SQL server's IP and make sure network Lib's are on TCP/IP (if thats what you want) In CF admin, enter the alias you created as the server name. - j -----Original Message----- From: Haggerty, Michael A. [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 11:27 AM To: CF-Talk Subject: RE: How do I conect a web server to a sql server? Can the Web server see the SQL server on the network? The setup is fairly simple: 1) Install CF on the Web server. 2) If necessary, install the latest SQL Server ODBC driver, freely available on M$'s Web site. 3) Use the CF administrator to set up an ODBC connection to the SQL Server. Something tells me there is a key piece of information missing.... Mike -----Original Message----- From: Phillip Broussard [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:07 AM To: CF-Talk Subject: How do I conect a web server to a sql server? I have 2 boxes. One is a Win 2k web server and the other is a Win 2k SQL server. I need to get the web server talking to the SQL server so I can get CFServer 5 hooked up. Can some one give me a quick "how to" or send me a link to some place that can help? I have 3 different books been all over the knowledge base and crawled iisfaq.com but cant find anything to do this. Then again it was late and I could have looked right over it. Thanks Phillip Broussard Tracker Marine Group 417-873-5957 ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
