need help on ADO.net connection string
Is that user granted login abilities in SQL?
If using SQL 2005, you go to Security->Logins
Double click the user, and click Status.
------Edit ----
Create a file on your desktop called TEST.UDL.  Double click it.
setup your connection until it works.
View the UDL in notepad,  there's your connection string.  Though I think you take out the first part which includes provider info.
I have to get the data from a User site. If I would work on their site, I would VPN and then remote into their server using username and password.
I thought getting data into my local machine than getting into their server where my work is not secured.
So, I thought of using Ironpython to get data from the remote server. 
So, I still VPN'd to their domain, but when I was using the ADO.net connection string to connect to their database, it does not work.
connection string:
Data Source=xx.xx.xx.xx;Initial Catalog=;User ID=;Password=;
and the error says:
login failed for 
Well, one thing to notice is: when  i remote into their server, I provide username and password once. Then when i log on to SQL Server, I dont have to provide username and password. It s windows authenticated. So, in the above connection string, I used the same username and password that I use while remoting in. I hope this gives an idea to ya'll what i might be missing. 
Help appreciated!!!