|
|
Posted by William Vaughn on 07/19/07 16:18
The SQL Server Config tools will tell you what port(s) have been assigned.
SS 2000 broadcasts and handles the incoming requests and maps to the ports,
but if the firewall blocks them...
--
____________________________________
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)
-----------------------------------------------------------------------------------------------------------------------
"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns9971F1A126FADYazorman@127.0.0.1...
> TerpZebra (terpzebra@gmail.com) writes:
>> 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"
>
> Difficult to say. Is SQL Server running on port 1433 on both servers?
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|