Connectivity with a SQL instance.

Hi,
I installed on a failover cluster, one default virtual sql
server installation named SERVER1 and a other one
installation of virtual server with instance name called
server2\ufa.
When I try to connect true a firewall on SERVER1 with an
UDL file the connection is OK, but When I'm trying the
same test on SERVER2\ufa I've got this error :
[DBNETLIB][ConnectionOpen (Invalid Instance()).]
When I pinging SERVER1 it's OK, When I trying a telnet
command on IP adresse 1433 it's also OK
But on virtual SERVER2 the port 1433 is on the name
SERVER2 so when I try a command telnet SERVER2 1433 it's
OK but SERVER2\UFA is not recognize.
On the firewall the port 1433 is open for Both IP adresses
and we openned also the ports 139 and 445 for the Netbios.
( Name Pipes )
Someone can help me ?You probably need to open up port 1434 or better yet, open the Server
Network Utility on SERVER2 and set the port explicity to something other
than 1433 or 1434, then connect using the port number rather than the
instance name. This is well documented in Books on Line under firewalls.
"Pierre" <anonymous@.discussions.microsoft.com> wrote in message
news:bfde01c4086c$a9472a00$a501280a@.phx.gbl...
> Hi,
> I installed on a failover cluster, one default virtual sql
> server installation named SERVER1 and a other one
> installation of virtual server with instance name called
> server2\ufa.
> When I try to connect true a firewall on SERVER1 with an
> UDL file the connection is OK, but When I'm trying the
> same test on SERVER2\ufa I've got this error :
> [DBNETLIB][ConnectionOpen (Invalid Instance()).]
> When I pinging SERVER1 it's OK, When I trying a telnet
> command on IP adresse 1433 it's also OK
> But on virtual SERVER2 the port 1433 is on the name
> SERVER2 so when I try a command telnet SERVER2 1433 it's
> OK but SERVER2\UFA is not recognize.
> On the firewall the port 1433 is open for Both IP adresses
> and we openned also the ports 139 and 445 for the Netbios.
> ( Name Pipes )
> Someone can help me ?
>|||To be able to connect to a named instance, (both clustered and stand alone)
1) If the client has MDAC 2.5 or lower, then you have to specify the port
number when connecting and make sure this port is open at the firewall.
2)If the client has MDAC 2.6 or higher, then specify the port number when
connecting or make sure UDP port 1434 is open at the firewall (This is true
even if the named instance is listening on port 1433)
The following articles maybe helpful.
286303 INF: Behavior of SQL Server 2000 Network Library During Dynamic Port
http://support.microsoft.com/?id=286303
287932 INF: TCP Ports Needed for Communication to SQL Server Through a
Firewall
http://support.microsoft.com/?id=287932
286303 INF: Behavior of SQL Server 2000 Network Library During Dynamic Port
http://support.microsoft.com/?id=286303
265808 INF: How to Connect to an SQL Server 2000 Named Instance with the
http://support.microsoft.com/?id=265808
Thanks
Deepali
This posting is provided "AS IS" with no warranties, and confers no rights

connection to miltiple server

i want to open query with server1 = 'server1.datasource'

in this query i want to connect to 'server2.datasource '

for copy record between the servers .

can i do it with sql server management studio?

You will want to define a Linked Server

http://msdn2.microsoft.com/en-us/library/ms190479.aspx

Or use OPENDATASOURCE

http://msdn2.microsoft.com/en-us/library/ms179856.aspx

Using the Linked Server you can then reference tables with the four-part name (server.database.schema.table)

|||

gabriel_333 wrote:

can i do it with sql server management studio?

I hope you can use the OPENROWSET.

See more on Books Online regarding OPENROWSET.

|||

I HAVE AN OLE DB SYSTEM DSN = SQLDATCON

WHEN I RUN :

SELECT *

FROM OPENDATASOURCE('SQLDATCON',

'Data Source=SQLDAT;USER ID = ?;PASSWORD =?')

.DBNAME.dbo.TB_ACID

I GET MESSAGE :

Msg 7403, Level 16, State 1, Line 6

The OLE DB provider "SQLDATCON" has not been registered.

|||

Try:

SELECT *

FROM

OPENDATASOURCE('SQLOLEDB', 'dsn=SQLDATCON;USER ID = ?;PASSWORD =?').DBNAME.dbo.TB_ACID

|||

thanks a lot!

i got possitive rspond from the server :' hd hook must have administrator permission '

this is the first life signal

when i need this query i will ask administrater to enable the surface area opendatasource

connection to miltiple server

i want to open query with server1 = 'server1.datasource'

in this query i want to connect to 'server2.datasource '

for copy record between the servers .

can i do it with sql server management studio?

You will want to define a Linked Server

http://msdn2.microsoft.com/en-us/library/ms190479.aspx

Or use OPENDATASOURCE

http://msdn2.microsoft.com/en-us/library/ms179856.aspx

Using the Linked Server you can then reference tables with the four-part name (server.database.schema.table)

|||

gabriel_333 wrote:

can i do it with sql server management studio?

I hope you can use the OPENROWSET.

See more on Books Online regarding OPENROWSET.

|||

I HAVE AN OLE DB SYSTEM DSN = SQLDATCON

WHEN I RUN :

SELECT*

FROMOPENDATASOURCE('SQLDATCON',

'Data Source=SQLDAT;USER ID = ?;PASSWORD =?')

.DBNAME.dbo.TB_ACID

I GET MESSAGE :

Msg 7403, Level 16, State 1, Line 6

The OLE DB provider "SQLDATCON" has not been registered.

|||

Try:

SELECT*

FROM

OPENDATASOURCE('SQLOLEDB', 'dsn=SQLDATCON;USER ID = ?;PASSWORD =?').DBNAME.dbo.TB_ACID

|||

thanks a lot!

i got possitive rspond from the server :' hd hook must have administrator permission '

this is the first life signal

when i need this query i will ask administrater to enable the surface area opendatasource