Yesterday I was trying to install Dot Net Panel and I installed all of its dependencies such as sql server 2008 express
but in the installation I was prompting with an error message that there is some kind of problem with the sql server or the login name is incorrect
“sql server does not exist or accesss denied”
I search so much for about half a day but I found nothing
finally I found the solution in one forum that I will share it with you so that you will debug this issue with minimum of time loss
the steps bellow are the guides to resolve this issue
1.In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
1. On the Security page, under Server authentication, select the SQL Server and Windows Authentication mode, and then click OK.
2. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
3. In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.
Then create a SQL Server login that uses SQL Server Authentication.
1. In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.
2. Right-click the Security folder, point to New, and then click Login.
3. On the General page, enter a name for the new login in the Login name box.
4. Select SQL Server Authentication.
5. Enter a password for the login.
6. Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
7. Switch to Server Roles tab and User Mapping tab and grant the server role and database roles to the account.
8. Click OK.
voshka
thanks
Recent Comments