Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Only getting "Loading Catalogs..." message.

I have just downloaded your SQLServer version and I have configured it to point to a couple of my SQL Servers. But, all I get is "Loading Catalogs...". One database has 7 user databases, the other has 25 user databases.

Thoughts on how to resolve this?

Thanks,
Jim
3 people have
this problem
+1
Reply
  • Walter (Customer Support Representative) September 24, 2010 16:24
    This happens with both your SQLServer instances? Do you happen to know which version of SQLServer they are, and whether you have them configured to use any non-standard authentication? Also, when you create a new database configuration, does DataGlass automatically detect the servers on your local network, or do you need to configure them manually (by typing in the server name, etc)?
    • Yes, it happens to both. Both are SQL Server 2008 (SP1). Non-standard authentication? Not sure what you mean by that one. I know of only two ways to authenticate to SQL Server; Windows Authentication (formerly known as a Trusted Connection) and SQL Server Authentication where you give it a user name and password. I am using a user name and password as Windows Authentication is not an option.

      Does DataGlass automatically detect servers on my local network? No. Do I manually configure them? Yes, via IP Address. Nor does it seem to try and detect servers. When I press on New Connection, it goes straight to the screen for manually configuring the connection.

      Thanks,
      Jim
    • Walter (Customer Support Representative) September 24, 2010 16:49
      Hmm. If you enter an incorrect IP address for a new connection, does it fail immediately, or does it hang in the same way as the connections you have configured correctly? Also, have you double-checked to make sure you are really on the same WiFi network as your databases (and that there isn't any firewall blocking attempts to connect from your device)? Lastly, are you using DataGlass SQLServer 2.0 (which was just released yesterday)?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I’m happy
    Weird. OK, yes, I just downloaded the app for the first time today. The first time I tried it, I was trying to use our VPN connection, which I forgot at the time, is blocking most ports including SQL. But, when I opened this ticket I had been trying it here at the office using our "inside" WiFi network (pretty much fully opened, but secured).

    Finally, I went back out the the Home screen, brought up the task manager, and killed off the instance of DataGlass. When I restarted it I was now able to auto-discover SQL Servers. Any new ones I added worked fine. But, when I tried the existing ones, they failed, but with a credential error instead. After I re-saved the credentials several times, I deleted the entry and re-added it (it did not show up in the discovery for some reason). After I re-added it, it worked just fine.

    Thanks,
    Jim
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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

  • I’m undecided
    I have the same problem, over wifi and 3g. Is a server with 5 databases in it. If I use the wrong credentials or db name, it fails instantly. But with the right data, nothing happens. Is Sql server 2008 R2 with sql server auth (using a non standard port)
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

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