tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clients

SQL Server connection error: 10060, 17

Hi,
I have an application which requires a connection to DB running on SQL
server 2005. The client OS is running Windows 2003 SP1. When trying to
configure the connection, I get the following error:
Connection Failed:
SQLState: '01000'
SQL Server Error: 10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(Connect ())

6/24/2010 9:22:03 PM

Clustering

SQL 2008 Cluster vs SQL 2008 R2 Cluster

I will be installing a new SQL Server cluster in a couple weeks. Is
there any benefit to going with SQL Server 2008 R2 over SQL Server 2008?
We already have in-house experience with SQL 2008 clusters but none with
R2 cluster yet.
With R2, during a failover, do users still get disconnected as they do

6/24/2010 7:57:23 PM

NNTP Clustering

SQL 2008 Cluster vs SQL 2008 R2 Cluster

I will be installing a new SQL Server cluster in a couple weeks. Is
there any benefit to going with SQL Server 2008 R2 over SQL Server 2008?
We already have in-house experience with SQL 2008 clusters but none with
R2 cluster yet.
With R2, during a failover, do users still get disconnected as they do

6/24/2010 7:57:23 PM

NNTP Setup

Installation of SQL 2008 R2 hangs

I try to install SQL Server 2008 R2 (Enterprice): New Instance, Only SQL
Server Module and Reporting Service.
The Setup starts and after a while the progress bar at install windows stuck
in the same location (i was waiting for more than one day!)
Text unter the progress bar: Install_sql_rs_Cpu64_Action

6/24/2010 1:08:16 PM

NNTP Setup

SQL2008 install fails on System Configuration Check VSShellInstall

System: Win 7 Ultimate
SQL 2000, SQL 2005 and VS 2008
The install goes on fine till the System Configuration Check and it tells me
that my Visual Studio has to be at SP1. When I checked my Visual Studio is
Version 3.5 SP1.
I was prompted to try using an slipstream install with SQL2008 SP1, :
[link]

6/23/2010 6:20:29 PM

NNTP Setup

List sharepoint find a custom column "Person or Group" sql server

Hello,
I can't figure this out.And i hope there's someone
way around that help's me.
I have a sharepoint (wss3.0) list with A,B and C fields.I found all
the fields but i can't find the C field.
C field is a custom column "Person or Group" field
and i want to pull data from sql server.
thank you.

6/23/2010 3:21:59 PM

NNTP Replication

max text repl size

What is the max setting for 'max text repl size'? I've read different
information on the web. One link to an MSDN article I found states that "A
value of -1 indicates no limit, other than the limit imposed by the data
type." Is this true?
Thanks,
Mark

6/23/2010 2:51:26 PM

NNTP Replication

Log shipping failed

Good Afternoon,
We current do log shipping of one of our databases to an offsite DR server.
Yesterday the portion of the log shipping that restores the trans log to the
DR database failed. The portion that backs up the trans log and transfers it
is still working. Error messages are not real great and telling what cause

6/22/2010 7:35:58 PM

NNTP Clustering

Upgrading a Windows 2008 cluster running SQL 2008 to Windows 2008

I am trying to upgrade a 2-node Windows 2008 Cluster with SQL Server 2008
installed to Windows 2008 R2.
I have followed the Microsoft practice of evicting one of the nodes from the
cluster, removing SQL Server, upgrading the OS to R2 and creating a new
cluster which all work fine.
My issue is that I need to migrate the SQL Server 2008 instance from the old

6/22/2010 9:35:35 AM

Clustering

Upgrading a Windows 2008 cluster running SQL 2008 to Windows 2008

I am trying to upgrade a 2-node Windows 2008 Cluster with SQL Server 2008
installed to Windows 2008 R2.
I have followed the Microsoft practice of evicting one of the nodes from the
cluster, removing SQL Server, upgrading the OS to R2 and creating a new
cluster which all work fine.
My issue is that I need to migrate the SQL Server 2008 instance from the old

6/22/2010 9:35:35 AM

NNTP Replication

About Snapshot Replication

I want to create a snapshot replication in sql server 2000. I have created
Publication and pull subcription. But the status of the Distribution agent is
Never started. But the status of the Snapshot Agents is succeeded.
I can't understand where is my configuration fault.
Plz any one help me as early as possible.

6/22/2010 6:26:08 AM

NNTP Replication

Newbie - Can replication do this?

Hello,
We have two separate web applications and each is using SQL 2005 severs.
These two hosted in completely different locations and domains. We have a
requirement that data from some tables(not all) needs to be in sync at both
of these sites (few minutes of delay is acceptable). So, if a user enters a

6/21/2010 3:07:06 PM

NNTP Setup

BUY FAKE ID CARD,SALE FALSE ID CARD,BUY FAKE ONLINE ID CARD,BUY FAKE ID UK,BUY FAKE PASSPORT

Our team is a unique producer of quality fake documents.
We offer only original high-quality fake passports, driver's licenses,
ID cards, stamps and other products for a number of countries like:
USA, Australia, Belgium, Brazil, Canada, Italia, Finland, France,
Germany, Israel, Mexico, Netherlands, South Africa, Spain, United

6/19/2010 7:04:38 PM

NNTP Clustering

Only $64 (including shipping fee) for newest GHD IV Styler--Paypal

We are Promptc Co.,Ltd from China .Professional in supplying
GHD ,Phone etc. The top quality but low price of our company have
found a good market in many countries.
1) [link]
2) [link]

6/19/2010 6:54:38 AM

Clustering

Only $64 (including shipping fee) for newest GHD IV Styler--Paypal

We are Promptc Co.,Ltd from China .Professional in supplying
GHD ,Phone etc. The top quality but low price of our company have
found a good market in many countries.
1) [link]
2) [link]

6/19/2010 6:54:38 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

pBlogCategories

sys.books