tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

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

NNTP 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

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

NNTP Clustering

advice please

i need a quick way to provide failover for my sql server. i just want
to have a backup ready to go if server A fails. i will have only two
servers. should i use clustering or mirroring?
tia,
mcnewsxp

1/21/2010 6:09:53 PM

Clustering

advice please

i need a quick way to provide failover for my sql server. i just want
to have a backup ready to go if server A fails. i will have only two
servers. should i use clustering or mirroring?
tia,
mcnewsxp

1/21/2010 6:09:53 PM

NNTP Clustering

Share SQL cluster group with IIS

I have a 2-node SQL Server 2008 cluster. S:\ is the shared drive for the SQL
Server cluster group. Can I create an INETPUT folder in S:\ for IIS? Is is
safe to create IIS resources (Generic Script, etc.) in the SQL Cluster
Group?
Thanks!

1/21/2010 2:58:49 PM

Clustering

Share SQL cluster group with IIS

I have a 2-node SQL Server 2008 cluster. S:\ is the shared drive for the SQL
Server cluster group. Can I create an INETPUT folder in S:\ for IIS? Is is
safe to create IIS resources (Generic Script, etc.) in the SQL Cluster
Group?
Thanks!

1/21/2010 2:58:49 PM

Clustering

Help with clustering SQL2K8 SP1 on iSCSI?

I'm seeing some issues on a Two Node cluster (majority + disk). Failover
works GORGEOUSLY. No problems. They go like a volleyball game. But when I
shut one of the nodes down, the node that's gone down won't give up the
reservations to the remaining node. As a result, failover works, but SQL
can't come up on the remaining node because the remaining node can't bring

1/20/2010 4:31:22 PM

NNTP Clustering

Help with clustering SQL2K8 SP1 on iSCSI?

I'm seeing some issues on a Two Node cluster (majority + disk). Failover
works GORGEOUSLY. No problems. They go like a volleyball game. But when I
shut one of the nodes down, the node that's gone down won't give up the
reservations to the remaining node. As a result, failover works, but SQL
can't come up on the remaining node because the remaining node can't bring

1/20/2010 4:31:22 PM

NNTP Clients

Install client components from command line

Hi,
for install client components with SQL Server 2005 Express Edition i use
this command:
"setup.exe /qb ADDLOCAL=Client_Components"
and with SQL Server 2008 Express Edition i try this command:
"setup.exe /qs /ACTION=Install /FEATURES=BC,Conn,SSMS /HIDECONSOLE"
but client components (for example feature called "SQL Server configuration

1/19/2010 12:01:01 PM

NNTP Clients

Default Date Column

How can I create a table where the primary key is the dateime datatype and
I'd like to default it to the current dateime on SQL Server 2005?

1/19/2010 10:25:01 AM

NNTP Connect

Free Antivirus: http://antivirus-gratis-descarga.blogspot.com

Many computer problems are caused by viruses and malware on your computer.
The best and easiest way to correct this is to use a recognized antivirus and
keep it updated.
Antivirus free download at:
[link]
Links Web Content: [link]

1/15/2010 11:46:11 PM

Clustering

Free Antivirus: http://antivirus-gratis-descarga.blogspot.com

Many computer problems are caused by viruses and malware on your computer.
The best and easiest way to correct this is to use a recognized antivirus and
keep it updated.
Antivirus free download at:
[link]
Links Web Content: [link]

1/15/2010 11:46:06 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