Remote server

Use the IP number and PORT instead of the server name. (Of course, that
assumes that the server is availalbe through the firewall and that the port
you indicate is open to the server.)
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Raul Romero" <rcoronado@.info-arch.com> wrote in message
news:Ooj9pbRnGHA.4816@.TK2MSFTNGP04.phx.gbl...
> Good morning ...
> I need to add a remote server (in another country) to my enterprise
> manager.
> I tried to add it like a local server (inside my network) but doesn't
> work.
> Please, could anybody provide me the steps to do that.
> Thank you for your help,
> Regards,
> Raul.
>Thank you for your answer Arnie ...
I am using IP number to add the servers.
We have two servers in the same city, both servers have a public IP, i tried
to add the servers
in both places (Added server A in B enterprise manager console and B in A
enterprise manager
console), however this only works in one direction, I checked the properties
in both servers and
they are the same, the services running are the same also. Do you have any
idea ?.
Thank you for your help,
Regards,
Raul.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:ewFvj$RnGHA.4328@.TK2MSFTNGP04.phx.gbl...
> Use the IP number and PORT instead of the server name. (Of course, that
> assumes that the server is availalbe through the firewall and that the
port
> you indicate is open to the server.)
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Raul Romero" <rcoronado@.info-arch.com> wrote in message
> news:Ooj9pbRnGHA.4816@.TK2MSFTNGP04.phx.gbl...
>|||Check that the firewall ports are open to allow traffic in on both sides.
You 'should' add a firewall rule that restricts access to that port to only
the remote server IP.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Raul Romero" <rcoronado@.info-arch.com> wrote in message
news:OVidspSnGHA.2128@.TK2MSFTNGP02.phx.gbl...
> Thank you for your answer Arnie ...
> I am using IP number to add the servers.
> We have two servers in the same city, both servers have a public IP, i
> tried
> to add the servers
> in both places (Added server A in B enterprise manager console and B in A
> enterprise manager
> console), however this only works in one direction, I checked the
> properties
> in both servers and
> they are the same, the services running are the same also. Do you have any
> idea ?.
> Thank you for your help,
> Regards,
> Raul.
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:ewFvj$RnGHA.4328@.TK2MSFTNGP04.phx.gbl...
> port
>|||Good morning ...
I need to add a remote server (in another country) to my enterprise manager.
I tried to add it like a local server (inside my network) but doesn't work.
Please, could anybody provide me the steps to do that.
Thank you for your help,
Regards,
Raul.|||Use the IP number and PORT instead of the server name. (Of course, that
assumes that the server is availalbe through the firewall and that the port
you indicate is open to the server.)
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Raul Romero" <rcoronado@.info-arch.com> wrote in message
news:Ooj9pbRnGHA.4816@.TK2MSFTNGP04.phx.gbl...
> Good morning ...
> I need to add a remote server (in another country) to my enterprise
> manager.
> I tried to add it like a local server (inside my network) but doesn't
> work.
> Please, could anybody provide me the steps to do that.
> Thank you for your help,
> Regards,
> Raul.
>|||Thank you for your answer Arnie ...
I am using IP number to add the servers.
We have two servers in the same city, both servers have a public IP, i tried
to add the servers
in both places (Added server A in B enterprise manager console and B in A
enterprise manager
console), however this only works in one direction, I checked the properties
in both servers and
they are the same, the services running are the same also. Do you have any
idea ?.
Thank you for your help,
Regards,
Raul.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:ewFvj$RnGHA.4328@.TK2MSFTNGP04.phx.gbl...
> Use the IP number and PORT instead of the server name. (Of course, that
> assumes that the server is availalbe through the firewall and that the
port
> you indicate is open to the server.)
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Raul Romero" <rcoronado@.info-arch.com> wrote in message
> news:Ooj9pbRnGHA.4816@.TK2MSFTNGP04.phx.gbl...
>|||Check that the firewall ports are open to allow traffic in on both sides.
You 'should' add a firewall rule that restricts access to that port to only
the remote server IP.
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Raul Romero" <rcoronado@.info-arch.com> wrote in message
news:OVidspSnGHA.2128@.TK2MSFTNGP02.phx.gbl...
> Thank you for your answer Arnie ...
> I am using IP number to add the servers.
> We have two servers in the same city, both servers have a public IP, i
> tried
> to add the servers
> in both places (Added server A in B enterprise manager console and B in A
> enterprise manager
> console), however this only works in one direction, I checked the
> properties
> in both servers and
> they are the same, the services running are the same also. Do you have any
> idea ?.
> Thank you for your help,
> Regards,
> Raul.
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:ewFvj$RnGHA.4328@.TK2MSFTNGP04.phx.gbl...
> port
>

