Is there a Default connection string when using microsoft sql server?

Question

I'm new to asp.net programming and I'm trying to connect to the database using microsoft sql server. Is there any default connection string in accessing your database in mssql server through your aspx code behind?

Community · Accepted Answer · 2017-05-23 12:33:03Z

1

A: There's really no such thing, there's too much variation.

You will have to make your own connection string. If the SQL Server is not located on the same machine where you are developing: http://www.connectionstrings.com/sql-server-native-client-10-0-oledb-provider/

Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;

If it is on your machine and you are using windows authentication (that is, if you log on to the server the same way you log on to your computer), see here Connection string using Windows Authentication

edited May 23, 2017 at 12:33

CommunityBot

11 silver badge

answered Aug 25, 2015 at 18:03

rlb.usa

15.1k17 gold badges86 silver badges130 bronze badges

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

Collectives™ on Stack Overflow

Is there a Default connection string when using microsoft sql server?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related