0
votes
1answer
38 views

Website can not connect to ODBC (no rights?) “Error: 80004005”

Background I am trying to migrate a website using MSSQL from MS Windows Server 2003 to a Server running MS WS 2008. It's been a while since I tried the last time (because I gave up on this problem) ...
0
votes
0answers
50 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 ...
1
vote
1answer
53 views

Issues connecting to SQL Server

I'm trying to boot up a sitecore application. Got the source code, set up my local IIS, but for some reason I'm getting the following error: A network-related or instance-specific error occurred ...
1
vote
0answers
360 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 ...
0
votes
2answers
155 views

IIS Express, SQL Express as production server

Can Microsoft's IIS Express and SQL Express servers be implemented for a small web application in production environment? What is the limitation of them?
1
vote
2answers
249 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
96 views

Are there any benefits to having IIS and SQL Server running on separate processors on the same server?

I have an ASP.NET 4.5 web app running in IIS 7 and connecting to SQL Server 2008 R2 on the same machine. The database is very read intensive with the occasional heavy write burst. Currently we have a ...
0
votes
1answer
742 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
1answer
497 views

Server 2008R2 in Extra Small Windows Azure Instance?

Windows Azure hosting for an Extra Small (XS) Windows VM seems to come out to be about $10 a month right now. I think this XS instance gives you the equivalent of a 1 GHZ CPU with 768MB of RAM. I ...
4
votes
2answers
187 views

Opinion about server slowness?

We have 2 servers for IIS with Load Balancer and 2 clustered MS SQL servers. Each servers has aprrox. 262GB RAM, 64 core processor(not all physical cores), etc. I mean servers are really powerful. The ...
0
votes
2answers
2k views

Install PHP MSSQL Driver on Windows 2008 64bit IIS 7 - Unable to load dynamic library

maybe somebody is able to help with the following problem: I have to install PHP 5.2 on Windows 2008 IIS with MSSQL Support but I'm unable to get MSSQL to work. Current situation Windows 2008 ...
3
votes
2answers
3k views

Too Many winlogon.exe LogonUI.exe csrss.exe open on server?

I just had to restart my content server because it bogged out. Everything was fine after i restarted IIS and SQL Server, but then i opened the task manager and found the following. I've never seen ...
0
votes
3answers
91 views

setting up a windows a development server

At my last company we had a development server where the developers could create websites/tools, upload to the development server and when setting up the host header in IIS would use ...
14
votes
7answers
2k views

When is the right time to introduce high availability for web site?

When is the right time to introduce high availability for web site? There are many articles on High Availability options. It’s not that obvious however WHEN is the right time to switch from single ...
0
votes
1answer
53 views

pull sql query execution location from either the sql server or IIS

I am working on restructuring the database for a project that has hundreds of classic asp pages. I need to be able to find out which pages are executing which queries so that I can analyze the data. I ...
1
vote
3answers
820 views

SQL connection is too slow

We have a business web application in ASP.NET + SQL Server 2008. In the beginning, SQL Server and IIS were on the same machine. Now we bought another machine. Current configuration is IIS machine ...
0
votes
3answers
365 views

setup database to use with MS SQL Server 2008 and IIS7 on own server

I have my own virtual server and I am looking to deploy a website to it. The problem I am having is setting up the database. Normally on a hosted site I just upload the mdf file and I get a ...
1
vote
2answers
2k views

WCF application Deploying in IIS, but SQL Server Database Connection is not working [closed]

I am new with WCF, I am trying to deploy my WCF sample application on IIS, This application works fine in debug mode with VS2008, This application authenticate the wcf messges with following code. I ...
3
votes
3answers
241 views

What daily checklist items are there for coldfusion, iis7, sql server administrators?

That is going to be part of a site app tool i am creating that has many different functions. But my question today, is for sql, iis, coldfusion administrators, what kind of daily checklists, do you ...
1
vote
3answers
170 views

I am about to create a site bible aka documentation of our web server?

I am creating this in ms word, to create a 3-ring binder with tabs, full of documentation of everything about our web server. What are the main categories that I should include? We have 2 servers, ...
1
vote
4answers
393 views

Cant Connect to Local SQL Server 2000 instance in code (but no problem with SQL Management studio)

I have just moved from Vista to Windows 7 with my development environment and ALL OF A SUDDEN my web app cannot connect to the local SQL Server instance [DBNETLIB][ConnectionOpen (Connect()).]SQL ...
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 ...
0
votes
2answers
741 views

IIS 7 much slower than IIS 6

I have a asp.net 3.5 web application running fine on Windows2003 IIS6. I published same exact application to IIS7.5 (Win2008R2) on a faster box (i5,8Gram) and it is significantly slower. 5-6 sec per ...
1
vote
1answer
667 views

“NT AUTHORITY\ANONYMOUS LOGON” error in Windows 7 (ASP.NET & Web Service)

I have an asp.net web app which works fine in Windows XP machine in a domain. I am porting it to a Windows 7 stand alone machine. The app uses a web service which makes a call to sql server. The web ...
3
votes
1answer
1k views

Reporting Services 2008 configuration for basic authentication using username and password

I want to configure Reporting Services 2008 to use a custom defined username and password for access. I read that I must set reporting services to do basic authentication : ...
2
votes
3answers
5k views

Error configuring SQL Reporting Services 2005 on Windows 7

I've installed SQL Server 2005 with Reporting Services on Windows 7 Ultimate x64 and when I try to configure it when clicking on "Windows Service Identity" I get this error message: There was an ...
1
vote
2answers
358 views

Advise about performance for local or remote SQL Server?

I currently have my web server and SQL Express / MySQL server on the same server. It is on a VPS. I have been having problems with my hosting so I am thinking of separating the web and db server into ...
1
vote
1answer
162 views

Remote login to SQL Server Express 2008

I am trying to remotely access MS SQL Server Express 2008. I have turned on service "SQL Server Browser" I have turned on service "SQL Server (SQLExpress)" I have enabled TCP/IP and set dynamic ...
0
votes
1answer
937 views

Ideal redundancy configuration for 3 physical servers running IIS and SQL Server

I'm looking to set up as redundant an architecture as possible to serve a data-centric web application with only 3 servers (only 5U of rack space). Between these two setups, which would be most ideal, ...
1
vote
2answers
4k views

IIS7, SQL Server 2008 & connection strings/authentication

OK folks, My company hosts quite a few websites. These websites all require a connection to SQL Server 2008. When we deploy a site to a new server, we constantly have to modify the web.config to ...
3
votes
2answers
1k views

Setting Up Login for ASP.NET Application on SQL Server 2008

I have 2 Windows 2008 Servers. One is a web server (IIS7). The other is a database server (SQL Server 2008). The instance of sql server 2008 is configured to use mixed mode authentication. Neither are ...
2
votes
1answer
78 views

Categorize sites in IIS manager

We're hosting >100 websites on a single IIS7 server, and adding about a dozen monthly. The problem is using the IIS manager - it displays all of the sites under the "Sites" node. The list is very long ...
1
vote
4answers
255 views

Long HTTP Get and Instant Response

We have an ASP.Net 3.5 Application on IIS7. On our preview server, it runs with almost instant gets and responses (~1 second from get to the page displaying). We have a production environment with 5 ...