July 30, 2010     |
Network Toaster
SQL Security Forums
Note: SQLSecurity.com does not allow nor require registration due to privacy concerns for users. SQLSecurity.com is open and anonymous for all. Please report any abuse or profanity.
Subject: Connecting to SQL server
Prev Next

Author Messages
PDA_HELP (guest)

03/21/2006 12:51 PM Quote Reply Alert 
We have a pocket PC application that connects with an SQL server over port 1433. We use a snippit of code from Chip Andrew's SQLver.NET v1.0 application to test to make sure a connection to the server can be made. Here is the problem we seem to be having. We have MSDE installed on a computer on our network and a PDA with our software is hooked directly to it. It is able to connect just fine. However the problem seems to occur when the computer does not log onto the network. Lets say the network cable is detached so it uses cached credentials to load the domain profile, or if the user chooses to log on to the local machine and not the domain. In either of these instances the PDA cannot connect to the SQL server. Does anyone have any idea why this would be happening?
mulhall (guest)

03/22/2006 1:20 AM Quote Reply Alert 
I'd say that you need to grant access to a local account, and use that account to allow your PDA to connect to MSDE.

Forums > Discussions > SQL Server Security > Connecting to SQL server

Quick Reply
Username:  
Subject:  
Body:
 



ActiveForums 3.6
Copyright 1999 by Chip Andrews   |  Privacy Statement  |  Terms Of Use