SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Unable to create new Database
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

niren
Starting Member

India
18 Posts

Posted - 05/21/2013 :  05:19:33  Show Profile  Reply with Quote
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.

Edited by - niren on 05/21/2013 05:29:38

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 05/21/2013 :  05:25:57  Show Profile  Reply with Quote
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

Edited by - visakh16 on 05/21/2013 05:26:26
Go to Top of Page

niren
Starting Member

India
18 Posts

Posted - 05/21/2013 :  05:35:18  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 05/21/2013 :  05:47:59  Show Profile  Reply with Quote
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

India
18 Posts

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

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 05/21/2013 :  06:00:01  Show Profile  Reply with Quote
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

India
18 Posts

Posted - 05/21/2013 :  06:26:14  Show Profile  Reply with Quote
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.

Edited by - niren on 05/21/2013 06:28:04
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 05/21/2013 :  06:29:53  Show Profile  Reply with Quote
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

India
18 Posts

Posted - 05/21/2013 :  06:44:00  Show Profile  Reply with Quote
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

India
18 Posts

Posted - 05/21/2013 :  07:27:47  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 05/21/2013 :  07:31:07  Show Profile  Reply with Quote
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

India
18 Posts

Posted - 05/21/2013 :  07:51:25  Show Profile  Reply with Quote
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?
'

Edited by - niren on 05/21/2013 07:54:38
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.33 seconds. Powered By: Snitz Forums 2000