exort

@ingvarorn I had hope but just try your map drive suggestion and it didn't work unfortunately.

@slavergne I'm running RDM from my home computer that isn't joined to my company domain trying to connect to the SQL DB over VPN. Therefore, runas with my corporate domain credentials isn't possible.

edited by exort on 12/3/2014

Hi,

I've been using the product for over a year and absolutely love it except for this little annoyance. I was never able to get my domain credentials to connect to the MSSQL datasource over VPN on a non-domain joined computer.

So basically from my home computer I have a VPN connection to the office, I can ping the SQL server and there's no firewall restrictions. I can ping the domain controllers as well. I specified a domain user which has admin access on the RDM database, the domain user password, the server in this format SQLSERVER\MSSQLSERVER (we're using the default instance name) and the correct database name we're using. Keep in mind that we use almost the same settings in the office everyday to connect to the same database, we just use the Integrated security instead as we're part of the domain.

With those settings when I click on Test Server I get: Unable to connect to the server!

A network-related or instance-specific error occured while establishing a connection to the SQL Server.

We're using version RDM 10.0.4 & our SQL server is running 2008 R2 64 bits.

Any help will be appreciated. We're a paid a customer so feel free to contact me privately.

Thanks!

edited by exort on 12/2/2014

Hi,

I've set a folder credentials to "my personal credentials" and batch edited the entries below it to credentials "Inherited". It's still prompting me for credentials.

I can only get it to work if I batch edit the entries to use directly "my personal credentials".

Please advice,

Merci

Alexandre