Post reply

AnalysisServices deployment wizard set user id and password null

  • November 4, 2010 at 12:37 pm

    #242619

    I have upgraded from SQL 2008 to SQL 2008 R2.

    Deploy the cubes to server by using files (.asdatabase, .deploymenttargets, .configsettings, .deploymentoptions) in command prompt using Microsoft.AnalysisServices.Deployment.exe in silent mode.

    When i deploy using SQL 2008, user id and password is there. But if i deploy using SQL 2008 R2, user id and password is null.

    The deployment process is same for both which is through command prompt, but why in SQL 2008 R2 user id/password is null?

    Any help will be great.

  • November 12, 2010 at 9:19 am

    #1250105

    We are having the same problem, however our issues started with SQL 2008 and still happen in SQL 2008 R2. When we deploy using SQL 2005 SP1 it works. Now that we are using new features of R2 we have to use the R2 to deploy and the username/password are empty.

    When we deploy using the command line to launch the GUI we see the username and password, however when it completes and we open the data connection it's gone.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply