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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Unable to create new Database

Author  Topic 

niren
Starting Member

18 Posts

Posted - 2013-05-21 : 05:19:33
I have installed Sql server 2012. Until yesterday i used to do create database and all, but today i can't able to create database and login also. I searched a lot found that i logged in as 'user' not 'sa' there the server role not checked in for sysadmin. so I think that's why I couldn't able to create a new database. I tried to login in 'sa' username, but I unable to login. I tried to change sysadmin as checked in 'user' Login, but i couldn't. Help me how to resolve this problem. I found similar problem in the following post [http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69334&SearchTerms=unable,to,create,new][/url], but I don't find answer there.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-21 : 05:25:57
login as sa or using an admin account. then go to security->login select the login you used before and assign sysadmin access to it by clicking the checkbox.
Now login back using the account and you should now be able to create dbs etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

niren
Starting Member

18 Posts

Posted - 2013-05-21 : 05:35:18
I tried to login in 'sa' account, but i could not login. This is what i did to login as 'sa' user, after I open SSMS one popup window was there says connect to server I changed Authentication to SQL server authentication from windows authentication and I typed sa in username field and I don't know the password to type, I tried with 'root' as password but no use.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-21 : 05:47:59
quote:
Originally posted by niren

I tried to login in 'sa' account, but i could not login. This is what i did to login as 'sa' user, after I open SSMS one popup window was there says connect to server I changed Authentication to SQL server authentication from windows authentication and I typed sa in username field and I don't know the password to type, I tried with 'root' as password but no use.


so is the actual issue about forgetting the sa password?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

niren
Starting Member

18 Posts

Posted - 2013-05-21 : 05:53:07
It is inbuilt login how do I know the password.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-21 : 06:00:01
quote:
Originally posted by niren

It is inbuilt login how do I know the password.


you'll set it at the time of installation.
If you know machine admin account credentials then you can set a new password for sa too

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/e3783055-09c3-458d-8cf0-602ad16cac6f

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

niren
Starting Member

18 Posts

Posted - 2013-05-21 : 06:26:14
There is only two account in my system they are Niren and User002. There is no password for Niren user. When I open SSMS the authentication is auto set to Windows authentication and user name also auto set to Thiru\Niern without password, Thiru is my computer name. The server now connect when I click connect button. After that I check the Thiru\Niern login under Object Window > Security > Login. There the server role is not checked in for sysadmin and in UserMapping the default DB's master, msdb and tempdb are also not checked in. What should I do now? Am unable to create new Database.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-21 : 06:29:53
you cant set security roles for login from same login. FOr that you need to use an administrator login. Do you know credentials of any admin accounts in that sql instance?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

niren
Starting Member

18 Posts

Posted - 2013-05-21 : 06:44:00
As per I know Sql server in my system has two login they are sa and Thiru\Niren, there is no password for Niren and I don't know the password of sa. What should I do now reinstall sql server again?
Go to Top of Page

niren
Starting Member

18 Posts

Posted - 2013-05-21 : 07:27:47
I don't know what you mean by 'credentials of any admin accounts in that sql instance'
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-21 : 07:31:07
quote:
Originally posted by niren

I don't know what you mean by 'credentials of any admin accounts in that sql instance'


That means any account which is in sql server instance having admin access. It may be local system admin account, domain admin account etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

niren
Starting Member

18 Posts

Posted - 2013-05-21 : 07:51:25
I don't know the admin account details and I don't the know the admin account details exists or not. I told you in my earlier post that 'As per I know Sql server in my system has two login they are sa and Thiru\Niren, there is no password for Niren and I don't know the password of sa. What should I do now reinstall sql server again?
'
Go to Top of Page
   

- Advertisement -