Solved

SQL Express 2008 can't login using windows authentication

Posted on 2010-08-19
3
719 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 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

828 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