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]
