Solved

SQL Express 2008 can't login using windows authentication

Posted on 2010-08-19
3
721 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
dhlotter earned 125 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 125 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

690 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