Installed ms sql 2005 local instance fails to log in

Posted on 2009-12-18
Last Modified: 2012-05-08
I installed ms sql 2005 in windows 7.

I can register a remote server but the local instance gives the following message:

Login failed for user 'R-PC\R'. (Microsoft SQL Server, Error: 18456)

Question by:robrodp
    LVL 26

    Expert Comment

    try to connect to the local instance with the account that you can connect from the remote host. Your account on the local host do not have login information...
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    did you create a login for that windows user on the other machine ?

    Author Comment

    I get this error:

    Server Name: R-PC
    Error Number: 18456
    Severity: 14
    State: 1
    Line Number: 65536

    I need to create and manage my local databases. With XP I install and the local instance has the pc name and windows login....

    When I installed there as a message that IIS was not installed, but I checke and it is installed. I got another message abour not registered
    LVL 22

    Expert Comment

    You need browser service running as well as the sql server.Start it manually....
    LVL 22

    Accepted Solution

    Another thing:
    Check if maybe a firewall of some sort  is blocking the connection and verify that you have set
    correctly log on credentials for the user if its sql server authentication.
    LVL 22

    Expert Comment

    by the way: error number suggests you are attempting to use a Windows login name with SQL Authentication !

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
    This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now