QtForum.org

I am trying to connect to a REMOTE SQL server 05 named instance using the following connection string resembling a dsn file produced from ODBC DATA SOURCES Administrator that managed to connect remotely:

DRIVER={SQL Server};
Address=<IP>\<INSTANCENAME>,<PORT>;
SERVER=<IP>\<INSTANCENAME>;
Network=DBMSSOCN;
DATABASE=master;
UID=<USER>;
PWD=<PASSWORD>;

//each <WORD> is replaced by the actual values

When using setDatabaseName() with this string or the dsn file location (that connects through ODBC Administrator!!!) i cannot connect and though i dont have the exact error message it says something about "not trusted user".

I ve searched a lot about SQL Server 05 remote connection configuration and i think everything is correctly set. I am sure server listens to My IP address and my PORT but i am not sure if i have to specify the location of the remote user - PC.

If anybody is somewhat familiar with these issues i would really appreciate your help as i am trying this out for quite a long time.

Thanks

P.S. when my application runs locally to the remote SQL server Instance PC
it succeeds to connect using the same connection string (same IP and PORT not localhost\127.0.0.1 and default port 1433)

Problem Solved quite unexpectedly!!

Though specifying username and password in the connection string you
must still use functions setUsername() and setPassword().