From: Andrew B. <a.g...@le...> - 2006-05-24 12:29:18
|
Yes, been there, done that, got the T-shirt. Took me a little while to work out how to set up the TCP/IP. At first glance it seems to be enabled, but when you start poking about in various tabs, you find that although TCP/IP may be enabled, no interface or port is listening. If you have any .NET stuff that you are fond of (seek treatment) be careful. The installation of SQL Server 2005 automatically installs .NET 2.0 and all sorts of things break - including the version 4.2 of Questionmark Perception. Aggie -----Original Message----- From: bod...@li... [mailto:bod...@li...] On Behalf Of Peter Crowther Sent: 24 May 2006 12:28 To: bod...@li... Subject: RE: [Bodington-developers] Bodington and SQL Server 2005 > From: Andrew Booth > In which case you probably need to put 2005 into 2000-compatible mode. Apparently not. In order to *connect*, merely ensure the TCP/IP protocol is enabled on the server (from computer management ==> services and applciation ==> sql server 2005 configuration ==> network configuration) and live on port 1433. God only knows about security. I might have a hack at it here in a few days, when I have a SQL Server 2005 live on our network. - Peter ------------------------------------------------------- All the advantages of Linux Managed Hosting--Without the Cost and Risk! Fully trained technicians. The highest number of Red Hat certifications in the hosting industry. Fanatical Support. Click to learn more http://sel.as-us.falkag.net/sel?cmd=k&kid7521&bid$8729&dat1642 _______________________________________________ Bodington-developers mailing list Bod...@li... https://lists.sourceforge.net/lists/listinfo/bodington-developers |