Using VB.Net 2.0 (VS2005), I compile a connection string that set "Integrated Security = True". I then executed a SQL Command using "ExecuteNonQuery()" to "CREATE DATABSE..." which worked fine on my Windows XP machiene.
I have recently upgraded to VB.Net 4.0 (VS2010) and a new computer (Windows 7). I run the same exact code and I now fail on the "ExecuteNonQuery()" with an error stating "Login failed for user <Domain>\<ComputerName>$"
My confusion is two-fold. One, why is ADO.Net passing over my "Computer Name" rather then my "User Name" for Integrated Security. And two, why does it behave perfectly fine on my old computer (WinXP / VS2005) and fail on my new machiene (Win7 / VS2010)?