[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Express 2008 can't login using windows authentication

Posted on 2010-08-19
3
Medium Priority
?
724 Views
Last Modified: 2012-05-10
Hello,

Could you please help me resolve the problem with connection  to SQL serverExpress 2008 R2.
My server has been setup to use mix sql and windows authentication. Its in my domain but everytime pople in company try to conenct using windows authentication ( their logins/passwords)connection failed we receive sql error 18456. Everything works fine for sa login and pass

Could you please help me investigate why we cant conenct using windows authentication?

Many Thanks,
0
Comment
Question by:siemian
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
dhlotter earned 500 total points
ID: 33476134
try the following taken from (http://support.microsoft.com/kb/889646)

To resolve this issue, you must add an account to the Database Creators role and to the Security Administrators role in SQL Server. You add the account that the application pool is running as. To do this:
Add the account that the application pool is running as to the Security Administrators role and to the Database Creators role in SQL Server. To do this:
Start SQL Server Enterprise Manager.
Expand Microsoft SQL Servers, expand the server group, expand the appropriate server, and then expand Security.
Right-click Logins, and then click New Login.
Type the account name in the Name box. Use the following format for the account name:
DomainName\AccountName
Note If SQL Server is installed on a separate computer and you want to run the application pool as the Network Service account, the computer that is running Windows SharePoint Services must have permissions to access the remote computer that is running SQL Server. On the remote computer that is running SQL Server, add the DomainName\ServerName$ account to the Database Creators role and to the Security Administrators role.
Click the Server Roles tab.
In the Server Role list, click to select the Security Administrators check box, and then click to select the Database Creators check box. Click OK.
Quit SQL Server Enterprise Manager.
On the Configure Administrative Virtual Server page of SharePoint Central Administration, create a new application pool, specify the account as the application pool account, and then click OK. The Application Pool Changed page is displayed.
Restart Microsoft Internet Information Services (IIS). To do this, click Start, click Run, type iisreset in the Open box, and then click OK.
On the Application Pool Changed page, click OK. On the Set Configuration Database Server page of SharePoint Central Administration, specify the configuration database settings.
0
 
LVL 2

Assisted Solution

by:rajeshprasath
rajeshprasath earned 500 total points
ID: 33476280
0
 
LVL 2

Expert Comment

by:rajeshprasath
ID: 33476358
If you still face the issue after delegation, then follow these steps,

1) goto client machine.
2) goto start -> Run -> type drivers -> press enter
3) open etc folder
4) open hosts file in notepad
5) Do this in last line. Type the server ip -> give some space -> Type Server Name

after that check connecting using sql server management studio. you will definetly able to connect.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question