The fix for this issue was first released in Cumulative Update 3. This fix enables you to rename SQL Azure databases in Object Explorer. Since SQL Azure Service Update 2, SQL Azure supports the 'ALTER DATABASE' statement to rename databases. SymptomsĪ fix is available for SQL Server Management Studio (SSMS) 2008 R2 that enables users to rename SQL Azure databases in Object Explorer. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. You should now still not have added any group to the sysadmin role.SQL Server 2008 R2 SQL Server Management Studio SQL Server 2008 R2 Service Pack 3 More.

Under Enter the object names to select, enter Administrators:Ĭlick Check Names, and ensure that you are not allowed to add groups:Ĭlick Browse., and ensure that you have no ability to add groups: How do i add a group to the sysadmin fixed server role? Here's the steps i try, that don't work:Įnsure that you have no ability to add groups: One of these days i'm going to start a list of changes around Microsoft's 'broken by default' initiative. Matt figure out the change that Microsoft made so that SQL Server 2008 R2 is broken by default:Īdministrators are no longer administratorsĪll that remains is to figure out how to make Administrators administrators. I'm sure there's a technote or knowledge base article describing why SQL Server 2008 R2 is broken by default, but i can't find it. Note: It's not a client problem, as we can connect fine to other (non-SQL Server 2008 R2 machines): Note: It's not limited to SQL Server Management Studio, standalone applications that connect using Windows authentication: i can login locally and remotely using SQL Server Authentication. Note: i cannot logon locally, or remotely, using Windows authentication. Just this one, whitch is the only one that is 2008 R2 is failing. We can connect to 8 other SQL Servers on the domain using Windows Authentication. i can log into SQL Server using the local Windows Administrator account. I can login to the computer itself using Windows authentication. Reason: Token-based server access validation failed with an infrastructure error. When i try to connect to SQL Server (2008 R2) using Windows authentication:Ĭhecking the Windows Application event log, i find the error:

Ms sql management studio 2008 r2