DataSource Controls :: How To Configure To Allow Windows Services Running On The Web Server To Access Sql Server

Jan 14, 2010

We have a cient we are stting up that has 2 separate physical servers, one that is the web server the other the database server. Using impersonation we have been able to get the website to connect and retrieve data from the sql server so that part is not an issue. The problem is I have a windows service application that must be installed on the web server (as it process files downloaded to an ftp site) and it must be able to connect and write to the sql server as well.We tried adding a system.web block with the impersonation stuff to the app.config file which of course did not work. Can anyone tell me what/how we need to configure this properly?

View 7 Replies


Similar Messages:

Web Forms :: How To Find All The Web Services And Windows Services Running On A Server

Feb 4, 2011

How to Find All the Web Services and Windows Services Running on a Server in ASP.Net. I have the server details with me and want to find all the Web services running on it.

View 1 Replies

Migrate Application Running In Windows 2000 Server To Windows Server 2008?

Mar 10, 2010

Currently we are running an application build in VB6,ASP,Commerce Server2000 and Sql Server 2000. This application is running in Windows 2000 server.Now we are planning to migrate Windows server 2000 to Windows 2008.Will this application run in Windows 2008 or do we need to upgrade this application to dotnet and Sql 2008?

View 1 Replies

WCF / ASMX :: How To Access A Wcf Service Hosted On A Server Running On A Virtual Machine On A Windows 2008 R2 Hyperv

Jul 14, 2010

I am trying to access a wcf service hosted on a server running on a virtual machine on a windows 2008 R2 hyperv. When i access this service when running my asp.net website through code everything works fine how ever when i deploy the application on the local IIS , in the deployed mode i am getting an securityaccessdeined exception. My Asp.net app is running on a IIS server on another virtual machine. The stack trace is as given below :

Environment Info: My asp.net app has built on .NET 4.0 framework using VS2010. My WCF services are based on .NET2.0 framework.
Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 14-07-2010 13:56:54

Event time (UTC): 14-07-2010 08:26:54

Event ID: dd1986e7e7dc4473beb908754c75a580

Event sequence: 4

Event occurrence: 1

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/1/ROOT/StratosTest-1-129235696025728041

Trust level: Full

Application Virtual Path: /StratosTest

Application Path: C:inetpubwwwrootStratosTest

Machine name: MC-NEWCODE

Process information:

Process ID: 1752

Process name: w3wp.exe

Account name: IIS APPPOOLASP.NET v4.0 Classic

Exception information:

Exception type: SecurityAccessDeniedException

Exception message: Access is denied.

Server stack trace:

at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)

at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)

at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)

at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)

at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:

at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

at VMMService.IVirtualMachineManagementService.GetAllVirtualMachines()

at Default2.Page_Load(Object sender, EventArgs e)

at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Request information:

Request URL: http://localhost/StratosTest/Dashboard.aspx

Request path: /StratosTest/Dashboard.aspx

User host address: ::1

User:

Is authenticated: False

Authentication Type:

Thread account name: IIS APPPOOLASP.NET v4.0 Classic

Thread information:

Thread ID: 4

Thread account name: IIS APPPOOLASP.NET v4.0 Classic

Is impersonating: False

Stack trace: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)

at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)

at VMMService.IVirtualMachineManagementService.GetAllVirtualMachines()

at Default2.Page_Load(Object sender, EventArgs e)

at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

at System.Web.UI.Control.LoadRecursive()

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Custom event details:

View 1 Replies

Configuration :: Doesn't Work When Published To Virtual Server Running Windows Server 2008 R2?

Feb 26, 2011

Does anyone know of any requirements to get the Ajax Control Toolkit (Calendar Extension in particular) working in this OS? I have it working on my local macjine (VS 2010 Development Server) but it doesn't work when published to my Virtual Server running Windows Server 2008 R2. No errors are reported, just nothing happens when I give focus to the Calendar textbox (no Calendar appears).Anyone know of any configutrations that need to be made in Windows Server 2008 R2?Is there a 32-bit/64-bit issue with the Toolkit?

View 8 Replies

C# - Connecting To A Linux Server Running Myql From A Windows .net Server, Ado.net?

Aug 19, 2010

Can I connect to a ubuntu server, that is running mysql using ado.net or do I need a special driver?

View 2 Replies

DataSource Controls :: SQL Server R2 On Windows 2003 Server Installation Error

May 17, 2010

i am trying to install SQL Server R2 on my windows 2003 server (I downloaded the x64 version) but on the installation directory, just before i click next, to get the error, the path is as follows: C:ProgramFiles(x86)Microsoft Sql Server im not too sure if thats the problem though, just guessing, since i dont know anyother problem, and its a new server. I also tried multiple server restarts and still got the same error.

