Well, I just tried it for the first time. I have named instances of both SQL Server 2005 and SQL Server Express on my laptop, although I have not used them until just now, to test your issue.
I created a new Plum app using the wizard, connecting to the 'pubs' database in SQL Server 2005. Using a trusted connection I was able to get the Plum IDE to connect to it and install the requisite Plum tables without incident.
However I cannot get a datasource setup in the CF admin to talk to it, so I can't get through the wizard to create a project because I can't connect to the datasource. I am just using the sa account/password to test, and CF tells me 'The requested instance is either invalid or not running.' I put the instance in there correctly as far as I can tell (Gort/SQLSERVER2005) and setup an ODBC connection with the ODBC Data Source Administrator using the same sa info, and I can connect no problem.
All three instances of SQL Server are running off the default port of 1433. I tried changing the port for the instance, but it didn't have any effect.
WinXP SP2, CFMX 7.01 Updater.
Any clue as to why I can't connect?
Curious if anyone has migrated a current plum project (and site) to SQL Server 2005? My current problem is that ColdFusion can connect to the database just fine but when I go into my already existing Plum project and attempt to sync the DB, no luck. The exact error is: [DBNETLIB][ConnectionOpen (InvalidInstance()).] Invalid connection.
I've Googled this error message and I get a bunch of stuff on TCP/IP ports and Named Pipes and even stuff on DBNETLIB and worm viruses all under SQL Server 2000 not 2005, none of which makes any sense since my ColdFusion server can connect just fine.
More details: in my Plum project I have verified that Environment, ColdFusion Data Source AND Database properties are using the same mapping, username, password as CF (and it worked fine under SQL Server 2000). Again, my exist site works fine and CF Admin verifies the data source.
If anyone has any hints, tips, tricks or .45 caliber bullets it would be greatly appreciated. (My apologies if this has been covered before on the reflector, I'm on a new laptop and don't have access to the past issues).
-Jeff
--
v/r,
Jeff Fleitz
