How do I know what is the connection String?

Tangara G

Hi,

I used to work with entity framework and I need not worry what is the connection String blah blah blah.

But now, I have to use ADO.net framework I do not know how to write the Connection String based on the Ms SQL Server 2016 I am using.

Can someone tells me from where I can know information on the above?

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
Accepted answer
Looks like i misread your question. Now I got it.

First thing is, are you been able to connect to SQL Server through Management Studio. If yes, you should have user Id, password and a database name.

After you succeed in doing above, you can use answer given by Abhilash.

The fact that you are talking about Server Properties, probably you have logged in. If yes, did you not use user Id and password? If not, you probably logged in using Windows Authentication.

If you are using Windows Authentication, your connection string would be

connectionString="Server=SQlServerName;Database=YouDatabaseName;Trusted_Connection=True;"
+1
Dilip Gupta9y ago
follow this link for more information:

https://msdn.microsoft.com/en-us/library/jj653752(v=vs.110).aspx
0
Tangara G9y ago
Hi Nitin,

I am not using EF so there is no context whatsoever.

So, I have to connect directly to the dataSource which is Ms SQL 2016 but I do not know what to put at the Connection String DataSource there at the web.config.

Can you pls advise me ?
0
Nitin Sontakke9y ago
I cannot buy that you didn't have to worry about connection string while using EF. How were you creating the context? You must definitely had a context name.

If yes, go in web.config and you will find a connection string named after your context name there.
+2
Bikesh Srivastava9y ago
Go=>Tools=>Connect to database=>new window will be open fill details.
click on ok=>go=>server explorer=.right click=>check property=>connection string,,,that's it
+2
Tangara G9y ago
Hi Abhilash,

Can I know YourDatabaseName is it referring to the name in the Server Properties ?

Cos the Server Properties it is using my name....
Also, is it necessary to put in User Id and password ?
Where can I find my User Id and password in the system ?

Pls clarify.
Tks.
0
Abhilash J A9y ago
Try this inside Web.Config file.
<configuration>
<connectionStrings>
   <add name="SQLDbConnection"
        connectionString="Server=SQlServerName; Database=YouDatabaseName; User Id=userid; password= password"
        providerName="System.Data.SqlClient" />
connectionStrings>
configuration>
+1