Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

create database failed Expand / Collapse
Author
Message
Posted Wednesday, February 13, 2013 11:22 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 4:13 AM
Points: 73, Visits: 333
I try to create database in sql server(logon as windows authentication).

GOT ERROR : "User does not have permission to create database".

Then i tried to enable 'sa' account.but it also failed .

i think 'sa' account have admin privilege.other users with admin privilege are removed from domain.



when i goes to the sql server configuration manager-> sql server services,

got error" Remote procedure call failed"


what want do to enable 'sa' account and add privilege to user ?




Post #1419820
Posted Thursday, February 14, 2013 1:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:52 AM
Points: 5,131, Visits: 4,918
Do you know a login for anyone with sysadmin, securityadmin or dbcreator?

If not you will need to add yourself as a local admin on the Windows host where SQL is installed, start SQL in single user mode, add yourself as a sysadmin and then you can go from their.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1419861
Posted Thursday, February 14, 2013 2:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:08 AM
Points: 6,162, Visits: 13,305
sumith1andonly1 (2/13/2013)
I try to create database in sql server(logon as windows authentication).

GOT ERROR : "User does not have permission to create database".

Then i tried to enable 'sa' account.but it also failed .

i think 'sa' account have admin privilege.other users with admin privilege are removed from domain.



when i goes to the sql server configuration manager-> sql server services,

got error" Remote procedure call failed"


what want do to enable 'sa' account and add privilege to user ?





Have you tried contacting your database administrator?


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1419890
Posted Thursday, February 14, 2013 4:50 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 10, 2014 3:22 AM
Points: 642, Visits: 518
[b]what want do to enable 'sa' account and add privilege to user ?


I think the 'sa' account is due to be deprecated in future versions of SQL Server but has the same privileges as sysadmin so you'd be better off using sysadmin but as Perry has said - if you're not the DBA for the server/DB then you'd need to contact them first rather than granting yourself access and then incurring the wrath of a scorned DBA!!



MCITP
MCTS - E-Business Card
Twitter: WWDMark

Try not! Do or do not, there is no try

email: info@weekendwebdesign.co.uk
Personal Website: www.markallen-online.co.uk
Business Website: www.weekendwebdesign.co.uk
Post #1419981
Posted Thursday, February 14, 2013 5:37 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:05 PM
Points: 3,943, Visits: 2,957
Not trying to be ignorant here, but if you don't have access to create databases on that server, then maybe you shouldn't be creating databases on that server. Instead, contact the DBA and have them do it for you, have the db_owner database role granted to you and go from there.

There may be reasons why you can't create a database. There may be a specific backup schedule that needs to be updated. There may be maintenance scripts/jobs that should include your database. I would definitely contact the DBA instead of having a "rogue database" show up on one of his reports with your name on it.



Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1420000
Posted Thursday, February 14, 2013 5:53 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, July 10, 2014 3:22 AM
Points: 642, Visits: 518
Ed Wagner (2/14/2013)
I would definitely contact the DBA instead of having a "rogue database" show up on one of his reports with your name on it.


+1 on the above.

As part of my daily SQL Server checks I run a script that lists logins created in the last 48 hours which includes permission types and permission states along with checking each database on the SQL instance. If I find a rouge login or a new database that I'm not aware of I go on the prowl for a culprit!! It's security 1-0-1 and I'm deeply possessive of my SQL Servers!!



MCITP
MCTS - E-Business Card
Twitter: WWDMark

Try not! Do or do not, there is no try

email: info@weekendwebdesign.co.uk
Personal Website: www.markallen-online.co.uk
Business Website: www.weekendwebdesign.co.uk
Post #1420007
Posted Thursday, February 14, 2013 11:11 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 4:13 AM
Points: 73, Visits: 333
actually , there are 5 logins including 'sa' login. none of them have the privilege to create database or change privilege except 'sa' login.

but 'sa' login is disabled.

when i tried to enable it using other user , it will fail( reason current login doesn't have privilege to change/add privilege).

i think there is login with syssdmin privilege ,only can assign privilege to other login....

i was trapped in all means.

i dont know how......?

Post #1420220
Posted Thursday, February 14, 2013 11:34 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, July 18, 2014 2:05 PM
Points: 3,943, Visits: 2,957
I think your first step should be to speak with your DBA.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1420230
Posted Thursday, February 14, 2013 12:18 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, June 23, 2014 4:13 AM
Points: 73, Visits: 333
its my challenge to to solve it myself...
Post #1420240
Posted Thursday, February 14, 2013 12:54 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 7:35 PM
Points: 22,992, Visits: 31,471
sumith1andonly1 (2/14/2013)
its my challenge to to solve it myself...


Question not asked, are you the DBA on this server?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1420257
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse