Can't Display Data From Remote Sql Server Because Login Fails

but i am able to login to the same remote sql server through SQL server managment studio express using the details i am using in the connection string in the "test.aspx" page.

ERROR:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)

When this page is run, i want all the user's UserName and Password to be dispalyed.

However, i am getting the above mentioned error.

what could be the problem?
 This is the code i am using in my test.aspx page to connect to "Login" table in my database.
 1 Imports System.Data
2 Imports System.Data.SqlClient
3
4 Private Sub GetAllTheComments()
5
6 Dim MyConnection As SqlConnection
7
8 Dim MyCommand As SqlDataAdapter
9
10 MyConnection = New SqlConnection("server=XXX.X.XXX.X;uid=X;pwd=X;database=X")
11
12 MyCommand = New SqlDataAdapter("select UserName, Password from Login", MyConnection)
13
14 ds = New DataSet
15
16 MyCommand.Fill(ds)
17
18 DataList1.DataSource = ds
19
20 DataList1.DataBind()
21
22 End Sub