Posted by William Vaughn on 07/19/07 20:14

So, there is something different about this particular server--assuming you
can connect to other servers from the client.
Have you run the surface area config tool on the target server?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
www.hitchhikerguides.net
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"TerpZebra" <terpzebra@gmail.com> wrote in message
news:1184866009.025953.319470@q75g2000hsh.googlegroups.com...
> On Jul 18, 3:50 pm, "William Vaughn" <billvaNoS...@betav.com> wrote:
>> Is the firewall open for port 1433?
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant, Dad, Grandpa
>> Microsoft MVP
>> INETA
>> Speakerwww.betav.comwww.betav.com/blog/billvawww.hitchhikerguides.netwww.betav.com/blog/billvawww.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>> Visitwww.hitchhikerguides.netto get more information on my latest book:
>> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
>> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
>> -----------------------------------------------------------------------------------------------------------------------
>>
>> "TerpZebra" <terpze...@gmail.com> wrote in message
>>
>> news:1184775545.291016.192510@i38g2000prf.googlegroups.com...
>>
>> >I am having difficulty connecting to SQL Server 2000 on one of our
>> > servers via a VB6 program on Vista. I can connect fine to a different
>> > server, but it gives me the following error with the server in
>> > question:
>>
>> > "Unable to connect to database. Please check your internet connection
>> > Error# -2147467259
>> > [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> > access denied"
>>
>> > Using the program, I am able to access the database just fine while
>> > running on Windows XP, but when I run the program on Vista, it gives
>> > me that error message for that server. If I change the connection
>> > string to a different server address, it works fine on Vista. What
>> > differences in the servers might cause this?
>>
>> > Here is my connection string:
>> > "driver={SQL Server};Server=ipaddress;Uid=userID;Pwd=pwd;database=db"
>
> Yes, it is open for port 1433. I can connect to a separate Server
> using the same connection string, except for the IP address, and it
> works fine.
>
> I can also connect to both Servers using the application on Windows XP
>

[Back to original message]