Kinley, You may be having a problem ..... that your client is trying to use "named pipes" to connect to the SQL Server ...since you said by IP address .... you probably want to use TCP/IP to connect to the server. Take a look at the "Client Network Utility" to make sure that you can use TCP IP to connect. And your Not being able to select the connection protocol when I'm registering a server just seems silly. It's one of the annoyances I've had with SQL server for a while now. To get the Register Server wizard .... Click on the root SQL group (named "SQL Server Group") then choose Tools from the menu bar ---> Wizards... (again silly way to have to do things) -eric ------------------------------------------------ Common sense is genius dressed in its working clothes. -- Ralph Waldo Emerson Eric Barr Zeff Design (p) 212.714.6390 (f) 212.580.7181 -----Original Message----- From: Kinley Pon [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 04, 2001 2:47 PM To: CF-Talk Subject: OT: Enterprise Manager I have been frustated out of my brains...I foolishly selected to have the wizard for registering a new SQL Server turned off. So from that point on, each time I right-click a server and then click "New SQL Server Registration", I get the "Registered SQL Server Properties" dialog box instead. Within the dialog, the dropdown list does not have anything available to select from except "(local)", so I enter the IP address of the server I wish to register. This is not working for me. I get a timeout when attempting to connect. I have used the wizard and that works beautifully. But how do I re-set my Enterprise Manager so that I can have access to the wizard again? I have tried uninstalling and installing Enterprise Manager several times but it is storing the original setup somewhere on my workstation. Really frustrated... Can anyone help...please? - Kinley ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
