   [.net] SQL Remote Connections and Username/Password?
  Well, first off I'm using VS 2005 and C# (.NET 2.0). I have SQL Server 2005 Express and SQL Server Management Studio Express installed. It works well with both local and remote connections, but now I've run into some trouble.How do you login (remotely) using a username and password. Here's my connection string:"Data Source=serverAddress\\SQLEXPRESS; Initial Catalog=MyDatabase; User ID=MyUserID; Password=MyPassword";And it keeps telling me that "MyUserID" (which is the Login I created in Server Mgmt. Studio, along with "MyPassword", which is the password for the username), is not a trusted connection, or something of that sort. I've tried adding "Trusted_Connection=Yes/No/True/False;". If it's set to "True" or "Yes", the username and password don't matter, and it connects without any problems. It only tells me the username isn't a trusted SQL connection when I set "Trusted_Connection" to "False" or "No".The local connection works fine (not using SQL Server Authentication, just Windows Authentication), and remote works as well. But only if I use Windows authentication. How do I setup a Login to be trusted in SQL Server (or Server Mgmt. Studio), and use the Username/Password to login?   
  Have you enabled the server to use SQL Server Authentication?  By default the server is set up to only accept Windows Authentication.  I am not sure what the Express Management Studio is like but you should be able to change the settings in the Security section of Server Properties.  I usually get to Server Properties by right clicking on the server in the Object Explorer and choosing Properties.   ;  Sorry about the long wait for a response. But thank you, I figured it out. I had TCP/IP enabled, but I had to use "Server=serverAddress, Port" instead of "Data Source=serverAddress, Port". =P   