473,699 Members | 2,800 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database on remote server

Database on remote server

On the remote server where my ASP.NET application is located there is no SQL
Server or SQL Server Express. When I test my application locally it works
fine because I have the SQL Server Express 2005 on my computer, but when I
deploy it I am getting error message telling me that there are some problems
connecting to the database. I have done the preparation on my SQL Server to
allow remote connection to the database. I am wondering if I understand the
problem right. The file located in my application with the extension .MDF
needs a service running on the remote server to allow my application to
connect to it (e.g SQL Server and SQL Server Browser services) .

Can anyone explain to me how this works? Do I need to create the same
database on the Database server at my ISP and change the connectionstrin g in
my application?

-DataBaseServer and WebServer are not the same server but I have access to
both

-The Webserver supports ASP.NET 2.0

TIRislaa
Oct 4 '06 #1
2 2091
So if you don't have SQL Server on your remote machine, where are you trying
to connect to? Back to your dev machine? For the most part, your database
needs to be on your operational .NET server or on another operational server
that has a dedicated database. Typically you develop using something like
SQL desktop on your dev machine, using one connection string (local) and
then change the connection string to your ops database when you compile your
app for publishing.

If you can tell me more about your setup, I can help you more.

Chip

"Tor Inge Rislaa" <to************ @rislaa.nowrote in message
news:u2******** ******@TK2MSFTN GP05.phx.gbl...
Database on remote server

On the remote server where my ASP.NET application is located there is no
SQL Server or SQL Server Express. When I test my application locally it
works fine because I have the SQL Server Express 2005 on my computer, but
when I deploy it I am getting error message telling me that there are some
problems connecting to the database. I have done the preparation on my SQL
Server to allow remote connection to the database. I am wondering if I
understand the problem right. The file located in my application with the
extension .MDF needs a service running on the remote server to allow my
application to connect to it (e.g SQL Server and SQL Server Browser
services) .

Can anyone explain to me how this works? Do I need to create the same
database on the Database server at my ISP and change the connectionstrin g
in my application?

-DataBaseServer and WebServer are not the same server but I have access to
both

-The Webserver supports ASP.NET 2.0

TIRislaa


Oct 5 '06 #2
The Web server and the Database server are on the same network at my ISP but
it is not on the same IP Address. Instead of referring to local host I need
to point to the server by using IP address or DNS name .

By default, user information (used for roles, users by login controls) is
stored in a Microsoft SQL Server Express database in the Data folder of the
Web site. Is it possible to store the data in a remote SQL Server 2005
instead of the SQL Server Express database on your local computer?

TIRislaa

"Chip" <ch**@intradata .comskrev i melding
news:eo******** ******@TK2MSFTN GP04.phx.gbl...
So if you don't have SQL Server on your remote machine, where are you
trying to connect to? Back to your dev machine? For the most part, your
database needs to be on your operational .NET server or on another
operational server that has a dedicated database. Typically you develop
using something like SQL desktop on your dev machine, using one connection
string (local) and then change the connection string to your ops database
when you compile your app for publishing.

If you can tell me more about your setup, I can help you more.

Chip

"Tor Inge Rislaa" <to************ @rislaa.nowrote in message
news:u2******** ******@TK2MSFTN GP05.phx.gbl...
>Database on remote server

On the remote server where my ASP.NET application is located there is no
SQL Server or SQL Server Express. When I test my application locally it
works fine because I have the SQL Server Express 2005 on my computer, but
when I deploy it I am getting error message telling me that there are
some problems connecting to the database. I have done the preparation on
my SQL Server to allow remote connection to the database. I am wondering
if I understand the problem right. The file located in my application
with the extension .MDF needs a service running on the remote server to
allow my application to connect to it (e.g SQL Server and SQL Server
Browser services) .

Can anyone explain to me how this works? Do I need to create the same
database on the Database server at my ISP and change the connectionstrin g
in my application?

-DataBaseServer and WebServer are not the same server but I have access
to both

-The Webserver supports ASP.NET 2.0

TIRislaa



Oct 6 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

20
17628
by: xixi | last post by:
hi, we use db2 udb v8.1 on windows, i am trying to use federated database objects to create wrapper, even though i have update dbm cfg using federated yes, i still get error "the instance for the db is not enable for the specified action", do i miss sth else?
5
3692
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops. Following problems occur: 1. Access is way too slow in WAN environment. Server is located in New Jersey and users are in California and Puerto Rico. 2. Database often becomes corrupt 3. When one user updates some data in the database, other users...
2
8343
by: James | last post by:
Dear Access Guru's, Hopefully you can help me (as Microsoft don't seem to be able to) We have an Access database on a Windows 2003 server with 5 CALS in our office. Access is loaded onto the server. We have 2 PC's connected to it on the LAN
0
1549
by: Bennett Haselton | last post by:
In Visual Studio .Net 2002 Server Explorer, if I add a new connection under "Data Connections", I can specify a remote server name and the username and password that I want to use, but then when the database appears, if I right-click on "Tables", there's no option to add a new table. If I right-click "Servers" in Server Explorer instead and add a new server on my local intranet, I can browse its SQL Server databases, and under each...
3
2685
by: Pakna | last post by:
Hello, I have what may be a beginner's question regarding DB2. How does one access a remote table on a remote database via SQL? What is the command string, is there an equivalent of Oracle DBLINK? I hope I was clear. If there are more information that I need to supply, please do tell me. Thank you very much for your replies
0
1063
by: jaykris9 | last post by:
Hello, I have a database on my system with same name as that on the remote server.I do have DSN Name, userid & password for connecting the remote server. Is there any possibility of restoring the database backup taken from the local system to the remote server database using Visual basic. I tried to get connected using the following string Set con = New ADODB.Connection con.ConnectionString = "Provider=SQLOLEDB;server=SYSTEM1;" & _ ...
7
3688
by: Martin | last post by:
Hello Does anyone know if it is possible to use the smo db.Create() method to create a new sql server database with sql server 2005 express? The debugger complains that remote operations are not allowed with the default install of sql server express. Thank you Martin
7
1918
by: =?Utf-8?B?a21jY29za2V5?= | last post by:
I'm trying to access an access database on the file server from a web server using asp.net and IIS 6.0. I can do it when I have anonymous access enabled in IIS 6.0 as in the public internet web site style. I want to do the same with the intranet setup where IIS 6.0 is not setup to allow anonymous access. The way the intranet works is the user authenticates to the IIS 6.0 web server through group membership in an active directory domain. ...
4
2917
by: dgleeson3 | last post by:
Hello all I am creating a VB.Net distributed SQL server 2005 application. Each computer in the system has a database with a table of users and their telephone numbers. Each computer has a unique 4 digit identifying code. The central server runs an application which reads the database table on each computer.
0
8704
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8623
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9054
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6544
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5879
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4390
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4637
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3071
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2361
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.