It’s pretty much all in the title. I expect the answer to be no, but wanted to ask to make sure. Basically, can a single SQL Server instance be referred to by multiple names. I know you can set the DNS to resolve multiple names to the same IP/server, but how would this affect connecting to SQL Server? SQL Server doesn’t give a damn about the DNS name you are connecting to, unless you are [...]

We’re at the end of a VDI deployment and have a new requirement to install SQL Server Developer Edition (2008) on the virtual desktop clients. The DBA’s were invited late to the party and subsequently tasked with finding out if this is possible. Apparently the VDI implementer we hired was advising our management that running SQL Server Desktop was impossible under VDI, but did not elaborate as to why (at least to my knowledge). Can [...]

I had a replication job (transactional) on the same server between two databases set to use my domain account, which is admin on the box. When I rebooted the box, the jobs failed, saying that my account wasn’t an “owner.” I changed the owner and now the sub is requiring a re-initialize. What did I do wrong? Should I have made a SQL Server account to do the job? What rights should I have assigned? [...]

Using RESTORE HEADERONLY and checking the BackupType column to tell differential and full backups apart, but a little stumped on how to restrict the data that is being returned from the RESTORE HEADERONLY command. How can you restrict the RESTORE HEADERONLY return set to just the BackupType column return info? I guess make a stored procedure…? Any suggestions? You can’t. You would need to create a table and do an INSERT INTO #MyTable RESTORE HEADERONLY [...]

new here, greetings and such. My problem is relatively simple, but the situation is a tad odd. Currently, I have just been hired on to improve (essentially fix) a server room for a health care dispatcher. However, their server room is in shambles. Everything works, but it’s a matter of I don’t know what is going to break first. They have just recovered from a 10-day data loss from their SQL server (the main server [...]

After talking to a friend who works for a virtualization firm, I started to think whether it could be of benefit to my small company. Right now we have our IIS web server on one server, and our SQL database on another. What he was saying is that with virtualization you could put both operating systems and application stacks onto one piece of physical hardware and then just get a massive big server with lots [...]

I originally posted this on stackoverflow. Not sure if this belongs on Serverfault. I am reasonably familiar with the guidelines of serverfault vs stackoverflow however, while it is a server question the goal is to get my XMPP development environment configured. Any recommendations on stackoverflow vs serverfault will also be appreciated. Anyway here’s my question I am trying to configure my Openfire Server with an instance of MS SQL Server 2008. I must admit that [...]

Our SQL queries sometimes take too long. We have a Windows Server 2003/SQL Server 2005 setup. We have already created indexes everywhere that’s possible. Can we get quicker disks? Any ideas from anyone? The current line of thinking (as of July 2011) is that the best performance on EC2 is by RAIDing the ephemeral disks (the larger your instance, the more there are of them). You had better be sure you have backups if you [...]

I want to set up some tools inhouse but just unsure of a few things. I want to build websites (e.g. a wiki) that can be used internally by staff (there are approximately 300 staff members). What would I need in terms of requirements of hardware software? I’ve asked for Windows Server 2008, IIS7, .net Framework 4.0 and SQL Server 2008 Express. Is SQL Server Express good enough? Ive been asked how many CAL’s I [...]

We are going to enable Kerberos to allow double hop authentication between our SQL Servers. Our company is nearly 24 hours which leaves a very small window for server restarts. Is it possible to enable Kerberos without requiring a reboot of our Domain Controllers or our SQL servers? Kerberos is already enabled, it’s how active directory works, what I assume your talking about is enabling delegation from your web server(or other application server) to your [...]