I input for "Jump to URL".
But I don't want to open URL on same page.
Is it possible to open new window for that URL page after click one which
have a "Jump to URL".Yes it is, something like this:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?%2fJBOSC%2fJLRRS%2fworkorder%2fwondetail&WON=" & Fields!COL2.Value &
"','_blank'))"
"Ken" wrote:
> I input for "Jump to URL".
> But I don't want to open URL on same page.
> Is it possible to open new window for that URL page after click one which
> have a "Jump to URL".
>
>
Showing posts with label window. Show all posts
Showing posts with label window. Show all posts
Friday, March 30, 2012
Help!!!Cannot connect to remote sql server by named pipe
Hi, all,
I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed.
I have already enabled named pipe and tcp/ip protocol for instance SQLEXPRESS on the server, and started sql server browser as well. Of course, I also enabled local and remote connection using tcp/ip and named pipe by sql server surface area configuration tool.
In this senario, I can connect to server locally or remotely by tcp/ip and connect to server locally by named pipe(c>sqlcmd -S \\192.168.1.100\pipe\MSSQL$SQLEXPRESS\sql\query -U * -P *), but I can not connect to server remotely using same command line.
According to some article from MSDN, it might be caused by firewall, but I already disabled my firewall. Moreover, I used tools like makepipe.exe and readpipe.exe, they didn't work too. Why the 2 computers can't create connection using named pipe protocol.
Thanks.
Johonson Chan
By "remotely" what do you mean? Are you talking a VPN or across the Internet?You do not want to run named pipes across the Internet for many reasons. Named pipes use TCP port 445. Across the Internet you are subject to firewall in all the routers in between the 2 computers.
Use TCP/IP.
|||
I'm having a similar issue. As far as I can tell, all the configuration is set up correctly. The remote connection is enabled, TCP/IP is enabled, firewall is turned off. I'm trying to connecto to a database on a remote server using Sharepoint desinger and always get an error message saying 'The data retrieval service encountered an error during connection to the data source'.
Anyone had a luck with using the database connection feature in the Sharepoint designer?
Thanks.
|||I am also having a simliar issue. Running sql server 2005, trying to connect using crystal reports 8.5, get error 'unable to connect to sql server <server name>' when connecting from a machine running windows server 2003 service pack 1.
The strange this is that it connects fine when I connect using the same crystal report, version 8.5 from my PC running Windows XP service Pack 2, so it means that the sql server 2005 is configured correctly.
I can connect to the server using ODBC on the windows server 2003 machine - just not through the crystal report.
Anyone else had this issue? Or any ideas how I can solve it?
Thanks.
|||I'm having a problem too. I can connect to SQL Server 2k5 via TCP/IP on all my WinXP machines, but my WinVista machine fails. I am also not using Windows authentication because I am connecting via the Intnernet, and will not be using Windows domains.-Simon
|||
same problem trying to connect over the internet to sql server 2005 using sql server authentication .
the client is sql server 2005 and is running on vista. it worked fine from my xp box. this problem is killing me at the moment.
tcp/ip is enabled and i've tried it with and without the firewalls. aarrrrrrrrrrrrrrrrrrrggggggggggggggghhhhhhhhhhhhhhhhhhhhhhhhhhhhh
Login failed for user 'xxxxxxxx'. (.Net SqlClient Data Provider)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
Server Name: xxxxxxxxxxx,1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
Help!!!Cannot connect to remote sql server by named pipe
Hi, all,
I installed sql server 2005 express on a server with window server 2003 SP1 and tried to connect it from a remote computer with vista installed.
I have already enabled named pipe and tcp/ip protocol for instance SQLEXPRESS on the server, and started sql server browser as well. Of course, I also enabled local and remote connection using tcp/ip and named pipe by sql server surface area configuration tool.
In this senario, I can connect to server locally or remotely by tcp/ip and connect to server locally by named pipe(c>sqlcmd -S \\192.168.1.100\pipe\MSSQL$SQLEXPRESS\sql\query -U * -P *), but I can not connect to server remotely using same command line.
According to some article from MSDN, it might be caused by firewall, but I already disabled my firewall. Moreover, I used tools like makepipe.exe and readpipe.exe, they didn't work too. Why the 2 computers can't create connection using named pipe protocol.
Thanks.
Johonson Chan
By "remotely" what do you mean? Are you talking a VPN or across the Internet?You do not want to run named pipes across the Internet for many reasons. Named pipes use TCP port 445. Across the Internet you are subject to firewall in all the routers in between the 2 computers.
Use TCP/IP.
|||
I'm having a similar issue. As far as I can tell, all the configuration is set up correctly. The remote connection is enabled, TCP/IP is enabled, firewall is turned off. I'm trying to connecto to a database on a remote server using Sharepoint desinger and always get an error message saying 'The data retrieval service encountered an error during connection to the data source'.
Anyone had a luck with using the database connection feature in the Sharepoint designer?
Thanks.
|||I am also having a simliar issue. Running sql server 2005, trying to connect using crystal reports 8.5, get error 'unable to connect to sql server <server name>' when connecting from a machine running windows server 2003 service pack 1.
The strange this is that it connects fine when I connect using the same crystal report, version 8.5 from my PC running Windows XP service Pack 2, so it means that the sql server 2005 is configured correctly.
I can connect to the server using ODBC on the windows server 2003 machine - just not through the crystal report.
Anyone else had this issue? Or any ideas how I can solve it?
Thanks.
|||I'm having a problem too. I can connect to SQL Server 2k5 via TCP/IP on all my WinXP machines, but my WinVista machine fails. I am also not using Windows authentication because I am connecting via the Intnernet, and will not be using Windows domains.-Simon
|||
same problem trying to connect over the internet to sql server 2005 using sql server authentication .
the client is sql server 2005 and is running on vista. it worked fine from my xp box. this problem is killing me at the moment.
tcp/ip is enabled and i've tried it with and without the firewalls. aarrrrrrrrrrrrrrrrrrrggggggggggggggghhhhhhhhhhhhhhhhhhhhhhhhhhhhh
Login failed for user 'xxxxxxxx'. (.Net SqlClient Data Provider)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
Server Name: xxxxxxxxxxx,1433
Error Number: 18456
Severity: 14
State: 1
Line Number: 65536
Monday, February 27, 2012
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 ####
>
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 ####
>
Subscribe to:
Posts (Atom)