I am not able to create a database in sql server 2005
-
Friday, October 05, 2012 6:06 AMI am not able to create a database in sql server 2005 it shows an permission denied sql server error 262. can any one tell me what to do?
All Replies
-
Friday, October 05, 2012 6:06 AMI am not able to create a database in sql server 2005 it shows an permission denied sql server error 262. can any one tell me what to do?
- Merged by Ahmed Ibrahim - MSFTMicrosoft Employee, Moderator Friday, October 05, 2012 6:13 AM
-
Friday, October 05, 2012 6:11 AMModerator
Would you please check-out below thread
http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/11337996-eec5-40a0-be42-72db27b02fa5/
Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.
- Marked As Answer by Shulei ChenModerator Tuesday, October 16, 2012 1:31 AM
-
Saturday, October 06, 2012 4:18 PM
I am not able to create a database in sql server 2005 it shows an permission denied sql server error 262. can any one tell me what to do?
create new schema and full control (create ,grant ) and then create new login and applied this schema on him.
Even aclock that is not going is right twice aday.
-
Monday, October 08, 2012 5:12 AM
Hi erd,
First, please try to run the SQL Server 2005 as Administrator (Right click on it choose "Run as Administrator"). If that does not work, please try to check the below links, hope them can help you.
http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/8626e979-95e4-4fc9-a2f9-6e797778381d/
http://social.msdn.microsoft.com/Forums/en/sqlgetstarted/thread/32604a68-a1dd-4644-be07-6eb87b99a6f2Regards,
Amy PengAmy Peng
TechNet Community Support
- Marked As Answer by Shulei ChenModerator Tuesday, October 16, 2012 1:31 AM
-
Monday, October 08, 2012 5:49 AMModerator
Mostly you are not having rights/permission
Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter -
Monday, October 08, 2012 8:27 PM It seems to be an permission issue. Please check user your using to create database is having proper rights or not.
Regards,
Rohit Garg
(My Blog)
This posting is provided with no warranties and confers no rights.
Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.- Marked As Answer by Shulei ChenModerator Tuesday, October 16, 2012 1:31 AM
.png)
