Solved

Connecting to hosted MS SQL Server database using MS Visual Web Developer 2010 Express

Posted on 2010-11-09
10
894 Views
Last Modified: 2012-05-10
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?
Thanks, David.
0
Comment
Question by:DataTrain
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 2

Accepted Solution

by:
Pacane earned 100 total points
ID: 34094938
Usually, the express versions of these dev tool don't allow by default remote connections, if I remember well..
0
 

Author Comment

by:DataTrain
ID: 34095107
If that is the case, what is the full version of Visual Web Developer 2010 Express software application called?
0
 
LVL 2

Expert Comment

by:Pacane
ID: 34095117
Same thing, without the Express keyword, usually. (Maybe someone can confirm, or it might be part of the Expression Suite...)
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:DataTrain
ID: 34095191
Can anyone else confirm it is not possible to connect to a remote database from the Express version?
Is the full version Visual Studio 2010?
0
 
LVL 2

Expert Comment

by:Pacane
ID: 34095211
PS: If the server is running as MS SQL Server Express, it won't accept remote connections by default either.
0
 
LVL 15

Expert Comment

by:John Tsioumpris
ID: 34095326
0
 
LVL 2

Expert Comment

by:Pacane
ID: 34095339
He should be able to do it graphically though.
0
 
LVL 41

Assisted Solution

by:guru_sami
guru_sami earned 100 total points
ID: 34095544
Yes the full version is called "Visual Studio 2010" with different editions Professional / Ultimate
Download Sql Express Management Studio and try connecting via it.
Also ask your host provider if they allow remote connections.
0
 
LVL 15

Assisted Solution

by:John Tsioumpris
John Tsioumpris earned 50 total points
ID: 34096603
The express editions lack this graphic approach thats u have to go programmatically.
0
 

Author Closing Comment

by:DataTrain
ID: 34100766
The comments taken together have been helpful. Thanks.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I've been asked to discuss some of the UX activities that I'm using with my team. Here I will share some details about how we approach UX projects.
Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
The viewer will learn how to count occurrences of each item in an array.

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question