Results 1 to 7 of 7
  1. #1

    application pool on Apache


    I've got web application to be installed on the server. The server contains MySQL & Apache. Unfortunately web application was created for MSSQL 2005 and IIS 6.0 or 7.0. (By the way. I've got Windows XP Prof on server but I'd like to ask because of my curiosity - is it possible to run MSSQL applications on Linux servers?). I tried to run MSSQL on MySQL - without success (Console Terminal, MS Query Browser, DBConvert). I decided to install MSSQL Server 2008 in order to run .sql script files which are responsible for creating new database.

    But my question is somehow different. The other thing required for installation is to "create application pool". I found h t t p : / / but it is about configuring it for IIS. My question is - how to do it for Apache?

    And about MSSQL. I just installed it. I open "All Programs" -> "Microsoft SQL Server 2008" -> "Configuration Tools" ("Create on the server Internet Information Serveces 6.0/7.0 web application. Assign application pool to the application, it is recommended for the application to have its own, separated application pool") -> and I see three things "SQL Server Configuration Manager", "SQL Server Error and Usage Reporting", "SQL Server Installation Center". Where can I run sql script?


  2. #2
    Join Date
    Dec 2007
    Indiana, USA
    To run MSSQL and MSSQL databases you're going to need to use a Windows Server/Windows Hosting.

    Generally if the application is designed for IIS/MSSQL then you're not going to be able to port it to Linux as-is.
    Michael Denney - MDDHosting LLC
    New shared plans for 2016! Check them out!
    Highly Available Shared, Premium, Reseller, and VPS

  3. #3
    Thanks for your reply!

    I installed Microsoft SQL Server 2008 and run in Command Prompt:

    C:\Documents and Settings\useruser>osql -Usa -Ppassword -i "F:\Data\MyApplication\Scripts\CreateDb.sql"
    [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].
    [SQL Server Native Client 10.0]Login timeout expired
    [SQL Server Native Client 10.0]A network-related or instance-specific error has occured while establishing a connection to SQL Server. Server is not found of not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.

    And more important question is how to create application pool in Apache instead of IIS? I couldn't google it.


  4. #4
    I found this h t t p : / / w w w . but it is for Microsoft SQL Server 2005 so I don't have any SQL Server Surface Area Configuration in Configuration Tools.

  5. #5
    Quote Originally Posted by johnyjj2 View Post
    And more important question is how to create application pool in Apache instead of IIS? I couldn't google it.
    Quite simply; you don't There is no Apache alternative for application pooling, strictly speaking.

  6. #6
    Thanks! Do you know what I should do to execute this sql file and get rid of those errors? The link which I gave is for Server 2005, I've got Server 2008 and because of this thing I cannot follow first step in that instruction.

  7. #7
    you can execute the sql file from management studio directly

Similar Threads

  1. Replies: 6
    Last Post: 08-18-2006, 12:23 AM
  2. Win2003 Application Pool Creation
    By div1 in forum Hosting Security and Technology
    Replies: 0
    Last Post: 01-25-2005, 07:59 PM
  3. dedicated or shared application pool
    By kellyboyce in forum Hosting Security and Technology
    Replies: 1
    Last Post: 12-15-2004, 06:12 AM
  4. win2k3 application pool monitoring
    By dg_ak in forum Programming Discussion
    Replies: 2
    Last Post: 12-14-2004, 10:25 AM
  5. Application Pool
    By MarcoJaneczek in forum Dedicated Server
    Replies: 1
    Last Post: 12-14-2004, 09:02 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts