 | |
Added new Instance for SQL 2000 SP4
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Added new Instance for SQL 2000 SP4 -
11-06-2008
, 08:10 PM
#2
| |||
| |||
|
|
Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail over, i am getting this error in the other server when trying to fail over to the other side. the services refuse to start after that on server 2 [sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [sqsrvres] ODBC sqldriverconnect failed it keep coming out every second in my application logs and was unable to start the services from the cluster admin. when i take offline and bring it back to server 1, it is working fine without any problem. Could there be any problem with my setup? regards, leezy |
#3
| |||
| |||
|
|
Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail over, i am getting this error in the other server when trying to fail over to the other side. the services refuse to start after that on server 2 [sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [sqsrvres] ODBC sqldriverconnect failed it keep coming out every second in my application logs and was unable to start the services from the cluster admin. when i take offline and bring it back to server 1, it is working fine without any problem. Could there be any problem with my setup? regards, leezy |
#4
| |||
| |||
|
|
Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail over, i am getting this error in the other server when trying to fail over to the other side. the services refuse to start after that on server 2 [sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [sqsrvres] ODBC sqldriverconnect failed it keep coming out every second in my application logs and was unable to start the services from the cluster admin. when i take offline and bring it back to server 1, it is working fine without any problem. Could there be any problem with my setup? regards, leezy |
#5
| |||
| |||
|
|
Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail over, i am getting this error in the other server when trying to fail over to the other side. the services refuse to start after that on server 2 [sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [sqsrvres] ODBC sqldriverconnect failed it keep coming out every second in my application logs and was unable to start the services from the cluster admin. when i take offline and bring it back to server 1, it is working fine without any problem. Could there be any problem with my setup? regards, leezy |
#6
| |||
| |||
|
|
Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail over, i am getting this error in the other server when trying to fail over to the other side. the services refuse to start after that on server 2 [sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [sqsrvres] ODBC sqldriverconnect failed it keep coming out every second in my application logs and was unable to start the services from the cluster admin. when i take offline and bring it back to server 1, it is working fine without any problem. Could there be any problem with my setup? regards, leezy |
#7
| |||
| |||
|
|
Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail over, i am getting this error in the other server when trying to fail over to the other side. the services refuse to start after that on server 2 [sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [sqsrvres] ODBC sqldriverconnect failed it keep coming out every second in my application logs and was unable to start the services from the cluster admin. when i take offline and bring it back to server 1, it is working fine without any problem. Could there be any problem with my setup? regards, leezy |
#8
| |||
| |||
|
|
Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail over, i am getting this error in the other server when trying to fail over to the other side. the services refuse to start after that on server 2 [sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [sqsrvres] ODBC sqldriverconnect failed it keep coming out every second in my application logs and was unable to start the services from the cluster admin. when i take offline and bring it back to server 1, it is working fine without any problem. Could there be any problem with my setup? regards, leezy |
#9
| |||
| |||
|
|
Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail over, i am getting this error in the other server when trying to fail over to the other side. the services refuse to start after that on server 2 [sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [sqsrvres] ODBC sqldriverconnect failed it keep coming out every second in my application logs and was unable to start the services from the cluster admin. when i take offline and bring it back to server 1, it is working fine without any problem. Could there be any problem with my setup? regards, leezy |
#10
| |||
| |||
|
|
Dear all, I have added a new instance for SQL 2000 SP4 on to one of the node in the clustered server. after i have add the second server for fail over, i am getting this error in the other server when trying to fail over to the other side. the services refuse to start after that on server 2 [sqsrvres] checkODBCConnectError: sqlstate = IM002; native error = 0; message = [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [sqsrvres] ODBC sqldriverconnect failed it keep coming out every second in my application logs and was unable to start the services from the cluster admin. when i take offline and bring it back to server 1, it is working fine without any problem. Could there be any problem with my setup? regards, leezy |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.