Help!! Need to get the MSDASQL provider in SQL 2005 EE 64 bit

I understand that the MSDASQL.dll is not available in 64 bit (unless you are running 2008 beta 3). I also understand that you can setup 32 bit ODBC without issues (using ODBCAD32.exe in WOW directory). My issue is how does SQL 2005 64 bit see these ODBC links? What is everyone doing to get around this? I want to be able to use openquery. Any advice would be much appreciated.

Carlton

I have also tried using the IBMDADB2 provider but im getting an interesting message of access denied.

sp_addlinkedserver @.server = N'name', @.srvproduct=N'sourcename', @.provider=N'IBMDADB2', @.provstr=N'DSN=sourcename'

Error using a select statement

SELECT *

FROM OPENQUERY (Name,'SELECT * FROM Database.table')

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "IBMDADB2" for linked server "sourcename" reported an error. Access denied.

Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider "IBMDADB2" for linked server "sourcename".

Help!! Need to get the MSDASQL provider in SQL 2005 EE 64 bit

I understand that the MSDASQL.dll is not available in 64 bit (unless you are running 2008 beta 3). I also understand that you can setup 32 bit ODBC without issues (using ODBCAD32.exe in WOW directory). My issue is how does SQL 2005 64 bit see these ODBC links? What is everyone doing to get around this? I want to be able to use openquery. Any advice would be much appreciated.

Carlton

I have also tried using the IBMDADB2 provider but im getting an interesting message of access denied.

sp_addlinkedserver @.server = N'name', @.srvproduct=N'sourcename', @.provider=N'IBMDADB2', @.provstr=N'DSN=sourcename'

Error using a select statement

SELECT *

FROM OPENQUERY (Name,'SELECT * FROM Database.table')

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "IBMDADB2" for linked server "sourcename" reported an error. Access denied.

Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider "IBMDADB2" for linked server "sourcename".

Help! Replication jobs fails when it was working fine.

Hello,
I have a push subscription setup to replicate some tables. Initially, this
was setup properly and everything was working perfectly. Until recently, the
jobs started failing even though nothing was changed. The errors do not give
me enough information to find out what the problem is. Can someone give me
some hints or ideas of what to do?
FYI, I've re-generated snapshots and re-initialized the subscriptions but it
still fails.
FIRST ERROR
==============================================
Date4/21/2005 9:01:35 AM
LogJob History (XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX)
Job NameXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Step ID2
Step NameRun agent.
MessageExecuted as user: xxx\Administrator. The step did not generate any
output. NOTE: The step was retried the requested number of times (10)
without succeeding. The step failed.
Duration00:05:10
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted10
SECOND ERROR
==============================================
Date4/21/2005 9:06:46 AM
LogJob History (XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX)
Job NameXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
Step ID3
Step NameDetect nonlogged agent shutdown.
MessageExecuted as user: NT AUTHORITY\SYSTEM. Replication-Replication
Distribution Subsystem: agent XXXXXXXX for XXXXXXXXXX failed. Executed as
user: Domain\Administrator. The step did not generate any output. NOTE: The
step was retried the requested number of times (10) without succeeding. The
step failed. [SQLSTATE 42000] (Error 14151). The step failed.
Duration00:00:00
Sql Severity18
Sql Message ID14151
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
its hard to say. Can you do logging to see if it reveals anything? also
look for dumps in case there were any access violations.
Follow these instructions to enable logging.
http://support.microsoft.com/default...b;en-us;312292
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
|||Also run profiler on the subscriber, check for blocking, or any exceptions
being thrown.
Donna
"Hilary Cotter" wrote:

> its hard to say. Can you do logging to see if it reveals anything? also
> look for dumps in case there were any access violations.
> Follow these instructions to enable logging.
> http://support.microsoft.com/default...b;en-us;312292
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>

Help! How to clustering SQL Server 2000 without Shared Disk?

hi all,

our company is going to setup ms sql server cluster for fault tolerance,
budget has to be kept minimum.

actaully, i was told that sql clustering (includes shared DB data sync)
can be done over a dedicated tcp/ip connection instead of using shared disk
array connected to the same scsi bus of 2 machines, however i could not even
configure cluster service on win2k server as there is no shared disk.

