connection string works on local but not on webserver(ASP.NET)

[Hitcher]

I'm trying to get some data out of SQLServer on our Webserver.
It wasn't working so I built the database on my local machine.
The code pages are on my C: drive and the virtual folders are in IIS
running on my local machine.

The following connection string works fine (TRHXP210 is my maching
name):-

Private Const m_strConnection As String = "Password=;Persist
Security Info=True;" & _
"User ID=sa;Initial
Catalog=Committee;" & _
"Data Source=TRHXP210;" &
_
"Network Library=dbmssocn"

The problem is if I change the Data Source to =TRDCLGA6 (our webserver
name) and run the page I get the following Error:-
System.Data.SqlClient.SqlException: SQL Server does not exist or
access denied.

The code files are on my local machine - could it be that I have to
build everything locally then disconnect the database, deploy the app
on the server, then re-attach the db on the remote instance of
SQLServer?
Should I be able to pull data from the remote server? It works with my
ASP pages!??
Can anyone help please.
TIA

[Aaron Bertrand - MVP]

[url]http://www.aspfaq.com/5002[/url]

> System.Data.SqlClient.SqlException: SQL Server does not exist or
> access denied.