The SQL Enterprise Manager will default to port 1433, so unless you changed
it, I wouldn't worry about that.
Try re-establishing the connection with the Client Network Utility. Also,
try using a different authentication routine. For example, login to Win98
as the username/password combo you would use to connect to the SQL server
and then try using trusted connection instead of SQL authentication.
If all else fails, call the ISP and have them walk you through it.
---mark
------------------------------------
Mark Warrick - Fusioneers.com
Personal Email: [EMAIL PROTECTED]
Business Email: [EMAIL PROTECTED]
Phone: 714-547-5386
Efax: 801-730-7289
Personal URL: http://www.warrick.net
Business URL: http://www.fusioneers.com
ICQ: 125160 / AIM: markwarric
====================================
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, June 17, 2001 11:14 AM
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
