Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
antony.kll
Starting Member
1 Post |
 Posted - 2011-09-02 : 06:25:51
|
| Hello,for my mssql2008 shared hosing I have create a database and login using security settings write by microsoft for sql shared hosting:http://learn.iis.net/page.aspx/530/sql-2008-for-hosters/http://download.microsoft.com/download/d/1/f/d1f05c2e-0741-442d-859e-9417b377fdfa/The%20architectural%20view%20of%20SQL%20Server.zipbut trying to publish some applications using webmatrix such as DotNetNuke I get the following error: Cannot find the user 'dbo', because it does not exist or you do not have permission.I found that the sql that generate the error is: CREATE ROLE [aspnet_Membership_BasicAccess] AUTHORIZATION [dbo]I have seen that adding on database the db_owner rolemember for userlogin the problem is solved but this feature is not included in the microsoft documents for shared hostingI think for security reason; On documentation for SQL2008 shared hosting Microsoft set only (db_ddladmin, db_datareader, db_datawriter)do you know if there is a way to solve the problem without giving permission dbo?thanks and regards |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2011-09-22 : 17:23:52
|
| Hi,What mssql2008 shared hosing means? |
 |
|
|
|
|
|
mssql2008 shared hosing login permission dbo