October 4, 2009 at 11:40 pm
I have a small wireless home network with a wifi router. I have two PCs attached to the router and both these PCs ping each others successfully. The only problem is that when my application (on PC1) tries to access SQL Server 2000 on the other PC (say, PC2) then , the network lights in the system tray keeps blinking but no connection DB connection is made and after sometime I have to terminate my application window.
If I run the same application on PC1 (that has SQL Server installed locally) it works perfectly.
Any ideas ??
Please note that I have disabled windows firewall on both ends, but still no luck
October 5, 2009 at 8:16 am
In theory accessing SQL Server over wireless should be no different than doing it via a hard-wired connection.
What application are you using to connect to SQL Server?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 5, 2009 at 8:28 pm
Hi,
Its a simple VB.NET databse application
October 5, 2009 at 8:53 pm
Either you are not allowing remote connections for some reason, or the connection string is wrong.
How are you coding the connection? Have you tried connecting from the Control Panel | Data Sources on PC2?
October 5, 2009 at 8:58 pm
Do you have Visual Studio installed on the client so you can step through the code? If not, can you modify the code to write to a log file or the event log as it loads and attempts to connect to the database?
Can you run SQL Server Profiler against the database to see if the application is really attempting to connect?
Can you connect to the database from any application on PC2?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy