Upgrade to CMS 6 problem

Iwona Lalik

Vote:

Hi,

During the upgrade from CMS 5 to CMS 6 I met an error which says: "Error - Login failed for user ''. The user is not associated with a trusted SQL Server connection." My default provider for rolemanager is set to Multiplexing, the same as membership one. Connection strings looks like this: <add name="EPiServerDB" connectionString="server=ip_address;database=databasename; User ID=username;Password=password;Connection Timeout=30;" providerName="System.Data.SqlClient" />

These settings work fine for all the aplication but when it somes to upgrade they don't.

#39651

May 27, 2010 11:11

Magnus Wallin

Vote:

Hello

We are experiencing the exact same problem. We suspect is has something to do with the Webserver not beeing in the same domain as the SQL-server. But we don't know. The upgrade from CMS5 SP2 to CMS5 R2 works like a charm.

Do someone have a solution to this problem? Doesn't deployment center support pure SQL-users?

#44081

Edited, Sep 30, 2010 11:20

Magnus Wallin

Vote:

Update!

We opened a query to the support and this is a known bug. Deployment Center when upgrading to CMS6 uses the user that starts the program, and not the information in connectionstrings.

Doesn't solve our problems, but atleast now we know. Mayby this information helps someone else.

Over and out.

#44089

Sep 30, 2010 12:31

Steve Celius

Vote:

Create an administrator user account on the machine where you run Deployment Center and the same username and password on the sql server (make it an Administrator, so it should be a sysadmin too.)

Run Deployment Center as this user (run as, or log in as). The upgrade should run fine.

Also, unrelated, but I think I remember a bug somewhere when using "server" instead of "datasource" in the connection string. Was in the previous deployment center (early versions I think).

#44095

Sep 30, 2010 13:40

Magnus Wallin

Vote:

We found a workaround close to your suggestion Steve:

- Add a domain user to DB-server with owner rights on the EpiServer database
- Run command:
runas /netonly /user:<DOMAIN>\<USER>"C:\Program Files (x86)\EPiServer\Shared\Install\EPiServerInstall.exe"

This starts deploymentcenter using the local account, but with the /netonly-switch we use the domain account for all network traffic. So we both get the local access and the network access we need.

#44100

Sep 30, 2010 14:13