Data Source Name, User ID and password RSS

• • Reply
  tangara

  Member

  31 Points

  251 Posts

  Data Source Name, User ID and password

  Nov 27, 2016 09:13 AM|tangara|LINK

  Hi forum members,

  I searched thru the forum but can't find the answer hence the question.

  I just downloaded MS SQL2016 after experience some glitches - cannot create table due to backend blah blah blah.

  Now, I wanted to follow this tutorial which is ADO.Net http://geekswithblogs.net/dotNETvinz/archive/2009/02/19/binding-gridview-with-data---the-ado.net-way.aspx

  And in my webconfig I need to define my SQL connection datasource so I am stuck cos I am not using entity framwork and I do not know how to find the Data Source name in this case.  Also, if I have to add in the User ID and password I do not know how to discover the facts in my computer cos when I downloaded 2016 everything is ported over automatically.

  So, I hope someone can tell me how to .

  Also, I wanted to mention I went to the Configuration Manager in SQL server 2016 but was denied access so I can't see it from there either.  Even though I am the administrator !

• • Reply
  Cathy Zou

  Star

  8670 Points

  2882 Posts

  Re: Data Source Name, User ID and password

  Nov 28, 2016 07:51 AM|Cathy Zou|LINK

  Hi tangara,

  In your web.config, your connection string should like below:

  <connectionStrings>
    <add 
      name="MyConnectionString" 
      connectionString="Data Source=\sqlexpress;Initial 
      Catalog=MyDatabase;User ID=userName;Password=password"
      providerName="System.Data.SqlClient"
    />
  </connectionStrings>

  Data Source is your server name.

  Initial Catalog is the default database queries should be executed against. For normal uses, this will be the database name.

  For the authentication, we have a few options.

  User ID and Password means using SQL credentials, not Windows, but still very simple - just go into your Security section of your SQL Server and create a new Login. Give it a username and password, and give it rights to your database. All the basic dialogs are very self-explanatory.

  1.open sql server 2016. click connect to server.

  2.change Authentication to SQL credentials. set user name and password.

  You can also use integrated security, which means your .NET application will try to connect to SQL using the credentials of the worker process.Check here for more info on that.

  Best regards

  Cathy

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
  
• • Reply
  tangara

  Member

  31 Points

  251 Posts

  Re: Data Source Name, User ID and password

  Nov 28, 2016 01:24 PM|tangara|LINK

  Hello Cathy,

  I am not using SQL Express I think.  I downloaded SQL Server 2016.

  This is the full name :

  Microsoft SQL Server Management Studio

  Thus, can you advise what is the Data Source I should be using ?

  Tks.

• • Reply
  Cathy Zou

  Star

  8670 Points

  2882 Posts

  Re: Data Source Name, User ID and password

  Dec 02, 2016 08:45 AM|Cathy Zou|LINK

  Hi tangara,

  As I description above, Data Source is your server name,

  You could get sever name through following step below:

  1, Right click you Sql sever 2016,

  2. Click Connect>click Database Engine, you will see an window as picture below ( below is sql sever 2014 ):

  

  Best regards

  Cathy

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.