[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 248
  • Last Modified:

Problem connecting to SQL2005 from Pocket PC 2003

Problem connecting to SQL2005 from Pocket PC 2003
I developed a pocket pc application with VB.net 2003 that was using SQL2000 as backend database.
I have been using .Net SqlClient data provider for the database communication.
The database was migrated to SQL2005 running as SQL2000 and now I am getting a SqlException that says Login failed even though I have the correct connections string.Does this error have something to do with the migration to SQL2005.
untitled.bmp
0
Smullings
Asked:
Smullings
  • 4
  • 3
1 Solution
 
chapmandewCommented:
can you connect through management studio to the 2005 instance w/ that user name and pwd?
0
 
SmullingsAuthor Commented:
Yes we are able to connect throught the management studio 2005 instance with the user name & password. We thought it was an NAT issue, So I physically went on-site to behind the client's firewall and the actual DB Server Name to connect and the same results.

A successfull log in using MGMT Studio 2K5
Failed Pocket PC connection.
0
 
chapmandewCommented:
Are you connecting using a sql account?  Are you able to ping the sql server from the pocket pc?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
chapmandewCommented:
Its strange because you are getting an error message that it can't authenticate you...but it looks like you are getting to the actual server.
0
 
SmullingsAuthor Commented:
I am able to ping the DB Server successfully & we are using a SQL account
0
 
chapmandewCommented:
check your pwd in your connection string.

0
 
SmullingsAuthor Commented:
Thank you. For your reference the device was hard coding the password to be CAPTIAL when authenticating to SQL2K5.
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now