Solved

SQL Express 2008 can't login using windows authentication

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help Required 3 97
TSQL - How to declare table name 26 30
T-SQL: New to using transactions 9 29
SQL - Use results of SELECT DISTINCT in a JOIN 4 20
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

773 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