anonymous pull replication problem - Logon failure: unknown user name or bad password.

I have setup a replication sandbox with the following:
server: SQL-Server 2k
workstation: MSDE 2000 (A)
I have setup a replication database on my server and configured it for
anonymous pull subscriptions. I am running this inside my LAN.
I run the following code in an Access 2000 module:
With SQLMerge
.Publisher = "SERVER"
.PublisherAddress = "SERVER"
.PublisherSecurityMode = DB_AUTHENTICATION
.PublisherLogin = "sa"
.PublisherPassword = "nnnn"
.PublisherDatabase = "mydb"
.Publication = "publ_mydb"
.PublisherNetwork = TCPIP_SOCKETS
.Subscriber = "HOME\myapp"
.SubscriberSecurityMode = DB_AUTHENTICATION
.SubscriberLogin = "sa"
.SubscriberPassword = "nnnn"
.SubscriptionType = PULL
.SubscriptionType = ANONYMOUS
.ExchangeType = BIDIRECTIONAL
.FileTransferType = FILETRANSFERUNC
.AddSubscription CREATE_DATABASE, NONE
.Initialize
.Run
.Terminate
End With
The sub runs up to the ".run" command where the logon failure occurs.
I have cut/pasted the login information into QueryAnalyser and am able to
log into the local Server.
I have noticed that the mdf & ldf files are transfered to the workstation
and the database is visible after running this code (without system tables
only).
I have to manually remove the 'mydb' database from EM before trying again.
Is this a security issue? What steps can I take to troubleshoot this?
Thanks very much.
You have to also specify DistrutionNetwork, DistributorLogin,
DistributorPassword and Distributor
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"astro" <astro@.bcmn.com> wrote in message
news:updsbFFGFHA.2824@.tk2msftngp13.phx.gbl...
> I have setup a replication sandbox with the following:
> server: SQL-Server 2k
> workstation: MSDE 2000 (A)
> I have setup a replication database on my server and configured it for
> anonymous pull subscriptions. I am running this inside my LAN.
> I run the following code in an Access 2000 module:
> With SQLMerge
> .Publisher = "SERVER"
> .PublisherAddress = "SERVER"
> .PublisherSecurityMode = DB_AUTHENTICATION
> .PublisherLogin = "sa"
> .PublisherPassword = "nnnn"
> .PublisherDatabase = "mydb"
> .Publication = "publ_mydb"
> .PublisherNetwork = TCPIP_SOCKETS
> .Subscriber = "HOME\myapp"
> .SubscriberSecurityMode = DB_AUTHENTICATION
> .SubscriberLogin = "sa"
> .SubscriberPassword = "nnnn"
> .SubscriptionType = PULL
> .SubscriptionType = ANONYMOUS
> .ExchangeType = BIDIRECTIONAL
> .FileTransferType = FILETRANSFERUNC
> .AddSubscription CREATE_DATABASE, NONE
> .Initialize
> .Run
> .Terminate
> End With
>
> The sub runs up to the ".run" command where the logon failure occurs.
> I have cut/pasted the login information into QueryAnalyser and am able to
> log into the local Server.
> I have noticed that the mdf & ldf files are transfered to the workstation
> and the database is visible after running this code (without system tables
> only).
> I have to manually remove the 'mydb' database from EM before trying again.
> Is this a security issue? What steps can I take to troubleshoot this?
> Thanks very much.
>
|||oops!
Thanks Hilary
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:ertlFqOGFHA.936@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> You have to also specify DistrutionNetwork, DistributorLogin,
> DistributorPassword and Distributor
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "astro" <astro@.bcmn.com> wrote in message
> news:updsbFFGFHA.2824@.tk2msftngp13.phx.gbl...
to[vbcol=seagreen]
workstation[vbcol=seagreen]
tables[vbcol=seagreen]
again.
>

Analysis Services Role created via AMO has unknown problem.

Hi,

This is a wierd problem so I hope I can explain the situation clearly

