235 reputation
211
bio website
location
age
visits member for 3 years, 10 months
seen Oct 6 at 12:48

Aug
19
comment Multiple wildcard certificates on one IIS site?
Finding a CA that issues certificates with wildcards as SANs seems almost impossible. I'm thinking it'll be easier adding another IP address to the same binding and using a separate SSL certificate.
Dec
6
comment Does the disk space used by this database seem normal (MSSQL 2008)?
Autogrowth is currently set to 1MB, unrestricted. Good or bad?
Mar
9
comment How can I provide shared hosting on my Windows 2008 r2 box?
I would definitely advise you purchase a reseller hosting plan instead. Or if you want to learn to be able to administer a server yourself, please get a managed server.
Mar
4
comment IIS Identities: Application Pool vs Connect As in Basic Settings
I guess but for us the password won't be being changed. Now that it's entered into IIS, we won't be needing it in the future. If we create a new web site, we'll use a new user account to lock down access to the database. Thanks!
Mar
4
comment IIS Identities: Application Pool vs Connect As in Basic Settings
I'm pretty sure it will be the delegation issue, thanks. For simplicity I'll just leave the credentials under the Connect As dialogue box, unless there's any downsides?
Mar
4
comment IIS Identities: Application Pool vs Connect As in Basic Settings
Seems like this is related too: blogs.technet.com/b/askds/archive/2008/11/25/…
Mar
1
comment Authentication between IIS & SQL Server for Load Balanced App
Is there any way to set this up without having to type out a password in the config or the code itself (Classic ASP)?
Mar
1
comment Authentication between IIS & SQL Server for Load Balanced App
Should we create a separate user account on the domain to be used for each SQL database?
Mar
1
comment Authentication between IIS & SQL Server for Load Balanced App
This is preferred to using the account the Application Pool is running as?
Feb
14
comment High Availability with 3 servers: To virtualise or not?
Sorry maybe I was unclear. We already use mirroring (with a 3rd witness server) in synchronous mode with automatic failover.
Feb
14
comment High Availability with 3 servers: To virtualise or not?
Sounds like the solution we have now then is ideal. Would be better if we had redundant hardware load balancers but for cost reasons this isn't possible. Also better if we had a central store (perhaps using DFS) for storing the web files - right now we rely on a robocopy script to keep the 2nd server up to date.
Feb
14
comment High Availability with 3 servers: To virtualise or not?
Thanks TomTom. So in this case, virtualisation is no benefit? I know there is VMware Fault Tolerance?
Feb
14
comment High Availability with 3 servers: To virtualise or not?
@JakeRobinson hosted with a managed provider at a datacenter
Feb
14
comment High Availability with 3 servers: To virtualise or not?
In practice what do people do? Is it better to separate out the web/db servers rather than have them on one machine? I think so but budget constraints mean this is only possible if we virtualise.
May
3
comment How to: Hot Standby SQL Server in another datacenter?
Thanks for the answer, yes I meant once we failover can we accept writes. Looks like the answer is no. Would have no way of restoring a tail log backup as I'm assuming we failover because the whole datacenter is down and thus I could not take a backup. I guess then log shipping with DNS failover for traffic, leaving the DB in read-only mode...
May
3
comment How to: Hot Standby SQL Server in another datacenter?
Great to hear from you. We already use mirroring for auto failover for within the datacentre. So the only way I see being able to failover in the event of the DC being down is to direct traffic there with DNS. If it were a client app you could direct the DB connection to the secondary site if the primary is down. For us, the app is in the same location as the DB server, so we either run the primary or if down, the secondary. Seems the secondary would have to be read only and would have to rely on DNS failover. Unless you have any other ideas?
Apr
27
comment How to: Hot Standby SQL Server in another datacenter?
I understand these concerns, thanks. However this question is aimed at finding out how to do the database stuff.
Apr
9
comment MSSQL Mirroring Failover: Login failed for user
Just to add, this works.
Jan
2
comment Dual SMTP Server issue with Unicast Network Load Balancing
Thanks, this is what I ended up doing just before I saw your answer. In the app code, I check if the email is bound to us, if so connect via the private IP to the primary server, otherwise send the mail via its own SMTP server.