tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clustering

Installing Reporting services on a cluster

Hi,
We have an existing production clustered SQL server with a default instance
and a named instance. I need to configure Reporting services on the named
instance but am getting the error "Existing cluster or cluster prepared
instance failed".
Has anyone installed RS on a SQL cluster, can you please give me some steps?

11/21/2009 3:12:01 AM

NNTP Connect

Linked server data access

Hello,
I have a linked server defined on my SQL server and I
I would like to monitoring all the query o store procedure that try to
access on this data becouse I would like to permit only one access per time
on that linked server. My indea is that only one query or stored procedure
can use the linked server in the same time, if there are one more query ore

11/20/2009 4:37:02 PM

NNTP Clustering

LUN configuration

Hello!
We will be installing SQL Server 2008 Active/Active Cluster on Windows
2008. SAN engineer told us that all space will be allocated accross the same
set of drives. I know this is not recommended because of potential IO issues,
but I guess this is something we would have to live with. The question we

11/19/2009 11:40:01 PM

Clustering

LUN configuration

Hello!
We will be installing SQL Server 2008 Active/Active Cluster on Windows
2008. SAN engineer told us that all space will be allocated accross the same
set of drives. I know this is not recommended because of potential IO issues,
but I guess this is something we would have to live with. The question we

11/19/2009 11:40:01 PM

NNTP Clients

setting relationships through the enterprise manager

I've very new to SQL Server and the Enterprise Manager. Can anyone
point me to how to set up the relationships between the tables, and
denoting which are the foreign keys?
I'm coming from an Access 2k background, it that makes a difference.
Regards,
Shay B.

11/19/2009 10:48:05 PM

NNTP Connect

Re: remote slqserver 2005 express connection problem ugent!

I would interpret this as you don't have the JDBC driver installed. But
I don't really know about Java at all, only that it's close to Sumatra.
You should probably ask in a forum devoted to the JDBC driver.

11/19/2009 10:27:29 PM

Clustering

SQL Server 2008 Active/Active cluster memory configuration

Hello!
We will be installing SQL Server 2008 64 bit EE on Windows 2008 EE
(Active/Active cluster). I would like to confirm following settings
considering we will have 32GB of memory on each node:
1. No need to enable AWE.
2. No need to set 'Lock Pages In Memory'.
3. Cap Min and Max Memory usage on each instance (leave memory not only to

11/19/2009 1:07:01 AM

NNTP Clustering

SQL Server 2008 Active/Active cluster memory configuration

Hello!
We will be installing SQL Server 2008 64 bit EE on Windows 2008 EE
(Active/Active cluster). I would like to confirm following settings
considering we will have 32GB of memory on each node:
1. No need to enable AWE.
2. No need to set 'Lock Pages In Memory'.
3. Cap Min and Max Memory usage on each instance (leave memory not only to

11/19/2009 1:07:01 AM

NNTP Connect

Turning the firewall on

Hello,
I have a windows 2003 sp2 hosting sql 2005 Ent sp2. I like to turn on
firewall.
Do use the exception to allow certain ports or do I allow the program to be
accessed.
I have clients on other machines connecting to his database server. I think
name pipe is needed. Not sure.
tnt

11/18/2009 8:58:09 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

11/18/2009 1:19:34 PM

NNTP Clustering

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

11/18/2009 1:18:43 PM

Clustering

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

11/18/2009 1:18:43 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

11/18/2009 1:17:48 PM

NNTP Clustering

SS2K8 on Win2K8 cluster 6 nodes

Hi,
We want to install 4 active SQL nodes and 2 passive nodes.
do we have to install 4 named instances or may it be 4 default instances?
will we have to install additional nodes on all nodes in the cluster for the
4 instances (24 install)?
Is there some good resource about installing multiple instances on multiple

11/18/2009 1:08:50 PM

Clustering

SS2K8 on Win2K8 cluster 6 nodes

Hi,
We want to install 4 active SQL nodes and 2 passive nodes.
do we have to install 4 named instances or may it be 4 default instances?
will we have to install additional nodes on all nodes in the cluster for the
4 instances (24 install)?
Is there some good resource about installing multiple instances on multiple

11/18/2009 1:08:50 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