CODEWITHSUNDEEP
sql-serverwindowssql-server-2008odbcvirtual-machine
user3508865
user3508865

Reputation: 153

How to create a new ODBC connection to one remote SQL Server

I'm trying to run an application that I've developped recently. This one uses an ODBC connection to browse a defined database.

I'm trying to execute this app from a remote computer. Using VMWare, I've created a new Windows 7 environment and connected on. After that I've tried to create a new System DSN, but, when I set the logins that I'm using to connect on my local SQL Server 2008 I get

Connection failed: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.

How may I to deal with this, please?

Thanks a lot!

Upvotes: 1

Views: 10733

Answers (1)

dean
dean

Reputation: 10098

You will have to use SQL Server authentication to connect or add the local machine to the same domain where the server is.

http://msdn.microsoft.com/en-us/library/ms144284.aspx

Upvotes: 1

Related Questions