Viewing 15 posts - 226 through 240 (of 392 total)
The instances are functionally seperate so you will still need a Linked Server between them, even if they are part of a single cluster.
May 28, 2013 at 10:24 pm
You could install a seperate instance of SQL as you have been trying, but your first installed instance will be useless and wasting memory. I would suggest uninstalling the...
May 28, 2013 at 9:11 pm
Start the install from SQLEXPRADV_x86_ENU.exe instead of the start menu, it should then allow you to install Full Text without prompting for installation media
May 28, 2013 at 5:35 pm
Follow the instructions in part two on this page to install the full text indexing feature: http://kiln.stackexchange.com/questions/1901/how-do-i-upgrade-sql-server-to-enable-full-text-search
May 27, 2013 at 7:47 pm
Im wondering if some permissions were stuffed somehow after the Windows updates.
You need to narrow down the cause for the Access Is Denied WMI event. You can...
May 27, 2013 at 7:16 pm
If moving to a different server, you need to script out the original server logins. You can use Microsoft stored procedure to do that http://support.microsoft.com/kb/918992
May 27, 2013 at 4:37 pm
It would only be required if you've changed user context earlier. The example from books online:
CREATE PROCEDURE dbo.usp_Demo
WITH EXECUTE AS 'SqlUser1'
AS
SELECT user_name(); -- Shows execution context is set to...
May 26, 2013 at 9:35 pm
Run SQL Server Configuration Manager as Administrator (right click) and try again. What error is in the Windows Application log? What error in SQL log? What are...
May 26, 2013 at 9:16 pm
There is a box to select the template under the "General" tab when you first open a New Trace.
However, that just sets the options of the "Events Selection" tab.
Under...
May 26, 2013 at 9:07 pm
When you run SQL Server Configuration Manager, right click-Run As Administrator, then under the Log On tab you should be able to select local system account.
May 26, 2013 at 8:12 pm
It works if you select TSQL Replay template, then filter on Database Name tempdb, exclude rows without value
May 23, 2013 at 6:25 pm
Yes it's safe to click, it's just a log file. The second node should be running but not running SQL, that's the definition of active-passive. An active-active would...
May 23, 2013 at 6:03 pm
It should not have a red dot next to it. Is it a dot or a red down arrow?
Right click on it and "show critical events for this...
May 23, 2013 at 5:47 pm
You need to troubleshoot the reason for SQL Express engine not starting up and running. You can find why in the SQL Errorlog.
To find where your errorlog is, do...
May 23, 2013 at 5:42 pm
Viewing 15 posts - 226 through 240 (of 392 total)