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
2  2094 
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
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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?
|
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...
|
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
|
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...
|
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
| | |
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;" & _
...
|
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
|
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. ...
|
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.
|
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...
|
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,...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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...
|
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...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
