New answers tagged sql-server-2008
1
SQL Server Tuning Advisor is a tool designed expressly for Microsoft SQL Server systems that enables database tuning in a variety of different ways. It can be used in both online and offline tuning applications depending on the needs of the individual or business. It has the ability to greatly improve the overall performance for searches by tuning various ...
0
You can safely add another vCPU. Upon boot, Windows will upgrade the HAL from Uniprocessor to Mutliprocessor.
6
KB888729: How to add processors to a computer that is running Windows Server 2003, Windows Server 2008, ... etc.:
When you restart the computer, Plug and Play detects and installs the
processor or processors.
All versions of Windows Server 2003, Windows Server 2008, Windows
Server 2008 R2, Windows Vista, Windows 7 and of Windows XP
...
0
You should generally be fine adding a virtual CPU to this configuration to ease contention issues. You don't mention your hardware configuration or the other guest virtual machines using resources on the host, though.
Do you have that visibility?
I would not mess with reservations at this juncture. Can you report back on the details from the Summary tab ...
2
Those three problems are all a result of the account running the SQL Service not being a domain account, and they will all be corrected by changing SQL to run under a domain account. Specifically:
A - an SPN is a Kerberos security feature that requires a domain account, and doesn't work with local accounts
B - In order to read from active directory, the ...
0
The First Answer From Sqillman (http://serverfault.com/a/506567/173328) works! Kudos!
Here's what it solved for us...
For us, the answer (above/below?) allows access to SQL Server 2000 databases from SQL Server 2012 Integration Services packages that are hosted on a SQL Server 2012 database server running on Windows Server 2012 OS. We followed these ...
0
Have a look at this post which tells of a similar situation. The author used the SQL Native Client .msi from the \x64\Setup\x64 folder of the SQL 2008 distribution media. Maybe that will do it.
If not, you should be ok to uninstall the SQL Native Client 11, install v10 and then reinstall 11.
0
Method 1: T-SQL
USE [master]
GO
CREATE LOGIN [test] WITH PASSWORD=N'test', DEFAULT_DATABASE=[xyz],
CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC master..sp_addsrvrolemember @loginame = N'test', @rolename = N'sysadmin'
GO
0
This can be fixed by running the following commands from an administrative command prompt.
Locate this directory: %systemroot%\system32\wbem
Then run these commands in sequence & restart your setup.
regsvr32 cluswmi.dll
mofcomp.exe ClusWMI.mof
0
This can be fixed by running the following commands from an administrative command prompt. Locate this
directory: %systemroot%\system32\wbem
Run these commands in sequence & restart your setup.
0
This can be fixed by running the following commands from an administrative command prompt.
Locate this directory: %systemroot%\system32\wbem
Then run these commands in sequence & restart your setup.
regsvr32 cluswmi.dll
mofcomp.exe ClusWMI.mof
Top 50 recent answers are included
