Connection string using SQL Server authentication in C#

Question

I am creating an Excel file in C# with SQL Server. I've tried several connection strings, but it keeps saying that it does not recognise my user ID (the ID is valid and can connect directly to SQL with this)

Can you help me, or tell me where is the error that comment?

Below I show the connections I've tried

connectionstring = "Integrated Security = SSPI;Initial Catalog='DATABASENAME'; Data Source=XXX.XXX.X.XX; ";

connectionstring = "SERVER=XXX.XXX.X.XX;DATABASE=DATABASENAME;UID=sa;PASSWORD=pass;";

connectionstring = "Persist Security Info=False;User ID=sa;Password=pass;Initial Catalog=DATABASENAME;Server=XXX.XXX.X.XX";

connectionstring = "Data Source=192.168.0.18;Initial Catalog=DATABASENAME;Persist Security Info=True;User ID=sa;Password=pass";

connectionstring = "Persist Security Info=False;Integrated Security=true;Initial Catalog=DATABASENAME;server=(XXX.XXX.X.XX)";

connectionstring = "Data Source=XXX.XXX.X.XX,1433;Network Library=DBMSSOCN; Initial Catalog=DATABASENAME;User ID=sa;Password=pass";

cnn = new SqlConnection(connectionstring);

The username is sa and the Password is pass right? And you have tried logging into SQL server using Management studio with those credentials? — Dave3of5
– Dave3of5, Commented Jul 31, 2015 at 14:28
Those aren't the credentials, i use these to show the code, but effectively, with my credentials i can enter without any problem. — Andres Aliaga
– Andres Aliaga, Commented Jul 31, 2015 at 14:31
Maybe it's a problem on the server then look at the server logs to see the reason it refuses authentication. Apart from that I doubt anyone here can help you with this. — Dave3of5
– Dave3of5, Commented Jul 31, 2015 at 14:32
- Alex K, i tried that option but, i keeps saying the same. - Dave3of5, i'll look there — Andres Aliaga
– Andres Aliaga, Commented Jul 31, 2015 at 14:35

Rohit Harkhani · Accepted Answer · 2015-07-31 14:47:56Z

3

Here is the sample connection string format

Data Source=[server];Initial Catalog=[databasename];User ID=[sa];Password=[password]

example - named instance

Data Source=localhost;Initial Catalog=master;User ID=sa;Password=sa123

in case of the default instance

Data Source=localhost\sqlexpress;Initial Catalog=master;User ID=sa;Password=sa123

if you are trying to access express version from another machine please refer and replace localhost with ip or machine name.

answered Jul 31, 2015 at 14:47

Rohit Harkhani

6665 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Pravin Durugkar Over a year ago

hey if we don't have to provide password in connection string and pooling=false

Pravin Durugkar Over a year ago

how can we do it

Rohit Harkhani Over a year ago

pooling you will be able to add with ;, for details i think refer this one connectionstrings.com/sql-server this will give you various combinations.

amza · Accepted Answer · 2015-07-31 14:44:34Z

2

Navigate to C:\Windows\System32\odbcad32.exe. Go to the Drivers tab and then check to see which ODBC drivers you have installed on your system.

Then go to this website and follow the links at the top for whichever ODBC driver you have installed on your system. For C# you may or may not need the Driver= buts its usually safe.

This is the connection string which usually works for me in C# asp.net, however:

Server=[SERVER];Database=[DATABASE];Uid=[USER];Pwd=[PASSWORD]

(note how it is different than yours: Pwd= as opposed to Password=)

edited Jul 31, 2015 at 14:44

answered Jul 31, 2015 at 14:34

amza

8102 gold badges8 silver badges32 bronze badges

1 Comment

Andres Aliaga Over a year ago

thanks, i reviewed that site, but i didn't knew how to see what ODBC driver have

ice1000 · Accepted Answer · 2018-05-01 07:29:36Z

0

"HP\\ADMIN;Initial Catalog = PAY_PROCESSING_GO; User ID=sa; Password=admin@123"

this is my connection string but connection consist Keywords. How to solve this problem

edited May 1, 2018 at 7:29

ice1000

6,6194 gold badges49 silver badges91 bronze badges

answered May 1, 2018 at 6:58

Sandy

11 bronze badge

Collectives™ on Stack Overflow

Connection string using SQL Server authentication in C#

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related