175 reputation
18
bio website
location
age
visits member for 3 years, 11 months
seen Jun 16 at 16:06

Mar
5
comment How can I add myself to my local sql server's windows authentication?
good to know thanks
Mar
5
comment How can I add myself to my local sql server's windows authentication?
Ah I was looking at the server properties, not the new login screen! Thanks!
Mar
5
comment How can I add myself to my local sql server's windows authentication?
sql server 2008 R2
Mar
5
comment How can I add myself to my local sql server's windows authentication?
I figured this was the case. I went to IT and got the local admin user he set sql server up with, reset the sa password. I was thinking that since I was a local admin I could set it up but I guess not. Can't figure out how to get it to recognize my domain account for windows auth though.
Mar
5
comment How can I add myself to my local sql server's windows authentication?
The error message is just "Login failed for user "DOMAIN\user""
Mar
5
comment How can I add myself to my local sql server's windows authentication?
yeah I should have but I thought that all local admins would have access so I didn't think about it.
Apr
25
comment How can I persist changes to Asp.net settings via Remote IIS manager (IIS 7)?
Yep already tried that, it's the actual publishing of an updated web.config that is overwriting my settings created and edited via Remote IIS Manager (connectionstrings, application settings, and smtp settings)
Apr
25
comment How can I persist changes to Asp.net settings via Remote IIS manager (IIS 7)?
Well my point is I don't want to edit this data in visual studio, because that information will then be stored in source control, thus exposing production database passwords and information to all of development. I was hoping to just keep all the information on the remote IIS server, since it's only relevant in that environment anyway. I don't want to exclude the transform in source control though because there are other transforms that are required that need to be source controlled and not forgotten (such as settings to NOT recreate the database on model changes)
Apr
25
comment How can I persist changes to Asp.net settings via Remote IIS manager (IIS 7)?
How do I tell remote IIS manager what web.config to edit though? The issue is that remote IIS manager is updating it's web.config, but the publish action pushes the development web.config up (which is sometimes needed if I have non-prod only settings change) which overwrites any changes made by the Remote IIS Manager
Apr
24
comment How can I persist changes to Asp.net settings via Remote IIS manager (IIS 7)?
This doesn't seem to be the case. When I deleted my ConnectionStrings section from my web.config, and published it to my IIS server, it always overwrites any connection strings I set with the remote IIS manager (as the IIS manager is writing it to web.config, which is being overwritten)
Mar
14
comment Is Sql Azure useful without windows azure?
It's not completely out of the question, the 5 cent option comes out to about $37.5 a month, which isn't excessive. I have just been referred to some $10 a month business hosting plans that seem reputable, but I would feel more comfortable with the redundancy and other features of Sql Azure for the backend. I'll probably end up using the Full Azure package instead of using piecesi n different area though, as it will probably make my life a lot easier in the long run.