SQL Server WINDOWSS Identity login and SA identity login

Today re-installed the system, but the computer name changed, and then changed the computer name, and then installed the Sqlsever, after the installation is completed, and found that no matter the Windows identity or SQL Server identity can not log on

1. Start by talking about SQL Server login, because the installation is not using the default instance name, so when the login is not found on the native instance.

such as Tu:

So we need to log in again. Enter the local computer name \ Instance Name For example, mine is huangrui\mssql2005 .

Then the underground user name \ password is sa\******.

2. Again, Windows identity Login

If you are using the default instance name when installing SQL Server, enter '. ' You can log in, if you modify the default instance name, you need to enter '. \ instance name ' and then choose Windows Identity Login.

If you can not log in, do not search the Internet, no one mentioned. If you are Win7 and a more advanced system, please open SQL Server Management Studio Right-click and select Use

Run as Administrator

SQL Server WINDOWSS Identity login and SA identity login