473,326 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Remote Development of VB.NET Application

Dear all,

Can you please provide some information on the following issue, at the
earliest.

I have a development server setup in the network, say machine X. Also,
there is another workstation, say Y, for a programmer, to work with.
The application is a Winforms Application and machine X (server) does
not have Visual Studio .NET installed on it. Machine Y(workstation)
has got Visual Studio .NET installed on it. Y is connected via
sourcesafe to the solution in X, without making a local copy( I mean
through a network share).

There are issues faced by the programmer, in executing the application
in X, via Studio environment in Y. Basically application is not doing
any database related activities, and throws exceptions and breaks at
will.

Will this kind of a scenario ever work??? If not, please detail a
suitable alternative.

Two constraints are
a> No direct access to the Server X is possible for development.
b> Things need to be stage managed from the workstation Y.

Please respond at the earliest.

Regards..
Varkey
Jul 19 '05 #1
2 3737
What kind of app, windows or web?

The most likely cause is the user the app is running (or debugging) under
does not have permissions for the database. The most common reason is you
are using integrated security and the process is running under an account
without db access. This is very easy to explain with a web application.

1. User hits app
2. User is anonymous, so he is authenticated as the local account
IUSR_ComputerName
3. IUSR_ComputerName is a local account, so it has no rights to anything on
the domain
4. You have given a Domain Group, or list of Domain Users, rights to SQL
Server
5. As IUSR_ComputerName is not a domain user, or in any domain group (and
cannot be due to the security model), data access fails.

Possible solutions
1. For web apps: get rid of anonymous access to the app. This will force a
log on for all users using the app. Not a good situation for Internet, but
great for Intranet.
2. Impersonate a particular user for database access. You can change the
user context of the worker process thread ... for both windows and web
applications.
3. Switch to SQL security and change the connection string to use a SQL
account. If you do this, encrypt the connection string.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge

************************************************** **************************
****
Think Outside the Box!
************************************************** **************************
****
"Varkey" <va****@wipro.co.in> wrote in message
news:be**************************@posting.google.c om...
Dear all,

Can you please provide some information on the following issue, at the
earliest.

I have a development server setup in the network, say machine X. Also,
there is another workstation, say Y, for a programmer, to work with.
The application is a Winforms Application and machine X (server) does
not have Visual Studio .NET installed on it. Machine Y(workstation)
has got Visual Studio .NET installed on it. Y is connected via
sourcesafe to the solution in X, without making a local copy( I mean
through a network share).

There are issues faced by the programmer, in executing the application
in X, via Studio environment in Y. Basically application is not doing
any database related activities, and throws exceptions and breaks at
will.

Will this kind of a scenario ever work??? If not, please detail a
suitable alternative.

Two constraints are
a> No direct access to the Server X is possible for development.
b> Things need to be stage managed from the workstation Y.

Please respond at the earliest.

Regards..
Varkey

Jul 19 '05 #2
Dear Gregory,

Thanks a lot for the response.

I am afraid, the application being a Winforms one, I am not able to
implement steps you have suggested. However extending your line of
thought into a Winforms app, let us assume, I have no access to the
database server from "P3", the server in which the application
resides. In this case, is it possible for me to specify somewhere in
the VS.NET IDE,that while trying to debug or run the application,
please use this particular USER ID to connect???
Or is it something entirely different I am thinking off, away from
what you were pointing to??

Thanks once again..

Regards,

Varkey

"Cowboy \(Gregory A. Beamer\)" <No************@comcast.netRemuvThis> wrote in message news:<#Y**************@TK2MSFTNGP10.phx.gbl>...
What kind of app, windows or web?

The most likely cause is the user the app is running (or debugging) under
does not have permissions for the database. The most common reason is you
are using integrated security and the process is running under an account
without db access. This is very easy to explain with a web application.

1. User hits app
2. User is anonymous, so he is authenticated as the local account
IUSR_ComputerName
3. IUSR_ComputerName is a local account, so it has no rights to anything on
the domain
4. You have given a Domain Group, or list of Domain Users, rights to SQL
Server
5. As IUSR_ComputerName is not a domain user, or in any domain group (and
cannot be due to the security model), data access fails.

Possible solutions
1. For web apps: get rid of anonymous access to the app. This will force a
log on for all users using the app. Not a good situation for Internet, but
great for Intranet.
2. Impersonate a particular user for database access. You can change the
user context of the worker process thread ... for both windows and web
applications.
3. Switch to SQL security and change the connection string to use a SQL
account. If you do this, encrypt the connection string.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
Author: ADO.NET and XML: ASP.NET on the Edge

************************************************** **************************
****
Think Outside the Box!
************************************************** **************************
****
"Varkey" <va****@wipro.co.in> wrote in message
news:be**************************@posting.google.c om...
Dear all,

Can you please provide some information on the following issue, at the
earliest.

I have a development server setup in the network, say machine X. Also,
there is another workstation, say Y, for a programmer, to work with.
The application is a Winforms Application and machine X (server) does
not have Visual Studio .NET installed on it. Machine Y(workstation)
has got Visual Studio .NET installed on it. Y is connected via
sourcesafe to the solution in X, without making a local copy( I mean
through a network share).

There are issues faced by the programmer, in executing the application
in X, via Studio environment in Y. Basically application is not doing
any database related activities, and throws exceptions and breaks at
will.

Will this kind of a scenario ever work??? If not, please detail a
suitable alternative.

Two constraints are
a> No direct access to the Server X is possible for development.
b> Things need to be stage managed from the workstation Y.

Please respond at the earliest.

Regards..
Varkey

Jul 19 '05 #3

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

Similar topics

0
by: Robert | last post by:
I get these errors when creating a asp .net web application project in VS 2003 on a remote web server: "Microsoft Development Environment The Web was created successfully, but an error occurred...
0
by: lucfax | last post by:
This is the situation: - Server windows 2003 (not in domain but only workgroup), with remote debugging component installed on it - Development PC Windows XP Professional in a domain XYZ with VS...
2
by: Mahir Karabacak | last post by:
Hi all, I need to write an server application which will work Windows Remote Desktop Server (may be Terminal server). But the difference, insted of sending whole windows desktop messages to...
2
by: Jon L. Lovesky | last post by:
Hello all, I am attempting to access a remote folder from an asp.net application (all within the same domain). The application is configured for windows authentication in IIS and the asp.net...
4
by: TC | last post by:
Hello All, I apology for posting to many groups but I wasn't sure which group would be best targeted with my question. I have inherited an ASP.Net application that requires some maintenance &...
2
by: felecha | last post by:
I'm stumped. I'm working on an application in VB.Net that uses System.Messaging.MessageQueue to listen for messages sent to a private queue on a remote machine. Both machines are in the same...
0
by: Michael Höhne | last post by:
Hi, we're developing some web services and use the local development server of Visual Studio 2005 to create, run and debug the project. The web service methods connect to a database hosted on a...
1
by: lauralucas | last post by:
Hello I'm using ASP.NET 1.1, Visual Studio 2003, IIS 5.1 and windows XP as development machine. I can work in this machine locally and create web apps that I can access via localhost. No problem...
7
by: | last post by:
I'm writing an ASP.NET app, using Visual Studio 2003. VS is running locally on my laptop, but the web app is running on a remote server. My laptop is not in the domain. I do have a domain account....
7
by: luker | last post by:
Hello Experts, I am writing an application for a device running windows xp embedded. I want to code on my developer pc and deploy the running executable to the embedded device. - The two boxes...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.