Problems Deleting / Renaming Dimensions

I had a problem with a dimension and so decided to re-created it. Once I was happy with the new dimension I deleted the old and renamed the new to what the old one was called previously. When I try and build my cube I get the following error:

Error 18 Errors in the metadata manager. The dimension with the name of 'dim_product' already exists in the 'Sales_AS' database.

Not sure why this is happening as I thought I'd got rid of all trace of the old dimension. If I rename the new dimension I have no problem.

Is anyone able to explain what's going on here? Thanks.

If you deploy with the default settings the old dimension still exists on the server and if you want too deploay a second one with the same name (but for sure a different id) the server does not allow this.

Try delete the DB from Analysis services and deploy the whole DB again (if possible for your solution).

HANNES

Problems after moving rebuilding a server and reconnect to old DBs

Hello,
I've the following problem:
running sql server on machine A
running reportservices on machine B
machine B is a week one, so I ordered from our IT a bigger server and
reinstall everything (win2003 / reportservices ...)
after setup everything works fine! (remember sql DBs on machine A,
webservice on machine B => "webfarm")
so I started take my midnight backup of the "old" reportserver-DB /rs-temp-
DB and restore them on machine A, I've followd all the steps in kb-artikle
842425 "how to move a rs database ..."
everthings works fine, but when I try to open the
http:/localhost/reports/pages/folder.aspx
I got the following strange error:
Diese Edition von Reporting Services unterstützt keine
Webfarmbereitstellungen. (rsInvalidRSEditionConfiguration)
(its german an means: This edition of reporting services does not provide
webfarm constellation)
WHY?
before restoring the DBs, the same constellation works fine! Does my
Reporting Service now think he has to use 2 different DBs? How can I fix it?
I have SQL SERVER Standart Edition (2 licenses)/ Reporting Services Standart
Edition
thanks for forcomming help
sequalDONE!!!
I've found a post from Brian Hartmann!
THANXS!!!!
"sequal" wrote:
> Hello,
> I've the following problem:
> running sql server on machine A
> running reportservices on machine B
> machine B is a week one, so I ordered from our IT a bigger server and
> reinstall everything (win2003 / reportservices ...)
> after setup everything works fine! (remember sql DBs on machine A,
> webservice on machine B => "webfarm")
> so I started take my midnight backup of the "old" reportserver-DB /rs-temp-
> DB and restore them on machine A, I've followd all the steps in kb-artikle
> 842425 "how to move a rs database ..."
> everthings works fine, but when I try to open the
> http:/localhost/reports/pages/folder.aspx
> I got the following strange error:
> Diese Edition von Reporting Services unterstützt keine
> Webfarmbereitstellungen. (rsInvalidRSEditionConfiguration)
> (its german an means: This edition of reporting services does not provide
> webfarm constellation)
> WHY?
> before restoring the DBs, the same constellation works fine! Does my
> Reporting Service now think he has to use 2 different DBs? How can I fix it?
> I have SQL SERVER Standart Edition (2 licenses)/ Reporting Services Standart
> Edition
> thanks for forcomming help
> sequal

Problems Accessing SQL after going from SQL 2000 to Mgmt Studio SQL 2005

I installed Mgmt Studio and SQL 2005 on a new server - I imported my complete old SQL 2000 databases - then shut down my Original SQL 2000 server and used that Idenitical IP as the Mgmt Studio SQL 2005's IP

I am using Linux Jakarta Tomcat v5.0.27 and all SQL references are referring only to the IP number of ther server and not using DNS -

Originally I was getting an error when my system tried to access the SQL stating that it was an untrusted connection - I then realized that the IP number referred to was not the primary IP and I changed that so the it was.

Both the Linux and SQL 2005 are now using network IPs and then I got a message that the password that I was using was not strong enough so I changed that as well - then all my logging dissappeared

When I try to connect now there is no indication in any log (SQL nor Windows) that I am attempting to connect - the website just hangs for like 3 minutes and fails the login stating that the username/password is incorrect (or it could not verify it) even though I changed nothing on the Tomcat side and it was logging before the IP werent matching.

Is there a significance difference between SQL 2000 and SQL 2005 that will not allow my Tomcat to connect?

Few Addl Notes
I can ping to and from each server
I can telnet from Linux to SQL 2005
Linux of course is not part of my Windows 2003 Domain but it is on the same network

Any and all help would be greatly appreciated

Did you already enable remote connections on the SQL Server 2005 ? See more information in my site in the Screencast section.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Yes - I have SQL 2005 Standard Edition which listens over TCPIP but I changed it to Use both TCPIP and pipes just in case - no luck - I also have already made sure that both Authentications are allowed (Windows and SQL)

Here is an error I am getting
Date 11/14/2006 11:58:00 AM
Log Windows NT (Application)

Source MSSQLSERVER
Category Logon
Event 3221243928
Computer SLATE2

Message
Login failed for user 'swamy'. [CLIENT: 207.145.184.148]

Now I can get ODBC connections with this response from an XP Client
Date 11/14/2006 12:47:14 PM
Log SQL Server (Current - 11/14/2006 12:47:00 PM)

Source Logon

Message
Login succeeded for user 'BESTREG\Swamy'. Connection: trusted. [CLIENT: 207.145.184.93]

|||Could you please post your connectstring here ?

-Jens.