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