<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 - General
»
create database failed
15 posts, Page 1 of 2
1
2
»»
create database failed
Rate Topic
Display Mode
Topic Options
Author
Message
sumith1andonly1
sumith1andonly1
Posted Wednesday, February 13, 2013 11:22 PM
Valued Member
Group: General Forum Members
Last Login: Sunday, May 05, 2013 11:09 PM
Points: 66,
Visits: 260
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
anthony.green
anthony.green
Posted Thursday, February 14, 2013 1:31 AM
SSCertifiable
Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075,
Visits: 4,831
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
Perry Whittle
Perry Whittle
Posted Thursday, February 14, 2013 2:26 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:36 AM
Points: 5,201,
Visits: 11,153
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
WWDMark
WWDMark
Posted Thursday, February 14, 2013 4:50 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 2:59 AM
Points: 448,
Visits: 351
[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
Website:
www.weekendwebdesign.co.uk
Post #1419981
Ed Wagner
Ed Wagner
Posted Thursday, February 14, 2013 5:37 AM
SSCommitted
Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:44 AM
Points: 1,856,
Visits: 528
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.
Post #1420000
WWDMark
WWDMark
Posted Thursday, February 14, 2013 5:53 AM
SSC-Addicted
Group: General Forum Members
Last Login: Today @ 2:59 AM
Points: 448,
Visits: 351
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
Website:
www.weekendwebdesign.co.uk
Post #1420007
sumith1andonly1
sumith1andonly1
Posted Thursday, February 14, 2013 11:11 AM
Valued Member
Group: General Forum Members
Last Login: Sunday, May 05, 2013 11:09 PM
Points: 66,
Visits: 260
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
Ed Wagner
Ed Wagner
Posted Thursday, February 14, 2013 11:34 AM
SSCommitted
Group: General Forum Members
Last Login: Thursday, May 16, 2013 6:44 AM
Points: 1,856,
Visits: 528
I think your first step should be to speak with your DBA.
Post #1420230
sumith1andonly1
sumith1andonly1
Posted Thursday, February 14, 2013 12:18 PM
Valued Member
Group: General Forum Members
Last Login: Sunday, May 05, 2013 11:09 PM
Points: 66,
Visits: 260
its my challenge to to solve it myself...
Post #1420240
Lynn Pettis
Lynn Pettis
Posted Thursday, February 14, 2013 12:54 PM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 5:20 PM
Points: 21,602,
Visits: 27,428
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 »
15 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
