This project has moved and is read-only. For the latest updates, please go here.

SqlConnection to Effort's database

Oct 17, 2013 at 10:50 AM
Hello,

I have an issue. I try to connect to a Effort's db through sqlconnection. Is it possible?
I tried with connection string looks like:
Data Source=localhost;Initial Catalog=EffortInstanceID;Provider=SQLNCLI11.1;Integrated Security=SSPI;
but I received an error

"An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Login failed for user 'myusername'.".
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Cannot open database "EffortInstanceID" requested by the login. The login failed."."

Can I change somehow, Effort's db access permission?

Regards
Oct 20, 2013 at 9:37 PM
Hello,

I am quite unsure what your goal is. Could you tell me a little more detail?