problem in connecting diff server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Analysis Services (2000)

problem in connecting diff server

Author

Topic

Devarajan
Starting Member

13 Posts

Posted - 2004-07-09 : 11:03:42

I got the error below when i created th cube using the data in SQL server databasee from the different server on processing the cube i am getting the following error

[Microsoft][ODBC SQL Server Driver][SQL Server]Login
failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.;28000;
Time:8/8/2003 8:27:16 PM

The login for all the systems are same
I used windows authentication mode

G.Devarajan
S/o K.Gopalakrishnan

jojo_jacob
Starting Member

24 Posts

Posted - 2004-07-09 : 11:14:11

The problem must be sue to lack of privilages in the SQL Server database. Add the login for your windows domain user there and give access to the needed database.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources