error in connect to sqlserver in windows and sql authentication mode

Question

i have a snippet that it work properly when i use windowsmode with follow connection string

data source=.;database=xDB;integrated security=true;

but i have to change it for sql and windows mode i changeit to

Data Source=.;Initial Catalog=xDB;User Id=krs;Password=12345;

but follow error occur

Login failed for user 'krs'. The user is not associated with a trusted SQL Server connection.

and when change dot(.) to(local) another error occur

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

plz help me im beginer n confused.thank

Can you Please show here your full Connection String from Web.Config File and have you also tried to log in Sql Server with Same Credential that you are passing here? — RL89
– RL89, Commented Sep 25, 2012 at 8:10
To address the secondary issue - it's localhost, not local — J. Steen
– J. Steen, Commented Sep 25, 2012 at 8:11
i dont puit inweb config: SqlConnection con = new SqlConnection("Data Source=local;Initial Catalog=xdb;User Id=krs;Password=1234;"); — quantum62
– quantum62, Commented Sep 25, 2012 at 8:18

J. Steen · Accepted Answer · 2012-09-25 08:25:00Z

2

You have to enable the Named Pipe & TCP/IP in SQL Server configuration. Go through following link to enable that

http://www.triostechs.com/Microsoft-SQL-Server-2008/Microsoft-SQL-Server-2008-Enable-TCP/IP-or-Named-Pipes.html

Also Make sure, only one instance of the SQL Server running. If it is more than one, just verify which one you are connecting to.

edited Sep 25, 2012 at 8:25

J. Steen

15.6k15 gold badges59 silver badges64 bronze badges

answered Sep 25, 2012 at 8:22

Rajesh Subramanian

6,4855 gold badges33 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

error in connect to sqlserver in windows and sql authentication mode

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related