>- see footer for list info -< Russ, Yes both dsns are on the same server and both sql instances on the same box...
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:dev- > [EMAIL PROTECTED] On Behalf Of Snake > Sent: 01 March 2006 22:35 > To: 'Coldfusion Development' > Subject: RE: [CF-Dev] trying to connect to a new named instance of SQL server > > >- see footer for list info -< > With the one that works and the one that doesn't > Are both DSN's on the same CFSERVER, and are both SQL instances on the same > server? > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Niklas Richardson > Sent: 01 March 2006 21:18 > To: Coldfusion Development > Subject: Re: [CF-Dev] trying to connect to a new named instance of SQL > server > > >- see footer for list info -< > Are you running Windows XP SP2? > > On 3/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> > wrote: > > > > >- see footer for list info -< > > Hi all > > > > > > > > I've done this a million times but this time I've missed something! > > Trying to setup a datasource to point to a named instance on a SQL server > box. > > I've > > checked everything I can think of, in the administrator I have > > servername\instance name, I have the port set to correctly match the > > port for the named instance as shown in the sql server server network > utility. > > I've restarted the server, I've been able to telnet to the database > > box on the correct IP/port address. Network guys have double checked > > the firewall > > - > > so I've run out of ideas. I have another database on the same server > > (different instance to which I can connect fine). Checked the user > > name and password and they can connect fine but I still get the > > following error (CFMX7, SQL 2000) > > > > > > > > Connection verification failed for data source: xxxxxxxx > > java.sql.SQLException: [Macromedia][SQLServer JDBC > > Driver][Macromedia][SQLServer JDBC Driver]The requested instance is > > either invalid or not running. > > The root cause was that: java.sql.SQLException: [Macromedia][SQLServer > > JDBC Driver][Macromedia][SQLServer JDBC Driver]The requested instance > > is either invalid or not running. > > > > > > > > Anything else I can try? Thanks > > > > > > > > Kola > > > > > > > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, go > > to http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > >- Hosting provided by www.cfmxhosting.co.uk -< > > >- Forum provided by www.fusetalk.com -< > > >- DHTML Menus provided by www.APYCOM.com -< > > >- Lists hosted by www.Gradwell.com -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > > >help > > -< > > > > > > -- > Niklas Richardson > Prismix Ltd > > UK based Flex and ColdFusion Specialists > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > >-< > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
