Summary of a problem just encountered.

Keywords : Multi-dimensional dataset Project , Release , Administrator No access permission

 

Fault description:

In Vs2005 You cannot deploy the Multidimensional Dataset on the server. . Prompt Administrator You cannot access the corresponding multi-dimensional dataset. .

 

Troubleshooting:

The first thing that comes to mind is security settings. , However, the multi-dimensional dataset is not deployed, but the system prompts that it cannot be accessed. , Therefore, the problem cannot be solved using the common method. . OK As Service Availability , Everything is normal , To further test whether it can be used , In Aw DW A simple multi-dimensional dataset is created under the database. , Every step is normal . So the problem must be on this project. , So open the problematic project again. , Finally, I found a problem with the data source. , Yes Sqlexpress. Therefore, we recommend that you attach the library Sqlserver Data Engine . Problem Solving .

 

Supplement:

Pay attention to the security of the attached database. , For example , Data cannot be changed after being appended , Naturally, it is a security issue. . I tried a lot of methods and it was fruitless. , So I used the most stupid method. ------ Rename an existing database , Create a new database , Export the renamed database to the new database. . In this way, some problems caused by security settings can be ignored. , At least the local Administrator The service is accessed normally. , This permission also exists. .

About Sqlexpress Security System , I have never studied , Therefore, it is recommended to attach to a normal Sqlserver Service in progress . And the emergence of problems , Obviously, this is also caused .

 

Postscript:

Someone suggested me reinstall it. , But I don't know why. . What's more , Add to the user's site , The risk of reinstallation is very high. , If you can use the conventional method to solve the problem, it is naturally the best. , This is also a training .