How do I manage a MS SQL database?
Posted by Joe Rebis (Import) on 16 September 2006 09:38 PM
|
|
Managing a MS SQL Database:
A MS SQL database physically resides on a separate server. You will not be able to download it by FTP. Instead you will edit the database live in real-time.
To do this, you will need to connect to the database using a database management tool. For MS SQL you have a few choices:
**NOTE: This edition does not allow you to use SSIS (the new name for DTS). If you need to use that functionality, download and install the MS SQL Server 2005 Developer version. It may be a paid product but well worth the investment.
Connection Information:IP Address: Please search the KB for "Important IP Addresses". Port: 1433 Database: The database name you created. Username: The database username you created. Password: The database password you created.
Complete details on how to manage your database from a programming standpoint is beyond the scope of this document. More information as well as tutorials can be found on Microsoft's website.
SEE ALSO
SEE ALSO: Database Knowledge base Articles | "Important IP Addresses" knowledge base article Contact Support If you are still having issues, please contact us for further help.
| |
|