Networks

Ask something
Discussion Locked

SQL7 server profiles problem

0 helpful
7 replies

by phan

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I'm running a Compaq Proliant3000 Pentium 3, 256MB RAM, 15G HDD, Windows NT4 in a local Domain Server with MS IE5, Microsoft Internet Information Server and SQL7 Database server.
I'm not sure if this is good idea as my Boss want us to use Intranet and make use of SQL7 database which able to trigger database message to user vial e-mail which this E-mail Exchange Server is in ISY department using different server and domain.
I have try update service pack 3 in my SQL7 server and follow the step Microsoft knowledge data base Q153676 and Q159425.
but still unable to capture the profiles name, the error message pop up as below.

Microsoft SQL-DMO(ODBC SQLState:42000)
Error 22030:A MAPI error(error number:273)occurred:Unable to get the default MAPI Message Store due to MAPI error 273:The information store could not be opened.

Maybe you have other idea which can workout.
Hope to hear from you soon and thanks you very much.

7 replies

by estebandelatorre

HI,
Be sure to have the outlook client with "no messages to send" as related in Q153676.
Another posibility is to change the oulook profile in order to reach another server ip address (if on internet site)
Prior to installing the sp, have the sqlmail service stopped.

Hope it helps!!

by estebandelatorre

Due to the fact that the error is a MAPI one, you will need to check if mapi conectivity existe between the sql and the exchange server where the store resides.
A MAPI coneection can be test by simply mapping the other server with a letter, like s:\mail_srv\some_share
Thies connection should be resolved both using an "ip address" or a "server name", and the "server name" can be resolved by DNS, WINS, NETBIOS , or a simply LMhost file.
Hope it now helps!!

This discussion is closed to new replies.