I’m frustrated

SQL Server 2005 can't connect. Even with autodiscovery.

Can't connect to my SQL Server 2005. Tried Hostname, then tried IP address. Using same credentials as my Client Tools. It just spins then gives "unknown error".

The autodiscovery sees my server and when I add it, it still just sits and spins. Then error's out. Are there specific services which need turned on or off? Do you guys have a tutorial anywhere or a walk thru for set up?

I really want your app to work, I'll gladly pay for the upgrade when it does.
3 people have
this problem
+1
Reply
  • Walter (Customer Support Representative) December 09, 2010 00:47
    I assume you've verified that your iOS device is on the same local network as your database and that SQL Server isn't running on some non-standard port.

    Is it possible your SQL Server instance is configured to require SSL to access it? DataGlass doesn't (yet) support SSL connections, and this has been a frequent cause of this kind of problem.

    Another potential issue is if you are using the integrated OS authentication option, which isn't something we can take advantage of (since we are on a non-Windows OS). You could test this out by making (or having your DBA create) a new test user that uses non-OS-level authentication.

    Please let us know if none of those suggestions help and we'll continue to noodle over the problem.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I thought this might be related to the problem I'm having ... but I can't even connect to the Demo SQL Server - AdventureWorks shows up ... but it never shows the db
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I purchased both the SQL client and the MySQL client. I'm able to use the MySQL client no problem to attach to our MySQL db on a hosted DB ... but not the SQL client. Nearly the same settings, just a name difference. It just says Connecting ... and sits there until I kill the app.

    I also went into advanced settings and set the timeout to 30 seconds, but that doesn't stop the connecting message and timer. I just restarted and I'm up to 1:50 min

    Also, I can connect to the demo DB on MySQL, but not on SQL.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Walter (Customer Support Representative) July 15, 2011 18:24
    Hmm. I assume you have verified that there really is a SQL Server instance running on that machine and port, and that your firewall is configured to allow external connections to the SQL Server instance? Are you able to connect to SQL Server from another Windows computer on your network (just to make sure that it is allowing external connection?)
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Yes, I actually used .asp to connect and represent data. Though that still doesn't answer why it won't time out.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Walter (Customer Support Representative) July 15, 2011 19:39
    How odd. One possibility: is your SQL Server instance configured to require SSL connections? DataGlass doesn't yet support SSL connections, so that could be the source of problems. If it's not that, can you let us know all the connection parameters (excluding the password) you are specifying?

    Also, the demo server should be available again. Can you try to connect to it (just to make sure your installation of DataGlass is OK)?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I am having a similar issue to Brian.

    I have tried both the access version and the SQL Server version. Access works fine but I cannot connect to any database using the SQL Server version. The error I get is "Error connecting to database Network error IOException: Invalid argument". No other error information is provided. I believe I have provided all of the information necessary.

    Also, the backslash "\" key is missing from the iPhone keyboard when the "User Name" field is selected within the database configuration section.

    Please advise on what might be the issue with connection to SQL Server. If you would provide an example of what generic settings should be for connecting to an SQL Server database on an internal network, I would appreciate it.

    Although DataGlass aspires to not needing documentation, It should would be better for us customers if you had some. You built the application and what DataGlass thinks is "Common Sense" or "Understood" we may not.

    Thank you,

    Kevin

    If your answer is SSL is not supported, I do not know if my db is using SSL; I simply connect using either WIndows Authentication or SQL Server Authentication.

    How do I check for SSL authentication? I will look this up but if you have a quick answer, that would be great.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • FYI Demo db still does not connect (1 month after Brian's post)
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned