To check the port in the client network utility, on the General Tab, make sure TCP/IP is an enabled protocol and click the properties button. The only option there is port number. Also, for each connection in the client network utility, You're mapping a server alias to the server's address. Under the alias tab, make sure Dynamically determine port is unchecked and you should be able to change the port if need be. Hope this helps =) -----Original Message----- From: JoshMEagle [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 5:12 AM To: CF-Talk Subject: RE: Enterprise Manager connection to SQL Server I had a similar issue recently ... trying to connect to our SQL Servers from a remote location. I was using the IP Address of the servers to connect, but this wouldn't work, I had to use the actual name (such as SQL.MYSITE.COM) instead of the IP ... then it connected flawlessly. I suppose it should work with the IP Address and I'm no expert in this field, so it may just be an anomaly here, but I'd give it a whirl if I were you. I'm sure the SQL experts will have a much more thorough answer for you, however. Joshua Miller Web Development Eagle Technologies Group Technology Solutions for the Next Generation www.eagletgi.com [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 2:14 PM To: CF-Talk Subject: Enterprise Manager connection to SQL Server Newcomer to SQL Server... I'm attempting to use Enterprise Manager to connect via an ISP to a SQL Server 2000 db on a shared host. I was successful in doing that on Friday, but after installing MSDE on my Win98 dev laptop, the connection always failed ("Server does not exist or access denied"). I've uninstalled MSDE and reinstalled Enterprise Mgr, still to no avail. I CAN successfully ping the db, and I've confirmed that the Client Network Utility is set up to use TCP/IP as the protocol. My hosting service says I should confirm that I can use Port 1433, but I'm unsure how to do that or how to further diagnose what's happening. Any help appreciated! Gene Kraybill ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
