Viewing 10 posts - 16 through 25 (of 25 total)
In the Server Network Utility, is it listening on named pipes and/or TCP? If it is only TCP, verify in the TCP properties that it does not have the...
March 12, 2007 at 4:42 am
In a 2-node SQL cluster, you can have multiple instances of SQL running. Ie:
- CLUSTER\INST1 (runs on NODE-A)
- Data entry DB
...
March 6, 2007 at 10:05 am
I have not put IIS/SSRS on the SQL Cluster if that's what you are thinking. I used separate machines (VMWare in fact) behind a hardware load balancer. I...
March 6, 2007 at 7:27 am
For the SQL cluster, configure two separate instances--one to run on each node. Mirror the data entry DB to the second instance, then schedule snapshots of the mirrored database...
March 6, 2007 at 4:56 am
You will get this when a connection is being made using TCP/IP, and there is no (or missing) DNS record or Service Principal Name. Both are required to validate...
March 5, 2007 at 5:18 am
After you've close/killed all of the connections to the database, don't right-click on the database you want to restore. Right-click on "Databases" instead, then choose Restore Database.
Don't have any...
December 19, 2006 at 4:52 am
As the error states, the account does not have permission to perform bulk insert operations.
GRANT ADMINISTER BULK OPERATIONS TO [domain\user] or [sqluser]
December 19, 2006 at 4:43 am
Ancient thread, but the answer is in the event itself. You are running the 32-bit version of SQL.
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c)...
December 16, 2006 at 4:36 pm
It sounds like you have the SQL EM installed on the web servers. If so, did you apply SP4 + hotfixes?
December 15, 2006 at 12:06 pm
I just posted a script to back up all SSAS databases in an instance. That may help.
http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1850
December 15, 2006 at 10:14 am
Viewing 10 posts - 16 through 25 (of 25 total)