Monday, March 19, 2012

MS SQL Server

Hola,

I'm totally a beginner. I already know how to administer SQL database from my computer. How does it work to administer SQL database to your hosting company?

Air :-(This would depend on what your hosting company allows you to do...|||Normally it works in the same way, only that you do not have access to anything but your own database and that your rights are limited to creating objects in your database ...
So you will not have access to logins and stuff like that ...
Your ISP will give you all the needed login info, with that you can connect to your database|||Depends very much on what "hosting" means. The answers above give you some options, but if you are doing something like renting a cabinet in you hosting company's environment, then the server is yours to do with as you please and you should even be able to use terminal services to connect to it. Another option, which I like to use in our case is the Microsoft Web Data Administrator which gives you web access to certain SQL server admin functions.|||Here is how my company does it. We will set you up just like "Foefie" said. When ever I set up a client that orders our package that has SQL. I just give them the domain "sql.washoetech.net" and a username and password then they can log into the sql server with the sql client network utility and then they can use the manager to access the DB.

J

No comments:

Post a Comment