SQL Server is installed on a Windows 7 computer (MyServer).
An application connects to the database via a UDL-connection. This works fine if the user logs in directly onto MyServer.
Another computer in the network also needs access to the same database. For this purpose a shortcut is placed on the desktop to the application exe on MyServer.
But somehow the user cannot connect to the SQL Server database. Although when a UDL is placed on the desktop on MY2PC, than the connectiontest can be established when using user "sa".
TCP/IP is Enabled on MyServer (via clicofg.exe and in the configuration manager).
Firewalls on both computer have temporarly been shut down for testing purposes.
What setting must be set in order to give USER2 on MY2PC full access to the database?