futhermore, i heard windows 2003 server can do it with no shared disk,
butr it can't be used for this purpose because of license issue.

i would to know if there is a way to cluster sql server nodes without a
shared disk array on windows 2000 adv/dc server + ms sql 2000 enterprise.

all advices are welcomed to reach chun_wail@.hotmail.com

thank you very much,

Will Law (hong kong)"wailaw" <chun_wail@.hotmail.com> wrote in message
news:bi7mdl$lpa1@.imsp212.netvigator.com...
> hi all,
> our company is going to setup ms sql server cluster for fault
tolerance,
> budget has to be kept minimum.
> actaully, i was told that sql clustering (includes shared DB data
sync)
> can be done over a dedicated tcp/ip connection instead of using shared
disk
> array connected to the same scsi bus of 2 machines, however i could not
even
> configure cluster service on win2k server as there is no shared disk.
> futhermore, i heard windows 2003 server can do it with no shared disk,
> butr it can't be used for this purpose because of license issue.
> i would to know if there is a way to cluster sql server nodes without
a
> shared disk array on windows 2000 adv/dc server + ms sql 2000 enterprise.
> all advices are welcomed to reach chun_wail@.hotmail.com
>
> thank you very much,
> Will Law (hong kong)

(Removed irrelevant newsgroups from the reply)

SQL Server clustering depends on the Windows clustering service, so you have
no way to avoid the shared disk requirement - clustering is managed by the
OS, not by SQL Server. However, from what you say, I suspect you may be
thinking of replication, which is a totally different concept. Replication
allows you to keep data in sync between databases on different servers, but
it doesn't provide the failover support that clustering has.

I suggest you read the Books Online overviews on both clustering and
replication and see which suits your needs best. Log shipping might be
another option if a warm standby server is good enough for your purposes.
But if you really need high availability, you can't do it without a decent
budget and resources, so make sure you know exactly what the business
requirements are before you choose a solution.

Simon

Help!

