How do we get access to the machines to load our files and to run database scripts against the database servers? More specifically, will we have a way to connect to SQL with our SQL management tools?
SQL management studio access is permitted and logins can be granted to specific databases. We cannot allow SA access for security concerns. We typically set up on ports other than the default 1433 so script kiddies cannot perform dictionary attacks against the SQL server. We also limit access from specific IP’s through ACL’s. FTP can also be setup for file based access to the servers.
Related Questions
- If I update some of my domain name database files, what must I type in order to load these new database files into the MachTen DNS server without restarting the system?
- How can I run scripts that use Loader-compatible libraries on different machines?
- Can I run mulitiple load generators against a single database instance?
