Just wanna share this one to my co-newbies.
Solution for the problem using any GMC for Ran EP6 to EP8, you put the correct setting but still you can't login. Just try the below steps.
"Login failed" = if you encounter this one, you have the problem in "Windows Authentication mode", as you can see if you try to login in "SQL Server using Windows Authentication mode" you have an error.
Just follow the below steps:
////////////////////////////////////////////////////////////////////
When you install the SQL Server using Windows Authentication mode, by default, the “sa” account is disabled. Sometimes, due to users/customers request, you may need to enable the sa account. You need to change the authentication mode for SQL server from Windows Authentication Mode to SQL Server and Windows Authentication Mode to use the sa account.
[h=5]To Change the Authentication Mode:[/h] Follow the steps mentioned below to change the authentication mode from Windows Authentication to SQL Server and Windows Authentication. You need to remember that, the SQL Server service needs to restart to make this change effective.
1. Login to the SQL server instance using SQL Server Management Studio. Right-click on the database instance, and go to Properties.
2. On the Server Properties page, Click on Security. Click on the radio button next to SQL Server and Windows Authentication mode, and click on OK to close the Server Properties page.
3. Once you clicked on the Ok button, we will get the following screen:
As discussed earlier, we need to restart the SQL Server service to make this change effective. After restarting the SQL Server, the authentication mode will be changed to SQL Server and Windows Authentication mode.
[h=5]Enable the sa Login:[/h] 1. Connect to the SQL Server instance using SSMS and go to Security. Expand Security, go to Logins.
2. You can see the sa account is disabled when you install SQL Server using Windows Authentication mode.
3. Right-click on the sa account and go to Login Properties. Specify a complex password for the sa account. By default, the Enforce password policy is checked. (if you don’t want to provide a complex password for the sa account, you can uncheck this option. However, this is not recommended.)
4. Click on the Status page. By default, the sa account will be disabled. Click on the Enabled button to enable the sa account. Click on Ok to close the sa Login Properties.
Thus, sa account is enabled and you will be able to login to the SQL instance using the sa account.
/////////////////////////////////////////////////////////////////////////////
After the above steps, got to your ODBC, change the configuration of your RanGame1, RanLog, RanShop, RanUser
I hope it will help!..
Credits to:
Link:
Solution for the problem using any GMC for Ran EP6 to EP8, you put the correct setting but still you can't login. Just try the below steps.
"Login failed" = if you encounter this one, you have the problem in "Windows Authentication mode", as you can see if you try to login in "SQL Server using Windows Authentication mode" you have an error.
Just follow the below steps:
////////////////////////////////////////////////////////////////////
When you install the SQL Server using Windows Authentication mode, by default, the “sa” account is disabled. Sometimes, due to users/customers request, you may need to enable the sa account. You need to change the authentication mode for SQL server from Windows Authentication Mode to SQL Server and Windows Authentication Mode to use the sa account.
[h=5]To Change the Authentication Mode:[/h] Follow the steps mentioned below to change the authentication mode from Windows Authentication to SQL Server and Windows Authentication. You need to remember that, the SQL Server service needs to restart to make this change effective.
1. Login to the SQL server instance using SQL Server Management Studio. Right-click on the database instance, and go to Properties.
You must be registered to see links
2. On the Server Properties page, Click on Security. Click on the radio button next to SQL Server and Windows Authentication mode, and click on OK to close the Server Properties page.
You must be registered to see links
3. Once you clicked on the Ok button, we will get the following screen:
You must be registered to see links
As discussed earlier, we need to restart the SQL Server service to make this change effective. After restarting the SQL Server, the authentication mode will be changed to SQL Server and Windows Authentication mode.
[h=5]Enable the sa Login:[/h] 1. Connect to the SQL Server instance using SSMS and go to Security. Expand Security, go to Logins.
2. You can see the sa account is disabled when you install SQL Server using Windows Authentication mode.
You must be registered to see links
3. Right-click on the sa account and go to Login Properties. Specify a complex password for the sa account. By default, the Enforce password policy is checked. (if you don’t want to provide a complex password for the sa account, you can uncheck this option. However, this is not recommended.)
You must be registered to see links
4. Click on the Status page. By default, the sa account will be disabled. Click on the Enabled button to enable the sa account. Click on Ok to close the sa Login Properties.
You must be registered to see links
Thus, sa account is enabled and you will be able to login to the SQL instance using the sa account.
/////////////////////////////////////////////////////////////////////////////
After the above steps, got to your ODBC, change the configuration of your RanGame1, RanLog, RanShop, RanUser
I hope it will help!..
Credits to:
You must be registered to see links
Link:
You must be registered to see links
