Error message is:
The server principal “<username>” is not able to access the database “<database>” under the current security context.
Solution:
That error can happen due to attach a copied database from a different source. When we attach a copy of database it will have the user account attached from is previous server and created server. If these two SID does not match the error will occur.
Error: In SQL Server – access database under the current security context.
October 30, 2012 by ashraf
Posted in Error Messages | Leave a Comment
- I work in
Energent Incorporated as a Software Architect
I worked inUniversity of Western Ontario as a Research Assistant in DIGS Lab
Orion Informatics Limited for Wolters Kluwer Financial Services, USA as a Senior Software Engineer.
eGeneration Limited, Bangladesh as a Lead Software Engineer
BrainStation-23, Bangladesh as a Lead Software Engineer
Pageflakes Limited, Malaysia as a Software Developer and Tester
AIUB as a System Analyst
My Articles
- Editable GridView in ASP.NET 2.0
- Prepare yourself before you start migration of sql server reporting services 2005 to 2008
- Send appointment through email in ASP.NET
- Handling BULK Data insert from CSV to SQL Server
- Automate Software using WPF UI Automation
- ASP.NET Web Site Performance Improvement
- Complete ListView in ASP.NET 3.5
- Nested Master Page in VS 2008
Category
Contact
Md. Ashrafur Rahaman
ashrafur.rahaman@hotmail
faisal10dec@gmail
faisal10dec@skypeMy Flickr Photos
Archive
- February 2013 (1)
- November 2012 (1)
- October 2012 (4)
- June 2012 (1)
- October 2010 (1)
- March 2010 (4)
- February 2010 (3)
- January 2010 (1)
- December 2009 (1)
- July 2009 (1)
- May 2009 (1)
- February 2009 (3)
- October 2008 (4)
- August 2008 (2)
- July 2008 (1)
- May 2008 (2)
- April 2008 (2)
- March 2008 (6)
- February 2008 (3)
- January 2008 (11)
- December 2007 (1)
- November 2007 (1)
- October 2007 (1)
- September 2007 (4)
- June 2007 (1)
- February 2007 (4)
- December 2006 (2)
- October 2006 (7)
- September 2006 (3)
- August 2006 (10)
- July 2006 (9)
- May 2006 (3)
- April 2006 (1)
- February 2006 (7)
Blog Stats
- 343,506 hits
Tweets
Tweets by ashrafur
Leave a comment