SQL Server question

Posted on 2010-01-05
Last Modified: 2012-05-08

I have installed SQL Server 2008 on 2 PC's. On one, i can connect using "localhost", on the other I can only connect using "MyPCNAME\local"

How can I change that, so I can also connect using localhost?

Question by:Ruttensoft
    LVL 60

    Expert Comment

    in sql configuration manager, do you have tcp/ip network protocols enabled?

    are you trying to connect to these instances on the physical machine?
    LVL 26

    Expert Comment

    by:Chris Luttrell
    localhost is just an alias pointing to your machine by name, in effect using MyPCNAME in your example.  Is it possible that you have more than one instance of SQL on the second machine, in which case it would have required you to "Name" the second instance and you can only refer to it with a MachineName\InstanceName?
    There are several things that could be wrong, and without the complete configuration or access it is hard to diagnose.

    Author Comment


    Actually I didnt know that I had 2 instances - that seems to be the problem. I have now uninstalled everything, but now I cannot reinstall SQL .... arggggh. Setup passes all tests, installs the Setup Support Files and after that, it just is closing :(

    No error message, nothing :-(
    LVL 7

    Accepted Solution

    You have to install SQL server with the choice of DEFAULT INSTANCE under the installation instead of named instance. This can be done by selecting advanced setting during the installation.

    SQL Server Express defaults to a named instance called computername\SQLEXPRESS.

    Regarding the reinstallation problem:

    Try this:

    Open Regedit
    Find the key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"
    Rename the "PendingFileRenameOperations" value to "PendingFileRenameOperations2"

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    760 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

    7 Experts available now in Live!

    Get 1:1 Help Now