I am trying to setup SQL server on MS Cluster Servers (with window 2003 OS).
I am always get following error during installation
"Setup failed to perform the required operation on the cluster nodes"
Base on sqlstp.log file (see below), it looks like cause by
10:35:07 C:\WINNT\TEMP\SqlSetup\Bin\remsetup.exe C:\WINNT\remsetup.ini
10:46:17 Process Exit Code: (2) The system cannot find the file specified.
Does anyone know how to solve this issue?
Thanks
Yong
10:35:07 Setup is performing required operations on cluster nodes. This may
take a few minutes...
10:35:07 C:\WINNT\TEMP\SqlSetup\Bin\remsetup.exe C:\WINNT\remsetup.ini
10:46:17 Process Exit Code: (2) The system cannot find the file specified.
10:46:17 Begin Action : GetRemsetupRetCode
10:46:17 Installation return status on SVMDB1 : 0
10:46:17 Installation return status on SVMDB2 : 2
10:46:17 End Action : GetRemsetupRetCode
#### SQL Server Remote Setup - Start Time 12/21/04 10:35:07 ####
CThreadPool::RunUntilCompleteHlpr create thread, index=0
CThread::Run thread [0x74] created for execution.
CThread::Process [0x74]
CThreadPool::RunUntilCompleteHlpr create thread, index=1
Running '\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setupsq l.exe k=Nb k=Rm
k=Cl -SMS -s -f "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
\\SVMDB1\admin$\SVMDB1_SVMOBILE.iss -f2 "\\SVMDB1\admin$\setup.log" -e
"stpsilnt._ex" -b -x "C:\WINNT\TEMP\"' (SVMDB1) ...
CThread::Run thread [0x78] created for execution.
CThread::Process [0x78]
CThreadPool::RunUntilCompleteHlpr start thread [0x74],index=0
CThreadPool::RunUntilCompleteHlpr start thread [0x78],index=1
Script file copied to '\\SVMDB2\ADMIN$\SVMDB2_SVMOBILE.iss' successfully.
Installing remote service (SVMDB2)...
Running '\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setupsq l.exe k=ClSec k=Rm
k=Cl -SMS -s -f "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
\\SVMDB2\ADMIN$\SVMDB2_SVMOBILE.iss -f2 "\\SVMDB2\admin$\setup.log" -e
"stpsilnt._ex" -x "C:\"' (SVMDB2) ...
CProcess::RunUntilComplete [0x74] exit code: 0
Remote process exit code was '0' (SVMDB1).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x74]
Thread [0x74] exit code: [0x0]
CRemoteProcess::RunUntilComplete [0x78] exit code: 2
Remote process exit code was '2' (SVMDB2).
CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
CThreadPool::RunUntilCompleteHlpr signaled thread [0x78]
Thread [0x78] exit code: [0x2]
CThreadPool::RunUntilComplete returned 2
CThreadPool::RunUntilComplete execution level=1, need execution: 0
One or more errors occurred while running the remote/unattended setups.
Disconnecting from remote machine (SVMDB1)...
Service removed successfully.
Remote files could not be removed.
#### SQL Server Remote Setup - Stop Time 12/21/04 10:45:59 ####
Disconnecting from remote machine (SVMDB2)...
Service removed successfully.
Remote files removed successfully.
#### SQL Server Remote Setup - Stop Time 12/21/04 10:46:16 ####
Have you tried coping the media onto the shared disk and running the install
from there? Have you already reboot both nodes? Make sure you reboot the
controlling node after any failure.
This should fix your issue.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Yong Zou (SearchIgnite)" <yz@.yz.com> wrote in message
news:eqpoTY35EHA.1596@.tk2msftngp13.phx.gbl...
>I am trying to setup SQL server on MS Cluster Servers (with window 2003
>OS).
> I am always get following error during installation
> "Setup failed to perform the required operation on the cluster nodes"
> Base on sqlstp.log file (see below), it looks like cause by
> 10:35:07 C:\WINNT\TEMP\SqlSetup\Bin\remsetup.exe C:\WINNT\remsetup.ini
> 10:46:17 Process Exit Code: (2) The system cannot find the file specified.
> Does anyone know how to solve this issue?
> Thanks
> Yong
> 10:35:07 Setup is performing required operations on cluster nodes. This
> may
> take a few minutes...
> 10:35:07 C:\WINNT\TEMP\SqlSetup\Bin\remsetup.exe C:\WINNT\remsetup.ini
> 10:46:17 Process Exit Code: (2) The system cannot find the file specified.
> 10:46:17 Begin Action : GetRemsetupRetCode
> 10:46:17 Installation return status on SVMDB1 : 0
> 10:46:17 Installation return status on SVMDB2 : 2
> 10:46:17 End Action : GetRemsetupRetCode
> #### SQL Server Remote Setup - Start Time 12/21/04 10:35:07 ####
> CThreadPool::RunUntilCompleteHlpr create thread, index=0
> CThread::Run thread [0x74] created for execution.
> CThread::Process [0x74]
> CThreadPool::RunUntilCompleteHlpr create thread, index=1
> Running '\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setupsq l.exe k=Nb k=Rm
> k=Cl -SMS -s -f "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
> \\SVMDB1\admin$\SVMDB1_SVMOBILE.iss -f2 "\\SVMDB1\admin$\setup.log" -e
> "stpsilnt._ex" -b -x "C:\WINNT\TEMP\"' (SVMDB1) ...
> CThread::Run thread [0x78] created for execution.
> CThread::Process [0x78]
> CThreadPool::RunUntilCompleteHlpr start thread [0x74],index=0
> CThreadPool::RunUntilCompleteHlpr start thread [0x78],index=1
> Script file copied to '\\SVMDB2\ADMIN$\SVMDB2_SVMOBILE.iss' successfully.
> Installing remote service (SVMDB2)...
> Running '\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setupsq l.exe k=ClSec
> k=Rm
> k=Cl -SMS -s -f "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
> \\SVMDB2\ADMIN$\SVMDB2_SVMOBILE.iss -f2 "\\SVMDB2\admin$\setup.log" -e
> "stpsilnt._ex" -x "C:\"' (SVMDB2) ...
> CProcess::RunUntilComplete [0x74] exit code: 0
> Remote process exit code was '0' (SVMDB1).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x74]
> Thread [0x74] exit code: [0x0]
> CRemoteProcess::RunUntilComplete [0x78] exit code: 2
> Remote process exit code was '2' (SVMDB2).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x78]
> Thread [0x78] exit code: [0x2]
> CThreadPool::RunUntilComplete returned 2
> CThreadPool::RunUntilComplete execution level=1, need execution: 0
> One or more errors occurred while running the remote/unattended setups.
> Disconnecting from remote machine (SVMDB1)...
> Service removed successfully.
> Remote files could not be removed.
> #### SQL Server Remote Setup - Stop Time 12/21/04 10:45:59 ####
> Disconnecting from remote machine (SVMDB2)...
> Service removed successfully.
> Remote files removed successfully.
> #### SQL Server Remote Setup - Stop Time 12/21/04 10:46:16 ####
>
|||Yes, I tried coping the media onto the shared disk and running the
installation from there. I also reboot both nodes after failure. I still get
same error
Thanks
Yong
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23XXHAf35EHA.1264@.TK2MSFTNGP12.phx.gbl...
> Have you tried coping the media onto the shared disk and running the
install[vbcol=seagreen]
> from there? Have you already reboot both nodes? Make sure you reboot the
> controlling node after any failure.
> This should fix your issue.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Yong Zou (SearchIgnite)" <yz@.yz.com> wrote in message
> news:eqpoTY35EHA.1596@.tk2msftngp13.phx.gbl...
specified.[vbcol=seagreen]
specified.[vbcol=seagreen]
k=Rm[vbcol=seagreen]
"\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1[vbcol=seagreen]
successfully.[vbcol=seagreen]
"\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
>
|||Darn, we had that issue here last night on two new clusters, IPSEC and a
firewall in between, local copy fixed it.
Ok, try these articles:
http://support.microsoft.com/default...b;en-us;818548
http://support.microsoft.com/default...b;en-us;318672
http://support.microsoft.com/default...b;en-us;302491
http://support.microsoft.com/default...b;en-us;321063
Please let me know which if any of these fix you issue.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Yong Zou (SearchIgnite)" <yz@.yz.com> wrote in message
news:Ogix7r45EHA.1028@.TK2MSFTNGP10.phx.gbl...
> Yes, I tried coping the media onto the shared disk and running the
> installation from there. I also reboot both nodes after failure. I still
> get
> same error
> Thanks
> Yong
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23XXHAf35EHA.1264@.TK2MSFTNGP12.phx.gbl...
> install
> specified.
> specified.
> k=Rm
> "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
> successfully.
> "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
>
|||Yong,
I think you hit the issue described in following article. Most often I have
seen this issue if the network connection name contains spaces or
parenthesis e.g. it should not be "Local Area Connection" or "Local Area
Connection 1" and should be something like "PUBLIC" or "PRIVATE". If this
does not solve the issue, you can try following other workarounds mentioned
in the article.
http://support.microsoft.com/kb/302491/EN-US/
PRB: SQL Server 2000 Cluster Setup may fail to perform required operations
on the cluster nodes when special characters are used in the resource name
Hope this helps.
Regards,
Shon Shah
Software Design Engineer/Test
Microsoft Cluster Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples, if any, are subject to the terms specified
at http://www.microsoft.com/info/cpyright.htm
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.
"Yong Zou (SearchIgnite)" <yz@.yz.com> wrote in message
news:eqpoTY35EHA.1596@.tk2msftngp13.phx.gbl...
>I am trying to setup SQL server on MS Cluster Servers (with window 2003
>OS).
> I am always get following error during installation
> "Setup failed to perform the required operation on the cluster nodes"
> Base on sqlstp.log file (see below), it looks like cause by
> 10:35:07 C:\WINNT\TEMP\SqlSetup\Bin\remsetup.exe C:\WINNT\remsetup.ini
> 10:46:17 Process Exit Code: (2) The system cannot find the file specified.
> Does anyone know how to solve this issue?
> Thanks
> Yong
> 10:35:07 Setup is performing required operations on cluster nodes. This
> may
> take a few minutes...
> 10:35:07 C:\WINNT\TEMP\SqlSetup\Bin\remsetup.exe C:\WINNT\remsetup.ini
> 10:46:17 Process Exit Code: (2) The system cannot find the file specified.
> 10:46:17 Begin Action : GetRemsetupRetCode
> 10:46:17 Installation return status on SVMDB1 : 0
> 10:46:17 Installation return status on SVMDB2 : 2
> 10:46:17 End Action : GetRemsetupRetCode
> #### SQL Server Remote Setup - Start Time 12/21/04 10:35:07 ####
> CThreadPool::RunUntilCompleteHlpr create thread, index=0
> CThread::Run thread [0x74] created for execution.
> CThread::Process [0x74]
> CThreadPool::RunUntilCompleteHlpr create thread, index=1
> Running '\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setupsq l.exe k=Nb k=Rm
> k=Cl -SMS -s -f "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
> \\SVMDB1\admin$\SVMDB1_SVMOBILE.iss -f2 "\\SVMDB1\admin$\setup.log" -e
> "stpsilnt._ex" -b -x "C:\WINNT\TEMP\"' (SVMDB1) ...
> CThread::Run thread [0x78] created for execution.
> CThread::Process [0x78]
> CThreadPool::RunUntilCompleteHlpr start thread [0x74],index=0
> CThreadPool::RunUntilCompleteHlpr start thread [0x78],index=1
> Script file copied to '\\SVMDB2\ADMIN$\SVMDB2_SVMOBILE.iss' successfully.
> Installing remote service (SVMDB2)...
> Running '\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setupsq l.exe k=ClSec
> k=Rm
> k=Cl -SMS -s -f "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
> \\SVMDB2\ADMIN$\SVMDB2_SVMOBILE.iss -f2 "\\SVMDB2\admin$\setup.log" -e
> "stpsilnt._ex" -x "C:\"' (SVMDB2) ...
> CProcess::RunUntilComplete [0x74] exit code: 0
> Remote process exit code was '0' (SVMDB1).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x74]
> Thread [0x74] exit code: [0x0]
> CRemoteProcess::RunUntilComplete [0x78] exit code: 2
> Remote process exit code was '2' (SVMDB2).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x78]
> Thread [0x78] exit code: [0x2]
> CThreadPool::RunUntilComplete returned 2
> CThreadPool::RunUntilComplete execution level=1, need execution: 0
> One or more errors occurred while running the remote/unattended setups.
> Disconnecting from remote machine (SVMDB1)...
> Service removed successfully.
> Remote files could not be removed.
> #### SQL Server Remote Setup - Stop Time 12/21/04 10:45:59 ####
> Disconnecting from remote machine (SVMDB2)...
> Service removed successfully.
> Remote files removed successfully.
> #### SQL Server Remote Setup - Stop Time 12/21/04 10:46:16 ####
>
|||Thanks Shon. Looks like this is not the source of cause my problem. I also
checked SQLSTPx.Log file, and find interesting things,
14:53:12 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1\sqldbreg.ex e -RegServer
14:53:12 Process Exit Code: (-2147312566) Error loading type library/DLL.
and don't know this is cause of my problem. If it is, any idea how to avoid
this?
Thanks again for your help
Yong
14:53:02 Begin Action PostSetupRegistry:
14:53:02 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 7 -Service
MSSQL$SVM -SvcStartType 1 -SvcAccount "TestNew\Administrator" -SvcEPwd
14:53:03 Process Exit Code: (0)
14:53:03 C:\WINNT\TEMP\SqlSetup\Bin\scm.exe -Silent 1 -Action 5 -Service
"SQLAgent$SVM" -Dependencies MSSQL$SVM -ExePath "C:\Program Files\Microsoft
SQL Server\MSSQL$SVM\binn\sqlagent.exe" -SvcAccount
"TestNew\Administrator" -SvcEPwd
14:53:12 Process Exit Code: (0)
14:53:12 SetupSQLExecSecurity returned: 0
14:53:12 PerfmonLoad returned: 0
14:53:12 C:\PROGRA~1\MICROS~1\80\Tools\Binn\dcomscm.exe /RegServer
14:53:12 Process Exit Code: (0)
14:53:12 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1\sqldbreg.ex e -RegServer
14:53:12 Process Exit Code: (-2147312566) Error loading type library/DLL.
14:53:12 regsvr32.exe /s "C:\PROGRA~1\MICROS~1\80\COM\repldsui.dll"
14:53:13 Process Exit Code: (0)
14:53:13 **** File registered: C:\Program Files\Microsoft SQL
Server\80\COM\repldsui.dll
"Shon Shah [MSFT]" <shonsh@.online.microsoft.com> wrote in message
news:%232xR4645EHA.1524@.TK2MSFTNGP09.phx.gbl...
> Yong,
> I think you hit the issue described in following article. Most often I
have
> seen this issue if the network connection name contains spaces or
> parenthesis e.g. it should not be "Local Area Connection" or "Local Area
> Connection 1" and should be something like "PUBLIC" or "PRIVATE". If this
> does not solve the issue, you can try following other workarounds
mentioned
> in the article.
> http://support.microsoft.com/kb/302491/EN-US/
> PRB: SQL Server 2000 Cluster Setup may fail to perform required operations
> on the cluster nodes when special characters are used in the resource name
> Hope this helps.
> --
> Regards,
> Shon Shah
> Software Design Engineer/Test
> Microsoft Cluster Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Use of included script samples, if any, are subject to the terms specified
> at http://www.microsoft.com/info/cpyright.htm
> Please do not send email directly to this alias. This alias is for
newsgroup[vbcol=seagreen]
> purposes only.
> "Yong Zou (SearchIgnite)" <yz@.yz.com> wrote in message
> news:eqpoTY35EHA.1596@.tk2msftngp13.phx.gbl...
specified.[vbcol=seagreen]
specified.[vbcol=seagreen]
m[vbcol=seagreen]
"\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1[vbcol=seagreen]
successfully.[vbcol=seagreen]
"\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
>
|||Thanks Rod, I checked all of these, and looks like it still didn't solve my
problem. Base onSQLSTPx.Log file,
14:53:12 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1\sqldbreg.ex e -RegServer
14:53:12 Process Exit Code: (-2147312566) Error loading type library/DLL.
I think this may be the cause of my issue, but don't know how to fix it
Thanks again for your helps
Yong
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:efnag445EHA.936@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Darn, we had that issue here last night on two new clusters, IPSEC and a
> firewall in between, local copy fixed it.
> Ok, try these articles:
> http://support.microsoft.com/default...b;en-us;818548
> http://support.microsoft.com/default...b;en-us;318672
> http://support.microsoft.com/default...b;en-us;302491
> http://support.microsoft.com/default...b;en-us;321063
> Please let me know which if any of these fix you issue.
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "Yong Zou (SearchIgnite)" <yz@.yz.com> wrote in message
> news:Ogix7r45EHA.1028@.TK2MSFTNGP10.phx.gbl...
the[vbcol=seagreen]
2003[vbcol=seagreen]
C:\WINNT\remsetup.ini[vbcol=seagreen]
C:\WINNT\remsetup.ini[vbcol=seagreen]
"\\SVMDB1\admin$\setup.log" -e[vbcol=seagreen]
k=ClSec[vbcol=seagreen]
"\\SVMDB2\admin$\setup.log" -e[vbcol=seagreen]
setups.
>
|||Please check this one out
http://support.microsoft.com/default...;en-us;810343, sure sounds
promising.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Yong Zou (SearchIgnite)" <yz@.yz.com> wrote in message
news:%230lmyq55EHA.3828@.TK2MSFTNGP09.phx.gbl...
> Thanks Rod, I checked all of these, and looks like it still didn't solve
> my
> problem. Base onSQLSTPx.Log file,
> 14:53:12 C:\PROGRA~1\COMMON~1\MICROS~1\SQLDEB~1\sqldbreg.ex e -RegServer
> 14:53:12 Process Exit Code: (-2147312566) Error loading type library/DLL.
> I think this may be the cause of my issue, but don't know how to fix it
> Thanks again for your helps
> Yong
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:efnag445EHA.936@.TK2MSFTNGP12.phx.gbl...
> the
> 2003
> C:\WINNT\remsetup.ini
> C:\WINNT\remsetup.ini
> "\\SVMDB1\admin$\setup.log" -e
> k=ClSec
> "\\SVMDB2\admin$\setup.log" -e
> setups.
>
|||It might be time to call PSS.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"Yong Zou (SearchIgnite)" <yz@.yz.com> wrote in message
news:OiAEC9D6EHA.1188@.tk2msftngp13.phx.gbl...
> Rod,
> Thanks again for your help. Still have problem.. Also this is happening
> before I apply SP3a. Any other suggestions?
> Yong
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:ukYtaZ75EHA.2540@.TK2MSFTNGP09.phx.gbl...
> sounds
> library/DLL.
> a
> k=Nb
> 0
> 0
>
|||Was one system an upgrade from Win 2000 and another one built from scratch?
The C:\WINNT folder is the old name. Windows server 2003 uses C:\Windows as
the default system folder name. Setup expects a parallel folder structure
on all nodes.
Also, make sure your TMP and TEMP system variables are set on all nodes to a
valid folder. Finally, log into the console of each node using all accounts
involoved (Setup Launch, Cluster, and SQL Service accounts.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Yong Zou (SearchIgnite)" <yz@.yz.com> wrote in message
news:eqpoTY35EHA.1596@.tk2msftngp13.phx.gbl...
> I am trying to setup SQL server on MS Cluster Servers (with window 2003
OS).
> I am always get following error during installation
> "Setup failed to perform the required operation on the cluster nodes"
> Base on sqlstp.log file (see below), it looks like cause by
> 10:35:07 C:\WINNT\TEMP\SqlSetup\Bin\remsetup.exe C:\WINNT\remsetup.ini
> 10:46:17 Process Exit Code: (2) The system cannot find the file specified.
> Does anyone know how to solve this issue?
> Thanks
> Yong
> 10:35:07 Setup is performing required operations on cluster nodes. This
may
> take a few minutes...
> 10:35:07 C:\WINNT\TEMP\SqlSetup\Bin\remsetup.exe C:\WINNT\remsetup.ini
> 10:46:17 Process Exit Code: (2) The system cannot find the file specified.
> 10:46:17 Begin Action : GetRemsetupRetCode
> 10:46:17 Installation return status on SVMDB1 : 0
> 10:46:17 Installation return status on SVMDB2 : 2
> 10:46:17 End Action : GetRemsetupRetCode
> #### SQL Server Remote Setup - Start Time 12/21/04 10:35:07 ####
> CThreadPool::RunUntilCompleteHlpr create thread, index=0
> CThread::Run thread [0x74] created for execution.
> CThread::Process [0x74]
> CThreadPool::RunUntilCompleteHlpr create thread, index=1
> Running '\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setupsq l.exe k=Nb k=Rm
> k=Cl -SMS -s -f "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
> \\SVMDB1\admin$\SVMDB1_SVMOBILE.iss -f2 "\\SVMDB1\admin$\setup.log" -e
> "stpsilnt._ex" -b -x "C:\WINNT\TEMP\"' (SVMDB1) ...
> CThread::Run thread [0x78] created for execution.
> CThread::Process [0x78]
> CThreadPool::RunUntilCompleteHlpr start thread [0x74],index=0
> CThreadPool::RunUntilCompleteHlpr start thread [0x78],index=1
> Script file copied to '\\SVMDB2\ADMIN$\SVMDB2_SVMOBILE.iss' successfully.
> Installing remote service (SVMDB2)...
> Running '\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setupsq l.exe k=ClSec
k=Rm
> k=Cl -SMS -s -f "\\SVMDB1\N$\ENGLISH\SQL2000\ENT\x86\setup\setup.i ns" -f1
> \\SVMDB2\ADMIN$\SVMDB2_SVMOBILE.iss -f2 "\\SVMDB2\admin$\setup.log" -e
> "stpsilnt._ex" -x "C:\"' (SVMDB2) ...
> CProcess::RunUntilComplete [0x74] exit code: 0
> Remote process exit code was '0' (SVMDB1).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x74]
> Thread [0x74] exit code: [0x0]
> CRemoteProcess::RunUntilComplete [0x78] exit code: 2
> Remote process exit code was '2' (SVMDB2).
> CThreadPool::RunUntilCompleteHlpr WaitForMultipleObjects returned: 0
> CThreadPool::RunUntilCompleteHlpr signaled thread [0x78]
> Thread [0x78] exit code: [0x2]
> CThreadPool::RunUntilComplete returned 2
> CThreadPool::RunUntilComplete execution level=1, need execution: 0
> One or more errors occurred while running the remote/unattended setups.
> Disconnecting from remote machine (SVMDB1)...
> Service removed successfully.
> Remote files could not be removed.
> #### SQL Server Remote Setup - Stop Time 12/21/04 10:45:59 ####
> Disconnecting from remote machine (SVMDB2)...
> Service removed successfully.
> Remote files removed successfully.
> #### SQL Server Remote Setup - Stop Time 12/21/04 10:46:16 ####
>

