SQL Azure connection string

Use this connection string to connect to SQL Azure database

<add name=”DatabaseEntities” connectionString=”metadata=res://*/Database.csdl|res://*/Database.ssdl|res://*/Database.msl;provider=System.Data.SqlClient;provider connection string=&quot;Server=tcp:[serverName].database.windows.net;Database=[myDataBase];User ID=[LoginForDb]@[serverName];Password=[myPassword];Trusted_Connection=False;Encrypt=True;&quot;” providerName=”System.Data.EntityClient” />

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s