tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clustering

MSDTC

We have an active-passive cluster environment with Windows Server 2003 and
SQL Server 2005, where the MSDTC is working correctly, in the passive
environment is installed SQL Server 2005 used for testing, but does not
activate the service Distributed Transaction Coordinator (DTC), we need
activate it for use with the Biztalk databases. The screen is disabled

2/5/2010 10:01:01 PM

Clustering

MSDTC

We have an active-passive cluster environment with Windows Server 2003 and
SQL Server 2005, where the MSDTC is working correctly, in the passive
environment is installed SQL Server 2005 used for testing, but does not
activate the service Distributed Transaction Coordinator (DTC), we need
activate it for use with the Biztalk databases. The screen is disabled

2/5/2010 10:01:01 PM

NNTP Clients

How to configure sql server 2008 client

Hi,
I've this trouble ...
- I've got this server: Windows XP SP3 with SQL Server 2008 Express
installed.
I've just enabled the SQL Server Browser and TCP-IP (an even Named Pipes
protocol, they were all-disabled).
- I've got one client: Windows XP SP3 with SQL Server 2008 Native Client
installed.
Fron client I cannot connect to Server in any way !!!

2/5/2010 3:36:51 PM

NNTP Clustering

[IMPORTANT!!!] Windows erasing SAN disk

I think I discovered a BIG problem with Windows 2003 x64 R2 SP2.
Suppose I set a setup a server and connecting it to a SAN disk and then
format this disk. When I setup a secondary server to the same disk the disk
is seen as unformatted and Windows has to initialize it again, so I lost all
data in it.

2/5/2010 1:03:36 PM

Clustering

[IMPORTANT!!!] Windows erasing SAN disk

I think I discovered a BIG problem with Windows 2003 x64 R2 SP2.
Suppose I set a setup a server and connecting it to a SAN disk and then
format this disk. When I setup a secondary server to the same disk the disk
is seen as unformatted and Windows has to initialize it again, so I lost all
data in it.

2/5/2010 1:03:36 PM

NNTP Clients

Can't get ImportRow to work - sorry if it's the wrong Group

'Visual Studio 2008, working with an Access 97 table, and an SQL
Server 2008 database. I have full rights to both...
'This program runs in x86 mode, due to the lack of a 64-bit JET
OLEDB.4.0 driver
Dim dsAccess As DataSet = New DataSet
Dim dsSQL As DataSet = New DataSet
Dim tblAccess As DataTable

2/5/2010 4:50:13 AM

Clustering

Urgent help on Kerberos

Hi All
Application uses ASP.Net 2005 and SQL server 2005
We are connecting to the web application from a local machine. When we
click a button on the app a file should be downloaded to the web
server where the app is hosted. This works with Kerberos enabled and
using integrated security set on the website properties.

2/2/2010 1:49:49 PM

NNTP Clustering

Urgent help on Kerberos

Hi All
Application uses ASP.Net 2005 and SQL server 2005
We are connecting to the web application from a local machine. When we
click a button on the app a file should be downloaded to the web
server where the app is hosted. This works with Kerberos enabled and
using integrated security set on the website properties.

2/2/2010 1:49:49 PM

NNTP Clients

a brand new query tool is out on beta, we need feedback, so you get a free copy

We at Nob Hill Software are working on a new query tool:
[link]
You can read all about it on the above web page, but basically, its a
very ambitious project to create what we call 'the query tool to end
all query tools': everything you ever wanted, desired, dreamed about

2/1/2010 7:58:20 PM

NNTP Connect

a brand new query tool is out on beta, we need feedback, so you get a free copy

We at Nob Hill Software are working on a new query tool:
[link]
You can read all about it on the above web page, but basically, its a
very ambitious project to create what we call 'the query tool to end
all query tools': everything you ever wanted, desired, dreamed about

2/1/2010 7:56:26 PM

NNTP Clustering

SQL 2005 Cluster performance

I am looking to implement SQL Clustering on a SAN with SATA drives. While I know that clustering is not a "performance" solution, however performance is a consideration when looking for read/write times.
The solution I am exploring has fibre DAE's and FC switches with FC HBAs in each server connecting to the SAN. Theoretically, the FC will achieve a better throughput with FC drives...however, the costs associated are too high.

2/1/2010 7:13:09 PM

Clustering

SQL 2005 Cluster performance

I am looking to implement SQL Clustering on a SAN with SATA drives. While I know that clustering is not a "performance" solution, however performance is a consideration when looking for read/write times.
The solution I am exploring has fibre DAE's and FC switches with FC HBAs in each server connecting to the SAN. Theoretically, the FC will achieve a better throughput with FC drives...however, the costs associated are too high.

2/1/2010 7:13:09 PM

Clustering

Unable to see all partitions SQL Server Management Studio

Hi,
I'm running 4 instane SQL Server 2005 in an active/passive clustered
enviroment utilizing a SAN.
I'm running out of space on one of my LUN's for one particular instance.
This instance was originally set up as follows:
LUN 1 - Database partition (3 databases) - K drive
LUN 2 - Log Partition - L drive

2/1/2010 2:49:01 PM

NNTP Clustering

Unable to see all partitions SQL Server Management Studio

Hi,
I'm running 4 instane SQL Server 2005 in an active/passive clustered
enviroment utilizing a SAN.
I'm running out of space on one of my LUN's for one particular instance.
This instance was originally set up as follows:
LUN 1 - Database partition (3 databases) - K drive
LUN 2 - Log Partition - L drive

2/1/2010 2:49:01 PM

NNTP Clustering

SQL Server 2005 cluster reverts to Windows only mode after failove

All,
SQL Server 2005 EE SP3 CU1 in an active-passive failover cluster
configuration.
Whenever I fail over the cluster or restart SQL Server, the SQL Server
reverts from mixed mode to Windows mode.
I've read that this is a known issue with SP3 CU1 and other later CUs for
SP3. Is this true?
Also, if it's true, will SP4 resolve this issue?

1/29/2010 4:45:02 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 56

pBlogCategories

sys.books