Solved

Login Failed for User ". (Microsoft SQL Server Error: 18456

Posted on 2009-05-17
10
3,252 Views
Last Modified: 2012-05-07
I installed MS SQL Server 2005 on my computer. I am using Vista. After installation, SQL Server was giving a compatibility error so I downloaded/installed SQL Server 2005 server pack 1for vista. Now, I can't login to SQL Server.
It gives the error:
Login Failed for User ". (Microsoft SQL Server Error: 18456

I also have MS SQL Server Express installed on my computer and I can login to that without any problem.
Any ideas? thoughts?

Thanks much
0
Comment
Question by:martyje
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 1

Expert Comment

by:8slash4
ID: 24409105
Try the latest Sql Server Service Pack 2 and see if the same problem persists.

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

You can use these packages to upgrade any of the following SQL Server 2005 editions:

    * Enterprise
    * Enterprise Evaluation
    * Developer
    * Standard
    * Workgroup

Note: To upgrade SQL Server 2005 Express Edition, obtain the SP2 version of Express Edition or Express Edition with Advanced Services.

Note 2: SQL Server 2005 Service Pack 2 (SP2) is designed to run on Windows Vista and Windows Server "Longhorn."
0
 

Author Comment

by:martyje
ID: 24409125
8slash4:
Sorry, just a correction, I have installed service pack 3. so that would be the latest one I think.
Still I should install service pack 2?
Also I am using "Enterprise Evaluation" version for 180 days.

Thanks.
0
 
LVL 1

Expert Comment

by:8slash4
ID: 24409170
My mistake, i have service pack 2 and thought that was the latest. As for your problem, the enterprise edition will only run on the following Operating Systems:

Windows Server 2003, Standard Edition*
Windows Server 2003, Enterprise Edition*
Windows Server 2003, Datacenter Edition*
Windows Small Business Server 2003 Standard Edition
Windows Small Business Server 2003 Premium Edition
Windows 2000 Server**
Windows 2000 Advanced Server**
Windows 2000 Datacenter Server**

Quoteing Microsoft,"In an effort to provide customers with more secure products, Microsoft Windows Server 2008 and Microsoft Windows Vista are supported by SQL Server 2005 Express Edition Service Pack 1 (SP1), and for all other editions will be supported by SQL Server 2005 Service Pack 2 (SP2) or later when it becomes available."
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 7

Expert Comment

by:meispisces
ID: 24409177
0
 

Author Comment

by:martyje
ID: 24409213
meispisces:
Thanks for googling, have read most of those articles, sorry but that's totally irrelevant information.
0
 
LVL 7

Expert Comment

by:meispisces
ID: 24409221
then try uninstalling and then again installing
0
 

Author Comment

by:martyje
ID: 24409229
8slash4:
So, what would you suggest?
Un-install SQL Server 2005, and maybe install MS SQL Server 2008?
Any thoughts?
0
 
LVL 1

Expert Comment

by:8slash4
ID: 24409292
Well,
I looked at the Microsft website and it looks the like the Enterprise edition, regardless of the release, will not support Vista. You have to use the express or standard edition. I suggest you try the Standard edition of SQL Server 2008.

The editions which support Vista are:
SQL Server 2008 Express
SQL Server 2008 Standard
SQL Server 2008 Developer
SQL Server 2008 Workgroup
SQL Server 2008 Web
0
 
LVL 13

Accepted Solution

by:
St3veMax earned 500 total points
ID: 24410424
You need to use the Vista Provisioning tool in order to add your local access.

It should be in the Programs folder o[n your machine.

HTH
0
 

Author Comment

by:martyje
ID: 24414729
St3veMax:
Awesome, you the man.
Provisioning tool solved the problem. Thanks much.
Just a small clarification for myself and other developers, "User Provisioning" is SQL Server Tool.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

810 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