|
If the Scheduled Jobs are setup properly, using an account that the job knows about (username/password), noone has to login to the machine at all. The Agent service will run the job as the user that's supplied. No interactive login required on your part.
|
|
|
|
|
Scheduled Jobs from the Server or SQL?
the server jobs already use this...
|
|
|
|
|
SQL Server has it's own scheduled tasks ability.
|
|
|
|
|
 yes I know... WE ALREADY USE IT!!!
but where can we set the login property there?
the >>SQL JOBS<< wouldn't run without a logged in user.
|
|
|
|
|
Go to "Administrative Tools / Services"
Rightclick "SQL Server Agent" and select Properties.
In the "General" tab, make sure the startup type is "Automatic".
In the "Log On" tab you put in the correct credentials for a user with the correct permissions.
"When did ignorance become a point of view" - Dilbert
|
|
|
|
|
Yeah, but you weren't too clear on that.
SQL Server Management Studio -> SQL Server Agent -> Edit the job -> the Run As drop down. Also, under the General tab, you get to enter the creds of a user.
|
|
|
|
|
I have a Server running Windows Server 2003 and Terminal Services.
I have several users on remote sites that connect to the server with RDP.
What I would like to do, is on a successful logon to the server, depending on who they are logon to other servers.
I have no problem identifying the user, but would like to logon to the other serveral from a batch file. Is there a command I can?
ThanksSteve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Are the servers in different domains?
If not, you only need to set the access rights.
Otherwise you set up trusts between the domains and you still only need to set up the access rights."When did ignorance become a point of view" - Dilbert
|
|
|
|
|
Thanks for the help.
You was right, the code was fine it was me at fault. I was referencing the wrong DataView control on the page.
AAAaaaaarrrrrhhhhhh !!!!!
ThanksSteve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
I am a one-man development team.
For years I have been using VSS for source control. Despite its shortcomings it has served me very well. I work using several PCs in various locations around the world. I have VSS server installed on a single workstation (with its 'database' on a file server). When I'm not connected to the local network I use a VPN to connect. It's not good but it works.
I am beginning to think it's time I moved to VSTS, or at least TFS but I don't really know the first thing about the requirements and benefits. I assume I would need to install it (whatever 'it' is) on an Internet-accessible server. I have trawled the MS web site and there's an immense amount of information but it seems mostly to be written in BS and I just don't have time (or patience) to plough through it all.
Please can someone point me to something that will tell me the essentials about deciding what I need to install and how to set it up and manage my migration.
Cost is not an issue since it comes with my MSDN subscription.
[Edit] I would use the 2010 version of whatever ... [/Edit]Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
modified on Monday, March 8, 2010 10:06 AM
|
|
|
|
|
http://blogs.msdn.com/bharry/archive/2009/10/01/tfs-2010-for-sourcesafe-users.aspx[^] does a good job of explaining the basics. Don't install any of the sharepoint stuff.
I did all that, but I still think it's too big for a one man team.
If you VPN'ed in before, you can still VPN in to your server.
I must say that I'm not using it anymore, since TFS2010 does not connect with VS2008 (at least not Beta 2, haven't looked at anything more recent).
Instead, since MS announced that VSS was about to get the chop (not a bad thing), I've switched to subversion (on Linux  ) which offers integration with ALL versions of VS, has file system integration on ALL platforms, and offers plug-ins for most IDE's (TFS plug-ins usually come with a price tag). I've even dropped the VPN connection with subversion, as I find that security is sufficient when using ssh or https on the big bad Net. There's even some free code to migrate from VSS, keeping history (almost) intact.
|
|
|
|
|
Thanks for that really useful information!
If the final version of TFS 2010 won't play with VS2008 and VS2005 it's no use to me. I still need to support lots of code with VS2005 until I get time to migrate properly.
I won't be running anything on Linux any time soon (at least not until I'm 127 or older).
[Edit]I just read in the blog that TFS doesn't support sharing!! That's a major issue for me. I think I'll be staying with VSS for a while longer ... [/Edit]Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
modified on Monday, March 8, 2010 11:50 AM
|
|
|
|
|
|
| Thanks. Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
|
|
|
|
|
Are there any good resources to CertUtil?
My specific problem is trying to import a .pfx into 'Trusted People'
The following command line puts it into 'Trusted Root Certification Authorities'
certutil -p "" -Importpfx "C:\Program Files\TEST\name.pfx"
Passing any other parameters causes an error.
Any ideas or resources??
Thanks!ed
~"Watch your thoughts; they become your words. Watch your words they become your actions.
Watch your actions; they become your habits. Watch your habits; they become your character.
Watch your character; it becomes your destiny."
-Frank Outlaw.
|
|
|
|
|
Why don't you just double-click the .PFK and import it using the Wizard? You can pick the target store you want to install the certificate to in there. That's IF the certificate is appropriate for that store. You can't just throw any certificate you want in any store you want.
|
|
|
|
|
| I'm building an installer that should hide that from the user. The users are not going to be very knowledgeable of certificates or what to do with them. ed
~"Watch your thoughts; they become your words. Watch your words they become your actions.
Watch your actions; they become your habits. Watch your habits; they become your character.
Watch your character; it becomes your destiny."
-Frank Outlaw.
|
|
|
|
|
That should have been in your original post. I can figure it out, but I need to take care of some stuff first before I start to look at it.
|
|
|
|
|
| I believe I've found what can work by using ImportPfx.exe rather than using CertUtil. ed
~"Watch your thoughts; they become your words. Watch your words they become your actions.
Watch your actions; they become your habits. Watch your habits; they become your character.
Watch your character; it becomes your destiny."
-Frank Outlaw.
|
|
|
|
|
Oh, OK. I didn't get a chance to look at it last night. When your 2 year old throws up on you, it kind of trumps everything else you were planning on doing...
|
|
|
|
|
Dave Kreskowiak wrote: When your 2 year old throws up on you, it kind of trumps everything else you were planning on doing...
Know what you mean!! My 11 yr old was running a fever of 103+ last night. Headed to the doctor shortly. Hope yours gets better & it all washes out!!
Many thanks!!ed
~"Watch your thoughts; they become your words. Watch your words they become your actions.
Watch your actions; they become your habits. Watch your habits; they become your character.
Watch your character; it becomes your destiny."
-Frank Outlaw.
|
|
|
|
|
Ouch! I hope it's nothing serious for you!
My little guy gets low grade fevers like this pretty frequently, so we don't worry about it too much. But, last year he really scared the **** out of us when he had a fever hit 105.9. He spent a week in the hosiptal with viral menengitis and a kidney infection.
Take it easy!
|
|
|
|
|
Every new operating system out of Microsoft seems more paranoid than the last. I am now battling against Windows 7 security. I have blundered into an unfortunate situation where the entire contents of a folder now seems to be owned by System and no user account has write or delete access. I am trying to delete this folder and start again.
I can delete individual files as follows:
1) Properties, Security, Advanced.
2) Select Owner tab, choose Edit and make myself the owner.
3) Properties, Security, Edit.
4) Set Full Control.
Now I can delete the file.
But there are dozens of files so this is slowly, but surely, driving me mad.
I tried taking ownership of the folder itself and resetting the permissions but then it whinges, for every contained file, "You require permission from SYSTEM to make changes to this file".
This is MY computer. I'm the only one who uses it. I don't want Windows 7's poxy security perventing me from deleting the files that I own. The one feature I would really like to see in Windows is a big button that says "I am the administrator and I want ALL security features turned off until further notice".
OK, ranting aside. Someone please put me out of my misery. There must be a way to bulk set these permissions and get rid of these files, mustn't there?
Keith
|
|
|
|
|
|
Thanks for that. Unfortunately, logging on using the (newly enabled) Administrator account is no more successful (the account I was previously using was a member of the Administrators group anyway). The files are still owned by SYSTEM (can I log on as that?) and cannot therefore be deleted, or have their security attributes changed, unless and until I take ownership and so far I have only found a way to do this on a file by file basis.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
