Ric,

server name = ip address

I am just trying to connect to the database server in the web domain server using sql server mngt studio express.

>Jess, Is the connection string on one of these formats: server name or IP\instance Name or server name or IP,port number?
>>Ric,
>>
>>I can ping the ip address.
>>
>>They're saying they tried connecting from different locations but who knows Ric? I also ried connecting from different locations but I can't connect to that server for some unknown reasons. I don't know.
>>
>>>Are you trying to access a named instance? Can you ping the IP address?
>>>
>>>If you are trying to connect to a named instance the problem might be a firewall issue. Named instances communcate through a random port by default. When the techs connected to the instance, were they outside their network?
>>>
>>>-R!
>>>
>>>>Using SQL Server Management Express Edition, I can't seem to access the database server of a web hosting. The instruction sent to me by the web hosting company is to specify the IP address as server in the connection window of SQL Server but it gives me the error below:
>>>>
>>>>Cannot connect to 74.86.130.67.
>>>>
>>>>------------------------------
>>>>ADDITIONAL INFORMATION:
>>>>
>>>>A network-related or instance-specific error occurred while establishing a
>>>>connection to SQL Server. The server was not found or was not accessible.
>>>>Verify that the instance name is correct and that SQL Server is configured
>>>>to allow remote connections. (provider: Named Pipes Provider, error: 40 -
>>>>Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
>>>>
>>>>The tech support kept on saying that they have no problem when accessing the database server and the database itself. They tried accessing it from different location but they don't encounter the error I was mentioning. I can't figure out why? any idea folks? Is this something to do with the firewall in my PC. BTW, I am not in an office environment which means ISA does not play a role here. I am at my house doing some personal stuff trying to use Visual WebGui.