Newbie help: SQL Server does not exist or access denied

I have created a simple ASP page, but when I call it up, I receive the following error:
SQL Server does not exist or access denied
I am using SQL Server 2000 and Win2K. Any idea what may be causing this error?What are you supplying for your connection string?

1) SQL Server name
2) Username
3) Password
4) Database

If you use a trusted connection remember that the ASP page will connect to SQL Server as the user account that IIS is running under.|||Hi,

I am getting the same error message:

"SQL Server does not exist or access denied"

when I attempt to register a SQL Server in SQL Server 2000.

Any ideas?

Thanks,

Chris|||'csf' can you ping the server from your workstation

c:\> ping MyServer

I have a feeling that you can not see the server by its user friendly name. Can you ping it by it's IP address.

c:\ ping xxx.xxx.xxx.xxx

If so, then use the Client Network Utility for SQL Server and define an Alias to this server. Set the network library to TCP/IP, set the server alias name to the server name and enter the IP address for the server name.|||Thanks for the reply.

I will try this when I get home this evening :)