Error connecting to remote server

[Database Administrator]

Hi

I am trying to cerate a System DSN (in ODBC Data Source Administrator) for a
remote SQL Server. I am getting the below error message;

Connection failed:
SQL State: '01000'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
Instance())
Connection failed:
SQL State: '08001'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection

What is the problem and how can I fix it?

Thanks

Regards

[Database Administrator]

On Sep 14, 4:57 pm, "John" wrote:
> Hi
>
> I am trying to cerate a System DSN (in ODBC Data Source Administrator) for a
> remote SQL Server. I am getting the below error message;
>
> Connection failed:
> SQL State: '01000'
> SQL Server Error: 14
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
> Instance())
> Connection failed:
> SQL State: '08001'
> SQL Server Error: 14
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection
>
> What is the problem and how can I fix it?
>
> Thanks
>
> Regards

the remote server isn't running sql as a named instance is it?

[Database Administrator]

Not sure. It is our web hosts which is an outside company. What should I ask
them to do?

Many Thanks

Regards

"densial" wrote in message
news:1189754261.882976.147900@r34g2000hsd.googlegr oups.com...
> On Sep 14, 4:57 pm, "John" wrote:
>> Hi
>>
>> I am trying to cerate a System DSN (in ODBC Data Source Administrator)
>> for a
>> remote SQL Server. I am getting the below error message;
>>
>> Connection failed:
>> SQL State: '01000'
>> SQL Server Error: 14
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
>> Instance())
>> Connection failed:
>> SQL State: '08001'
>> SQL Server Error: 14
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection
>>
>> What is the problem and how can I fix it?
>>
>> Thanks
>>
>> Regards
>
> the remote server isn't running sql as a named instance is it?
>

[Database Administrator]

We are trying to access the SQL Server from behind an ISA 2004 firewall.
Even though I have created a rule for port 1433 on ISA 2004, I wonder if
there is something still missing at the ISA 2004 that I need to do.

Many Thanks

Regards

"densial" wrote in message
news:1189754261.882976.147900@r34g2000hsd.googlegr oups.com...
> On Sep 14, 4:57 pm, "John" wrote:
>> Hi
>>
>> I am trying to cerate a System DSN (in ODBC Data Source Administrator)
>> for a
>> remote SQL Server. I am getting the below error message;
>>
>> Connection failed:
>> SQL State: '01000'
>> SQL Server Error: 14
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
>> Instance())
>> Connection failed:
>> SQL State: '08001'
>> SQL Server Error: 14
>> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection
>>
>> What is the problem and how can I fix it?
>>
>> Thanks
>>
>> Regards
>
> the remote server isn't running sql as a named instance is it?
>

[Database Administrator]

On Sep 14, 8:49 pm, "John" wrote:
> We are trying to access the SQL Server from behind an ISA 2004 firewall.
> Even though I have created a rule for port 1433 on ISA 2004, I wonder if
> there is something still missing at the ISA 2004 that I need to do.
>
> Many Thanks
>
> Regards
>
> "densial" wrote in message
>
> news:1189754261.882976.147900@r34g2000hsd.googlegr oups.com...
>
> > On Sep 14, 4:57 pm, "John" wrote:
> >> Hi
>
> >> I am trying to cerate a System DSN (in ODBC Data Source Administrator)
> >> for a
> >> remote SQL Server. I am getting the below error message;
>
> >> Connection failed:
> >> SQL State: '01000'
> >> SQL Server Error: 14
> >> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Invalid
> >> Instance())
> >> Connection failed:
> >> SQL State: '08001'
> >> SQL Server Error: 14
> >> [Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection
>
> >> What is the problem and how can I fix it?
>
> >> Thanks
>
> >> Regards
>
> > the remote server isn't running sql as a named instance is it?

that error msg Invalid Instance() makes me think your
providor is using a named instance, just ask them if they are, then
reference your server as "servername\instancename" (check the slash
direction, can't remember off hand if it's forward or backward).
Another issue could be the port number, try either "servername,1433"
or "servername\instancename,1433" as your server address. this is
often a problem if your using load balanced sql server. also there's
somestuff about the server knowing which port to reply on (for
sql2005), but this is a bit more complex and sometimes requires some
server side config in awkward situations, anyways if it's 2k5 your
connecting to read up about sqlbrowser replying to the client on port
1434 instead of 1433.

[steelydan]

THis worked perfectly - I used the servername\instancename,portnumber
I used port 1433 and it worked after spending literally 6 hours trying to figure this out. Thanks for the help !!

Steely Dan

[kulajay99]

Thanks, servername\instancename,portnumber helped me connect my remote database.

[obetho82]

Thank you very much, I spend more than 3 hours trying to solve this, thank you very much.

But I dont have clear which was the problem.

Best regards and thanks.