Cannot connect to azure db via SqlConnection

Question

I have a webiste hosted on Azure and I have uploaded my db to azure via SSMS 2012 and I can connect to the azure server and db in SSMS and when i create a connection to the db in Database Explorer and test the connection it says it works fine.

I cannot access the management section for the db in azure management portal (I can do this for another db but I have the same problem when accessing that one via the website as well)

I tried giving the Login 'ashley' the db_owner privilege

EXEC sp_addrolemember 'db_owner', 'ashley'

and got this error

Msg 15151, Level 16, State 1, Line 1 Cannot alter the role 'db_owner', because it does not exist or you do not have permission.

This is the connection in the webconfig file

add name="C:\USERS\USER\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\ORGANISER\ORGANISER \APP_DATA\CUSTOMER_DB.MDFConnectionString2" connectionString="Server=tcp:{myserver};Database=C:\Users\User\Documents\Visual Studio 2012\Projects\Organiser\Organiser\App_Data\Customer_db;User ID=ashley;Password={mypassword};Trusted_Connection=False;Encrypt=Tr‌ue;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" /

and the connection string i use to reference this in the code behind

string Connection = @"C:\USERS\USER\DOCUMENTS\VISUAL STUDIO 2012\PROJECTS\ORGANISER\ORGANISER\APP_DATA\CUSTOMER_DB.MDFConnectionString2";

I cannot understand why I can access the db in SSMS and in database explorer but not when the website is running.

I am also new to Azure, ASP and MSSQL in general

I used azure Migration wizard to upload my db to the server instead of SSMS and now using the correct server username which needed username@{server} instead of just username to connect! All is working fine now. Thanks Fabrizio — user2241161
– user2241161, Commented Apr 3, 2013 at 21:38

sqlandmore.com · Accepted Answer · 2016-07-04 18:30:50Z

1

Depending on your account configuration, you may need to add an allowed port/IP range to azure DB configuration. Go to Data "SQL Databases" properties - Configure - allowed ip addresses - Add your IP range

and you'll be able to connect.

answered Jul 4, 2016 at 18:30

sqlandmore.com

1631 silver badge8 bronze badges

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

Comments

Fabrizio Accatino · Accepted Answer · 2013-04-03 16:37:21Z

0

Your connection string is pointing to a local mdf file. Change the Database= to the name you assigned to your db on Sql Azure.

answered Apr 3, 2013 at 16:37

Fabrizio Accatino

2,31020 silver badges25 bronze badges

2 Comments

user2241161 Over a year ago

When I use this connection > <add name="customer" connectionString="Server=tcp:{myserver};Database=[customer];User ID=ashley@dmdf78i69g;Password=*******;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;" providerName="System.Data.SqlClient" /> Then I get the same problem. in the first string I saved the name of the db with its filepath. Which i know is bad practice but at the time I was just playing around with it. It is like I dont have the right permissions. Firewall rules are set up also Thank You

user2241161 Over a year ago

Login failed for user exception. I have now fixed the problem by using Azure Migration Wizard instead of SSMS. Thank you :)

Alex Feng · Accepted Answer · 2013-04-05 07:32:49Z

0

Make sure you are running the T-SQL query in the correct database context, select your user database in dropdown list.

answered Apr 5, 2013 at 7:32

Alex Feng

411 silver badge3 bronze badges

Collectives™ on Stack Overflow

Cannot connect to azure db via SqlConnection

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related