Help with UPDATE trigger

I am trying to setup a trigger that sends an email if a field is changed to specific data. The trigger works when ever the field is changed, but I only need an email if the field is changed to 'In Review'
Any help is greatly appreciated.

-- Create the trigger
CREATE TRIGGER reviewntc

--indicate which table the trigger is to be executed on
ON CltDue

--indicate that this an UPDATE Trigger
FOR UPDATE
AS

IF UPDATE(CDSTATUS)
BEGIN
--holds the changes
declare @.CDStatus varchar(40), @.CDClientName varchar (40), @.CDEventDesc varchar (40)
--grabs the data that we need
SELECT @.CDStatus = CDStatus, @.CDClientName = CDClientName, @.CDEventDesc = CDEventDesc
FROM inserted
declare @.rc int, @.mymessage nvarchar(4000), @.mysubject varchar (4000)
SET @.mymessage = N'The '+@.CDClientName+' "'+@.CDEventDesc+'" project has been changed to '+@.CDStatus+''
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'sender@.domain.com',
@.FROM_NAME = N'sender',
@.TO = N'rcpt@.domain.com',
@.subject = N'A project has been changed to "In review"',
@.message = @.mymessage,
@.type = N'text/plain',
@.server = N'email serverl'
select RC = @.rc
END