View 6 Replies

Configuration :: Cannot Access Web Services In Web Configure

Oct 7, 2010

I have an AJAX web application.ASP pages are accessing various Web Services that are part of the application using standard Microsoft .NET AJAX extension APIs.Now, I have to call some of the web services from the Windows app.It works when I add web reference to a project on my local development machine.

View 1 Replies

Security :: Using Microsoft Windows Web Server 2008, How To Configure A Folder Under Inetpub To Be Able

Mar 9, 2010

I have a web app, can upload images when running it on the local development machine, but when runnign it on WebServer 2008, it gives me an error saying "access is denied". I konw it is something to do with security, but how do I make it such that an internet user can have acces to it. The folder is located in: c:inetpubsiteimages494

View 4 Replies

Running Windows Services Application In Framework 2.0?

Feb 8, 2010

1)My Windows services application folder is MyWInservice

2)Executable .exe i.e. “myServices .exe“ file located under MyWInservice \myServicesinDebug

3)I have RUN bat file
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727InstallUtil.exe /u "myServices.exe"
C:WINDOWSMicrosoft.NETFrameworkv2.0.50727InstallUtil.exe "myServices.exe"

4)After running InstallUtil, myServices.InstallLog and myServices.InstallStategenerated under .. binDebug folder.

5)Upon pressing F5, I still get the same error.
Error is:

Windows Service Start Failure,Cannot start service from the command line or a debugger. A Windows Service must first be installed (using installutil.exe) and then started with the ServerExplorer, Windows Services Administrative tool or the NET START command.

View 6 Replies

DataSource Controls :: Roles And Views In The Application Services Database For SQL Server

Jun 13, 2010

I want set roles and views to my dataBase.

this three roles: FullAccess - BasicAccess - ReportingAccess

I don't know how I can set this three to my database for users access.(webapplication)

I'm using sqlserver 2008 and visual studio 2008.

View 1 Replies

DataSource Controls :: Running Sql Server Management Studio?

Aug 11, 2010

I am having a problem connecting to my SQL Server 2008 Express database with SQL Management Studio Express and from the website at the same time.

Everytime I want to view any pages in my site that access the database, I have to close management studio and restart the server for some reason or i get a failed login error message. Then when I want to go back to SSMS I get this error message:

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

Additional Information: Unable to open the physical file c:..... Operating system error 32: "32(The process cannot access the file because it is being used by another process.)" (Microsoft SQL Server, Error: 5120)

Is it NOT possible to work on the database through SSMS at the same time as viewing pages in the website that access the database?

I sure hope that there is a work around or something for this.

Just in case my connection string is:

<add name="ApplicationServices" connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />

View 5 Replies

DataSource Controls :: SQL Server Express 2008 Not Running?

May 6, 2010

After reimaging my hard drive, I reinstalled SQL Server Express 2008, this time using the Windows Platform Installer for the first time. Tried running websites within VS2008 and VS2010 and can't connect to database. Tried to turn on using Sql Server Config Manager. Won't turn on. Also tried to connect via Sql Server Management Studio 2008, but got this error:

A network-related or instance specific error occured....the server was not found or was not accessable.

View 3 Replies

SQL Server Reporting Services Not Able To Install On Windows Vista Home Premium

Aug 26, 2010

Recently I had a weird problem while trying to install SQL Server Reporting Service in my local PC. I am using Windows Vista Home Premium and I wanted to configure SSRS in my PC. During the installation, the setup wizard listed all the services that we want to install and I found that only Reporting Server checkbox option was disabled and I wondered why??? I thought it may be becuase of some installation problem and tried again and its useless... I googled lot of sites for 3 days and finally found that due to some IIS issues, it is not possible to install Reporting Server in Vista Home Premium version. Reporting Server needs some specific IIS features to be installed in the machine.

But unfortunately those features are not available for Home Premium users which in term restricts users not to install reporting server in our PCs... Also, Microsoft has accepted it as an issue and its not possible to get it install in Home Premium...just wanted to share and might be useful for someone like me.

Reference: http://support.microsoft.com/kb/920201/en-us

View 1 Replies

Running Asp Site On Windows Server 2003 And Accessing It Over LAN?

Sep 6, 2010

I want to run an ASP.Net application on Windows Server 2003 and access it over a LAN.
Like http://serverIP/sitename.com

How do I do this? What configuration changes should I make to IIS?

View 1 Replies

