tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clustering

SQL 2005 Cluster Error and VIA protocol error

I cannot diasbale the VIA protocol and get the primary SQL instance to start
in my Virtual Cluster the Attributes of the Server configuration is as follow:
VMWare: Cluster configuration
OS: WServer2003R2 SP2
SQL2005 SP3
2 virtual servers
2 SQL Virtual Instances installed
The following errors are generated in the log:

3/10/2010 7:07:02 PM

Clustering

SQL 2005 Cluster Error and VIA protocol error

I cannot diasbale the VIA protocol and get the primary SQL instance to start
in my Virtual Cluster the Attributes of the Server configuration is as follow:
VMWare: Cluster configuration
OS: WServer2003R2 SP2
SQL2005 SP3
2 virtual servers
2 SQL Virtual Instances installed
The following errors are generated in the log:

3/10/2010 7:07:02 PM

Clustering

Cluster service is attempting to failover the cluster resource gro

The SQL cluster is not failover over to another node. Can anyone shed some
light in to this. I have checked the config on the cluster administrator side
and it all seems correct to me. The event id appeared is 1153 event source:
clussvc.
In theory the cluster is not working if a disaster happens. A manual reboot

3/8/2010 12:46:01 PM

NNTP Clustering

Cluster service is attempting to failover the cluster resource gro

The SQL cluster is not failover over to another node. Can anyone shed some
light in to this. I have checked the config on the cluster administrator side
and it all seems correct to me. The event id appeared is 1153 event source:
clussvc.
In theory the cluster is not working if a disaster happens. A manual reboot

3/8/2010 12:46:01 PM

NNTP Clustering

SQL Server 2008 and tempDB with SAN

Hi all,
Is it possible to place the tempDB on internal disk and the data on SAN?
Please help....
Many thanks

3/3/2010 10:40:01 AM

Clustering

SQL Server 2008 and tempDB with SAN

Hi all,
Is it possible to place the tempDB on internal disk and the data on SAN?
Please help....
Many thanks

3/3/2010 10:40:01 AM

NNTP Connect

connection error #17:

I am trying to install the ODBC SQL SErver system driver in the System ODBC
Manager in
the ODBC Services control Panel. I have Windows XP Professional. I should
have the latest updates and service packs. I have SQL Server Express 2005
service running. I also have the SQL SErver browser service running.

3/3/2010 6:49:01 AM

NNTP Connect

Strange problem connecting to SQL Server with windows authentifica

Hi there,
I'm struggling for hours with a very strange problem trying to connect from
Microsoft Dynamics Nav to SQL Server using Windows authentification.
The scenario: I have a Windows XP client at which a domain user is logged
in. (Login: TESTDOMAIN\TESTUSER)
This domain user tries to connect with the Dynamics Nav Client to its SQL

3/2/2010 9:11:01 PM

NNTP Clustering

Managing Cluster Log Turnover

Can anyone suggest a best practice for maintaining cluster.log history? I
know there are environment variables that control the log size and a few
other things, but I've seen no good way of handling log rollover.

2/26/2010 3:06:45 AM

Clustering

Managing Cluster Log Turnover

Can anyone suggest a best practice for maintaining cluster.log history? I
know there are environment variables that control the log size and a few
other things, but I've seen no good way of handling log rollover.

2/26/2010 3:06:45 AM

NNTP Clustering

Expand 2-node SQL 2005 cluster to 3-node

Hi
We have a 2-node cluster running Enterprise x64 SQL 2005 on W2K3. We
wish to install additional instances to assist management. We intend
to expand to a 3-node A-A-P cluster. Currently the heartbeat is
running via a cross-over cable with the private network being
prioritised.for internal communication.

2/24/2010 3:43:53 PM

Clustering

Expand 2-node SQL 2005 cluster to 3-node

Hi
We have a 2-node cluster running Enterprise x64 SQL 2005 on W2K3. We
wish to install additional instances to assist management. We intend
to expand to a 3-node A-A-P cluster. Currently the heartbeat is
running via a cross-over cable with the private network being
prioritised.for internal communication.

2/24/2010 3:43:53 PM

NNTP Connect

Sequel Server issue

We have installed a new sonic wall and router to an existing server ,we have
Lytec for a pm system, we now have big connectivity issues.
We can run it on one or two stations but it will shut down after a little
while, stating can't find sequel server can be found and it looks like it
want to create a new connection.

2/24/2010 3:09:08 AM

NNTP Connect

Cannot initialize the data source...

Using SQL Express 2005, why do I get the error below from this query:
SELECT Field1, Field2
FROM OPENROWSET('Microsoft.Jet.OLED B.4.0', 'C:\MyDB.MDB'; 'admin'; '',
Table1) AS Table1_1
Error:
SQL Execution Error.
Executed SQL statement: SELECT Field1, Field2
FROM OPENROWSET('Microsoft.Jet.OLED B.4.0', 'C:\MyDB.MDB'; 'admin'; '',

2/22/2010 8:08:14 PM

NNTP Clustering

Node refuses to release clustered disk resource

Good morning, all -
Two node SQL 2008 cluster attaching to SAN storage. Dual path software in
place on both nodes. On a failover attempt (planned or unplanned), the
cluster controller node will not allow clustered disks (including quorum
resource) to failover unless a complete reboot is performed. For some reason,

2/22/2010 3:44:01 PM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55

pBlogCategories

sys.books