Connecting to hosted MS SQL Server database using MS Visual Web Developer 2010 Express
Posted on 2010-11-09
I have a hosted website. The service includes an MS SQL Server 2008 database. From the host control panel I have created a simple Database with an initial table tPeople. I have the following information: Server IP address, Port Number, Server URL, Username (=Database name) and Password. In Visual Web Developer 2010 Express I have tried to test the connection as follows:
Tools menu and Connect to Database --> Add Connection Dialog:
Data source = Microsoft SQL Server (sqlClient)
Server name = 12.345.67.890 (IP address)
Use SQL Server Authentication = Yes Selected
Username = NAME
Password = PWORD
Database = NAME (same as Username)
On clicking "Test Connection" it always fails with Error 25 (Connection string is not valid) or Error 40 (Can not open a connection).
Does anyone know what I am doing wrong or is there something else I need to be aware of?