Remote connection problems

Hi
I'm having problems connecting remotely to my sql 2005 server
sql instance is atl64\compaq
ip is x
and i would like to use a different port let's say 62322
how do i configure my server and how do i connect using either sql
query analyzer or Sql server management studio
i tried to :
set the port to 62322 in sql server configuration manager
set local and remote connection using tcp/ip only in remote connection
in surface area connection
i tried to connect to server management studio with
server name : ipadress,62322
or
server name : ipadress:62322
both not working
i still get error ... sql does not allow remote connection ...
any help
thanks
Forgot to mention
xp firewall if off
router will route port 62322 to 1433 (i tried with routing and without
nothing works)
also what would be the correct server name to connect using a different
port ?
servername,port
or
servername:port
thanks
frederic.nou...@.gmail.com wrote:
> Hi
> I'm having problems connecting remotely to my sql 2005 server
> sql instance is atl64\compaq
> ip is x
> and i would like to use a different port let's say 62322
> how do i configure my server and how do i connect using either sql
> query analyzer or Sql server management studio
> i tried to :
> set the port to 62322 in sql server configuration manager
> set local and remote connection using tcp/ip only in remote connection
> in surface area connection
> i tried to connect to server management studio with
> server name : ipadress,62322
> or
> server name : ipadress:62322
> both not working
> i still get error ... sql does not allow remote connection ...
> any help
> thanks
|||The "sql does not allow remote connection" error makes me think that you
need to restart SQL Server. It doesn't listen on the new port until
restarted.
Also, you can check the error log to see what port it's listening on.
servername,port should do the trick.
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
<frederic.nourry@.gmail.com> wrote in message
news:1138697240.871053.309700@.g44g2000cwa.googlegr oups.com...
> Forgot to mention
> xp firewall if off
> router will route port 62322 to 1433 (i tried with routing and without
> nothing works)
> also what would be the correct server name to connect using a different
> port ?
> servername,port
> or
> servername:port
> thanks
>
> frederic.nou...@.gmail.com wrote:
>
|||Thanks Rick
looking at the event viewer I found that the server is listening to
2414
change to server,2414 worked fine
i noticed that, that is the port configured under IPAll, dynamic ports
in server configuration manager
shouldn't i change the port for ip1 and ip2 ?
thanks now i can work
|||This is a confusing aspect of the tool. If the TCP/IP Properties, Protocol
tab has Listen All as Yes, then the individual settings for IP1 and IP2 are
not necessary. If you want to make do different things, you must first
change Listen All to No, and then change the IP settings.
And since one of the IP addresses is the loopback adapter 127.0.0.1, which
isn't visible over the network, you can ignore that. So right now, it sounds
like you are listening on dynamic ports and it is currently listening on
port 2414. If you stop and restart SQL Server, it might come up on a
different port. If that's a problem, remove the 0 from TCP Dynamic Ports,
and pick a port number you like, and then restart SQL Server.
Sorry this is confusing. SP1 will have some new wording in the help topic to
try and clarify this. (No, I don't know when SP1 will be released. <g>)
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
<frederic.nourry@.gmail.com> wrote in message
news:1138768634.322274.24780@.o13g2000cwo.googlegro ups.com...
> Thanks Rick
> looking at the event viewer I found that the server is listening to
> 2414
> change to server,2414 worked fine
> i noticed that, that is the port configured under IPAll, dynamic ports
> in server configuration manager
> shouldn't i change the port for ip1 and ip2 ?
> thanks now i can work
>

remote connection error SQL2005

I am trying to connect to a remote 2005 SQL server “A” from my 2005 SQL Server Management Studio on a different network. I have opened up port 1433 on the remote server A. I have made sure that “Allow remote connections to this server” is checked on the remote server properties under connections. I have also chosen “Using both TCP/IP and named pipes” under Remote Connections in the SQL Server 2005 Surface Area Configuration.

I am using \\xxx.xxx.xxx.xxx\sqlservername and user sa to connect. I get the following error: “An error has occurred while establishing a connection to the server. When connecting to the SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 5 – Invalid parameter(s) found) (Microsoft SQL Server, Error:87)”

