connection problem 2k -
03-17-2005
, 05:31 PM
I am trying to create a new cube from a SQL 2k in the database. I walked
thru the wizard to set up a data source and was successful, including setting
up the server name and the database name with login and password. I also
pressed the test connection button and it worked.
Next I went to the cube section and tried to start the cube wizard. At that
point the connection failed message came up. Here is the message:
---------------------------
Connection failed
---------------------------
Connection to the 'laptopdev - ItemAdmin' data source failed.
Error: Login failed for user 'UserMaster'.
Do you want to retry?
---------------------------
Yes No
Can you please help me with this issue?
Thanks in advance,
Stewart Rogers |