MS SQL Server Windows Logon Problem

Question

Hi,

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

ERROR:

Msg 262, Level 14, State 1, Line 1
CREATE DATABASE permission denied in database 'master'.

Please help to recover from  that

 

---

Kartikeyan

Answer 1

http://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/

Blog : MS SQL Development and Optimization

Blog : Large scale of database and cleansing

Answer 2

Karthik:

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, 

---

Thanks, Satish Kumar. Please mark as this post as answered if my anser helps you to resolves your issue :)

Answer 3

Hi Satish,

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.

---

Kartikeyan

Answer 4

Hi, Dimant

I already Tried this one but Not help full for me.. :-(

---

Kartikeyan

Answer 5

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.

RLF

Answer 6

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

Answer 7

Hi Russell Fields,

After that i re-installed OS and SQL... But I think your answer will work...

Thanks a lot....

Thanks for all...

---

Kartikeyan