?
Solved

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

Posted on 2010-11-09
10
Medium Priority
?
898 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 2

Accepted Solution

by:
Pacane earned 300 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

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 17

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 300 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 17

Assisted Solution

by:John Tsioumpris
John Tsioumpris earned 150 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

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.

Question has a verified solution.

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

This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

752 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