Hi all!

This has been driving me nuts for a few days now of searching forums for answers. I need to connect to my remote (about 5 feet away) Windows Server 2003 SQL Server 2005 Express database. It is using Windows Authentication. I can login just fine to SQL using remote desktop to make any changes to the Management Studio and I have made exceptions for the server and the browser in the firewall. Here is my connection string:

Code:
Public strDBLocal As String = "Data Source=DATA_SERVER\SQLEXPRESS;Initial Catalog=dbdbdbdb;User ID=xxxxx;Password=yyyy"
DATA_SERVER is the name of the computer and what I use to login using remote desktop. I have tried using "Integrated Security=SSPI" and some others. My current string seems to get the closest. the error is:

"Login failed for user xxxxx. The user is not associated with a trusted SQL server connection."

What am I doing wrong? How do I make this user associated with a trusted SQL connection? Is this not using Windows Authentication? I know how to change to SQL Server Authentication, but how do I create that user name and password?

Any help would be appreciated!!!

Thanks.