Remote SQL database

9 posts, 0 answers
  1. acm2001
    acm2001 avatar
    30 posts
    Member since:
    May 2007

    Posted 06 Dec 2008 Link to this post

    I am using OpenAccess for the first time and have succesfully installed in VS2008. I have SQL05 installed on a different machine in a remote location on the internet. I wish to connect to that SQL05 database and use OpenAccess. All of the examples I have seen appear to be for localhost. The Wizard has grayed out all the db settings in my VS. I have tried manually to access to the remote SQL db but without success.

    Is it possible to connect? If not what suggestions do you have for getting OpenAccess to work in this situation?
  2. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 08 Dec 2008 Link to this post

    It is possible to connect to a remote database server. There are a number of obstacles to obey however:
    (a) The server must accept remote connections. Use the "Server Configuration Manager" from the MSSQL 2008 installation to configure this.
    (b) The firewall(s) must not block the required ports (usually 1433).
    (c) The client must be configured that TCP/IP connections are used.
    (d) The server should not use dynamic ports as otherwise the firewall can be easily misconfigured.

    I always use the test connection buttons to see whether the connection is correctly set up. You might want to use the server explorer from the VS too to see if the connection can be made.

    Greetings,
    Thomas
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  3. DevCraft banner
  4. acm2001
    acm2001 avatar
    30 posts
    Member since:
    May 2007

    Posted 08 Dec 2008 Link to this post

    Thanks

    I can connect to the database from inside VS08 using the Tools Menu then "Connect to Database" choice. the test connection works, everything is fine.

    With the OpenAccess panel inside VS08 when i click on "Expert Wizard" all of the selections are grayed out. This is where I am having the trouble. Why would the selections not be active. They are set on Database1 for localhost and appear to be unchangable?

    Alan
  5. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 10 Dec 2008 Link to this post

    Hello Alan,

    they are grayed out? This shouldn't be the case. After all, expert wizard is there to let you enter settings!
    Which version did you use? When it is not the newest one, I would recommend to get it as we did improve the configuration in this area.

    Sincerely yours,
    Thomas
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  6. acm2001
    acm2001 avatar
    30 posts
    Member since:
    May 2007

    Posted 10 Dec 2008 Link to this post

    I used version 2.5.1.8313
    I currently have a trial version of VS08 on my machine i am using this on. could that be the problem?

    Everything is definately grayed out. I cannot even click the "test connection" button. it is also grayed out.
    I was able to connect to my remote sql database using this version of VS08 through VS's data connection wizard

    thanks
    alan

  7. Thomas
    Admin
    Thomas avatar
    590 posts

    Posted 10 Dec 2008 Link to this post

    Hi Alan,

    that is a very strange version number. Where does it come from? It should be in a 2008.3.1204.1 or similiar style.
    You can obtain the OpenAccess version number from the Help->Product Info menu.

    Kind regards,
    Thomas
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  8. acm2001
    acm2001 avatar
    30 posts
    Member since:
    May 2007

    Posted 10 Dec 2008 Link to this post

    apologies. I gave you the version number for OpenID i was working with. Sorry to cause confusion.

    the version number for OpenAccess I have is

    Version 2008.3 1205



    thanks
    alan

  9. Jan Blessenohl
    Admin
    Jan Blessenohl avatar
    707 posts

    Posted 12 Dec 2008 Link to this post

    Hello Alan,
    which kind of project are you trying to enable? We have some restrictions on specific project kinds. Maybe that is the problem. What happens if you try the same on a class library project?


    All the best,
    Jan Blessenohl
    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
  10. acm2001
    acm2001 avatar
    30 posts
    Member since:
    May 2007

    Posted 12 Dec 2008 Link to this post

    thanks
    that got it to un-gray the objects.

    I have put in the details for the remote server and am reaching the server and database but the SQLUser field and SQL password field are still grayed out preventing me from getting a succesful connection. should they still be grayed out?

    and just solved this by turning off "Use integrated Security" when i went back to the wizard after being on the 1st page of the Expert Wizard. If that doesnt make sense it is probably because i got lost trying to find the way and ended up exactly where i wanted to be.

    Thanks for your help.
    Issue solved
    alan
Back to Top
DevCraft banner