Hi all.

I'm trying to conect to another datasource in Contour, but I'm having difficulty setting it up.

When I create the datasource, I'm given a 'template' connection string that looks like this;

Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

But the database I need to connect to uses windows authentication, and I'm led to believe that I need to use something like this;

"Data Source=SERVERADDRESS; Initial Catalog=DATABASENAME;Integrated Security=True;"providerName="System.Data.SqlClient"

But I simply don't understand enough of this to make it work. I have no control over the database, so I can't create a user account for it or anything.

I've searched the forums, and the web, and I can only find reference to editing things in web.config, but I'm not certain this is the right approach since the database is not the same as the one Umbraco uses.

Can anyone point me in the right direction?

Thanks. :)