[ILL-L] Ariel v 4.1 installation problem on a MS SQL server

[Hoover, Cheryl]

Hello,

My IT person is having problems installing Ariel 4.1 and wanted me to
post this message to the ILL world.  Any suggestions would be greatly
appreciated. You can reply directly to me at choover at msubillings.edu 

 

Here is her note:

 

~~~~~~

 

Installing Ariel v 4.1 on a MS SQL server. As we have other databases on
the server cannot use an sa account for connectivity.  Tried creating an
account for the Ariel Database with many rights and putting the login
and password of that account in the odbc reference on the pc.  It will
not connect to the data.  Need to know if can create an account after
moving the database from SQL express to MS SQL Box and just change the
account in odbc reference and what rights that account would need on
tables, stored procedures, etc. in MS SQL.

 

Thank you,

Cheryl

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Cheryl Hoover, Interlibrary Loan Supervisor

Montana State University - Billings

1500 University Drive

Billings, MT 59101-0298

 

Voice: 406-657-1666  Fax: 406-657-2037

OCLC:  EM2  Docline: MTUEML

Ariel: 207.196.232.37

Odyssey: 192.156.215.186/EM2

 

View our catalog at www.msubillings.edu/library

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.webjunction.org/wjlists/ill-l/attachments/20090515/9274c9bd/attachment.htm