.Net Application

[Chris]

I have a dot Net application installed on a windows 2000
server with Sql database. The server has .Net framework
1.1 installed. The application works on a local machine
but once installed on a server and linked to the
appropriate database, when trying to access through
browser window the application is opened but with an
error "We are Sorry - The system is not available at the
moment! Please try again later or contact your Systems
Administrator"

 

[ScottFrye]

Hi Chris,

Can you "see" the SQL database when you are on the machine that you are
installing your .NET program on? I would go to that machine physically and
see if you can connect to the database with query analyzer.

-Scott Frye

 

[Chris]

Hi Scott,

Yes i can "see" the database. I have installed the .Net
application locally on my machine and linked it to that
same sql database on the server and that has worked.

 

[ScottFrye]

Here are some things I would check.....

-From what I understand, you have an .NET application and SQL database on
your local machine.
-You copy your .NET application to a server and then tell the application to
access the SQL database on the server. (fails)
-When you use your application on the development machine and direct it to
the SQL database on the server there is no problem.
- I assume you are using a Windows Forms application instead of an Web
application.
- I assume you are not connecting through ODBC but instead through an
SQLConnection control.

1. Are the rights you are running your application on when you run it on the
server different than the rights you run when you test the machine on your
local machine?
2. are you using an admin login on development machine and a generic user on
server?
3. is the local NET policy different on the server and the development
machine?
4. Are you logging in to the SQL database with a specific SQL login or a
Windows login?

Hope it helps....

-Scott Frye

 

[Hector Correa]

The application works on a local machine

but once installed on a server and linked
to the appropriate database, when trying
to access through browser window the
application is opened but with an error

There are several security things that you need to
configure to launch an application through a browser
window successfully. Here is an article that describe
some of them:

http://www.code-magazine.com/article.aspx?quickid=0307061