{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Evening l夕情丶 的问题《ASP NET Identity Manager database permissions》','https://www.manongdao.com/q-1130537.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I have got Identity Manager set up and running locally, working with ASP.NET Identity. I have a SQL Server 2012 database for the backend. I can create a user and get a list back, however whenever I try and create a role, edit a user or list the roles i get the following:
CREATE DATABASE permission denied in database 'master'.
The user i have in the connection string is a valid SQL login and is a user on the database that Identity Manager is pointed at, (and obviously can login as i can see the user in the database table) however it seems like for these actions the database is claiming the user connecting hasn't got permission.
I am running the app pool for identity manager under the AppPoolIdentity.
Appreciate any help.
So issues were due to first of all me not passing my context to the role store (i was passing it to my user store however) and then making sure the identity manager service was getting my role manager. After i went through all the dependencies carefully i got it all working with no issues.