This question is locked. New answers and comments are not allowed.
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?
Is it possible to connect? If not what suggestions do you have for getting OpenAccess to work in this situation?
8 Answers, 1 is accepted
0
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.
(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.
0
acm2001
Top achievements
Rank 2
Rank 2
answered on 08 Dec 2008, 08:11 PM
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
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
0
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.
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.
0
acm2001
Top achievements
Rank 2
Rank 2
answered on 10 Dec 2008, 01:20 PM
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
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
0
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.
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.
0
acm2001
Top achievements
Rank 2
Rank 2
answered on 11 Dec 2008, 01:28 AM
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
thanks
alan
the version number for OpenAccess I have is
Version 2008.3 1205
thanks
alan
0
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.
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.
0
acm2001
Top achievements
Rank 2
Rank 2
answered on 12 Dec 2008, 03:53 PM
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
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