Difference between revisions of "Making a connection to your SME database"
| (One intermediate revision by the same user not shown) | |||
| Line 20: | Line 20: | ||
b. (Note: The path to the database should fill in automatically) | b. (Note: The path to the database should fill in automatically) | ||
| + | |||
9) Copy the database name to the Company name field | 9) Copy the database name to the Company name field | ||
10) [[File:SME_Database_Connection_IMG_2.png]] | 10) [[File:SME_Database_Connection_IMG_2.png]] | ||
| + | |||
| + | Common Files Connection | ||
| + | |||
| + | 11) Browse to your database Common Folders files, (CFPath) through the My Network Places UNC path | ||
| + | |||
| + | 12) [[File:SME_Database_Connection_IMG_3.png]] | ||
| + | |||
| + | 13) \\server\High5Software\Data\<CompanyName> Should look like this with your server & database name. | ||
| + | |||
| + | 14) [[File:SME_Database_Connection_IMG_4.png]] | ||
| + | |||
| + | 15) Check Use as default: | ||
| + | |||
| + | 16) [[File:SME_Database_Connection_IMG_5.png]] | ||
| + | |||
| + | 17) Click ‘Ok’ to open SME | ||
Latest revision as of 19:31, 28 July 2014
1) Log on to your Server or Workstation hosting the SME database
2) Navigate to the SME program folder
3) Locate and rename the Alias62.ini file to Alias62.old.ini or something similar
4) Launch SME
5) SME will open the SME connection dialogue
Database Connection
6) Select your MS SQL Server instance name from the top drop down (If you do not know the SQL instance Name Open the old Alias62.ini file and look at the line: Server=<your Server\SQL instance>
7) 
8) Select your database name from the database field dropdown
a. The Database field is the lower of the two fields
b. (Note: The path to the database should fill in automatically)
9) Copy the database name to the Company name field
10) 
Common Files Connection
11) Browse to your database Common Folders files, (CFPath) through the My Network Places UNC path
12) 
13) \\server\High5Software\Data\<CompanyName> Should look like this with your server & database name.
14) 
15) Check Use as default:
16) 
17) Click ‘Ok’ to open SME