Connect MVC C# App to SQL Server DataBase

Question

I have a DataBase in SQLSever. Into the webConfig file of my MVC project, when i configure the connectionString by giving the user and the password, it's correct:

<connectionStrings> <add name="jcConn" connectionString="Data Source=LAPTOP\MSSQLSERVERAXVAL;Initial Catalog=bd_school;Persist Security Info=True;User ID=sa;Password=namin"/> </connectionStrings>

But I dont want to specify the user and the password. So by trying to do this, it doesn't work:

<add name="jcConn" connectionString="Data Source=LAPTOP\MSSQLSERVERAXVAL;Initial Catalog=bd_school;Integrated Security=True;" providerName="System.Data.SqlClient" />

How can i do that ?

Thank you.

Read How to Ask and elaborate on "doesn't work".

CodeCaster
– CodeCaster

2018-01-23 09:31:13 +00:00
Commented Jan 23, 2018 at 9:31 — CodeCaster
– CodeCaster, Commented Jan 23, 2018 at 9:31

David Perry · Accepted Answer · 2018-01-23 09:51:27Z

1

First: Does the user you're logged in as have access to the database you're trying to connect to? If you're running in IIS express then that's the user you're logged into the machine with and if you're hosting in IIS then the user the application pool is running as (assuming you're not impersonating).

Secondly: Integrated Security=true;

answered Jan 23, 2018 at 9:51

David Perry

281 silver badge7 bronze badges

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

Comments

Fazal Qayyum · Accepted Answer · 2018-01-23 10:54:43Z

0

If you do not want to put your SQL User Id and Password in connection string then you must use Windows Authentication to login in SQL. And use your Database in Windows user in SQL. use this Integrated Security=true;

answered Jan 23, 2018 at 10:54

Fazal Qayyum

828 bronze badges

2 Comments

determine Over a year ago

Okey thnak you guys. But, if i use Windows authentication (by configuring webconfig) as you mentionned, can i create a user table in my database and create user on the database (with attributes[username, password]) ? It will allow me to control user when they connect on the web app mvc. Is it correct like i said ?

Fazal Qayyum Over a year ago

Yes you can BUT your data base and web hosting (deployment) should be on same server.

Buttercup Cumbersnatch · Accepted Answer · 2018-01-23 11:09:21Z

0

If you use SQL login, then you need to specify the username and password in your connection string. If you don't want that, you need to use Windows Authentication. Check this answer in that case.

answered Jan 23, 2018 at 11:09

Buttercup Cumbersnatch

291 silver badge10 bronze badges

Collectives™ on Stack Overflow

Connect MVC C# App to SQL Server DataBase

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related