create table permission denied in database 'ma

2019-01-23 06:56发布

I have installed the free version of sql server 2008 (sql server management studio express edition) on my PC. After installation I get the following error

create table permission denied in database 'master'

I tried reinstalling several times, but I keep getting the same error. When i checked

select user_account();

It showed that I was logged in as guest. How do I solve this? since I am not permitted to create a new login.

7条回答
The star\"
2楼-- · 2019-01-23 07:51

If your table actually exists in a different database (not master), you will need to switch to that database. A GUI option to change the database reference is shown below.

change_database_reference

查看更多
登录 后发表回答