connection string is not working in asp.net webforms

Question

i registered my website on somee.com. for that i have uploaded MS SQL database. i was wrting this connection string in my code:

connectionString="metadata=res://*/nrcsaEntities.csdl|res://*/nrcsaEntities.ssdl|res://*/nrcsaEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=My-PC;initial catalog=nrcsa;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&quot;"

now as i registered somee.com is providing me new connection string that is:

workstation id=nrcsadb.mssql.somee.com;packet size=4096;user id=DuaZoya_SQLLogin_1;pwd=abcd;data source=nrcsadb.mssql.somee.com;persist security info=False;initial catalog=nrcsadb

i have changed connectiong string in file web.config by replacing this first connection string with provided connection string by somee.com

PROBLEM:

This replacement is generating warning that:

 System.ArgumentException: Keyword not supported: 'user id'.

how to solve this problem?

If you're using EF, you need to only replace the inner provider connection string. — SLaks
– SLaks, Commented Jan 1, 2014 at 17:54

Mukesh Kumar · Accepted Answer · 2014-01-02 05:32:16Z

4

In the web.config file ....

     <connectionStrings><add name="nameofConnection" connectionString="Data   Source=servername; Initial Catalog=DatabaseName; User ID=UserName; Password=Password;"/>  </connectionStrings>
 <system.web>
<compilation debug="false" targetFramework="4.0" />  </system.web>

you can edit target Framework according to you.

from : http://dotnet-developers-cafe.blogspot.in/2013/08/create-connection-string-in-aspnet.html

answered Jan 2, 2014 at 5:32

Mukesh Kumar

2,4044 gold badges31 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SLaks · Accepted Answer · 2014-01-01 17:59:42Z

2

You're using Entity Framework.

Entity Framework has its own connection string which contains a reference to the EF metadata (metadata=...) as well as the inner connection string to connect to the actual database.

You need to insert your actual database connection string inside the EF connection seting, in the provider connection string=... section.
You will also need to add multipleactiveresultsets=True to their connection string; EF needs that setting.

answered Jan 1, 2014 at 17:59

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

8 Comments

Tameen Malik Over a year ago

now it is saying System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. how to solvw this ?

SLaks Over a year ago

@TameenMalik: Your inner connection string is wrong. You may need to add integrated security=false

Tameen Malik Over a year ago

Thank's @SLaks .... now problem is [SqlException (0x80131904): Login failed for user ''.]

Tameen Malik Over a year ago

i am writing this : ` <connectionStrings> <add name="nrcsaEntities" connectionString="metadata=res://*/nrcsaEntities.csdl|res://*/nrcsaEntities.ssdl|res://*/nrcsaEntities.msl;provider=System.Data.SqlClient;provider connection string="data source=nrcsadb.mssql.somee.com;initial catalog=nrcsadb;integrated security=False;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" /></connectionStrings>`

SLaks Over a year ago

@TameenMalik: That isn't the connection string they gave you.

|

Ankush Jain · Accepted Answer · 2014-01-01 18:09:54Z

2

As you are using entity famework, then your connection string will look like

<connectionStrings>
  <add name="BlogContext" 
        connectionString="metadata=res://*/BloggingModel.csdl|
          res://*/BloggingModel.ssdl| res://*/BloggingModel.msl;
          provider=System.Data.SqlClient 
          provider connection string=&quot;data source=[you somee.com connetion string];&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

what you need to do is simply change the value of data source from the actual connectionstring provided by somee.com

answered Jan 1, 2014 at 18:09

Ankush Jain

7,2534 gold badges41 silver badges71 bronze badges

2 Comments

Tameen Malik Over a year ago

oh it says: System.ArgumentException: Keyword not supported: 'user id'.

Ankush Jain Over a year ago

try this connectionString="metadata=res://*/nrcsaEntities.csdl|res://*/nrcsaEntities.ssdl|res://*/nrcsaEntities.msl;provider=System.Data.SqlClient;provider connection string="data source=user id=DuaZoya_SQLLogin_1;password=abcd;server=nrcsadb.mssql.somee.com;database=nrcsadb;multipleactiveresultsets=True;App=EntityFramework""

Tameen Malik · Accepted Answer · 2014-01-01 18:11:22Z

2

Don't replace the whole connection string. You will need to remove the Integrated Security = true section and replace it with user=DuaZoya_SQLLogin_1;password=abcd.

Also change the data source to nrcsadb.mssql.somee.com.

You pretty much just need to replace values in your existing connection string with the values provided.

edited Jan 1, 2014 at 18:11

Tameen Malik

1,2686 gold badges17 silver badges46 bronze badges

answered Jan 1, 2014 at 18:01

field_b

6986 silver badges21 bronze badges

6 Comments

Tameen Malik Over a year ago

now it is saying System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. how to solvw this ?

field_b Over a year ago

Did you specify the user and password explicitly and remove Integrated Security = true? Check the Connection Strings snap in in IIS and see what the user name and password are.

field_b Over a year ago

Make sure you specify the user and password they supply, and remove Integrated Security = true. You can just change the true to false if you want, so Integrated Security = false.

field_b Over a year ago

No. Set integrated security = false. And make sure your password is what they gave you.

field_b Over a year ago

Change user id to user. Change pwd to password. You have to use the original attributes that entity framework understands.

|

Collectives™ on Stack Overflow

connection string is not working in asp.net webforms

4 Answers 4

Comments

8 Comments

2 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

8 Comments

2 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related