Reputation
596
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
2 10
Newest
 Caucus
Impact
~15k people reached

  • 0 posts edited
  • 0 helpful flags
  • 11 votes cast
Apr
8
comment What MS SQL Server administrator client should I use?
I guess when the OP commented: "The ssms version is the most recent. I downloaded it today.", he must have meant he downloaded the most recent version of SSMS 2005.
Apr
8
answered Why is PHP -> MSSQL very slow when the DB is not on the same machine as the PHP code
Apr
8
answered will a 100GB database with large tables on MSSQL 2008 server run on a 3GB RAM system?
Mar
12
comment Windows Server 2008 R2: Weekly network failure
How long does the problem last if you don't do a reboot? Or does it never go away unless you reboot?
Mar
9
revised Outlook 2010 cannot reply to encrypted email
added 545 characters in body
Mar
8
comment Trusted Connection to SQL fails after connecting to a VPN
Ok, in that case, the vpn domain is taking precedent for some reason. I don't know if there's a way when you're logged into both to specify the precedent domain. Since you said you setup trusts, can you give your user in the vpn domain permission to sql server the same way your normal user has? That way you wouldn't have to use the runas /netonly command when vpn'd in.
Mar
7
comment Trusted Connection to SQL fails after connecting to a VPN
I just had another thought. If you open SSMS and connect before you vpn in- I assume it doesn't stop working after you connect to the vpn?
Mar
7
revised Outlook 2010 cannot reply to encrypted email
Added new information.
Mar
7
comment Trusted Connection to SQL fails after connecting to a VPN
Are the VPN and local network on the same subnets? (From a command prompt, do ipconfig /all when vpn'd in and see what your two IPs are.) If the networks are overlapping this might cause it. If this is the case, you can just change your local subnet to a different IP range.
Mar
7
comment Trusted Connection to SQL fails after connecting to a VPN
Sorry I wasn't clear about how to use the /netonly switch. It must be used in conjunction with the runas command. I updated my answer with better instructions.
Mar
7
revised Trusted Connection to SQL fails after connecting to a VPN
added 271 characters in body
Mar
7
asked Outlook 2010 cannot reply to encrypted email
Mar
5
awarded  Commentator
Mar
5
comment How exactly does one store SQL Server on an attached EBS volume? EC2
Where is that quote from? Perhaps with more context it will make better sense.
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)