Menu
After upgrading to Service Pack 1, sometimes i got failed to login my server
at this time, Server Configuration Manager is like below
Do I need to change anything? thank you.
--
Once I could login, Server Configuration Manager is like below
During the failure time, I try to start "SQL Server (MSSQLSERVER)" but got fail to start. What is wrong in my R2 express? Please share me your idea.
After running "SQL Server (MSSQLSERVER)", I could login in to my server as 'sa'.
535
Go to your server, click on Security and then Logins, right click on sa and then click on Properties. Now go tot Status and then select Enabled under Login. Then, click OK. Now we can restart the SQLExpress, or the SQL you are using.
This connection is normally authenticated using SQL Server Authentication, and with the user name [sa] and default password [RPSsql12345].
Although my below snaps mention SQL Server 2008/express I would suggest to check for the below points.
Check whether you need to put the local computer name prefix before your DB name
If you connect using Windows authentication with the account you've created when you create your DB instance you can troubleshoot with right click database --> Database properties and select the below security option.
Check sa login under security option by double clicking. You can change the password if required as below.
Also if you see USER MAPPING option on the same properties view, check it and makesure sa is checked into the database you want to login.
services.msc)
81
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
