Why do I see a Microsoft SQL Server login screen after installing a new workstation?

After either installing a new SQL GIFTS or GIFTS Alta workstation or re-installing a SQL GIFTS or GIFTS Alta workstion you may get a SQL Server login option instead of a GIFTS login option. This is because the program is trying to log you into the SQL Server before logging you into GIFTS. This usually is done automatically, but some elements may impede this process, which can be corrected following steps below.

1. Go to the following directory on your workstation:
C:\USERS\<USERNAME>\AppData\Local\VirtualStore\Windows\
[NOTE: If you log into your computer as smithjohn, the directory appears as C:\USERS\smithjohn\AppData\Local\VirtualStore\Windows]

2. See if there is a file called GIFTS.INI > Delete the file if it exists

3. Go to the C:\Windows directory on your workstation

4. Locate the file there also called GIFTS.INI

5. Open the file in Note pad

6. Under the [SQL Server] section, note the following:
Connect=ODBC;UID=GIFTSLOGIN;PWD=Ù¥ÕCÝ‚©Œ;DSN=gifts;DATABASE=GIFTS

7. Remove the characters within the PWD=  section, in this case Ù¥ÕCÝ‚©Œ, before the ;DSN=

8. Replace that value with the correct SQL Database password [NOTE: This information should be provided by your IT department's database administrator]

9. Go to PWDEncrypted=-1 section > Remove the -1 > Replace with 0

10. Save the file > Relaunch GIFTS or GIFTS Alta depending on your install to confirm the change was successful

Environment

 Windows 7 (32-bit);Windows 7 (64-bit)
 GIFTS Alta
 Yes
 GIFTS

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.