my CF datasource setting: CF Data Source Name: test_northwind Database: northwind Server: 10.240.0.63\sql2000 (where 'sql2000' is the instance name) Port: 2866 (I never use the defaut 1433)
or from the Quantum db plug-in for Eclipse: jdbc:jtds:sqlserver://10.240.0.63:2866;user=XXX;password=ZZZZ the short story is that Brian is right on the money about the ports - more info here: http://sqljunkies.com/How%20To/BBF1935A-3D85-4C95-B4EC-5CD76A220B39.scuk HTH barry.b (aplologies if this is a dupe post - my work email -> cfczone account is playing up) On 7/17/05, Barry Beattie <[EMAIL PROTECTED]> wrote: > Sean: > > by non-default do you mean a "named instance" of SQLServer? > > if so (and it hasn't been answered before me) when I get to work*, > I'll copy my DSN details so you can get the correct format of the > settings (it's not hard but it took me a couple of goes to get it > right). > > HTH > barry.b > > *now + 9 hours > > > > On 7/16/05, Brian Hegeman <[EMAIL PROTECTED]> wrote: > > I haven't done this myself, but I think you have to differentiate by > > port. You can find the port an instance is running on in the SQL Server > > Network Utility. Choose your instance from the dropdown and check the > > properties of the TCP/IP protocol. Then just use the IP and port (no > > instance names) in CFAdmin to distinguish between between instances. > > > > HTH > > brian > > > > Sean Zhang wrote: > > > > >My MS SQL Server 2K has two instances: the default and production. For > > >the datasource for the default instance, I just put the IP (10.0.0.10) > > >address of the server box as Server and connection is verified ok. For > > >the datasource for the production instance, I put 10.0.0.10\production As > > >Server, but the verification failed with the message saying something like > > >"could not find the instance". > > > > > >How can I connect to non-default instance of SQL Server 2K? Please help. > > > Thanks. > > > > > >\Sean > > > > > > > > >---------------------------------------------------------- > > >You are subscribed to cfcdev. To unsubscribe, send an email to > > >[email protected] with the words 'unsubscribe cfcdev' as the subject of > > >the email. > > > > > >CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > > >(www.cfxhosting.com). > > > > > >CFCDev is supported by New Atlanta, makers of BlueDragon > > >http://www.newatlanta.com/products/bluedragon/index.cfm > > > > > >An archive of the CFCDev list is available at > > >www.mail-archive.com/[email protected] > > > > > > > > > > > > > > > > > > > > > ---------------------------------------------------------- > > You are subscribed to cfcdev. To unsubscribe, send an email to > > [email protected] with the words 'unsubscribe cfcdev' as the subject of > > the email. > > > > CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting > > (www.cfxhosting.com). > > > > CFCDev is supported by New Atlanta, makers of BlueDragon > > http://www.newatlanta.com/products/bluedragon/index.cfm > > > > An archive of the CFCDev list is available at > > www.mail-archive.com/[email protected] > > > > > > > ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
