Sunday, August 19, 2012 8:22 AM
Sorry its big story....
Yesterday I changed the permissions in one of hard disk partitions and that drive becomes un accessible. So i did many way to recover that.
1. changed users and user group
2. changed computer name
3.Edited some registries
4.run Takewon commands in cmd
after 7 hours get back permission to that disk drive
and today morning I open my sqlserver 2008
@ I found Different login names(what i new created with new computername\sqlexpress)
@ Logged in with that window login credentials
@ I didn't found database what i already created.(Important data is there in that DB So please help to recover that too..)
@ and I tried create new DB but shows the
Msg 262, Level 14, State 1, Line 1
CREATE DATABASE permission denied in database 'master'.
Please help to recover from that
- Edited by Karthikeyan.Ramalingam Sunday, August 19, 2012 8:23 AM
Sunday, August 19, 2012 8:51 AMhttp://blogs.msdn.com/b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx
Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/
Monday, August 20, 2012 6:08 AM
Few days back i was also faced the same situation like: CREATE DATABASE permission denied in database 'DBNAME'.
My issue was in disk level not from the sql server level. At disk level permissions the user don't have specific privileges to do things.
Fix: We granted full privileges on disk @ "Advance securities settings" from disk level securitites.
So please take a look on required privileges and grant them the same at disk level..
May be your issue: permissions of oldsystemname\user to NOT reflected to newsystemname\user at disk level.
Hopes this may helps u...
Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)
Monday, August 20, 2012 1:25 PM
Now I logged in my system with Administrator rights.
But what the problem in MS SQL SERVER is
The user name what i provided to SQL Server at the time of installation for ADMINSTRATOR to the database is now changed(I gave only Window Mode NOT Mixed Mode).
At that time of installationi have different user administrator to loggon my system but now i delete that Coumputer Name and that user and Now I changed my computer name and administrator name to login to my system.]
I think Other then that administrator username to MS SQL Server(Provided at the time of Installation) all Other Administrator and Users to System can Not Create database.
- Edited by Karthikeyan.Ramalingam Monday, August 20, 2012 1:29 PM
Monday, August 20, 2012 1:26 PM
I already Tried this one but Not help full for me.. :-(
Monday, August 20, 2012 3:11 PM
Are you aware of this startup feature: Start SQL Server in Single-User Mode
In SQL User mode an Administrator of the server is also sysadmin on SQL Server. You can use these elevated privileges to clean up your problems. This means that you can create additional logins with sysadmin permissions.
And, of course, you should ensure that your SQL Server service account has rights to all the needed drives. If is does not, then as the Windows administrator you should be able to grant those rights.
This is all happening in Single-User mode, so you will be the only connection to the server. Once you have everything cleaned up, restart SQL Server in the normal fashion.
Monday, August 20, 2012 3:55 PM
When you change the account that is used by the service, I hope you used SQL Server Configuration Manager. That is the only way to get all the permissions adjusted properly.
Also, since you have changed a disk, you might need this Configure File System Permissions for Database Engine Access http://msdn.microsoft.com/en-us/library/jj219062.aspx
Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
Friday, August 24, 2012 10:35 AM
Hi Russell Fields,
After that i re-installed OS and SQL... But I think your answer will work...
Thanks a lot....
Thanks for all...