Microsoft Sql Server 2005 Error 15247
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us error 15247 sql server 2012 Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community create database permission denied in database 'master' sql server 2008 r2 Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Create new sql server error 15151 user for local instance of SQL Server up vote 2 down vote favorite 1 I am attempting to set up a development machine. One of the components is SQL Server 2008 R2. I log in into the machine as local administrator and cannot alter the server role 'sysadmin', because it does not exist or you do not have permission. then I am trying to use windows authentication to log in into local instance of SQL Server. When I try to change password for sa I get error: Change password failed for Login 'sa'. (Microsoft.SqlServer.Smo) Cannot alter the login 'sa', because it does not exist or you do not have permission. (.Net SqlClient Data Provider) When I attempt to create a regular user. I get error that I don't have permissions to create user. Create failed for Login 'bob'. (Microsoft.SqlServer.Smo) User does not have permission to
Sql Server Error 229
perform this action. (Microsoft SQL Server, Error: 15247) My understanding was that all I needed to do is to log in as Local Admin in Windows to be able to administer SQL Server. Please advise how can create users or change sa password. Thank you sql-server sql-server-2008-r2 share|improve this question edited Nov 4 '13 at 16:06 marc_s 454k938701032 asked Nov 4 '13 at 16:02 svager 3423722 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote When you installed SQL server, what account did you set as the administrator for the instance? Usually you are asked if you would like to set a specific user or group to be sysadmin, the exception is SQL express where it automatically adds the local administrators group. I think it defaults to the user that you used to run setup, so if that is different to the account you are signing in with now, use that one, otherwise, if you can't get in as sysadmin, you will need to follow this procedure: Connect to SQL Server When System Administrators Are Locked Out share|improve this answer answered Nov 4 '13 at 16:21 steoleary 5,88821338 This article is for SQL Server 2012. Unfortunately it doesn't tell me how to use Config Manager for SQL Server 2008 –svager Nov 4 '13 at 16:25 1 Click the other versions dropdown box on the article and it will change to the 2008 version –steoleary Nov 4 '13 at 17:00 add a comment| up vote 1 down
here for a quick overview of the site Help Center Detailed answers to any questions you might have
Create Database Permission Denied In Database 'master'. (microsoft Sql Server, Error: 262)
Meta Discuss the workings and policies of this site About Us user does not have permission to perform this action Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with default password for sa in sql server 2014 us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just http://stackoverflow.com/questions/19771808/create-new-user-for-local-instance-of-sql-server like you, helping each other. Join them; it only takes a minute: Sign up SQL Server 2008 R2 Express permissions — cannot create database or modify users up vote 11 down vote favorite 5 Recently just upgraded to SQL Server 2008 R2 Express. When I attempt to create a database after logging in using Windows Authentication with http://stackoverflow.com/questions/9185142/sql-server-2008-r2-express-permissions-cannot-create-database-or-modify-users my id roger.moore I receive this error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) CREATE DATABASE permission denied in database 'master'. RESTORE HEADERONLY is terminating abnormally Error 262 If I try to add the sysadmin role to roger.moore, this is the error I receive: Add member failed for ServerRole 'sysadmin'. (Microsoft.SqlServer.Smo) An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) User does not have permission to perform this action Error 15247 If I try to add this role to my user with T-SQL, using this command, EXEC sp_addsrvrolemember 'ziffenergy\roger.moore', 'sysadmin'; GO Here is the error I receive: Msg 15247, Level 16, State 1, Procedure sp_addsrvrolemember, Line 29 User does not have permission to perform this action. Does anyone have any suggestions? It seems that I can't do anything with database on the local machine. Please note that I am the administrator on the Windows 7 workstation I am using, and if I try to create or modify databases and/or users on
Unanswered Topics Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005 user does not have permission (error 15247) User Name Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts http://p2p.wrox.com/sql-server-2005/56121-user-does-not-have-permission-error-15247-a.html | Search SQL Server 2005 General discussion of SQL Server *2005* version only. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any sql server forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) April 1st, 2007, 05:28 AM hertendreef Friend of Wrox Join Date: Apr 2006 Location: , , . Posts: 160 Thanks: 0 Thanked 0 Times in 0 Posts user does not have permission (error microsoft sql server 15247) Hi, I have installed sql server 2005 express on a Windows xp system with windows authentification. I did this with my administrator account (dan). When i start sql server management studio, i see: user name: myserver\dan . Now i want to create a new login, so i rightclick on 'logins' in 'Security' of 'Database'. I take an existing windows-account, but when i click on OK, i get the error: user does not have permission to perform this action (error 15247). I also tried to delete a login, but same error. Any help would be appreciated H. #2 (permalink) April 1st, 2007, 02:23 PM hertendreef Friend of Wrox Join Date: Apr 2006 Location: , , . Posts: 160 Thanks: 0 Thanked 0 Times in 0 Posts I reinstalled the whole thing and it works now. « Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is OffTrackbacks are Off Pingbacks are On Refbacks are Off Similar Threads Thread Thread Starter Forum Replies Last Post How to change user permission in SharePoint 2007. so