If I take out the \\ from the server path I get an error that the server not found. So I think I am getting to the server.

I have run SQL profiler and there is no event or failed login on the remote server when I try to connect to SQL server A. SQL Server A is on Windows2003 with all current patches. I have tried connecting from Windows XP pro and Windows2003 server.

Is this a network issue, Windows2003 issue, or a SQL issue?

If the server path starts with \\ the client stack assumes the connection is intended over Named Pipes, which requires the full pipe name specification, which is not the case in the above example, hence, the error "Invalid parameter(s) found".

The solution depends on whether the SQL Server is installed as a "default" or a "named" instance:

(1) For a default instance: specify the server by either (a) the server's machine name only (no \\ or \), or (b) the server machine's IP address only (again, no \\ or \).

(2) For a "named" instance:

- specify the server as either (a) machineName\instanceName, or (b) ipAddress\instanceName. Note that if you installed the Express edition it is installed as named instance with name SQLEXPRESS by default.

- grant firewall expection for the sqlservr.exe processes.

- start SQL Browser service on the server's machine.

- grant firewall expection for the sqlbrowser.exe processes.

|||This worked! Thank you!|||

I also can't connect to my SQL Server Express, running on xxx.xxx.xxx.xxx. I tryed out everything! F***

Could you write out a complete connection string, pls? I tryed:

string strConn = "Data Source=xxx.xxx.xxx.xxx; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

string strConn = "Data Source=servername; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

|||

I am facing a similar problem.

I have Microsoft SQL Server 2005 Express (Named Instance:=01HW050876\SQLEXPRESS) in my machine (OS : Windows XP). I am using ADO in Visual Basic 6 to connect to the database. I use SQL Server Authentication to connect to ther server. It works fine if I connect from my machine. However, if i try to connect from a different machine I get the following error:

Unhandled Error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Here is my connection string:

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=01HW050876\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

I have also used the Ip address

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=xxx.xxx.xxx.xxx\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

The other computer is also in the same network and I was able to ping my machine from there. I have also set the login mode of the SQLServer to Mixed mode in the registry and have added the user from the other machine to the database and have given access rights.

Could you help me to track down the problem

|||

Shasur

This blog can help you.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

remote connection error SQL2005

I am trying to connect to a remote 2005 SQL server “A” from my 2005 SQL Server Management Studio on a different network. I have opened up port 1433 on the remote server A. I have made sure that “Allow remote connections to this server” is checked on the remote server properties under connections. I have also chosen “Using both TCP/IP and named pipes” under Remote Connections in the SQL Server 2005 Surface Area Configuration.

I am using \\xxx.xxx.xxx.xxx\sqlservername and user sa to connect. I get the following error: “An error has occurred while establishing a connection to the server. When connecting to the SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 5 – Invalid parameter(s) found) (Microsoft SQL Server, Error:87)”

If I take out the \\ from the server path I get an error that the server not found. So I think I am getting to the server.

I have run SQL profiler and there is no event or failed login on the remote server when I try to connect to SQL server A. SQL Server A is on Windows2003 with all current patches. I have tried connecting from Windows XP pro and Windows2003 server.

