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 : / / technet.microsoft.com/en-us/library/cc786585(WS.10).aspx 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?
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 .
[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.
I found this h t t p : / / w w w . mydigitallife.info/2007/10/31/error-has-occurred-while-establishing-a-connection-to-sql-server-2005-which-does-not-allow-local-and-remote-connections/ but it is for Microsoft SQL Server 2005 so I don't have any SQL Server Surface Area Configuration in Configuration Tools.
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.