> I am using the following settings: > DSN: cm > database: cm (this is a database in my > local instance of SQL Server) > server: (local)
Try the IP address or FQDN - I don't think JDBC recognizes "(local)". > port: 1433 > username: system OR cm (system with only windows > security set, cm with SQL Server auth set) > password: [none] or "password" You can't use Windows security, only SQL Server logins. You might want to test the account from the ODBC control panel, by setting up an ODBC datasource for testing. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
