471 reputation
17
bio website
location
age
visits member for 1 year, 5 months
seen Jul 7 at 20:57

Mar
5
comment Trusted Connection to SQL fails after connecting to a VPN
I assume the app pool users can still connect when you're VPN'd in, it is only you with SQL Server that can't access the DB while VPN'd in? Does running SSMS with /netonly work?
Mar
5
comment to overwrite a table or update it?
The consensus seems to be choose TRUNCATE over DROP: stackoverflow.com/questions/9103037/…
Mar
5
comment to overwrite a table or update it?
I just want to point out that your third option is functionally different than the first two. Consider the case when the new table has less rows than the one you are overwriting. In the 3rd case the old rows would still be there.
Feb
28
answered Trusted Connection to SQL fails after connecting to a VPN
Feb
23
answered Amazon Web Services viable for OpenGL driven app?
Feb
22
answered RUNAS Error (Windows 7)
Feb
20
answered Amazon EC2 - Change SQL Server from Standard to Web
Feb
19
answered Perfmon counters for monitoring general IIS/MSSQL server activity
Feb
19
comment Getting “error: 26 - Error Locating Server/Instance Specified” all of a sudden
In Sql Server Configuration Manager, you are absolutely sure SQL Server (SQLEXPRESS) is running on both machines? Perhaps stop it and restart it on the problematic machine to rule out any weird issues that may have happened on the last startup. What is the "Log On As" user listed in SQL Server Configuration Manager (usually it is NETWORKSERVICE), and in Management Studio, are you using SQL authentication or Windows Authentication? Could any passwords have recently changed?
Feb
18
answered Configuring ISS and SQLSERVER for ASP.NET MVC application and windows authentication
Feb
14
awarded  Informed
Feb
14
awarded  Supporter
Feb
14
revised if I select more than 15 fields, I get catastrophic failure
deleted 111 characters in body
Feb
14
awarded  Teacher
Feb
14
awarded  Mortarboard
Feb
14
awarded  Editor
Feb
14
revised if I select more than 15 fields, I get catastrophic failure
deleted 6 characters in body
Feb
14
answered if I select more than 15 fields, I get catastrophic failure
Feb
13
comment win2008r2: Delete corrupted directory without reboot
The original problem hasn't recurred yet, however I just tried to move a directory on a Win7 machine, and couldn't because it was locked. I just used handle for the first time to tell me what process was the culprit. Worked wonderfully!
Feb
11
comment win2008r2: Delete corrupted directory without reboot
I used the term "corrupted" because I thought when there is an open handle it should give you "permission denied" or an "in use by process" type message and it shouldn't attempt the delete at all? The directory would still be browsable after that happens. In my case it thinks it succeeded with the delete. If there is an open handle, I would think that is a bug that Windows still tried and got as far as it did. Anyway, thanks for the link, when it happens again I will try using Handle and update this post.