NETWORK account in Analysis Services error/bug?

I was having problems connecting to an OLAP database on the same domain as my IIS box, and read that adding a 'NETWORK' account may help resolve this. Somehow when it was added, no domain (specifically no 'NT AUTHORITY') was. Now I have an account with name 'NETWORK' but no domain. Every time I try to remove/delete this account, or do anything on the database withing Analysis Manager, it freezes. There is another database running on the same machine and we were able to add the NETWORK account with the domain 'NT AUTHORITY', and it is working fine, no freezing/lockups.

IIS is running on a Windows 2000 box with SP3 and Analysis Services w/ SP3a. The SQL Server is on a Windows 2003 Server, and Analysis Services w/ SP3a. Both machines have MDAC 2.8.

Is there any way to manually add the domain name to the account, or to remove it without using Analysis Manager? If you need any more information please let me know.

Thanks.Fixed. Had to go into the OlapObjects table and remove any relations to the NETWORK role. NOT RECOMMENDED because this can easily hose your db. After the Objects were removed we had to stop and start the Analysis Services service for it to take effect.

Originally posted by ArizonaBay
I was having problems connecting to an OLAP database on the same domain as my IIS box, and read that adding a 'NETWORK' account may help resolve this. Somehow when it was added, no domain (specifically no 'NT AUTHORITY') was. Now I have an account with name 'NETWORK' but no domain. Every time I try to remove/delete this account, or do anything on the database withing Analysis Manager, it freezes. There is another database running on the same machine and we were able to add the NETWORK account with the domain 'NT AUTHORITY', and it is working fine, no freezing/lockups.

IIS is running on a Windows 2000 box with SP3 and Analysis Services w/ SP3a. The SQL Server is on a Windows 2003 Server, and Analysis Services w/ SP3a. Both machines have MDAC 2.8.

Is there any way to manually add the domain name to the account, or to remove it without using Analysis Manager? If you need any more information please let me know.

Thanks.sql

Need to track SQL activity

Hi all -
We are running a CRM application on a SQL 2K SP3a box. Through SQL, are
there any logs that I can go back to in order to see what data was viewed,
exported and by whom, for a specific date?
Thanks - MikeTransaction logs contain all the data modification information, but SQL
Server doesn't provide a friendly way to get at that information (DBCC LOG,
and fn_dblog are available).
Another approach would be to use Profiler or server side trace procedures to
capture the information you are after. For additinoal information on server
side traces, see:
http://vyaskn.tripod.com/server_sid..._sql_server.htm
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"HelpPls" <smd6169@.hotmail.com> wrote in message
news:uaczuKYeEHA.2532@.TK2MSFTNGP09.phx.gbl...
> Hi all -
> We are running a CRM application on a SQL 2K SP3a box. Through SQL, are
> there any logs that I can go back to in order to see what data was viewed,
> exported and by whom, for a specific date?
> Thanks - Mike
>
>