Installation :: Running A Web Application In Vs-2008 On Windows 2003 Server?

Jun 3, 2010

I am running a web application in vs-2008 on windows 2003 server.While execution of .net application, I am getting an error as"Unable to start debugging on the web server. Unable to connect to the web server. Verify that web server is running and that incoming HTTP requests are not blocked by firewall."

View 5 Replies

DataSource Controls :: EXECUTE Permission Error On SQL Server 2005 Stored Procedure When Running From The IIS?

Apr 10, 2010

sing VS 2008 at a workstation, I have successfully developed a local, file-system ASP.NET 3.5 website. The wbesite included a membership page with Windows authentication and a web parts page. The SQL Server 2005 ASPNETDB database has been created at an IIS web servr. Using the ASP.Net development server of the workstation, both the membership Membership/WebParts pages at the local website worked very well.

Then, I copied the website to a virtual directory at the IIS web server and creates a remote website for the workstation. Under theASP.NET development server of the workstation, both membership and webparts pages of the remote website at the IIS web server also worked fine.

However, when running these web pages from the IIS web server machine, something wrong happened with the web parts page. (The membership page still worked very well.) For the ASPNETDB database at the IIS web server machine, there is an EXECUTE permission error on an ASPNET stored procedure.

What are the differences between the ASP.NET development server and IIS web sever, which caused the EXECUTE permission error on the ASP.NET S.P.? How to find and fix the errors?

View 2 Replies

DataSource Controls :: Connecting To A Windows Authenticated Sql Server?

Apr 14, 2010

When i go to insert data into the sql server db i get an error when it tries to connect.

Heres the code

string sConnectionString = "Integrated Security=SSPI;Initial Catalog=;Data Source=localhost";
SqlConnection objConn = new SqlConnection(sConnectionString);
objConn.Open();

It is on an on button click event.

The area that shows up in the error message is

objConn.Open();

View 6 Replies

DataSource Controls :: SQL Server On Windows 7 Ultimate Edition?

Apr 4, 2010

After installing Sql Server 2005 Express edition and Sql Server 2005 Management studio Express on Windows 7 Ultimate Release Candidate, it work's fine but when I install Windows 7 Ultimate Edition....I got this error when creating or attaching new database "

"Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)"

View 2 Replies

DataSource Controls :: Windows 7 Sql Server Installation - Use Authentication Mode?

Mar 2, 2010

im using windows 7 home premium-64 bit,when i want to install sql server its not asking for mixed mode its directly creating windows authentication mode but i want to use sql server authentication mode,when im installing im unable to see any mode selection?

View 4 Replies

DataSource Controls :: SQL Server Express Supported In Windows 7 Starter?

May 17, 2010

Is SQL Server Express supported in Windows 7 Starter edition?

View 3 Replies

WCF / ASMX :: Access Denied And Null Returned While Accessing Web Services From Remote Server?

Sep 2, 2010

writing a web Service and one of its web method, I want it to download a png file in form

of buffer from remote server. And My consume application will write that buffer retured by Web service in to file on User's Computer.

However, I am able to do this using Local Web Service but when I published that service on my web server, I always get null retuned

And even in one of my test code while copying file from that server , I always get Access Denied.


Following things I have done for above issue.

1] I even tried making the Anonymous user for the web service the system administrator (with the correct password), to no avail.

2] I also tried sharing out the folder I'm pulling files from to allow access from Everyone.

[Previously same service was working fine on another remote server with IIS 7.0, we checked server IIS Settings but in vain.]

if you know where we are mistaken guide me to resolve this issue as its very urgent.

View 2 Replies

DataSource Controls :: Install Sql Server Express Using Windows Authentication Mode?

Mar 2, 2010

i have installed sql server express using windows authentication mode,but i have a doubt if we want to acces the data from front end we type like uid="",pwd="",servername="" but when using windows auth what credentials we have to give or there is no need of any details?

View 3 Replies

DataSource Controls :: Connecting Sql Server / To Read The Windows User Account  Name And Pass In The Connection

Apr 6, 2010

I would like to do a connection of asp.net page with Sql Server. Here I would like to read the Windows user account name and pass in the connection.The connection should be Windows authentication. IIS server and Sql server are installed in different machine. Here I am able to connect locally, When I am running from server, It takes windows account of Server.

so i can read local account(Where user is accessing the web application) and make windows authentication sql server connection.

View 3 Replies

DataSource Controls :: Cannot Access Sql Server 2008?

Jan 30, 2010

i could write a query and i could debug forms using both sql server 2008 and visual studio 2008,but i could not connect to the sql server 2008 and test could not be succeded

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved