Proper Format For Sql Server Connection String On 1and1.com

I have spent several hours trying to search this on the web in addition to calling and emailing support at 1and1.com web hosting with no success. I have ASP.NET pages which connect

Solution 1:

Here is what ended up working for me:

<addname="TimeDataLicenseEntities"providerName="System.Data.EntityClient"connectionString="metadata=
 res://<assemblyname>/Model1.csdl|
 res://<assemblyname>/Model1.ssdl|
 res://<assemblyname/Model1.msl;
 provider=System.Data.SqlClient;
 provider connection string=&quot;
 data source=dbXXXX.db.1and1.com,1433;
 Integrated Security=false;
 initial catalog=database_name;
 user id=dboXXXX;
 password=valid_password;
 multipleactiveresultsets=True&quot;" />

By including the assemblyname for my code in the sections above (the brackets ('<' and '>') should not be included), I was able to finally get it to work.

Thanks all for your assistance.

Solution 2:

Here is what actually works on 1and1 server from ASP.NET Code first design. So, simply replace your serverName, DatabaseName, UserID, and Password.

<add name="DefaultConnection"
     connectionString="Data Source=dbXXX.db.1and1.com,1433;Initial Catalog=dbYYYYY;Integrated Security=False;user id=dboZZZZZ;password=YOURDBPASSWORD;MultipleActiveResultSets=True;Application Name=EntityFramework"
     providerName="System.Data.SqlClient" />

Hope this can help anyone looking to use 1and1 asp.net server since their customer service is pretty useless.