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?
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?
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.
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?
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.
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.
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
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.
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.
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.
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.
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."
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?
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)"
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?
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?
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.