If you are using SqlConnection then the connection string should be as follows:
server=localhost;uid=sa;password=;database=northwind
i.e
server=;uid=;password=;database=\\'
For SqlConnection we do not provide a Provider . Provider is used in cases where OleDbConnection is used.