Anonymous Logon error since SP4

Since SP4 my application and SQL log are filling with "Login failed for user
"NT Authority\Anonymous Logon". Where can I find more information
concerning this?
I've seen one or two references to this error showing up with SQL
replication but this is a single server install.
-trevor
Trevor,
Check that SQL Server is running under a domain account - this error
commonly occurs when running as LocalSystem and you try to access network
resources.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Trevor Miller" wrote:

> Since SP4 my application and SQL log are filling with "Login failed for user
> "NT Authority\Anonymous Logon". Where can I find more information
> concerning this?
> I've seen one or two references to this error showing up with SQL
> replication but this is a single server install.
> -trevor
>
>
|||SQL server indeed runs as LocalSystem but it's always been configured this
way, is the error msg a result of SP4 or a change in behavior? What network
resources would SQL be trying to access? I've tried putting the computer
account into domain admins but the error persists.
Additional advise?
-trevor
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:30AAB157-EB94-4680-B088-44689F364AF9@.microsoft.com...[vbcol=seagreen]
> Trevor,
> Check that SQL Server is running under a domain account - this error
> commonly occurs when running as LocalSystem and you try to access network
> resources.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Trevor Miller" wrote:

Anonymous Logon error since SP4

Since SP4 my application and SQL log are filling with "Login failed for user
"NT Authority\Anonymous Logon". Where can I find more information
concerning this?
I've seen one or two references to this error showing up with SQL
replication but this is a single server install.
-trevorTrevor,
Check that SQL Server is running under a domain account - this error
commonly occurs when running as LocalSystem and you try to access network
resources.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Trevor Miller" wrote:

> Since SP4 my application and SQL log are filling with "Login failed for us
er
> "NT Authority\Anonymous Logon". Where can I find more information
> concerning this?
> I've seen one or two references to this error showing up with SQL
> replication but this is a single server install.
> -trevor
>
>|||SQL server indeed runs as LocalSystem but it's always been configured this
way, is the error msg a result of SP4 or a change in behavior? What network
resources would SQL be trying to access? I've tried putting the computer
account into domain admins but the error persists.
Additional advise?
-trevor
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:30AAB157-EB94-4680-B088-44689F364AF9@.microsoft.com...[vbcol=seagreen]
> Trevor,
> Check that SQL Server is running under a domain account - this error
> commonly occurs when running as LocalSystem and you try to access network
> resources.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Trevor Miller" wrote:
>

Anonymous Logon error since SP4

Since SP4 my application and SQL log are filling with "Login failed for user
"NT Authority\Anonymous Logon". Where can I find more information
concerning this?
I've seen one or two references to this error showing up with SQL
replication but this is a single server install.
-trevorTrevor,
Check that SQL Server is running under a domain account - this error
commonly occurs when running as LocalSystem and you try to access network
resources.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Trevor Miller" wrote:
> Since SP4 my application and SQL log are filling with "Login failed for user
> "NT Authority\Anonymous Logon". Where can I find more information
> concerning this?
> I've seen one or two references to this error showing up with SQL
> replication but this is a single server install.
> -trevor
>
>|||SQL server indeed runs as LocalSystem but it's always been configured this
way, is the error msg a result of SP4 or a change in behavior? What network
resources would SQL be trying to access? I've tried putting the computer
account into domain admins but the error persists.
Additional advise?
-trevor
"Mark Allison" <marka@.no.tinned.meat.mvps.org> wrote in message
news:30AAB157-EB94-4680-B088-44689F364AF9@.microsoft.com...
> Trevor,
> Check that SQL Server is running under a domain account - this error
> commonly occurs when running as LocalSystem and you try to access network
> resources.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "Trevor Miller" wrote:
>> Since SP4 my application and SQL log are filling with "Login failed for
>> user
>> "NT Authority\Anonymous Logon". Where can I find more information
>> concerning this?
>> I've seen one or two references to this error showing up with SQL
>> replication but this is a single server install.
>> -trevor
>>

