>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