Is this a network issue, Windows2003 issue, or a SQL issue?

If the server path starts with \\ the client stack assumes the connection is intended over Named Pipes, which requires the full pipe name specification, which is not the case in the above example, hence, the error "Invalid parameter(s) found".

The solution depends on whether the SQL Server is installed as a "default" or a "named" instance:

(1) For a default instance: specify the server by either (a) the server's machine name only (no \\ or \), or (b) the server machine's IP address only (again, no \\ or \).

(2) For a "named" instance:

- specify the server as either (a) machineName\instanceName, or (b) ipAddress\instanceName. Note that if you installed the Express edition it is installed as named instance with name SQLEXPRESS by default.

- grant firewall expection for the sqlservr.exe processes.

- start SQL Browser service on the server's machine.

- grant firewall expection for the sqlbrowser.exe processes.

|||This worked! Thank you!|||

I also can't connect to my SQL Server Express, running on xxx.xxx.xxx.xxx. I tryed out everything! F***

Could you write out a complete connection string, pls? I tryed:

string strConn = "Data Source=xxx.xxx.xxx.xxx; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

string strConn = "Data Source=servername; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

|||

I am facing a similar problem.

I have Microsoft SQL Server 2005 Express (Named Instance:=01HW050876\SQLEXPRESS) in my machine (OS : Windows XP). I am using ADO in Visual Basic 6 to connect to the database. I use SQL Server Authentication to connect to ther server. It works fine if I connect from my machine. However, if i try to connect from a different machine I get the following error:

Unhandled Error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Here is my connection string:

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=01HW050876\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

I have also used the Ip address

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=xxx.xxx.xxx.xxx\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

The other computer is also in the same network and I was able to ping my machine from there. I have also set the login mode of the SQLServer to Mixed mode in the registry and have added the user from the other machine to the database and have given access rights.

Could you help me to track down the problem

|||

Shasur

This blog can help you.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

remote connection error SQL2005

I am trying to connect to a remote 2005 SQL server “A” from my 2005 SQL Server Management Studio on a different network. I have opened up port 1433 on the remote server A. I have made sure that “Allow remote connections to this server” is checked on the remote server properties under connections. I have also chosen “Using both TCP/IP and named pipes” under Remote Connections in the SQL Server 2005 Surface Area Configuration.

I am using \\xxx.xxx.xxx.xxx\sqlservername and user sa to connect. I get the following error: “An error has occurred while establishing a connection to the server. When connecting to the SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 5 – Invalid parameter(s) found) (Microsoft SQL Server, Error:87)”

If I take out the \\ from the server path I get an error that the server not found. So I think I am getting to the server.

I have run SQL profiler and there is no event or failed login on the remote server when I try to connect to SQL server A. SQL Server A is on Windows2003 with all current patches. I have tried connecting from Windows XP pro and Windows2003 server.

Is this a network issue, Windows2003 issue, or a SQL issue?

If the server path starts with \\ the client stack assumes the connection is intended over Named Pipes, which requires the full pipe name specification, which is not the case in the above example, hence, the error "Invalid parameter(s) found".

The solution depends on whether the SQL Server is installed as a "default" or a "named" instance:

(1) For a default instance: specify the server by either (a) the server's machine name only (no \\ or \), or (b) the server machine's IP address only (again, no \\ or \).

(2) For a "named" instance:

- specify the server as either (a) machineName\instanceName, or (b) ipAddress\instanceName. Note that if you installed the Express edition it is installed as named instance with name SQLEXPRESS by default.

- grant firewall expection for the sqlservr.exe processes.

- start SQL Browser service on the server's machine.

- grant firewall expection for the sqlbrowser.exe processes.

|||This worked! Thank you!|||

I also can't connect to my SQL Server Express, running on xxx.xxx.xxx.xxx. I tryed out everything! F***

Could you write out a complete connection string, pls? I tryed:

string strConn = "Data Source=xxx.xxx.xxx.xxx; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

