How do
I connect to my MS SQL DB?
Connections for administrative purposes can be made via Microsoft's
Enterprise Manager 2000. Each database created on the Hybeam
system is assigned a unique Database Name, User Name, and Password.
These credentials are used whenever a client attempts to make
a connection to the database.
Start your Enterprise Manager Console, and branch out to the
Server group level.
At this point you can choose the action menu at the top, and
select “New SQL Server Registration” or right click on your
server group and choose the same option.
The Register server wizard will start as shown by this screen
below.
Click “Next” to continue to the next step.
In the box called “Available servers” simply type in the following:
mssql.megasqlservers.com
Click “Add.”
That should put that new server name into the “Added Servers”
box.
Click “Next.”
At this stage, choose the 2 nd authentication mode: “The SQL
Server Login information that was assigned to be by the system
administrator.”
Click “Next.”
Choose a connection option. If you want to login automatically,
enter your login name and password in the text boxes provided.
Your Login name will be dbm.yourname.com (Substitute your
domain name for yourname_com.)
Your password will be the password you chose with your sales
representative.Click “Next.”
At this point, the wizard will prompt you to add the newly
registered server to your server group. Select the option labeled,
“Add the SQL Server(s) to an existing SQL Server group.”
Click “Next.”
At this point, the server registration is completed as shown.
Click “Finish.”
You will now have a new server listed in your Enterprise Manager
console. You can branch out this server, branch out the databases,
and proceed to your database. There you can perform various
administrative tasks such as create tables, stored.
FAQ's