> -----Original Message----- > From: Dana [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 01, 2007 10:15 PM > To: CF-Community > Subject: Re: sql server management studio > > ok well. Where it says Server Name I am putting the ip address of the > Crystaltech server. I am choosing SQL Server authentication because > the password over there is different than the one here on my desktop. > Server Type is Database Eng but it's greyed out. > > An error has occurred while establishing a connection to the server. > When connecting to SQL Server 2005, this failure may be caused by the > fact that under the default settings SQL Server does not allow remote > connections. (provider: Named Pipes Provider, error: 40 - Could not > open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
I see one problem - you shouldn't be using name pipes as the protocol for CrystalTech - use TCP/IP instead. The default port (1433) should be fine. Unfortunately I don't have the program installed so I can't walk you through it, but I think you need to run the Configuration tool and enable TCP/IP. I don't think that an icon to the tool is provided but the command line should be: C:\WINNT\system32\mmc.exe /32 "C:\WINNT\system32\SQLServerManager.msc" I'm sorry I can't be more specific but your problem is clear: you need to connect to CyrstalTech's servers using TCP/IP. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:239416 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
