Search my blog
-
-
Recent Posts
- Reading list for the week – 24/10/11
- Reading list for the week – 17/10/11
- Reading list for the week – 10/10/11
- Reading list for the week – 03/10/11
- Reading list for the week – 26/09/11
- MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
- Reading list for the week – 19/09/11
Page Views
283,436-
Popular Posts
- How the Cannot generate SSPI context error was fixed
- Cannot create an instance of OLE DB provider ‘OraOLEDB.Oracle’ for linked server
- Find the SQL Server Instance name using Task Manager
- The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON
- Script to check database user permissions
Archives
Tags
backup configure data corruption data file hardware hotfix index internals locks maintenance plan performance PradeepAdiga restore RLFTW scripts security services setup sql 2000 sql 2005 sql 2008 sql 2012 sql agent ssis system databases tips and tricks tools Top Posts trace transaction log troubleshoot windows
Tag Archives: sql 2008
Hide SQL Server Instance on all versions
It is holiday season everywhere. It means that Freeze on Change Controls. Nothing changes so nothing breaks. Also the instances my team supports have been very supportive this holiday season. Hence most of my recent posts have been inspired by … Continue reading
Posted in SQLServerPedia Syndication
Tagged services, sql 2000, sql 2005, sql 2008, sql 2012, tips and tricks
3 Comments
Server is in script upgrade mode. Only administrator can connect at this time
Yesterday I replied to a question in which the user was not able to connect to the SQL Server 2008 instance after installing Service Pack 2. The error message is Login failed for user ‘LoginName’ Reason: Server is in script … Continue reading
Posted in Hotfix, SQLServerPedia Syndication, Troubleshoot
Tagged hotfix, services, sql 2008, windows
1 Comment
RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare