logo_michael-thomas.jpg (3143 bytes)

MS SQL

Free Web Tutorials & Survival Guide

bulletMS SQL Installation Notes
bulletMS SQL Survival Guide - list of all functions and other helps.
 

Vendor Resources

bullet 

Other Resources

bulletwww.sqlservercentral.com - Great resource for info.
bulletwww.mssqlcity.com

Miscellaneous Notes:

 
Topic Description
Ports Default is: 1433

??? Change/Configure: Sql Server Client Network Utility: General, TCIP

SQL Logins SQL Logins

SQL Server Enterprise Manager, <select server>, Security, Logins.
Now right click and add a new user with password.
Next, right click on the user and choose "properties".  Now grant access to the DB's neccessary.