0
votes
1answer
860 views

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

Possible Duplicate: How to Deploy an ASP.NET Web API- and Browser-based Application to a Production Environment We have an ASP.NET Web API server that serves up a SQL Server data driven ...
0
votes
2answers
157 views

Scaling web application with SQL Server 2008 database

I have a database which has 90% of read only tables. 10% of the tables has writable data. We need to scale the ASP.NET application.We need to add more users who will not be writing to the database. We ...
0
votes
3answers
46 views

Unable to locate any server in SQL Server 2008

I am a newbie. I recently installed SQL Server 2008 on my server. When I try to login, it does not show me any server when in Browse (see below) What could be wrong? Please let me know.
0
votes
1answer
151 views

ASP.NET Application Connection String and SQL Server Security / Permissions

I am deploying an ASP.NET application and SQL Server (2008) database on a live (production) server. The physical server is running both SQL Server 2008 and IIS 7 - it is provided by a hosting company ...
0
votes
3answers
1k views

SQL Server 2008: Getting Login failed for user “Domain\User”. Failed to open the explicitly specified database [CLIENT: IP.ADD.RR.ESS]

This is a very similar issue to " SQL Server 2008 login problem with ASP.NET application: Failed to open the explicitly specified database " which unfortunately seems to have gone unsolved. My issue ...
1
vote
1answer
1k views

The package failed to load due to error 0xC0011008 Error Loading from XML

Environment: Windows Server 2008 SP2 Enterprise Edition 64-bit SQL Server 2008 SP3 Standard Edition 64-bit Previously had SQL Server 2005 Developer Edition 32-bit Integration Services. That has now ...
2
votes
1answer
93 views

Website & database hosted across multiple data centers

We recently had a major data center outage from our hosting provider. They lost a fibre connection, causing a 9 hours outage, where most of our customers could not connect. This has caused us to ...
0
votes
1answer
67 views

How do i grant my windows user access to a production database restored to my local machine?

So I am trying to migrate schema changes to my production system. To do this I want to first test the schema changes on a local backup of my production database, so I downloaded the latest backup ...
1
vote
1answer
471 views

Microsoft SQL 2008 R2 login failed for user 'sa' using aspnet_regsql

I've been working on this for the better part of the morning, and looked at various answers and such, but haven't found anything. I am trying to run aspnet_regsql from the command line (as part of a ...
0
votes
3answers
83 views

SQL Server 2008 Login Problem

I'm trying to install yet another forum on my local machine, and while I'm configuring the database connection I got this message Failed to connect: Login failed for user 'NT ...
1
vote
1answer
298 views

SQL Server 2008 has started becoming unavailable for connections at seemingly random intervals

This is happening on a server that has been in constant use for over a year, with SQL Server 2008 and the web applications all hosted on the same machine. This morning i had 100-or-so emails with ...
0
votes
2answers
103 views

Web Hosting Company that Allows custom SMTP servers, multi domains, .NET 4.0 and mixed hosting

I am in search of a new Hosting company. I currently use GoDaddy, but I've had enough with their service so i'm looking for a hosting company that can meet my criteria. Currently I have 10+ Websites ...
1
vote
2answers
571 views

Diagnosing poor performance on IIS / ASP.NET / MSSQL app

I'm trying to diagnose the cause of poor performance from a third-party web application we've deployed; the environment is: ASP.NET on IIS, Windows 2003 Server SQL Server 2008 on a separate Windows ...
0
votes
2answers
1k views

What is the optimal schedule for running DeleteExpiredSessions?

What is the optimal time between running DeleteExpiredSessions. I've just inherited a database for a 3M monthly unique session web app and the DeleteExpiredSessions runs every minute. This seems like ...
3
votes
2answers
112 views

Is hosting my websites and databases with different providers a bad idea?

I'm trying to find a home for three ASP.NET 3.5 websites using three respective SQL Server 2008 databases. I've found one possible solution where I host the websites on a "semi-dedicated" environment ...
2
votes
5answers
114 views

Developed against MSSQL 2005 - host only has MSSQL 2008

Hey, I've been developing my ASP.NET application against SQL Server 2005. The web host I intend to go with only supports SQL Server 2008. Will there be any changes I have to make in my database so ...
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 ...