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.



>>Hi All,
>>
>>How to create a connection string to SQL server with user ID, this is the connection string I am using:
>>

>>strConnString = "Data Source=" & strDataSource & "; Integrated Security=SSPI" & "; Initial Catalog=" & strDatabase
>>
>>oAdoNetSql_Conn.ConnectionString = strConnString
>>oAdoNetSql_Conn.Open()
>>

>>
>>Thanks for the help
>
>

>string ConnectString = "Data Source=" + strDataSource + ";Integrated Security=SSPI" + "; Initial Catalog=" + strDatabase;
>
>SqlConnection oConnection = new SqlConnection(ConnectString);
>oConnection.Open();
>
>

>
>Is that what you wanted?
>
>Morgan