Connect application to database using SQL Server authentication

Question

I got the task:

user on login page types login/password, and your application should try to connect to SQL Server using these parameters

And I don't know how to do this on server-side... I was googling it for an hour with no success.

BTW, I'm using ASP.NET MVC

What specifically do you need to do with SQL Server? Run a query to return data? Insert a record? Do you know the name of the database, table(s), column(s)? — rory.ap
– rory.ap, Commented Apr 17, 2014 at 11:49
@roryap I need to get several values from the table "Calls". How this is connected to my question? I just want to know how can I connect to SQL Server from server-side code using login/password, that's all — Andrew
– Andrew, Commented Apr 17, 2014 at 11:54
Does your database actually provide direct logins for users who come to the web page? In other words, if a user comes to your page who has a user account "bob123" and a password "@#4323", does that map directly to a user account associated with your database? Or is it that you connect to your database with an application account and password and your web user accounts are stored as records in the database? I'm not a web developer, but the latter seems like it would be better. — rory.ap
– rory.ap, Commented Apr 17, 2014 at 12:01

HCJ · Accepted Answer · 2014-04-17 12:08:19Z

2

For an application, where you have access to usernames and password and you wish to connect to SQL Server. Create a connection like

SqlConnection myConnection = new SqlConnection("user id=username;" + 
                                   "password=password;server=serverurl;" + 
                                   "Trusted_Connection=yes;" + 
                                   "database=database; " + 
                                   "connection timeout=30");

then you can use this connection to query the database

See sample code here

Hope this helps.

answered Apr 17, 2014 at 12:08

HCJ

5271 gold badge6 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Connect application to database using SQL Server authentication

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