While registering sqlserver group I am getting the following
error message
"You must upgrade your SQL Enterprise Manager and SQL DMO (SQL-OLE) to SQL server (SQL DMO) to connect to server."
Can any one please guide me how to overcome this proble.
thanx regardsLook at Knowledge Base Article:
HOW TO: Administer Different Versions of SQL Server by Using SQL Server Enterprise Manager (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q225/5/45.asp&NoWebContent=1)sqlsql
Showing posts with label registering. Show all posts
Showing posts with label registering. Show all posts
Thursday, March 22, 2012
Friday, February 10, 2012
Connection problem when registering a remote SQL2000
Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
In that network , port 1433 is open and what it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 !!!
Any idea ?
If you can you use Enterprise Manager from the W2003 server, please check
the following:
Launch the Properties dialog from the server object of Enterprise Manager
Select the Network Configuration button on the General tab
Is TCP/IP enabled?
Select the Connections tab
Is the Query time-out value set too low?
Is the maximum concurrent user connections value set too low?
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
Keith Wilson
"Charles" <ccolell@.softeng.es> wrote in message
news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> Hello,
> I try to register a remote SQL Server 2000 installed in a W2003, but it
> doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
> In that network , port 1433 is open and what it really surpises me, is
that
> I can connect via ODBC to any database of that remote SQL Server2000 !!!
> Any idea ?
>
|||Hello,
Yes , everything is ok. TCP/IP is enabled, and the rest values, the query
time is 600 (the default value), and the maximum users is (0, the default
value which means that are unlimited).
Any other idea ?
"Keith Wilson" <keithwi@.online.microsoft.com> escribi en el mensaje
news:4074336d$1@.news.microsoft.com...
> If you can you use Enterprise Manager from the W2003 server, please check
> the following:
> Launch the Properties dialog from the server object of Enterprise
Manager
> Select the Network Configuration button on the General tab
> Is TCP/IP enabled?
> Select the Connections tab
> Is the Query time-out value set too low?
> Is the maximum concurrent user connections value set too low?
>
> This posting is provided "AS IS" without express or implied warranty,
> guarantee, or rights.
> Keith Wilson
>
> "Charles" <ccolell@.softeng.es> wrote in message
> news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> that
>
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
In that network , port 1433 is open and what it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 !!!
Any idea ?
If you can you use Enterprise Manager from the W2003 server, please check
the following:
Launch the Properties dialog from the server object of Enterprise Manager
Select the Network Configuration button on the General tab
Is TCP/IP enabled?
Select the Connections tab
Is the Query time-out value set too low?
Is the maximum concurrent user connections value set too low?
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
Keith Wilson
"Charles" <ccolell@.softeng.es> wrote in message
news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> Hello,
> I try to register a remote SQL Server 2000 installed in a W2003, but it
> doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
> In that network , port 1433 is open and what it really surpises me, is
that
> I can connect via ODBC to any database of that remote SQL Server2000 !!!
> Any idea ?
>
|||Hello,
Yes , everything is ok. TCP/IP is enabled, and the rest values, the query
time is 600 (the default value), and the maximum users is (0, the default
value which means that are unlimited).
Any other idea ?
"Keith Wilson" <keithwi@.online.microsoft.com> escribi en el mensaje
news:4074336d$1@.news.microsoft.com...
> If you can you use Enterprise Manager from the W2003 server, please check
> the following:
> Launch the Properties dialog from the server object of Enterprise
Manager
> Select the Network Configuration button on the General tab
> Is TCP/IP enabled?
> Select the Connections tab
> Is the Query time-out value set too low?
> Is the maximum concurrent user connections value set too low?
>
> This posting is provided "AS IS" without express or implied warranty,
> guarantee, or rights.
> Keith Wilson
>
> "Charles" <ccolell@.softeng.es> wrote in message
> news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> that
>
Connection problem when registering a remote SQL2000
Hello,
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
In that network , port 1433 is open and what it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 !!!
Any idea ?If you can you use Enterprise Manager from the W2003 server, please check
the following:
Launch the Properties dialog from the server object of Enterprise Manager
Select the Network Configuration button on the General tab
Is TCP/IP enabled?
Select the Connections tab
Is the Query time-out value set too low?
Is the maximum concurrent user connections value set too low?
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
Keith Wilson
"Charles" <ccolell@.softeng.es> wrote in message
news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> Hello,
> I try to register a remote SQL Server 2000 installed in a W2003, but it
> doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
> In that network , port 1433 is open and what it really surpises me, is
that
> I can connect via ODBC to any database of that remote SQL Server2000 !!!
> Any idea ?
>|||Hello,
Yes , everything is ok. TCP/IP is enabled, and the rest values, the query
time is 600 (the default value), and the maximum users is (0, the default
value which means that are unlimited).
Any other idea ?
"Keith Wilson" <keithwi@.online.microsoft.com> escribi en el mensaje
news:4074336d$1@.news.microsoft.com...
> If you can you use Enterprise Manager from the W2003 server, please check
> the following:
> Launch the Properties dialog from the server object of Enterprise
Manager
> Select the Network Configuration button on the General tab
> Is TCP/IP enabled?
> Select the Connections tab
> Is the Query time-out value set too low?
> Is the maximum concurrent user connections value set too low?
>
> This posting is provided "AS IS" without express or implied warranty,
> guarantee, or rights.
> Keith Wilson
>
> "Charles" <ccolell@.softeng.es> wrote in message
> news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> that
>
I try to register a remote SQL Server 2000 installed in a W2003, but it
doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
In that network , port 1433 is open and what it really surpises me, is that
I can connect via ODBC to any database of that remote SQL Server2000 !!!
Any idea ?If you can you use Enterprise Manager from the W2003 server, please check
the following:
Launch the Properties dialog from the server object of Enterprise Manager
Select the Network Configuration button on the General tab
Is TCP/IP enabled?
Select the Connections tab
Is the Query time-out value set too low?
Is the maximum concurrent user connections value set too low?
This posting is provided "AS IS" without express or implied warranty,
guarantee, or rights.
Keith Wilson
"Charles" <ccolell@.softeng.es> wrote in message
news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> Hello,
> I try to register a remote SQL Server 2000 installed in a W2003, but it
> doesn't work. Afer 6 or 7 seconds, it says: Timeout expired.
> In that network , port 1433 is open and what it really surpises me, is
that
> I can connect via ODBC to any database of that remote SQL Server2000 !!!
> Any idea ?
>|||Hello,
Yes , everything is ok. TCP/IP is enabled, and the rest values, the query
time is 600 (the default value), and the maximum users is (0, the default
value which means that are unlimited).
Any other idea ?
"Keith Wilson" <keithwi@.online.microsoft.com> escribi en el mensaje
news:4074336d$1@.news.microsoft.com...
> If you can you use Enterprise Manager from the W2003 server, please check
> the following:
> Launch the Properties dialog from the server object of Enterprise
Manager
> Select the Network Configuration button on the General tab
> Is TCP/IP enabled?
> Select the Connections tab
> Is the Query time-out value set too low?
> Is the maximum concurrent user connections value set too low?
>
> This posting is provided "AS IS" without express or implied warranty,
> guarantee, or rights.
> Keith Wilson
>
> "Charles" <ccolell@.softeng.es> wrote in message
> news:eGpQpjJHEHA.3576@.tk2msftngp13.phx.gbl...
> that
>
Subscribe to:
Posts (Atom)