0
votes
1answer
31 views

Moving a MSSQL and IIS server to AWS - Web Applications that use Integrated Authentication

I have been tasked with migrating a solution that contains a few WCF services and a ASP.Net v4.0 website from individual MSSQL and IIS servers to the Amazon Web Services infrastructure. Whilst I have ...
0
votes
0answers
1k views

Error connecting to MS SQL from one server but not the other

We got a MS SQL server and two web site servers. I'm in the process of moving all the sites from one of the web site servers to the new one. My asp.net sites are not able to connect to the external ...
0
votes
0answers
89 views

IIS7.5 Not connecting to MS SQL Server 2008 with PHP5.2.9 via php_mssql driver

Ok this is going to be somewhat involved. I have three servers: First I have a box running Linux with Apache and PHP 5.2.17. We shall call this "LB" for Linux Box. Second I have a Server Running ...
0
votes
1answer
497 views

How to get php_mssql.dll working properly on IIS 7.5 and PHP version 5.2.17?

First of all I'll give a very brief introduction of what I'm trying to make. I need the mssql php functions to work on the webserver. I know that such functions were deprecated in PHP 5.3 and above. ...
0
votes
0answers
97 views

IIS Hang after moving to locally hosted SQL Server Session States

We have an in-house IIS7 server hosting our various Intranet applications (All coded in .net 2). Its quite a busy server; around 400 users logged in at any given point with peaks of 600+ sessions at ...
0
votes
1answer
135 views

How can I view the SQL Server database created by an ASP.NET MVC web application?

I have an ASP.NET MVC web application deployed to IIS on a Windows Server 2012 machine. When the application first starts, it will create the database and tables it needs if necessary. This all ...
2
votes
3answers
157 views

Is it okay to put applications on an Active Directory secondary server? What pitfalls?

I have a fixed number of VMs in my Windows/IIS website setup, which I cannot change in the short term: a web server, which is badly overloaded from a memory and cpu load standpoint (IIS6, Server ...
1
vote
0answers
94 views

SSRS reachable by FQDN on local computer, but not from a different computer

I am having trouble getting my SSRS server to successfully cohabitate with IIS, after having to move the server to a different subnet. I have 2 static IPs for that server: .242 is defined explicitly ...
2
votes
2answers
135 views

Latency between IIS and SQL on same physical, two VMs

I have a single server (2x4 core CPUs, 32GB ram), that is a Windows Server 2012 Hyper V host, and it hosts two guest VMs (also Windows Server 2012 instances). One of them is a web server, the other is ...
1
vote
0answers
532 views

Configuring IIS application pool to access SQL Filestream with ApplicationPoolIdentity

I have an IIS 7.5 server with a number of applications in a single Application Pool. Some of these applications access a SQL Server 2008 R2 Filestream on a remote machine, on the same domain. The ...
1
vote
4answers
447 views

TCPing reports 20ms latency between Web Farm and DB

We have a IIS web farm sitting in a DMZ connecting to a MSSQL DB(Windows Cluster). After troubleshooting some performance problems we stumbled upon strange network behavior. We wanted to test network ...
1
vote
2answers
117 views

2012 domain functional level with 2008 r2 web server

We are in the process of setting up a brand new domain and associated services (exchange, etc), on a new VMware environment. We want use Windows 2012 however the web-based ERP application requires ...
0
votes
2answers
511 views

Perfmon counters for monitoring general IIS/MSSQL server activity

I have a virtual server with a hosting company so CPU and RAM are limited. I need to watch load/performance over time to know when to upgrade the server. The site runs multiple ASP.NET apps as well ...
1
vote
1answer
2k views

installing PHP for IIS8 on a windows server 2012 machine?

We are running a web server IIS8 on a windows server 2012 machine. I need to install PHP on it. I found a nice tutorial here: ...
0
votes
1answer
121 views

Deploying .vbhtml on Local IIS Installation

I've come into a company that has been using asp.net for some web applications stored on our local servers. There's no current programmer, so I've used what knowledge I have to build a new feature ...
1
vote
1answer
147 views

Forms authentication failed between web server and sql server

I've actually found the solution, but I'm trying to understand why it failed, and why my solution fixed the problem. We have an application that uses forms authentication between a web server and ...
1
vote
2answers
344 views

Adding anonymous IURS IIS user fails into SQL SERVER 2008 R2

I am trying to add a anonymous IIS user [IUSR] to a SQL SERVER 2008 r2 database. But I am getting the following error: 'notebook/iusr' is not a valid login or you do not have permission. I think ...
1
vote
1answer
114 views

IIS listening to all ip on specific port

I'm running both IIS and Apache. I have Apache set to 127.0.0.2 and IIS to 127.0.0.1 so that I can have them both on port 80. In order to do this, i had to go into netsh and make it so IIS only ...
1
vote
0answers
351 views

ASP.NET + MVC 4 + IIS 7 + MSSQL slow response

I have recently deployed an ASP.NET MVC4 application to a IIS 7 server, but something is not quite right. I have a log-in action that access the user credentials stored in a MSSQL 2008 R2 server, and ...
0
votes
1answer
163 views

EC2 + RDS, or just a bigger EC2? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Web Sites I need to develop a system that connect to multiples outter systems to get XML data and reply with ...
2
votes
1answer
807 views

How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment [closed]

(Please forgive if this is posted in an incorrect forum. We didn’t know exactly where to post it.) We have an ASP.NET Web API single page application - a browser-based app running in IIS to serve up ...
0
votes
1answer
59 views

Is it safe/wise to run Drupal alongside bespoke business web apps in production? [closed]

I'm interested to know the general community feeling about the safety of running Drupal alongside bespoke, business critial ASP.NET MVC apps on a production server. Previously my employer's Drupal ...
0
votes
1answer
228 views

Troubleshoot IIS 6 and Intermittent SQL Server Connectivity Loss

I am not a System Administrator, but I am temporarily trying to fill that role. I have 2 Windows 2003 Servers. 1 server has my Microsoft SQL Database (SQL Server 2005) and the other is the web ...
0
votes
1answer
354 views

Strange 400 error with IIS 7.5 and a webservice?

Ok, this is a longshot. I have been pondering this for hours. I have no clue how to solve this. But maybe someone here can recognize the problem and point me to right direction. I have an IIS 7.5 ...
3
votes
6answers
16k views

SQL - an error occurred during the pre-login handshake

Until yesterday evening, I was able to connect to my server from my local machine. Now, I get the following error: A connection was successfully established with the server, but then an error ...
0
votes
1answer
877 views

where can I find the user in this IIS error 'Login failed for user 'IIS APPOOL\Web2'

I encounter the following error: Cannot open database "testbase" requested by the login. The login failed. Login failed for user 'IIS APPPOOL\Web2'. Description: An unhandled exception occurred ...
0
votes
2answers
310 views

Why is SQL Server limiting speed to/from one database from IIS

I am having troubles with SQL server (or IIS, but I am pretty sure its SQL) I have posted before with a more vague question, however its still happening and I have some more detailed information. ...
2
votes
2answers
1k views

Windows authentication to SQL Server via IIS and PHP

We're running a PHP 5.4 application on Server 2008 R2. We would like to connect to a SQL Server 2008 database, on a separate server, using Windows authentication (must be Windows authentication--the ...
0
votes
1answer
73 views

Can Reporting Services 2008 be installed on an existing web farm?

I have a question regarding whether Reporting Services can be installed on an existing web farm, at least the front end portion. The situation is that we have a limited number of servers available to ...
2
votes
1answer
279 views

Building fault tolerant IIS/MSSQL stacks (Sql Clustering?)

We had a raid failure yesterday on a server that was hosting databases and IIS. We're trying to determine the best way forward in terms of our IIS and MSSQL hosting environment. We'd like redundancy ...
3
votes
2answers
574 views

Authentication between IIS & SQL Server for Load Balanced App

I'm looking to use this connection string however I'm not sure how to set this up: Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase; Trusted_Connection=yes; Previously our SQLNCLI10 ...
0
votes
1answer
262 views

IIS Session Sharing between Two IIS Instances

For testing purposes, I have 2 sites on the same IIS server that I want the session state to be shared between. The sites are identical (they point to the same folder) and originally they used the ...
0
votes
1answer
74 views

Basic Windows networking questions

Basically I got started looking into this because I got tired of just selecting stuff like NETWORKSERVICE just to make things magically work across our network, and wanted to learn more about what is ...
1
vote
1answer
116 views

Load balancing for Web and Database Servers

I'm trying to get a greater understanding around load balancing for Windows IIS Web servers and MSSQL database servers. In our environment I have 2x IIS web servers and 2x MSSQL database servers. I ...
0
votes
2answers
739 views

loadBalancing/clustering on IIS/ASP.Net/SQL Server

I've to create an offer for a future ASP.NET application. They wants an high availability(99.9%+). So I'm searching the best solutions with .Net technologies(asp.net mvc 3, IIS 7, SQL Server 2008 R2) ...
3
votes
4answers
244 views

Implications of having IIS on SQL Server 2008 R2 machine

an application needs to have IIS on the same box of Reporting Services. Today SSRS and SQL stay on the same clustered box. I need to evaluate the options which for me are: Installing IIS on both ...
0
votes
2answers
732 views

How to setup Database Permissions on SqlServer Express 2008

I'm using a code-first approach of using the Entity Framework. When I first run the application it will try to create the database matching my MVC models. However, it doesn't have permission to ...
0
votes
2answers
229 views

SQL server 2008 R2 with IIS on same machine and mirroring

I want to install SQL server 2008 R2 and IIS on same server with a mirroring configuration with principal/mirror/witness setup. Both principal and mirror servers will have IIS and SQL server. My ...
1
vote
2answers
199 views

Monitor SQL transactions in ColdFusion Administrator?

Using CF9, IIS, and MSSQL, is there a way to monitor SQL commands sent by a script? Something that shows the raw query, preferrably. I got this idea after seeing that WEBrick and Ruby on Rails ...
6
votes
2answers
2k views

Is there a secure way to allow IIS 7 in a DMZ to access a DB server behind the firewall?

Our network admins are adamant that it is insecure for our web servers, which are hosted in the DMZ, to access the DB server behind our firewall. To get round the problem, we access the data via web ...
0
votes
2answers
83 views

Advice needed on system requirements

I want to set up some tools inhouse but just unsure of a few things. I want to build websites (e.g. a wiki) that can be used internally by staff (there are approximately 300 staff members). What ...
3
votes
1answer
92 views

Virtualization versus simple consolidation of a web infrastructure

After talking to a friend who works for a virtualization firm, I started to think whether it could be of benefit to my small company. Right now we have our IIS web server on one server, and our SQL ...
0
votes
0answers
354 views

IIS ASP Configuration - Old ASP

We are using IIS 7.0. I have created a website, and set the permissions for share. I am able to read a text file remotely through IE using our URL to the website. However, I am not able to connect to ...
0
votes
1answer
258 views

Tool to monitor bandwidth between IIS and SQL Server

I'm looking for a way to track the data traffic between IIS (ASP.NET website) and SQL Server, both running on a local developer box (Windows 7). This is so we can improve the bandwidth usage of ...
1
vote
2answers
105 views

how to scale a web application - common patterns

consider iis and mssql on one hand and apache and mysql on another. is it the same tactic when scaling iis and apache? i got the basic scaling thing - separate web tier and db tier, and then db ...
2
votes
1answer
113 views

sql server windows authentication with IIS

Here is the situation: Where I work (small division of large company), we have a single on site big company owned server running SQL Server. We only have access to this server through windows ...
1
vote
3answers
959 views

High CPU Usage (95-99%) for mssql on the server

our server is running win2003 with mssql 2005 on the same box with 2GB ram. the website itself is based on dnn 4. We are seeing these high cpu usage spikes (mssql) of 95-99% even with no ...
2
votes
3answers
547 views

Windows Server 2008 R2 running at a snail's pace

Really weird problem here. Our main web server has started running at a snail's pace, for absolutely no reason we can discern. Even after restarting the machine, when there's no little or no ram usage ...
0
votes
1answer
180 views

MSSQL, ASP.NET, IIS. SQL Server perfmon log question

I'm testing a web application that runs on a hypervisor. The database server and the webserver are seperate vm's that run on the same hypervisor. We did some tests and the functions perform ok. I want ...
1
vote
1answer
142 views

configure the reporting services and/or IIS to give access permission

how to configure the reporting services and/or IIS to give access permission: Reporting Services