1. Home
  2. Point-Of-Sale Software
  3. RMS, SQL Server, Windows Authentication

RMS, SQL Server, Windows Authentication

I need to run RMS and CRM on a single SBS2003 server. I've replaced MSDE on the SBS2003 with SQL2000 Server, but now find that I cannot connect to my RMS database. This is because SQL 2000 is configured for Windows Authentication (a prerequisite for CRM), instead of the SQL login method.

Is there anyway I can get RMS and CRM to co-exist? For instance I've tried changing the authentication method from Windows only to SQL and Windows in the SQL Enterprise Manager, but the setting refuses to change from Windows only.

How do I resolve this?

Reply to
amwbgi
Loading thread data ...

first thing that comes to mind:

You must be logged in as an administrator and after you change the authentication method, you must stop and re-start the SQL services (i would suggest a re-boot!!).

a link showing how to manually change the login mode:

formatting link

Reply to
root

It's been awhile but I believe you can select either authentification as an option when setting up the SQL database. Right-click on the database in Enterprise Manager and select Properties.

Reply to
Public POS

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.