tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

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

NNTP Connect

Descargas - Antivirus Gratis 1835

Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:
[link]
Links de contenido del sitio web:

1/29/2010 1:37:02 PM

Clustering

Descargas - Antivirus Gratis 1834

Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:
[link]
Links de contenido del sitio web:

1/29/2010 1:36:01 PM

NNTP Clustering

Descargas - Antivirus Gratis 1834

Muchos problemas de rendimiento y seguridad de tu computador son causados por
virus maliciosos, la mejor forma de combatir esto es tener instalado un
Antivirus reconocido y actualizado en tu computador
Descarga gratis Antivirus en:
[link]
Links de contenido del sitio web:

1/29/2010 1:36:01 PM

Clustering

SQL active-active setup on windows clustering

we would like to setup the SQL DB using windows cluster, is it a must to have
external storage ?
the 2 server have Raid 5 configure, can we implement without external
storage ?

1/28/2010 9:23:01 AM

NNTP Clustering

SQL active-active setup on windows clustering

we would like to setup the SQL DB using windows cluster, is it a must to have
external storage ?
the 2 server have Raid 5 configure, can we implement without external
storage ?

1/28/2010 9:23:01 AM

Clustering

upgrade sql 2000 active/passive cluster to sql 2008

hi
i have an active/passive sql sever 200+sp4 cluster and i need to upgrade
it to sql2008 cluster. the BOL is saying " to run the setup on passive
node first then active node & when i failover to passive node the
databases will be upgraded to 2008".
any best practices/steps i need to follow to upgrade with out any

1/28/2010 1:15:42 AM

NNTP Clustering

upgrade sql 2000 active/passive cluster to sql 2008

hi
i have an active/passive sql sever 200+sp4 cluster and i need to upgrade
it to sql2008 cluster. the BOL is saying " to run the setup on passive
node first then active node & when i failover to passive node the
databases will be upgraded to 2008".
any best practices/steps i need to follow to upgrade with out any

1/28/2010 1:15:42 AM

Clustering

Problems with installation of MS SQL 2005 for 64 bits

Hello,
I am trying to install a MS SQL SERVER 2005 64 Bits in cluster, but when the
process is finish I get this error (Microsoft SQL Server 2005 (64-bit) --
Error 1920. Service 'SQL Server Browser' (SQLBrowser) failed to start.
Verify that you have sufficient privileges to start system services.), I

1/27/2010 10:41:02 PM

NNTP Clustering

Problems with installation of MS SQL 2005 for 64 bits

Hello,
I am trying to install a MS SQL SERVER 2005 64 Bits in cluster, but when the
process is finish I get this error (Microsoft SQL Server 2005 (64-bit) --
Error 1920. Service 'SQL Server Browser' (SQLBrowser) failed to start.
Verify that you have sufficient privileges to start system services.), I

1/27/2010 10:41:02 PM

NNTP Clustering

SQL 2005 Cluster on Windows 2008 R2 - Multiple Instances

having an issue installing a 2nd instance on a 2005 sql cluster running on
win2008 R2. It may be simple since i've never done this on 2008 before.
our environment consists of 2 nodes currently running 1 named instance. all
the shared drives are in the SQL Network Name Group - which is the one
virtual server created.

1/27/2010 8:31:02 PM

Clustering

SQL 2005 Cluster on Windows 2008 R2 - Multiple Instances

having an issue installing a 2nd instance on a 2005 sql cluster running on
win2008 R2. It may be simple since i've never done this on 2008 before.
our environment consists of 2 nodes currently running 1 named instance. all
the shared drives are in the SQL Network Name Group - which is the one
virtual server created.

1/27/2010 8:31:02 PM

NNTP Connect

Creating a new datavase/Connecting to SQL Server

Firstly, I'm completely new to SQL Server and may need guided by the hand
until I get this solved.
From VS2008 Server Explorer I elect to "Create a new SQL Server Database"
and get the first dialog
I select ACER as the server name (The only option). "The log on to the
server" I leave as "Use Windows Authentication" (This was the option I used

1/27/2010 5:30:38 PM

NNTP Connect

Login failed for IUSR after IIS reinstallation

I have Windows XP Pro SP3. I had to uninstall and reinstall IIS. The
problem is that now I cannot connect to sql server 2000 from an asp
page using the Internet Guest Account (IUSR) (although I changed
nothing is the sql server settings, where the user ERIC\IUSR_ERIC is
declared as a db_owner in my database). I am receiving this error:

1/25/2010 5:14:57 PM

Clustering

Guide me on Windows 2008 and SQL 2008 clustering - Installation

Hi all,
I am new to Windows and SQL Server clustering.
I want to install Windows 2008 on two servers and have two SQL Server 2008
sp1 clusters. Each instance will be active in its own server but failover to
the other .
I believe in this mechanism, I can use both servers and use high
availability too.

1/23/2010 8:25:01 AM

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