SQL Server - Using Enterprise Manager

• If you are serious about building a database driven site using SQL Server as the database engine, then you should consider using SQL Server Enterprise Manager to manage your database. With Enterprise Manager, you can manage tables, indexes, views, and stored procedures.
  
  You will need to use Enterprise Manager from MS SQL Server 7 or MS SQL Server 2000 in order to connect to the LaMarSOFT SQL Server. The Enterprise Manager from previous versions of MS SQL Server will not be able to connect to the LaMarSOFT SQL Server. If you do not already have Enterprise Manager, your first step will be to obtain Enterprise Manager and install Enterprise Manager onto your local Win9x/WinNT/Win2000 PC.
  
  Enterprise Manager is included with MS SQL Server 2000. You can download MS SQL Server 2000 Evaluation Edition for free from Microsoft's website. The Evaluation Edition of MS SQL Server 2000 includes a version called SQL Server Desktop Edition. Installing the SQL Server Desktop Edition onto your local PC will also install the appropriate SQL Server Enterprise Manager onto your local PC. If you have a slow connection to the Internet, you might prefer to order the Evaluation Edition CD from Microsoft instead of downloading the Evaluation Edition.
  
  Once you have Enterprise Manager for MS SQL Server installed on your local Windows PC, you can connect to the LaMarSOFT SQL Server and create objects within your database.
  
  Follow these 13 steps to build a table in SQL Server using Enterprise Manager:
  
  1) Open Enterprise Manager on your local PC.
  2) Right click on the right section of the Enterprise Manager. Select "New SQL Server Registration".
  3) Enterprise Manager will show a screenshot similar to the following. Use the information from the SQL Server setup email you received from LaMarSOFT to correctly fill out this form. Once you have the correct information entered into the form, click the OK button.
  
  
  
  

  NOTE: If you get an error that says "A connection could not be established to 209.81.157.181 - specified SQL server not found. ConnectionOpen (CreateFile())...", then you need to switch the protocol that your local PC is using to connect to the SQL Server. By default, some systems will try to connect using named pipes, even though you specified an IP Address as the target server. Using the Client Network Utility, you must specify TCP as the protocol to use when connecting to 209.81.157.181.

  
  4) Enterprise Manager will let you know that it does not currently know the status of the 209.81.157.181 server. Enterprise Manager will ask whether or not you want to start the SQL Server. It does not matter whether you click YES or you click NO, since your login does not have permissions to start or stop the SQL Server. So all you need to do is click YES or click NO.
  5) In the left section of Enterprise Manager, click on the newly registered SQL Server (209.81.157.181).
  6) Click on the folder named Databases, or on the plus sign to the left of the word Databases.
  7) Enterprise Manager will get a list of the databases currently installed on the LaMarSOFT SQL Server. The only one that you will be able to access is the one that is the same name as your login name. In this example, I logged in as SQLDB101, so I will only be able to access SQLDB101. Select database that you want to edit.
  8) If you click on the plus sign that is left of the name of the database that you want to edit, then Enterprise Manager will expand a list of categories within the selected database. In this example, I logged in as SQLDB101 and I am editing the SQLDB101 database. The following screenshot shows the list of categories within SQLDB101.
  
  
  
  9) To create a table in the SQLDB101 database, click on the Tables category. The right section of Enterprise Manager will show the existing tables in SQLDB101.
  10) Right click on the right section of Enterprise Manager. Select "New Table".
  11) Enterprise Manager will switch to a slightly different view, and a dialog box will appear that says "Enter a name for the table:". Type a name into the text box, and then click OK.
  12) Define each column field in the table.
  13) Save the table.
  
  

• FAQs
• Privacy Policy