Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 16th, 2007, 11:58 AM
BHL BHL is offline
Registered User
 
Join Date: Mar 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server and Wireless

Hi,
I am currently using MP2 SQL 6.1 to track equipment, work orders, purchase orders, and inventory. Im trying to use a laptop in the stockroom to help me take inventory. Previous to today as a temporary solution I ran a LAN cable from my office to the stock room and everything worked fine. Today IT installed the wireless access point I asked for. Since then I have been unable to login into my database fromm the laptop. I get the following error:

' Connection Failed:
' SQLState: '01000'
' SQL Server Error: 53
' [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
' Connection Failed:
' SQLState: '08001'
' SQL Server Error: 17
' [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
I am not a trained IT Specialist, I am an engineer with a good tech background. Please keep that in mind when replying. I may need it dumbed down a bit. I have already tried pinging my server, and my gateway, no problems. I tried using the following telnet command and it does not work. C:\telnet warehouse 1433. I think this may be a port issue. I have also tried re-installing the software with my wireless connection as the only active connection between the server and client in the hopes that the software would recognize this and reconfigure my *.ini file for the software I am using.

 
Old March 16th, 2007, 12:24 PM
Authorized User
 
Join Date: Dec 2006
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Sounds like you are starting in the right place with telnet.
Does the wireless router allow all ports? First glance, TCP:1433 is probably blocked. Try unblocking all ports, then you can work your way back to tighten which ports you need.

If that doesn't help, try connecting using named pipes. From a UDL file or managment studio/enterprise manager, test connecting to NP:<servername>. You can force TCP using TCP:<servername>[,port].

Check out this link for other ideas...
http://support.microsoft.com/kb/328306

Adam Gossage
Lake Wylie, SC, USA
 
Old March 19th, 2007, 09:53 AM
Friend of Wrox
 
Join Date: May 2006
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you on the same subnet?







Similar Threads
Thread Thread Starter Forum Replies Last Post
wireless data collection from microcontroller muhammadazeemazam Visual C++ 0 August 17th, 2006 08:45 AM
Wireless A katsarosj Linux 1 January 31st, 2005 09:58 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.