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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
May 17, 2010
Is SQL Server Express supported in Windows 7 Starter edition?
View 3 Replies
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
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
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
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
