It would be in your best interests to have some experience with SQL development before you decide to utilize this feature. You will need to have Microsoft SQL 2000 on your own computer to connect to SQL server and maintain your databases. You can use Enterprise Manager to connect to your specific SQL server, or you can use remote SQL statements. If you are new to databases you may wish to use Microsoft Access and start off with an access database.
If your package comes with SQL database support and you would like to take advantage of Microsoft SQL server send an e-mail to support and request a SQL database be setup for you.
We will prefix any Username, DSN, or Database name you chose with the first 3 to 4 characters of your domain name. We require this for tracking, and troubleshooting purposes should the need ever arise.
i.e. your domain is microsoft.com, and you request the following from us...
database name: software
username: dave
password: rover
DSN: software
We would modify your request to look something like this:
database name: micrsoftware
username: micrdave
password: rover58 (security of course)
DSN: micrsoftware
Yes, you can use the SQL 2000 Enterprise Manager for administration of your database. You will have a separate login using SQL authentication, which you will provide us as stated above. Be sure that you set the Client Network Utility on your local machine to use "TCP/IP" as its protocol, so you can reach an outbound SQL server.
You can also now use Microsoft Access for administration of your SQL 2000 database. Find more on that here:
Connecting to SQL with Access
Using SQL with Access
--------------------------------------------------------------------------------
Setting up the SQL Server Client Network Utility
Open up the SQL Server Client Network Utility.
Ensure that you are using TCP/IP as your default network protocol/library.
Let’s add in a static mapping to your SQL Server now. Click on the Add button and enter in a name for the SQL Server connection, select TCP/IP and type in the computer name/IP Address for the server that you wish to connect too – leave the port number set at 1433.
When you have completed, click ok.
Your static mapping will now be inputted in your Client Network Utility.
Now let’s open up Microsoft SQL Enterprise Manager.
Right click on the SQL Server group and select New Registration. In the Server title box, select the pull-down and find the static server mapping that you have just created.
Once you have done this, select SQL Server Authentication and enter in the username, password for the server that you are trying to connect too.
Click Ok.
If you have all the settings correct you should now be logged into the SQL Server to begin working on a single, or specific databases.
- 0 Users Found This Useful
