Brinkster Knowledge Base
How do I connect to a MS SQL database using Enterprise Manager
2. Select the 'Alias' Tab, Click Add, and add a new Network Library Configuration; name the connection.
*** To find the name of the server your SQL Database is located on log into your account, select the 'Control Panel', select the 'Web Site Settings', and use the listed SQL Server name.***
3. The following settings apply to your database:
Server: PremSQL??.Brinkster.com (on port 1433 using TCP/IP)
4. Click Apply and OK.
5. Open the Enterprise Mgr.
6. Right click on SQL Server Group and select New SQL Server Registration. Click Next.
7. In the list of available servers, select the new connection you created in steps 2 and 3 above. Click Next.
8. Select the second radio button next to "The SQL Server login information that was assigned to me". Click Next.
9. Input your user name for the "Login Name" and your password that you chose at signup under "Password." Click Next.
10. Click ‘Next’ on the next page, and then Finish on the page following that.
You will now see the connection name you chose in the list under SQL Server Group. Double click on it. Expand it. Expand the Databases option. Select your database and you are ready to start using it.