SQL Server 2008 R2 login just doesn't work

Question

I have been unsuccessfully trying to do this work all day long. I have tried dozens of sentences in posts with the same result.

80040ed4 Login failed for user 'myuser'

Please, if you have a link to a tutorial with screenshots that do not reserve any important step, submit it here.

If you know how to do this from step 1 to the final, answer.

SBS 2008 R2 is the version

I just want to create a user who can read data from a database called "SharedWebDb", which is located on MYSQLSERVER / SHAREPOINT

Thanks.

Answer 1

Step 1. Create a new login with sql server authentication. Step 2. On the "Server Role" tab, enter its system administrator. Step 3: On the user mapping tab, select the database, wizard, tempdb, etc. And mark it as dbowner Step 4: Click ok. Step 5: Right-click on the server name and select properties, then select the sql server and the Authentication mode window in the securities tab and click ok. Step 6: Restart the sql server. Step 7. Now a new login to SQL Server will work :)