Remove "Integrated Security=SSPI" from the connection string. Since you have it in the connection string, you're connecting to SQL Server using Windows Authentication. It sounds like you're looking for SQL Server Auth.
-Mike
>I tried that and added a userid and password not exist in the sql, but it still connects to the database, well it should not.
>
>
>>>Thank you Morgan for your reply,
>>>
>>>No not this what I want, my connection strings works fine, but I need to add a User ID authentication to my string, meaning the connection will connect to database server with the user mentioned in the connection string only.
>>>
>>>
>>>>>
>>>>
>>>>string ConnectString = "Data Source=" + strDataSource + ";Integrated Security=SSPI" + "; Initial Catalog=" + strDatabase + ";uid=" + strUsername +
>>";pwd=" + strPassword;
>>>>
>>>>SqlConnection oConnection = new SqlConnection(ConnectString);
>>>>oConnection.Open();
>>>>
>>>>
>>>>
>>>>Is that what you wanted?
>>>>
>>>>Morgan
>>
>>
>>Trying that, w/ the strUsername equals the username and strPassword equals the password.
>>
>>Morgan