MS SQL Server not running on Win7
- by Anas
I have installed available all components of "MS_SQL_05" as give named instance on Win-7. I had a default instance running of MSSQL08. While Installing MSSQL05 Instance I choose to use windows authentication.
But now I got a problem and my database engine is not running, actually no components are working except I am just able to login to Integration service.
I think there is some Username issue, coz It using UsrNm :'Anas-PC\Anas' which seems incorrect. Here below is the detail
===================================
Cannot connect to ANAS-PC\MS_SQL_05.
===================================
Login failed for user 'Anas-PC\Anas'. (.Net SqlClient Data Provider)
Server Name: ANAS-PC\MS_SQL_05
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536