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
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
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.
There are several things that could be wrong, and without the complete configuration or access it is hard to diagnose.
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 :-(
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
are you trying to connect to these instances on the physical machine?