Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3310
  • Last Modified:

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

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
martyje
Asked:
martyje
  • 4
  • 3
  • 2
  • +1
1 Solution
 
8slash4Commented:
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
 
martyjeAuthor Commented:
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
 
8slash4Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
martyjeAuthor Commented:
meispisces:
Thanks for googling, have read most of those articles, sorry but that's totally irrelevant information.
0
 
meispiscesCommented:
then try uninstalling and then again installing
0
 
martyjeAuthor Commented:
8slash4:
So, what would you suggest?
Un-install SQL Server 2005, and maybe install MS SQL Server 2008?
Any thoughts?
0
 
8slash4Commented:
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
 
St3veMaxCommented:
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
 
martyjeAuthor Commented:
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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now