Unable To Connect To New Database
hi, i've created new database in payg azure subscription can't publish project new database , can't connect using ssms. any ideas i'm doing wrong? when try publish project using publish wizard database not visible. when use ssms connect can connect database server can see master database , don't see database created. i've added ip address firewall. perhaps i'm using wrong log in. when created wasn't asked create login user assume used 1 i'd used on other databses had on same server. never went through last week when set first db. it worked fine , set new db , hassle.
thanks,
@azuresupport
good day evan,
it sound permissions issue, simple fix.
>> when created wasn't asked create login user assume used 1 i'd used on other databses had on same server.
a login instance level element , not database level element.
user database level element.
* bit confusing azure interface give option add user under servers, mean azure user else.
>> sql database security: manage database access , login security
https://azure.microsoft.com/en-us/documentation/articles/sql-database-manage-logins/
in short, need use server-level principal login created when set azure sql server. if cannot remember password can reset it.
reset server-level principal login
1. go new portal.
2. on left menu select "sql servers"
if cannot find in list, use browser
3. click on server name
4. on top menu click on "reset password"
5. insert new password
** if not remember server-level principal login check windows on step 4.
name under title "server admin"
back question:
the server-level principal login sa login in local sql server. you can use login in order connect ssms , menage other logins using simple t-sql queries (check above link). once have connection option can check permissions of login did not work , add permission , can map databases login , menage users... etc'
 | ronen ariely [personal site] [blog] [facebook] [linkedin] |
Microsoft Azure > Azure SQL Database
Comments
Post a Comment