RMS, SQL Server, Windows Authentication


A

amwbgi

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?
 
Ad

Advertisements

Ad

Advertisements

P

Public POS

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top