RE: Upgrade from 2005 to 2008: Invalid Credentials
- From: changliw@xxxxxxxxxxxxxxxxxxxx ("Charles Wang [MSFT]")
- Date: Thu, 02 Oct 2008 07:02:18 GMT
Hi Mark,
From your description, I understand that when you upgrade your SQL Server 2005 to 2008, you encountered the error:"The credentials you provided for the Integration Services service are invalid. To continue, provide a valid account and password for the Integration Services service."
If I have misunderstood, please let me know.
According to my research, this seems to be a known issue for installing SQL Server 2008 on Domain Controller. Currently it has been reported to our product team and the root cause is still in
investigation. Based on the current status, it seems that this issue was related to NETWORK SERVICE account for SSIS service could not be validated on DC. By default SSIS uses NETWORK
SERVICES as its service account.
Please first go to your Services pane, double click your SQL Server Integration Services, switch to the Log On tab to check if the service account is NETWORK SERVICE account. If so, I
recommend that you first change you try the service account to a domain user account or a local user account and then upgrade your SQL Server 2005 to 2008 from command prompt.
For example:
========================================================
Setup.exe /q /ACTION=upgrade /INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /RSUPGRADEDATABASEACCOUNT="<Provide a SQL Server logon
account that can connect to the report server during upgrade>" /RSUPGRADEPASSWORD="<Provide a password for the report server upgrade account>" /ISSVCAccount="<Provide a domain
user account for your integration service>" /ISVCPassword="<Provide the password for your domain user account for your integration service>"
=========================================================
For more information regarding install SQL Server 2008 from command prompt, please refer to this article:
How to: Install SQL Server 2008 from the Command Prompt
http://msdn.microsoft.com/en-us/library/ms144259.aspx
Hope this helps.
Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.
Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
.
- Follow-Ups:
- Re: Upgrade from 2005 to 2008: Invalid Credentials
- From: Mark Olbert
- Re: Upgrade from 2005 to 2008: Invalid Credentials
- From: Mark Olbert
- Re: Upgrade from 2005 to 2008: Invalid Credentials
- From: Mark Olbert
- Re: Upgrade from 2005 to 2008: Invalid Credentials
- References:
- Upgrade from 2005 to 2008: Invalid Credentials
- From: Mark Olbert
- Upgrade from 2005 to 2008: Invalid Credentials
- Prev by Date: Upgrade from 2005 to 2008: Invalid Credentials
- Next by Date: Re: SQL Server Cluster Setup
- Previous by thread: Upgrade from 2005 to 2008: Invalid Credentials
- Next by thread: Re: Upgrade from 2005 to 2008: Invalid Credentials
- Index(es):
Relevant Pages
|
