Database access problem after site hosted.

Question

0.00/5 (No votes)

See more:

Hi,
I have hosted a website. The dataconnection I am using is (web.config file)

XML

<add name="dbTestConnectionString" connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbTest.mdf;Integrated Security=True;User Instance=True" providername="System.Data.SqlClient" />

It works fine on the localhost but when run over the internet, it gives error that access to databse is not possible. (please visit http://www.ezitek.somee.com for detailed error)
I think I need to change the connection string, but I do not know what to do.

When hosted, my database is in App_Data folder of my solution, which has been uploaded as it is.

My host has given me the following detail:

Website local path: d:\DZHosts\LocalUser\fsehgal\www.ezitek.somee.com
Protected local path: d:\DZHosts\LocalUser\fsehgal\Protected.ezitek.somee.com

Please advise what to do to avoid this error.

Thank you very much.
With best regards,
Furqan

Posted 14-Sep-11 21:21pm

Furqan Sehgal

Updated 14-Sep-11 21:37pm

walterhevedeich

v3

Add a Solution

Comments

Herman<T>.Instance 15-Sep-11 3:24am

is there an sqlexpress db installed on the webserver?

Herman<T>.Instance 15-Sep-11 3:25am

source . means localhost.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

uspatel · Answer 1 · 2011-09-14T21:30:00

Solution 1

use connection string as

C#

Data Source=OMX11SFD;Initial Catalog=omx;Persist Security Info=True;User ID=sa;Password=uuuu@!"

in your web config file.
Hope it Works.

Posted 14-Sep-11 21:30pm

uspatel

Comments

Furqan Sehgal 15-Sep-11 3:36am

Mr. Patel thanks for the reply. Where does my database name fit? Could you plese give me complete statement to replace with my connection string
"<add name="dbTestConnectionString" connectionstring="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbTest.mdf;Integrated Security=True;User Instance=True" providername="System.Data.SqlClient">"

uspatel 15-Sep-11 4:20am

in my example database name is omx as
Initial Catalog=omx

uspatel 15-Sep-11 4:21am

Data Source=.\SQLEXPRESS;Initial Catalog=dbTest;Integrated Security=True

uspatel 15-Sep-11 5:35am

pass full data source name rather than .\SqlExpress

uspatel 15-Sep-11 6:00am

If you use sql server, then if you connect to database engine ,then a login window appears in sql server, the Server name in this window is your data source name.

uspatel 15-Sep-11 6:05am

A simple way to find out the connection string.
open visual studio project
>server explorer
>Add connection
>After connection established
>Rigt click on database in your dataconnections
>properties
>Connection string
>copy this
>and paste in web config

Furqan Sehgal 15-Sep-11 6:13am

Right Clicked database, in properties it showed the connection string as
Data Source=.\SQLEXPRESS;AttachDbFilename="D:\VS2008\ASP.Net\ASP.Net DataBase Basics\App_Data\dbTest.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True

uspatel 15-Sep-11 6:15am

are u tried data source name

Furqan Sehgal 15-Sep-11 6:20am

Where to check what is datasource name?

uspatel 15-Sep-11 6:28am

if you are hosting the site on internet then You need to server name of sql server to connect database.It will be ip address of server.
and SQL server should be alloew Remote Connections.
use this link to configure SQl Server http://support.microsoft.com/kb/914277

Furqan Sehgal 15-Sep-11 6:36am

The IP address 66.96.210.16
Please advise how to fit it into the connection string.
(Connectionstring in Default.aspx to be left as it is????)

uspatel 15-Sep-11 6:41am

Is it your database on remote server,if not first take space on remote and then host the site.
If this is IP of Server thent it will be pass as Data Source name with Id and Password.
also use Web configuration connection string in default.aspx page.

rkthiyagarajan · Answer 2 · 2011-09-14T21:50:00

I think ConnectionString Problem you try this code.

Use bellow code in Web.cofig

XML

<connectionStrings>
   <!--<add name="OsmEmpConString" connectionString="Data Source=.\sqlexpress;Initial Catalog=Reg.Mdf; "  providerName="System.Data.SqlClient" />-->
   <add name="OsmEmpConString" connectionString="Data Source=.\sqlexpress;Integrated Security=SSPI;AttachDBFilename=C:\Documents and Settings\Administrator\My Documents\Downloads\Rags_Modified\Rags\Rags\App_Data\Reg.mdf;User Instance=true" providerName="System.Data.SqlClient"/>

   <add name="SomeDataBase" connectionString="Data Source=.\SQLEXPRESS; AttachDbFilename=C:\Documents and Settings\Administrator\My Documents\Downloads\Rags_Modified\Rags\Rags\App_Data\Reg.mdf; Integrated Security=True; Connect Timeout=30; User Instance=True" providerName="System.Data.SqlClient"/>

   <!--<add name="SomeDataBase" connectionString="Data Source=.\SQLEXPRESS; AttachDbFilename=C:\App_Data\Reg.mdf; Integrated Security=True; Connect Timeout=30; User Instance=True"  providerName="System.Data.SqlClient" />-->

 </connectionStrings>

In code behind

string constr = ConfigurationManager.ConnectionStrings["SomeDataBase"].ToString();