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 |
|
s2002
Starting Member
49 Posts |
 Posted - 2008-02-25 : 14:26:17
|
| My website host allows me to create DB and DB users from its control panel and then I am able to use SQL server Management studio to Manage My DB.Therefore I create My DB (TBC20) and create a user for it(Tony) from Host Panel.When I want to Export My Local copy DB data to the remote DB using Import/Export wizard and set the It won’t Generate any DB objects. Even When I use aspnet_regsql Command I encounter Following error:SQL error number is 262 and the SqlException message is: CREATE DATABASE permission denied in database 'master'.Creating the TBC20 database...------------------------------------------------------When I View permissions in Database properties window No Permission is Grant for user: Tony. Only some permission Grant for Grantor: dbo. When I check Boxes to Grant Permission for user Tony None of permissions will be grant to this user.How could I allow this user ti take ownership of DB and create DB objects |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 14:33:16
|
| You have to work this out with your hosting company, ensure they give your proper permission. |
 |
|
|
s2002
Starting Member
49 Posts |
Posted - 2008-02-25 : 14:39:24
|
| I can create DB user but can't create even one table on this DB.I think I can select DB user permission but this don't work.Could you please tell me what should I ask them to do? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-25 : 14:43:07
|
| You need at least db_ddladmin rights in the db. |
|
|
|
|
|
|
Error while Create DB objects