Last post Dec 02, 2016 08:45 AM by Cathy Zou
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
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 !
Nov 28, 2016 07:51 AM|Cathy Zou|LINK
In your web.config, your connection string should like below:
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.
Nov 28, 2016 01:24 PM|tangara|LINK
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 ?
Dec 02, 2016 08:45 AM|Cathy Zou|LINK
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 ):