string strConn = "Data Source=servername; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

|||

I am facing a similar problem.

I have Microsoft SQL Server 2005 Express (Named Instance:=01HW050876\SQLEXPRESS) in my machine (OS : Windows XP). I am using ADO in Visual Basic 6 to connect to the database. I use SQL Server Authentication to connect to ther server. It works fine if I connect from my machine. However, if i try to connect from a different machine I get the following error:

Unhandled Error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Here is my connection string:

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=01HW050876\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

I have also used the Ip address

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=xxx.xxx.xxx.xxx\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

The other computer is also in the same network and I was able to ping my machine from there. I have also set the login mode of the SQLServer to Mixed mode in the registry and have added the user from the other machine to the database and have given access rights.

Could you help me to track down the problem

|||

Shasur

This blog can help you.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

remote connection error SQL2005

I am trying to connect to a remote 2005 SQL server “A” from my 2005 SQL Server Management Studio on a different network. I have opened up port 1433 on the remote server A. I have made sure that “Allow remote connections to this server” is checked on the remote server properties under connections. I have also chosen “Using both TCP/IP and named pipes” under Remote Connections in the SQL Server 2005 Surface Area Configuration.

I am using \\xxx.xxx.xxx.xxx\sqlservername and user sa to connect. I get the following error: “An error has occurred while establishing a connection to the server. When connecting to the SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 5 – Invalid parameter(s) found) (Microsoft SQL Server, Error:87)”

If I take out the \\ from the server path I get an error that the server not found. So I think I am getting to the server.

I have run SQL profiler and there is no event or failed login on the remote server when I try to connect to SQL server A. SQL Server A is on Windows2003 with all current patches. I have tried connecting from Windows XP pro and Windows2003 server.

Is this a network issue, Windows2003 issue, or a SQL issue?

If the server path starts with \\ the client stack assumes the connection is intended over Named Pipes, which requires the full pipe name specification, which is not the case in the above example, hence, the error "Invalid parameter(s) found".

The solution depends on whether the SQL Server is installed as a "default" or a "named" instance:

(1) For a default instance: specify the server by either (a) the server's machine name only (no \\ or \), or (b) the server machine's IP address only (again, no \\ or \).

(2) For a "named" instance:

- specify the server as either (a) machineName\instanceName, or (b) ipAddress\instanceName. Note that if you installed the Express edition it is installed as named instance with name SQLEXPRESS by default.

- grant firewall expection for the sqlservr.exe processes.

- start SQL Browser service on the server's machine.

- grant firewall expection for the sqlbrowser.exe processes.

|||This worked! Thank you!|||

I also can't connect to my SQL Server Express, running on xxx.xxx.xxx.xxx. I tryed out everything! F***

Could you write out a complete connection string, pls? I tryed:

string strConn = "Data Source=xxx.xxx.xxx.xxx; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

string strConn = "Data Source=servername; Initial Catalog=table; Connect Timeout=30; User ID=xxxxxxx; Password=xxxxxxx;";

|||

I am facing a similar problem.

I have Microsoft SQL Server 2005 Express (Named Instance:=01HW050876\SQLEXPRESS) in my machine (OS : Windows XP). I am using ADO in Visual Basic 6 to connect to the database. I use SQL Server Authentication to connect to ther server. It works fine if I connect from my machine. However, if i try to connect from a different machine I get the following error:

Unhandled Error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied

Here is my connection string:

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=01HW050876\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

I have also used the Ip address

Public Const CONNECT_STRING_SQL As String = "PROVIDER=SQLOLEDB.1;SERVER=xxx.xxx.xxx.xxx\SQLEXPRESS;UID=user;PWD=sqlpwd;DATABASE=SalesWindow"

The other computer is also in the same network and I was able to ping my machine from there. I have also set the login mode of the SQLServer to Mixed mode in the registry and have added the user from the other machine to the database and have given access rights.

Could you help me to track down the problem

|||

Shasur

This blog can help you.

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx