How do I create more Server name from Database Engine

Rama Tito
Rama Tito used Ask the Experts™
i did manage to create another server name expect from my pc name. But when i did try to make connection Error 26- Error locating server / Instance Specified -  MS SQL Server. Its stand alone pc.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
does this article help troubleshooting the issue?
That article from angellll is thorough.

Most common things would be to Open the SQL Server configuration manager and enable TCP/IP (also try Named Pipes) and then  your PC Windows Firewall (try disable it to see if it is causing a problem - you can re-enable later).
Have you installed SQL Server 2005 Express, then the server name is


Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial