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 !
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.
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.
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 !
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:
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
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.
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.
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
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.