[RESOLVED] How to update and view records from database off web server

[Proctor]

Hello: I created a database off a web server that we have hosted by another party; however, it seems that there's no interface on the web server that allows me to directly view the records or update the database. I wanted to know if there's a way to use sql server 2000 that I have at my location in order to pull all the objects from the database off the web server and allow me to update or view data.

The database off the web server is sql 2008.

Thanks,
Proctor

[jmcilhinney]

If the host doesn't give you direct access to the database then you can't directly access the database. If the only way to access the database is via the web site then you'll have to add the required functionality to either the existing or another web site.

[leinad31]

Either the host allows access via a database tool, e.g. SQL Server Management Studio which is more likely, or it allows access via remote desktop (or similar technologies such as VNC) which I doubt because that type of access is reversed for sysads.

Have you checked if you can access via SQL Server Management Studio Express? Get in touch with the host, who is in a better position to answer your questions, rather than relying on community who has no knowledge of the infrastructure.

[Proctor]

I installed SQL Server Management Studio Express and was able to access the database this way.

Thank you for your help!!

Proctor