Link to home
Start Free TrialLog in
Avatar of Ruttensoft
Ruttensoft

asked on

SQL Server question

Hello

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?

Thanks
Avatar of chapmandew
chapmandew
Flag of United States of America image

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

are you trying to connect to these instances on the physical machine?
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.
Avatar of Ruttensoft
Ruttensoft

ASKER

Hi

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 :-(
ASKER CERTIFIED SOLUTION
Avatar of beester
beester
Flag of Norway image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial