tblMashedUp

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Clustering

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

NNTP Clients

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:01 PM

NNTP Connect

Problem with MS DTC on SQL2008 win server 2k8 with linked server from sql2000 win server 2k

Hi,
We have migrated our db from sql2000 win server 2k to sql2008 win server 2k8. We have linked server from sql2000 win server 2k. By our opinion the problem is with DTC and we have made a lot of setting that we found as solution for our problem, but still the problem exist. There is no any error or worning or information niether in the sql log nor in win event viewer. The application is hanging out and at the end the time out exception is shown.

1/13/2010 9:44:26 PM

NNTP Connect

WIndows Authentication Connection String

I need to be able to connect to a database on a remote SQL Server from
a .NET client using ODBC and Windows Authentication. I need to be able
to specify a Domain username and password to connect where the domain
username may or may not be the my currently logged in Domain username.
In other words, let's say I was logged into the username

1/13/2010 8:01:19 PM

Clustering

SQL2k8 Clustering Vs. Mirroring Scale Out Clarification

Hi All,
My company is looking to build a scalable, high availability SQL Server 2008
instance. I've been searching online to find definitive answers for a couple
of questions, namely:
If I setup Fail-over Clustering on 2k8 with 3 nodes, am I able to split the
workload across all 3 nodes? I've read that I can do this with a shared copy

1/13/2010 6:50:02 PM

NNTP Clustering

SQL2k8 Clustering Vs. Mirroring Scale Out Clarification

Hi All,
My company is looking to build a scalable, high availability SQL Server 2008
instance. I've been searching online to find definitive answers for a couple
of questions, namely:
If I setup Fail-over Clustering on 2k8 with 3 nodes, am I able to split the
workload across all 3 nodes? I've read that I can do this with a shared copy

1/13/2010 6:50:02 PM

Clustering

Failover not starting SQL Service

I have a SQL 2005 cluster, 2 node, running on 2003 Server, all patches/
sp's up to date. It was working fine until yesterday. We installed
Reporting services a couple of days ago and installed iscsi initiator
so we could use some storage from NAS yesterday. The failover ot B-
node went fine but took longer than usual, maybe 4 minutes vice about

1/13/2010 3:02:06 PM

NNTP Clustering

Failover not starting SQL Service

I have a SQL 2005 cluster, 2 node, running on 2003 Server, all patches/
sp's up to date. It was working fine until yesterday. We installed
Reporting services a couple of days ago and installed iscsi initiator
so we could use some storage from NAS yesterday. The failover ot B-
node went fine but took longer than usual, maybe 4 minutes vice about

1/13/2010 3:02:06 PM

Clustering

Can't install SQL2K8 Failover Cluster on Server 2K8R2 Cluster

Trying to install SQL2K8 Failover Cluster on 2 Node Server 2K8R2 Cluster
fails in section "Instance Configuration" with the following message:
------------------------------
The given network name is unusable because there was a failure trying to
determine if the network name is valid for use by the clustered SQL instance

1/13/2010 11:56:01 AM

NNTP Clustering

Can't install SQL2K8 Failover Cluster on Server 2K8R2 Cluster

Trying to install SQL2K8 Failover Cluster on 2 Node Server 2K8R2 Cluster
fails in section "Instance Configuration" with the following message:
------------------------------
The given network name is unusable because there was a failure trying to
determine if the network name is valid for use by the clustered SQL instance

1/13/2010 11:56:01 AM

NNTP Connect

DTC ports, kind of urgent

Hi,
I'm struggling with an deploying an application server and SQL server at a
customer location.
The SQL server will be deployed in a trusted zone and the app server in a
DMZ with firewall rules allowing access to the SQL server.
I have followed douments to reduce the number of ports that DTC will use to

1/13/2010 9:01:01 AM

NNTP Connect

Enabling Windows Server 2008 Firewall to block SQL Server Access

I just inherited a Windows Server Standard 2008 sp2 (64 bit) machine. I
installed SQL Server 2008 Standard. Now I want to block outside access to
the database. I enabled the firewall and deleted all rules related to port
1433 and the sqlserver.exe file. However I am still able to connect to the

1/13/2010 12:21:01 AM

NNTP Connect

How to check if a linked server exist on an usb drive?

I have seen numerous answer to the question "how to check if a linked server exist", but my problem is a bit different.
In my application I'm certain that the linked server exist, but this server is an access mdb file stored on a pen drive.
The customer is free to disconnect the pen drive to keep is data secure but my stored procedures fail with an oledb error message if the file is not there!

1/12/2010 3:46:52 PM

NNTP Connect

Connecting to remote sql server with windows auth using db library

Hello,
I habe an application (developed with MS Visual Studio 2008) which connects
to a sql server 2005 or sql server 2008 using the db library (ntwdblib.dll
ver 2000.080.0194.00).
When testing this under win 7 or win 2008 server the connection via
dbopen(...) works fine with a local sql server but fails with a remote sql

1/12/2010 1:54:01 PM

NNTP Connect

Login failed for user 'IIS APPPOOL\DefaultAppPool'.

I recently rebuilt my laptop to Windows 7 Ultimate 64-bit and am trying to
rebuild my local test web sites - I support 2 DotNetNuke sites. I've got IIS
up and SQL Server 2005 Express up, I downloaded the x86 binaries for 64-bit.
I downloaded the web site production files and database backup, created the

1/12/2010 1:40: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

pBlogCategories

sys.books