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 |
|
janakiram_infy
Starting Member
3 Posts |
 Posted - 2007-02-01 : 10:30:39
|
| Hi,I have created a new database by connecting to server in Windows authentication.after that i tried to later database as fallowsUSE MASTER/CLRTEST/....ALTER DATABASE CLRTEST SET TRUSTWORTHY ONError: User does not have permission to alter database 'CLRTEST' or the database does not exist.It is saying user doesn't have permission, but I have not entered into the server as a user, entered in Windows authentication mode.but why is the error coming?How do I alter the database? - Please resolve.Thanks in advance.Yours,Janakiram |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-01 : 14:38:29
|
| You are connecting with Windows Authentication but there is a login in SQL Server associated with your Windows account. You have the permissions of that login. The error is saying that the account you are connected to the server with (whether that is a SQL Server login or a Windows login) does not have permissions to alter the database. So you need to get permissions or use an account that has permissions.Also make sure that you have the database name correct, as using a database name that is incorrect gives the same error. |
 |
|
|
|
|
|
Could not alter Database