goYou need to check for the updated value.|||I'm sorry, but I am new to SQL.
Where and how do I insert CHECK|||Got it.

I added an IF
Here is the code I have if anyone needs

-- Drop the trigger if it already exists
IF EXISTS(
SELECT *
FROM dbo.sysobjects
WHERE id = object_id(N'[reviewntc]') AND
OBJECTPROPERTY(id, N'IsTrigger') = 1)
DROP TRIGGER [reviewntc]
GO

-- Create the trigger
CREATE TRIGGER reviewntc

--indicate which table the trigger is to be executed on
ON CltDue

--indicate that this an UPDATE Trigger
FOR UPDATE
AS

IF UPDATE(CDSTATUS)
BEGIN
set nocount on
--holds the changes
declare @.CDStatus varchar(40), @.CDClientName varchar (40), @.CDEventDesc varchar (40)
--grabs the data that we need
SELECT @.CDStatus = CDStatus, @.CDClientName = CDClientName, @.CDEventDesc = CDEventDesc
FROM inserted
IF @.CDStatus = 'In Review'
BEGIN
declare @.rc int, @.mymessage nvarchar(4000), @.mysubject varchar (4000)
SET @.mymessage = N'The '+@.CDClientName+' "'+@.CDEventDesc+'" project has been changed to '+@.CDStatus+''
exec @.rc = master.dbo.xp_smtp_sendmail
@.FROM = N'sender@.domain',
@.FROM_NAME = N'sender',
@.TO = N'rcpt@.domain',
@.subject = N'A project has been changed to "In review"',
@.message = @.mymessage,
@.type = N'text/plain',
@.server = N'email server'
select RC = @.rc

END
END
go