SQL Server - SS Denali installation steps and SSMS

Microsoft SQL Server Denali installation steps and SSMS



The installation steps of SQL Server Denali is the same as SQL Server 2008 / 2008 R2.



It shows the new functions and improvement of SQL Server Management Studio in Denali to compare with 2008 R2:
1. Surround With and Insert snippet to make the learner to use it conveniently - new
2. can drag the query window. - improvement
3. SSISDB - you can deploy the project which is created by SSIS to server. - new
4. Sequences folder in [database]\Programmability - new. for more information, you can visit here.
5. more? please do not hesitate to comment.

SQL Server - How to change the login name in SQL Server?

When I renamed the computer name, the login name in SQL Server was displayed as previous computer name. It did not affect all of the function of SQL Server and I just needed to rename the log in when I logged in SQL Server. But a problem is when I renamed the computer name, the previous log in name is still there in properties.

I have tried:

first delete Win***\administrator - i can't login to recreate it
repair it - still can't login
remove database engine and reinstrall with SQLVM\administrator - solve it... and i have to reattached database.

it was an idiot solution, eh?

I have asked my instructor - Ms. Donabel Santos for a solution, and she said I needed to drop the server and add it again to solve this problem.

sp_dropserver <'old_name\instancename'>
GO
sp_addserver <'new_name\instancename'>, local
GO

However, her solution was for just dropping the old server and adding it again - couldn't solve this problem.

Then I found the simplest way: "just rename the login name by correcting computer name."


That is it!