SQL Server 2005 permission problems

2008-09-16 Thread James Buckingham 
Hi there,

I'm trying to setup an exported 2000 server DB on my local SQL Server (2005 
Express) and getting a permissions problem when I try and set things up in 
ColdFusion. The error I'm getting is:

Connection verification failed for data source: myDB
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot 
open database myDB requested by the login. The login failed.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC 
Driver][SQLServer]Cannot open database myDB requested by the login. The login 
failed.



I have a couple of other SQL Server DBs setup and they work fine which is 
what's confusing me a bit. I've got a global user account within my DB for 
Coldfusion and I'm trying to use this, the datasources that are working are 
using this as well!

As I say the only difference with this DB is that it's been built from an SQL 
script rather than manually by me. I've changed the owner of the tables to DBO 
and apart from that I can think what else would be different.

There isn't a lot on Google about this error message so I thought I'd see if 
anybody else on here has had this issue.

Thanks a lot,
James 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312569
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQL Server 2005 permission problems

2008-09-16 Thread James Buckingham 
Well I got this up and running through ODBC but unforunately when I did 
Transfer ORM, which I'm using to manage my DAO, throws an error message.

How do permissions work in SQL Server in terms of CF. From what I can all I 
need is the datawriter and datareader roles applied to that user. This is what 
I've got on my working DBs and it's fine!

Any help would be appreciated.

Cheers,
James 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312578
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4