February 13, 2013 at 11:22 pm
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 ?
February 14, 2013 at 1:31 am
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.
February 14, 2013 at 2:26 am
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" 😉
February 14, 2013 at 4:50 am
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:
email: info@weekendwebdesign.co.uk
Personal Website: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk
February 14, 2013 at 5:37 am
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.
February 14, 2013 at 5:53 am
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!! 😀
email: info@weekendwebdesign.co.uk
Personal Website: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk
February 14, 2013 at 11:11 am
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......?
February 14, 2013 at 11:34 am
I think your first step should be to speak with your DBA.
February 14, 2013 at 12:18 pm
its my challenge to to solve it myself...
February 14, 2013 at 12:54 pm
sumith1andonly1 (2/14/2013)
its my challenge to to solve it myself...
Question not asked, are you the DBA on this server?
February 14, 2013 at 9:50 pm
no im just a developer. but im trying to be a DBA
February 15, 2013 at 12:05 am
sumith1andonly1 (2/14/2013)
no im just a developer. but im trying to be a DBA
Polite tip: if you're after access to a sysadmin style login and you're not the DBA looking after the database server but you want to get into the DBA side of things, I'd suggest getting in touch with your DBA and getting to know him/her rather than circumventing them and trying to solve the issue yourself (an admirable but flawed action when you ignore the expertise of the one person that can help and guide you), plus we're generally an approachable bunch that when buttered up the right way will help anyone!! 😀
email: info@weekendwebdesign.co.uk
Personal Website: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk
February 15, 2013 at 12:13 am
thanks
February 15, 2013 at 1:17 am
Here's another thread on the forum regarding moving from a developer role to a DBA that you may want to have a look at: http://www.sqlservercentral.com/Forums/Topic1419857-391-1.aspx
There's a post on there from ScottPletcher that gives some good starting points.
email: info@weekendwebdesign.co.uk
Personal Website: http://markallen.co.uk/
Business Website: https://www.weekendwebdesign.co.uk
February 15, 2013 at 6:11 am
sumith1andonly1 (2/14/2013)
no im just a developer. but im trying to be a DBA
All I am going to say is this, stop trying to circumvent the DBA. His (or her) job is to protect the database system. You need to enlist the help of your DBA. If you want to become one, approach one, in this case yours. Start working with him (or her). All I can tell you is if you keep going in the direction you are currently treading, it won't end pretty.
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply