0
votes
1answer
45 views

SQL Server with one ethernet output and Webserver with another ethernet output

Scenario: I have one server which is virtualizated using VMWare ESXi. Specs: Windows Server 2008 R2 SQL Server Standard 2012 IIS 7.5 Hosting a MVC and a Webform application (using Reporting ...
1
vote
1answer
291 views

Clear SPN changes from server cache

We have in house IIS apps built on ASP .Net 2.0 running on IIS 7.5- Server 2008 R2 x64. Back end is SQL 2005. It uses Kerberos (Windows integrated) authentication. Once in a while we need to change ...
1
vote
1answer
318 views

Security issues/risks connecting from IIS7.5 to SQL Server 2008+ using Machine Account (DOMAIN\MACHINENAME$)

I'm working with a group of engineers doing .NET 4 / MVC 3 development, using Windows 7 Enterprise and IIS 7.5 locally, and connecting to MSSQL 2008+ dev/testing databases. The databases are remote ...
1
vote
3answers
155 views

Windows Server 2008R2 Enterprise for Web Server. Any Benefits?

Hi I've looked at the comparison charts between editions of Windows Server 2008 R2 but I don't see a definitive answer to my question. We have licenses for Windows Server R2 Web as well as R2 ...
1
vote
2answers
773 views

Connection String for MS SQL Server 2008 using Windows Authentication

MS SQL Server and the web application are both on the same machine. In web.config, I have: connectionString=" Server=COMPUTER_NAME\MSSQLSERVER; Database=MyDatabase; Integrated ...
2
votes
1answer
290 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
619 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 ...
1
vote
1answer
248 views

WebSites can't access to Sql Server DBs while recycling Application pool

I have some websites hosted on IIS7.5 windows 2008 R2 sometimes I am notified that sites report an error on connection to DBs and can't connect to DB while sql server is running. Nothing changed on ...
5
votes
1answer
206 views

Specific site unable to connect to MSSQL server after reboot

I have a very annoying problem on my Windows 2008 R2 server. Each time it's restarted, either planned or unplanned, one specific site is not able to connect to the database server, a MSSQL Server 2008 ...
0
votes
1answer
802 views

Performance Issue Between SQL and IIS on Seperate Machines

First time OP on serverfault, but an avid user of stackoverflow. We have two high-specification boxes, both running Windows Server 2008 R2 Standard. On one we have IIS 7.5, the other SQL Server 2008 ...
0
votes
1answer
1k views

How to allow AppPoolService access to your SQL Server & database?

I have an IIS 7 server(2008 ) and ms sql server 2005 on the same machine. I want my application pool that was created to be able to access ms sql server 2005. How can I do this Set your app pool to ...
2
votes
6answers
4k views

Why am I getting this 500 error from IIS?

I'm running PHP 5.3.1 on IIS 7.5 on Windows 7 Ultimate x64. I've been trying to make PHP connect to my local installation of SQL Server 2008 Express over ODBC using ADODB. At first I had trouble ...