setup os: xp sp2, SQL Server 2005

Topics: Technical Questions
Mar 21, 2008 at 9:52 PM
I am encountering problems while installing MSE at the system like in subject.

Below important part of a log file:

InstallFiles: File: AddIntegersResponse.xslt, Directory: C:\Program Files\Microsoft Managed Services Engine\Samples\, Size: 789
InstallFiles: File: Walkthrough.xps, Directory: C:\Program Files\Microsoft Managed Services Engine\Documents\, Size: 500682
InstallFiles: File: InstallationGuide.xps, Directory: C:\Program Files\Microsoft Managed Services Engine\Documents\, Size: 907110
InstallFiles: File: TechnicalGuide.xps, Directory: C:\Program Files\Microsoft Managed Services Engine\Documents\, Size: 4865871
Action 21:45:56: CreateDatabase. Creating Databases
CreateDatabase: Error 0x80004005: failed to create to database: 'MSE6DB', error: unknown error
Error 26201. Error -2147467259: failed to create SQL database: MSE6DB, error detail: unknown error.
MSI (s) (40!44) 21:47:25:328: Product: Microsoft Managed Services Engine -- Error 26201. Error -2147467259: failed to create SQL database: MSE6DB, error detail: unknown error.
Apr 1, 2008 at 12:46 AM
I had the same problem. MSE is connecting to the sql server 2005 using named pipes. I enabled named pipes via the Configuration Manager and the installation went smoothly.

HTH,
An
Apr 24, 2008 at 3:52 PM
I am having the same issue.

Product: Microsoft Managed Services Engine -- Error 26201. Error -2147467259: failed to create SQL database: MSE6DB, error detail: unknown error.

I tried enabling the named pipes. Still i have the problem.

Am i missing something?

Thanks,
--Kurinchi

Apr 25, 2008 at 6:15 AM
Hi Kurinchi,

Did you stop and restart the mssqlserver service?
Which OS are you using?
Apr 25, 2008 at 4:16 PM
Yes. I stoped and restarted the mssqlserver service.
I am using XP, SP2, SQL Server 2005.

and my machine also has VS 2005, VS 2008 and SQL Express.

Thanks,
--Kurinchi
Apr 29, 2008 at 1:53 PM
I figured out. My Windows credentials was a member of database sysadmin role on that SQL Server 2005 . I added dbcreator access and it works.

Thanks,
--Kurinchi
May 24, 2008 at 8:05 PM
I am also experiencing the same installation problem.  I'm an administrator on the machine and am using SQL Server 2005.  I've also enabled named pipes as suggested by a previous post and still have the problem.  Any more help/insight would be appreciated.

Cheers,
Steve
May 24, 2008 at 11:38 PM
I am also experiencing the same installation problem.  I'm an administrator on the machine and am using SQL Server 2005.  I've also enabled named pipes as suggested by a previous post and still have the problem.  Any more help/insight would be appreciated.

Cheers,
Steve
May 26, 2008 at 8:33 AM


stevehart wrote:
I am also experiencing the same installation problem.  I'm an administrator on the machine and am using SQL Server 2005.  I've also enabled named pipes as suggested by a previous post and still have the problem.  Any more help/insight would be appreciated.

Cheers,
Steve


Did you restart the mssql service?  Are you using Windows Vista and have UAC enabled?  If so, you'll need to install MSE from a command prompt with adminsitrator privileges.  Are you getting the same error code?
May 26, 2008 at 5:07 PM
Yes, I have restarted the mssql service.  I'm using Windows XP SP2.
Jun 4, 2008 at 7:22 PM


stevehart wrote:
Yes, I have restarted the mssql service.  I'm using Windows XP SP2.


Check if BUILTIN\Administrators is a member of the sysadmin fixed server role.  If this account does not exists or is not a member, add your own account to the sysadmin fixed server role.