Skip to main content

How do you setup connection string with windows authentication.

Hi guys,

I know setting up a connection string is a simple deal as all of us do daily. Have anyone came across with issue of setting up connection with a local server and using windows authentication.  May yes and may be no. Whatever lets see what is the correct way of defining connection string for local database with windows authentication.


You will need to know following components as prerequisites ,

  • Data Source : Server name.
  • Initial Catalog : Database name.

Then setup the connection string as per below given format,

<add name="NothwindDb" connectionString="data source=<Your Data Source>;initial catalog=<Your Database Name>;persist security info=True;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>

 Eg : <add name="NothwindDb" connectionString="data source=Home-ISURI\SQLEXPRESS;initial catalog=Backup2015Nov26;persist security info=True;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>




Labels:

Comments

Post a Comment

Popular posts from this blog

Differences between Severity ,Priority and Status

In market there are many bug tracking and project management tools available. These tools allow us to keep essential information of a bug or task. You will see there are three places have to fill when key in a task. Those three places are Status, Priority and Status of a bug/task. Let's see what those stand for.  Severity Priority Status Connotation Severity of a bug means how much it affecting to functionality of the software. Total damage it can do. Priority means how fast a bug or task should be resolve. Status means the current position of the bug/task. Types            Critical            Major            Moderate            Minor           Cosmetic           Low           Medium       ...
1 comment
Read More »

MVC Architecture

Model-View-Controller (MVC) is a design pattern recently most popular among software engineers for applications which are needed to provide multiple views with using same data. I am suggesting MVC is better than WCF, because of this module separation. For an examples       ·          Multiple views and controllers can interface with same model for modification even those never exist before add this model.       ·          It is supporting all type of HTML verbs.       ·          No view state and post back events.       ·          Easy integration with JavaScript framework.       ·          Helps to decrease complexity of project       ·          P...
2 comments
Read More »