Anaylsis Services over HTTP

Hi guys,
I am hoping this will be a quick one. I am using Analysis Services 2000 with SP4 on Windows XP. It is the Developer Edition so I should have all the functionality of the Enterprise Edition without the scalability.

Ok, so I have followed the “INF: How to Connect to Analysis Server 2000 By Using HTTP Connection” (http://support.microsoft.com/?kbid=279489) article on MSDN. On completing the steps I did see a blank page, which suggests everything is working properly. However, when I try to connect to Analysis Services via HTTP it is unable to see the OLAP database. I have tried this with the MDX Sample Application, Excel and an OLAP Report web application and neither can connect to the database using HTTP. I can, however, connect to the OLAP database if I connect to the server without using HTTP.

I could well be missing something very simple and if that’s the case then great. I have tried changing the security of IIS to use anonymous, basic authentication and windows integrated authentication but neither affect the visibility of the OLAP database. I have also examined the IIS log files but there is nothing that indicates errors.

Any help would be gratefully appreciated.

Let's try to get this straight:

- you can connect to the server over HTTP

- but you can't see any databases

Is that accurate? If yes, then most likely it is a permissions issue -- turn *off* the Anonymous access and turn *on* Integrated authentication. Then try again.

HTH,

Akshai

Analysis Services: Data source provider error

Trying to go through the Analysis Services tuturial. Logged in as Administrator on a 64 bit W2K server. SQL Server 2000 AS and SP4.

As I come to the Design Storage step I get a message saying
Data source provider error: ; Time:2006-04-10 19:51:47
There are no further details given and the Event Logger has nothing.

Grateful for any help.

Screenshot: http://i23.photobucket.com/albums/b366/biund/sql/DesignStorageproblem.png

And the version Screenshot:
http://i23.photobucket.com/albums/b366/biund/sql/DesignStorageproblem2.pngReason was probably that I defined the data source as a User DSN. Should have been System DSN.

I opted to use Jet instead or the Access driver - solved it.|||I'm just starting out with Analysis Services. Also new working with databases. A friend of mine sent me a couple of Databases and they are files with .mdf file extensions. When I try and setup datasource in the control panel wizard, there are no drivers with the .mdf extensions. Just .dbo and others.

Could you explain to me what I need to do to get AS to work with my databases?

Thanks in advance,
Milfredo|||No idea how the drivers are distributed, but I guess installing MS Access will do it. Probably instaling Analys Services includes driver installation.

I am more of a unix guy, so do not trust me. :D

Analysis Services SP4 problems

Hello I hope someone can help me.

On a SQL server that has had SP4 recently installed on it for both the SQL Server service and OLAP service, I am unable to browse the data of any of the Shared Dimensions or Cubes of any of the databases when I use the Analysis Manager MMC. At the time I am logged onto the server as an administrator using terminal services. Upon attempting to browse a shared dimension the following error is returned "Unable to browse the dimension <dimension name>, Type mismatch" and when attempting to browse a cube the error is "Unable to browse the cube <cube name>. An unexpected internal error has occured. Please restart the application."

The Cubes can be browsed via Excel though and all Reporting Service mdx queries are functioning correctly.

If I register the same server in Analysis Manager MMC on a different server also with SP4 all Cubes and Dimensions data can be browsed.

I tried archiving the database cubes and restoring them on a server with SP3 and all data can be browsed via the servers own Analysis Manager MMC.

Any ideas?

This can be related to an MDAC version issue if this post is correct: http://www.dbforums.com/archive/index.php/t-357508.html

Regards

Thomas Ivarsson

|||

I suspect you are right. Thank you for the help Thomas.

On the servers that have "MDAC 2.8 on Windows XP SP2" seem to have the same problem. Servers that are using "MDAC 2.8 RTM" are all functioning correctly, (as determined by "Component Checker").

Do you happen to know the link of a webpage that gives a walkthrough on how to perform a MDAC Rollback?

I have not found any information on how to do this correctly.

|||

Sorry, I have no link, except that I think there is a newsgroup for this(http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1).

Kind Regards

Thomas Ivarsson

|||

I have encountered the same situation aftr installing SP4. Please let me know how to fix this apparently MDAC related problem

Thanks

Attila

|||

I am currently administrating the production Analysis Server with Analysis Manager MMC via a remote connection that also uses "MDAC 2.8 on Windows XP SP2". This permits browsing of dimension and cube data as well as virtual cube editing. (An annoying work around).

I have discovered that "MDAC 2.8 RTM" seems to function correctly but I have not yet found the correct procedure for performing a MDAC rollback, which is quite probably quite complicated considering all the dll's and registry settings involved. All I can suggest is to browse the relevant forum as per Thomas's rely above.

Best of luck.

Analysis Services SP4 problems

Hello I hope someone can help me.

On a SQL server that has had SP4 recently installed on it for both the SQL Server service and OLAP service, I am unable to browse the data of any of the Shared Dimensions or Cubes of any of the databases when I use the Analysis Manager MMC. At the time I am logged onto the server as an administrator using terminal services. Upon attempting to browse a shared dimension the following error is returned "Unable to browse the dimension <dimension name>, Type mismatch" and when attempting to browse a cube the error is "Unable to browse the cube <cube name>. An unexpected internal error has occured. Please restart the application."

The Cubes can be browsed via Excel though and all Reporting Service mdx queries are functioning correctly.

If I register the same server in Analysis Manager MMC on a different server also with SP4 all Cubes and Dimensions data can be browsed.

I tried archiving the database cubes and restoring them on a server with SP3 and all data can be browsed via the servers own Analysis Manager MMC.

Any ideas?

This can be related to an MDAC version issue if this post is correct: http://www.dbforums.com/archive/index.php/t-357508.html

Regards

Thomas Ivarsson

|||

I suspect you are right. Thank you for the help Thomas.

On the servers that have "MDAC 2.8 on Windows XP SP2" seem to have the same problem. Servers that are using "MDAC 2.8 RTM" are all functioning correctly, (as determined by "Component Checker").

Do you happen to know the link of a webpage that gives a walkthrough on how to perform a MDAC Rollback?

I have not found any information on how to do this correctly.

|||

Sorry, I have no link, except that I think there is a newsgroup for this(http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1).

Kind Regards

Thomas Ivarsson

|||

I have encountered the same situation aftr installing SP4. Please let me know how to fix this apparently MDAC related problem

Thanks

Attila

|||

I am currently administrating the production Analysis Server with Analysis Manager MMC via a remote connection that also uses "MDAC 2.8 on Windows XP SP2". This permits browsing of dimension and cube data as well as virtual cube editing. (An annoying work around).

I have discovered that "MDAC 2.8 RTM" seems to function correctly but I have not yet found the correct procedure for performing a MDAC rollback, which is quite probably quite complicated considering all the dll's and registry settings involved. All I can suggest is to browse the relevant forum as per Thomas's rely above.

Best of luck.

Analysis Services SP4 problems

Hello I hope someone can help me.

On a SQL server that has had SP4 recently installed on it for both the SQL Server service and OLAP service, I am unable to browse the data of any of the Shared Dimensions or Cubes of any of the databases when I use the Analysis Manager MMC. At the time I am logged onto the server as an administrator using terminal services. Upon attempting to browse a shared dimension the following error is returned "Unable to browse the dimension <dimension name>, Type mismatch" and when attempting to browse a cube the error is "Unable to browse the cube <cube name>. An unexpected internal error has occured. Please restart the application."

The Cubes can be browsed via Excel though and all Reporting Service mdx queries are functioning correctly.

If I register the same server in Analysis Manager MMC on a different server also with SP4 all Cubes and Dimensions data can be browsed.

I tried archiving the database cubes and restoring them on a server with SP3 and all data can be browsed via the servers own Analysis Manager MMC.

Any ideas?

This can be related to an MDAC version issue if this post is correct: http://www.dbforums.com/archive/index.php/t-357508.html

Regards

Thomas Ivarsson

|||

I suspect you are right. Thank you for the help Thomas.

On the servers that have "MDAC 2.8 on Windows XP SP2" seem to have the same problem. Servers that are using "MDAC 2.8 RTM" are all functioning correctly, (as determined by "Component Checker").

Do you happen to know the link of a webpage that gives a walkthrough on how to perform a MDAC Rollback?

I have not found any information on how to do this correctly.

|||

Sorry, I have no link, except that I think there is a newsgroup for this(http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1).

Kind Regards

Thomas Ivarsson

|||

I have encountered the same situation aftr installing SP4. Please let me know how to fix this apparently MDAC related problem

Thanks

Attila

|||

I am currently administrating the production Analysis Server with Analysis Manager MMC via a remote connection that also uses "MDAC 2.8 on Windows XP SP2". This permits browsing of dimension and cube data as well as virtual cube editing. (An annoying work around).

I have discovered that "MDAC 2.8 RTM" seems to function correctly but I have not yet found the correct procedure for performing a MDAC rollback, which is quite probably quite complicated considering all the dll's and registry settings involved. All I can suggest is to browse the relevant forum as per Thomas's rely above.

Best of luck.

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.

Analysis Services 2005 is not getting connected

All,

I am running Windows 2003 Server Standard Edition. Installed SQL Server 2000 and SP4 with default instance.

Installed SQL Server 2005 including analysis services with named instance (SQL2005).

Able to connect to SQL Server 2005. But when i am trying to connect to analysis services with

Windows authentication and server name as "UKPRESALES1\SQL2005".

Getting an Error : "A connection cannot be made to redirector. ensure that sqlbrowser service is running."

Pls suggest me. Finally I ended up in un-installing everything and trying out.

Raja.

Have you read the following paper on AS connectivity problems?

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

It could be a firewall problem...

HTH,

Chris

|||

Indeed, please make sure that both Analysis Services 2005 (msmdsrv.exe) and SQL Browser are allowed in the firewall to accept connections (related article here: http://msdn2.microsoft.com/en-us/library/ms175638.aspx).

|||

hello chris,

Windows Firewall have been disabled already. That too i am trying to connect in the local machine. Even the Sql browser service is running under local account.

As of now i am trying to install sql 2005 in default instance. Later I will install Sql 2000 with named instance.

Pls help me if any other solution is available.

Rajas.

|||So, to be clear - you can't connect even from the same server that you've installed AS on?

Analysis Services 2005 is not getting connected

All,

I am running Windows 2003 Server Standard Edition. Installed SQL Server 2000 and SP4 with default instance.

Installed SQL Server 2005 including analysis services with named instance (SQL2005).

Able to connect to SQL Server 2005. But when i am trying to connect to analysis services with

Windows authentication and server name as "UKPRESALES1\SQL2005".

Getting an Error : "A connection cannot be made to redirector. ensure that sqlbrowser service is running."

Pls suggest me. Finally I ended up in un-installing everything and trying out.

Raja.

Have you read the following paper on AS connectivity problems?

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx

It could be a firewall problem...

HTH,

Chris

|||

Indeed, please make sure that both Analysis Services 2005 (msmdsrv.exe) and SQL Browser are allowed in the firewall to accept connections (related article here: http://msdn2.microsoft.com/en-us/library/ms175638.aspx).

|||

hello chris,

Windows Firewall have been disabled already. That too i am trying to connect in the local machine. Even the Sql browser service is running under local account.

As of now i am trying to install sql 2005 in default instance. Later I will install Sql 2000 with named instance.

Pls help me if any other solution is available.

Rajas.

|||So, to be clear - you can't connect even from the same server that you've installed AS on?