UDL failed to connect to SQL server

[MengHuiHanTang]

I have been using UDL as the means to connect to SQL server in Windows XP. But after upgraded to Window 7, UDL cannot connect any more. I still can connect to SQL database through the means of ODBC.

UDL itself connects successfully. I know it is something about Windows 7. What is exactly the problem here?

[josborne]

Where is the SQL Server?  I assume its on a remote machine?

Did you try using an IP address instead of host name?

In your UDL, you you are using Windows Authentication.  Did you happen to install the SQL Server in mixed mode?  If so, you could try specifying a known username/password instead of using Windows Authentication.

Turn off your firewall to see if that is the problem.

[MengHuiHanTang]

It could be the firewall. I tried on another PC with windows 7. UDL connection works fine with firewall shut off. 

Thanks for the help.