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

NEEDED: SQL Server Express 2005 Setup Walkthrough

Someone please help me, Im trying to set up SQLServer on my website(IIS v4.0) and I cant seem to get any web apps that use SQL to intall correctly, I get errors like, SQL does not recieve remote connections by default, or just 'Server Not Found'.

This is what I need to know

- How to set SQL to accept incomming remote connections

- Where to find the Name of the SQL instance

- Is it a good idea to have a password on the db, and how do I add one

- A walkthrough on how to set up SQL Express 2005(what to do after the istall is complete)

As you can see Im very new to SQL. So any information you could give to help would be greatly appreciated.

Thanks

Admin @. Something-to-do.com

1. Here is a KB Article that goes through setting up remote connections. http://support.microsoft.com/kb/914277

2. With SQL Server 2005 Express the server install defaults to ".\SQLEXPRESS" for the instance. To find the name though you can check the windows service list in the Services mmc inside the administration folder under the control panel. The name will be inside brackets beside the SQL Server Service.

3. You should try and stay with Windows Logons for the security.. if you do need to use sql logons you should try a strong password on the database accounts.