SQL Server does not exist

[Anonymous]

when i use localhost in connection string dose not connect to the server i got SQL Server does not exist or access denied but when i use computer name it work the problem that programs use localhost dose not work how to resolve this My Configrations1-WinXP SP2 -Firewall OFF 2-SqlServer 2000 SP4 thanks for your help

[Luis Alonso Ramos]

Use (local). It is recgonized by the SQL Server provider as the local computer, while localhost must be resolved, and it dependes on your local network configuration. -- LuisR

---

Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog!

The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005

[Mahesh Kumar V K]

Yes, you can either try local or you can even use a . in the place of Server name as SQL will resolve it to your local SQL Server. In can use have more than one instance of SQL server installed, then pls use local\. For example, I have two instances of SQL Server one SQL Server 2000 which is installed with out any specific instance and and hence local and two SQL Server 2005 Beta named as SQL2K5. When I need to connect to SQL Server 2000, I use . or local and when I need to connect to SQL Server 2005, I use local\SQL2K5. Hope this helps you. Regards Mahesh