>>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
>
>
>I'm not familiar w/ Integrated Security=SSPI i just set server, database uid = pwd and that is it.
Thanks for your help Morgan.
<><><><><><><><><><><><><><><><><><><><>
<><> REMEMBER,,,,KNOWLEDGE IS POWER <><>
<><><><><><><><><><><><><><><><><><><><>