ADP connection to SQL

I would like any advice on connecting an Access Project to SQL Server 2000. Authentication is in mixed mode and user enter a name and password. When he click cancel twice, it will appear error - he enter without check a name and password. How I can prevent that?Any chance of changing the authentication to Windows only?|||

I don't understand what is happening in your scenario - can you explain with more details how you set up your project to connect to SQL Server?

Thanks
Laurentiu

ADP connection to SQL

I would like any advice on connecting an Access Project to SQL Server 2000. Authentication is in mixed mode and user enter a name and password. When he click cancel twice, it will appear error - he enter without check a name and password. How I can prevent that?Any chance of changing the authentication to Windows only?|||

I don't understand what is happening in your scenario - can you explain with more details how you set up your project to connect to SQL Server?

Thanks
Laurentiu

ADP , MDB help

I hv adp and mdb files. When i double click them they oppen as application. But i wanna open them in design mode so that i could see whats in thr.
Is there any special key combination...
plz tell
thxi think it was hold down shift and double click but I do not encourage that kind of behavoir. I always used to compile mine before I gave them out to people but that changes the file extension.|||I have tried this so many times but it is not working
any other way...|||thx its workng now...

AdomdConnection Error

Hi~

I write a web service by using ADOMD.

When I excute the program under debug mode in my computer for testing,it's ok.

But when I establish this web in the server,and browse(In Server) it to use, the error is happened.

follow is my code & error messahe

Code Snippet

<WebMethod()> _
Public Function Test2() As String
Dim UserIdPwd As String = "Data Source = olapdw;Catalog = STATION;"
Dim advwrksConnection As New AdomdConnection(UserIdPwd)
Dim tmp

advwrksConnection.Open()
tmp = advwrksConnection.Database.ToString + advwrksConnection.Cubes.Count.ToString + advwrksConnection.ConnectionString
advwrksConnection.Dispose()
Return tmp

End Function

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: Either the user, NT AUTHORITY\NETWORK SERVICE, does not have access to the STATION database, or the database does not exist.
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, Boolean sendNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.GetPropertyFromServer(String propName, Boolean sendNSCompatibility)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.get_Database()
at Service.Test2() in C:\Inetpub\wwwroot\Service\App_Code\ASAdminService.vb:line 709

Could some tell me why? or how to check?

Thanks~

This is the same issue as your AMO question:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2032042&SiteID=1

The web service is running under an account that does not have rights to access SSAS, you need to either run the web service under a different account which does have rights to the cube or grant access in SSAS to the account which the web service is currently running under.

If SSAS and IIS are on different machines, the setting up a domain account for the web service and giving it access is probably the way to go. If they are on the same machine your could put the NETWORK SERVICE account in a role in SSAS so that it has rights to access the cubes.

|||

Thanks for your answer~

The problem has already resolved.