How do I create more Server name from Database Engine

Rama Tito
Rama Tito used Ask the Experts™
on
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.
Comment
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
Commented:
does this article help troubleshooting the issue?
http://www.experts-exchange.com/A_1881.html
Commented:
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).
Commented:
Have you installed SQL Server 2005 Express, then the server name is

yourmachinenam\namedinstancename

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