Surprisingly I don't see this question on ServerFault already. I'm wondering about the pros and cons of hardware token vs software token for two-factor authentication - only in the context of security, not convenience. I am referring only to the time-based one-time password generators.
Is there a clear winner in terms of security? Does it vary according to the platform the software token (app) is installed on?
Are there any issues with Hyper-V (on Server 2008 r2) if the host is formatted as GPT? Someone out there has tried this...
We are using Excel 2010 and sometimes users are working from a network share. When a user on the network opens the file in Excel, the file is locked for editing - this is the expected behavior. When another user tries to open the file, Excel gives the message
[filename] is locked for editing by 'John Doe'
The problem is, the user is always this one particular user's name, no matter who actually has the file open. Where does Excel get this info, and how do I fix it?
Update: I should have mentioned that in Excel, under Options (General), the correct user names have been set up. That is not where this user name is coming from.
SQLIO seems like a useful tool. I thought it would be interesting to try to measure the speed difference between a physical disk and a VHD. So I ran SQLIO on the Hyper-V host on the physical drive. Results seemed reasonable. Then I ran it from the guest to test the vhd (on the same physical disk). I expected it to be a bit slower. But instead it was way faster - like 0ms average latency.
So I'm trying to learn something here. It seems like hyper-v is fooling SQLIO somehow but I don't understand it well enough to figure it out.
It's a dynamic vhd, no snapshots or anything, and the vhd is the only file on the disk. The physical disk is actually a two SAS drive RAID 1.
I'm the DBA and the Accpac guy is telling me we need a SQL login for the Accpac databases. Right now I use only Windows authentication, and I don't like the idea of turning on mixed authentication if I don't have to. So before I agree to it, I want to make sure it's necessary. Can Accpac use Windows logins?
How can I export an Exchange 2007 public folder (IPM.Contact) as an Excel or Access file? We use Outlook 2010 on the client side.
This is in the System Event log (Windows Server 2008) ATAPI Event 11 "The driver detected a controller error on \Device\Ide\IdePort2."
It is probably a hardware problem, but I'm not sure how to determine that for sure. The machine still works most of the time, but it locks up at random. Sometimes at boot time, sometimes well after that.
Are the Canadian Office 2010 release dates different from the American ones?
I'm interested in the volume license release date in Canada. I beleive it was May 1 in USA.
Are academic open licenses different?
By default, users do not see the "Report Builder" button on the Report Manager toolbar in SQL Server 2008 (R1). How do I give the user permission to use the Report Builder?
In the Windows 7 credential manager, what is the virtualapp/didlogical credential for?
Please explain what is required to set up a SQL Server linked server.
Server A is SQL 2005 Windows logins only . Server B is the same (SQL 2005 Windows logins only) .
Server A runs Windows XP . Server B runs Windows Server 2003 .
Both SQL Server services are running under the same domain account. I am logged into my workstation with a domain account that has administrative rights on both SQL Servers.
Note these are both SQL Server 2005 SP2 - I've had old hot-fixes pointed out to me, but those are already applied.
The issue I am having is this error:
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)"
Did my first P2V experiment with SCVMM R2 - Vista 32 (Dell Precision 490) to Hyper-V on Windows Server 2008. I'm having issues with "integration Services" and "virtual machine bus" driver.
When I install Integration Services it claims to install successfully, but clicking the mouse on the screen still says I need to install Integration Services.
When I try to install a virtual machine bus driver I get "Windows cannot load the device driver for this hardware. The driver may be currupted or missing. (Code 39)"
The VM doesn't see the virtual network card, and I'm assuming this is related to the virtual machine bus.
How can I fix this?
I know you can remotely shutdown a Windows machine with the "shutdown" command line. But I think it's impossible to remotely get a machine into safe mode (with networking). Does anyone know of a way to do this?
I've been using a "Windows 2008 Workstation" (google it) on my laptop. I am aware of the workarounds to get Hyper-V to work on a wifi card.
But I'm wondering if Server 2008 R2 adds this capability? Seems like something there would be some demand for.
Is there an easy way in WSS to track when files are downloaded from a site?
I am using VPN to connect to work. I am used to listening to streaming music when I am in the office, but when i do that over the VPN, the connect drops. So, no big deal, I just won't use the streaming music when I'm on the VPN.
But I just had a Skype meeting with the office, and lost the VPN. So now this is getting in my way and I want to fix it. Any ideas where I should look?
I'm running Server 2008 on a laptop, using a wireless connection in my house to a decent, relaiable DSL connection. I'm using the built in Windows VPN client.
update: On the office side, the VPN is on a DLink firewall - it's PPTP with 128 bit MPPE encryption.
update: I beleve this is related to the DPC latency issue which seems to be plaguing many laptops on the market. I've still not solved the problem. In my case, I'm using a Dell Studio XPS 16, which is one of the laptops with this problem. I'm hoping eventually to find the right mix of drivers to solve the problem.
We are using an out of date custom application for managing mailing/contact lists. We are a very small office, an all Microsoft shop. We have Exchange and Windows Sharepoint Services and Office 2007.
I'm looking for thoughts about the best solution for setting up a shared contact list which would be used for mail merges and also simple searches for email/phone.
Sharepoint and Exchange/Outlook both have pros and cons - what are they? Any other options?
I set up a Sharepoint (WSS) site with forms-based authentication (FBA) via ASP.Net membership provider - I can change user's passwords with the ASP.Net config tool. But I want them to be able to change their own password. Should be something obvious that I'm just not seeing, right?
I'm about to start full-time telecommuting. I would like to save myself some trouble and learn from everyone's experience.
I'm pretty much an IT generalist in a small office, but I focus more on SQL Server and the business intelligence side of things.
I'm moving to a different city (5 hours away), with laptop and cell phone as my mobile office.
What tips do you have for me?
What pitfalls should I look out for?