SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


create database failed


create database failed

Author
Message
sumith1andonly1
sumith1andonly1
SSC-Addicted
SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)

Group: General Forum Members
Points: 446 Visits: 346
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 ?
anthony.green
anthony.green
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23694 Visits: 6519
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
When a question, really isn't a question - Jeff Smith
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


Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52479 Visits: 17672
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" ;-)
WWDMark
WWDMark
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1067 Visits: 530
[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!! Crazy


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
Ed Wagner
Ed Wagner
SSC-Forever
SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)

Group: General Forum Members
Points: 46621 Visits: 10844
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
WWDMark
WWDMark
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1067 Visits: 530
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!! :-D


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
sumith1andonly1
sumith1andonly1
SSC-Addicted
SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)

Group: General Forum Members
Points: 446 Visits: 346
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......?
Ed Wagner
Ed Wagner
SSC-Forever
SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)SSC-Forever (46K reputation)

Group: General Forum Members
Points: 46621 Visits: 10844
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
sumith1andonly1
sumith1andonly1
SSC-Addicted
SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)

Group: General Forum Members
Points: 446 Visits: 346
its my challenge to to solve it myself...
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (92K reputation)SSC Guru (92K reputation)SSC Guru (92K reputation)SSC Guru (92K reputation)SSC Guru (92K reputation)SSC Guru (92K reputation)SSC Guru (92K reputation)SSC Guru (92K reputation)

Group: General Forum Members
Points: 92493 Visits: 38954
sumith1andonly1 (2/14/2013)
its my challenge to to solve it myself...


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

Cool
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)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search