I'm creating a single role via AMO for an Analysis Services database and adding domain users to the role just fine. When our 3rd party reporting tool tries to create a report an error gets generated and they bubble back the error shown below.

Now here is the wierd part...if I simply view the Role in SQL Server Managment Management Studio and click OK the problem goes away. If I click Cancel when viewing the Role the problem persists. Obviously when I click "OK" in the Role dialog some sort of save routine is going on and fixes whatever problem is present.

I'm creating the role using standard MSDN examples and everything looks in order. Any suggestions on how I can better track down what the problem is?

System.Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) Thanks

Could you post the code you use to generate the role? I'll compare it to some code we have that is working. My first guess is there is probably something not quite right in the permissions.

Bryan

|||

To see what is different (between the role create with AMO and the role fixed by the dialog), you can do this:

- re-create the role with AMO

- connect with 'SQL Management Studio' and script the Create or Alter operation of the role (right click on the role and there should be the 'Script' option)

- run the role dialog, press 'OK'

- script again and compare with the previous script

Adrian Dumitrascu

Analysis Services on SQL2000 SP4

"unable to browse the dimension [dimension name].

Provider cannot be found. or Unknown Error.

Everything else looks good, like processsing, looking at the tables,fields, datasource is connected.

Dear,

Did u used a shared dimension in the cube.

from

sufian

|||

I tried both, shared and not shared. Input is from Access db. It fails already in the Create Dimension Wizard screen. Data should be populated on the screen

|||

Can you please describe your situation in bit more details.

What version of Analysis Services you are using?
What relational database are you using?
What OLEDB provider ?
What is the exact error message you are getting and at what stage?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Analysis Services Version 8.0.194

Input Database MS Access2000

Provider = MS Jet 4.0 OLE DB Provider

OS = Windows 2000 Professional with SP4

Error appears already on the Finish the Dimension Wizard Screen

"Unable to browse the dimension [dimension name]. Unspecified Error.

I have processed the cube and the dimension. I get the count on all records processed.

Also if I try to browse data on individual dimension(s)I get ;

"Unable to browse the dimension [dimension name]. Provider not found or not properly installed" however testing the database connection works fine.

|||

What happens if you try to browse your cube after your processed it? Do you see dimensions and measures?

I suspect you just having problem browsing dimension. Is that so?

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

FYI - I am using Professional SQL Server 2000 Programming by Robert Vieira (WROX) See page 920 top(data is already displayable for the Customer Dimension at creation time. I fail right there.

To answer your questions: I cannot browse the cube after processing - Same error "Unable to browse the cube - unspecified error".

Same applies to the dimensions.

Validate dimension, Count Dimension members and metadata all check out. Processing is going to normal end for both cube and individual dimensions and I get the correct number of members that I am supposed to get with no errors in processing.

|||

It is possible that you got some client components installation corrupted.

Try installing "Microsoft SQL Server 2000 PivotTable Services " from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks again, but no cigar. To install pivot tables I had to de-install Analysis Services, Install the pivot tables and re-install the Analysis. However I can't browse the results and/or the cube.

I went a step further installing SQL Server 2000 and Analysis Services on a different PC, using Windows XP with the same negative results.

Unable to browse the Cube [cube name] or

Unable to browse the dimension [dimension name]

Unspecified error. It will help how to find and read the OLAP server error logs or dump for a better understanding of what is wrong.

Since I am using the same version of the SQL Server (developer edition 8.00.760(SP3) from Microosoft) on both PC's I tend to believe there is a limitation on it. I have no other logical explanation.

|||

Are you talking about SP3 or SP4? The title suggests you'd like to install SP4.

Is that so?

Please make sure your run the same service pack version of the server and client.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Veo,

Is the Access database stored on a network drive? The Analysis Services service would normally be installed to run as a system account which would not have access to network resources.

|||

I am the administrator of my PC. Acces is installed on the same PC with the SQL Server.

Operating system Windows2000 has SP4 applied and SQL Server has SP3 applied.

My next step will be to import Access data base into SQL 2000 to see if that makes a difference

|||

I think you should be better off with keeping your database in SQL Server.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.