Database connection problem

Hi,

I have a retail version of FP2007 XPE development tools. Everything worked
pretty well (from development to deployment) until now I got "Cannot connect
to the database at 'xxxxx'. Please verify your database connection" error
message when I launched Component Database Manager. I never had a remote
database connection and I always have the database in the XPE development
machine. I suspect this could be related to my recent installation of
"Microsoft Visual C# 2008 Express Edition"

Here are the error messages I got from event log.

The CMI encountered the following error: 0x80042335 (-2147212491) Method
CMI.OpenDB failed.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

The CMI encountered the following error: 0x80042335 (-2147212491) A database
error occurred within the CMI. For more information see the application event
log.

\utilc-481

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

The CMI encountered the following error: 0x80004005 (-2147467259) Error
occurred in CMI.
HRESULT: 0x80004005 (-2147467259)
Source: Microsoft OLE DB Provider for SQL Server
Source IID: Interface IID not available
Description: [DBNETLIB][ConnectionOpen (Initialize()()).]General network
error. Check your network documentation.
Help file: Help file not available
Help context: 0
Database Errors:
************************************************** ******************************
ADO Error Number: 0x80004005 (-2147467259)
Source: Microsoft OLE DB Provider for SQL Server
Native Error: 0x0000000B (11)
SQL State: 08001
Help Context: 0
Description: [DBNETLIB][ConnectionOpen (Initialize()()).]General network
error. Check your network documentation.


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

I have tried to reboot the computer, restart SQL Server(SQLEXPRESS), and SQL
Server Browser and still I got the same error. I would appreciate if you can
provide me info to resolve this.
--
Chip

It happend to me also, if I installed Visual Studio after Embedded
tools.
What you should start is MSSQLSERVER and not SQLSERVER. MSSQLSERVER is
the one that manages Embedded data. That is the one that is installed
when you install Embedded tools.
Or uninstall MSSQLSERVER and install it again.


Chip wrote:
> Hi,
>
> I have a retail version of FP2007 XPE development tools. Everything worked
> pretty well (from development to deployment) until now I got "Cannot connect
> to the database at 'xxxxx'. Please verify your database connection" error
> message when I launched Component Database Manager. I never had a remote
> database connection and I always have the database in the XPE development
> machine. I suspect this could be related to my recent installation of
> "Microsoft Visual C# 2008 Express Edition"
>
> Here are the error messages I got from event log.
>
> The CMI encountered the following error: 0x80042335 (-2147212491) Method
> CMI.OpenDB failed.
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> The CMI encountered the following error: 0x80042335 (-2147212491) A database
> error occurred within the CMI. For more information see the application event
> log.
>
> \utilc-481
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> The CMI encountered the following error: 0x80004005 (-2147467259) Error
> occurred in CMI.
> HRESULT: 0x80004005 (-2147467259)
> Source: Microsoft OLE DB Provider for SQL Server
> Source IID: Interface IID not available
> Description: [DBNETLIB][ConnectionOpen (Initialize()()).]General network
> error. Check your network documentation.
> Help file: Help file not available
> Help context: 0
> Database Errors:
> ************************************************** ******************************
> ADO Error Number: 0x80004005 (-2147467259)
> Source: Microsoft OLE DB Provider for SQL Server
> Native Error: 0x0000000B (11)
> SQL State: 08001
> Help Context: 0
> Description: [DBNETLIB][ConnectionOpen (Initialize()()).]General network
> error. Check your network documentation.
>
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> I have tried to reboot the computer, restart SQL Server(SQLEXPRESS), and SQL
> Server Browser and still I got the same error. I would appreciate if you can
> provide me info to resolve this.
> --
> Chip

Hi Danis,

Thank you for your reply. I have tried to stop and then start MSSQLSERVER
through Services in Computer Management. I still have the same problem when
I launch Component Database Manager. I guess my next option is to uninstall
MSSQLSERVER and install it again. But I have some concern about before doing
that. I have very limited knowledge about MSSQLSERVER and SQLSERVER and I
concern about uninstall SQLSERVER may actually remove my component database
that includes all FP2007 components from MS and my own custom components.
Could you or anyone else comment on this? I really don't want to lose my
custome components in the database.

When I take a look of the XPE install CD Databae Engine Setup, it mentioned
about Component Database run on either SQL Server or MSDE. How do I know
which one I am using in my XPE development computer because I don't remember
what I did in the installation long time ago?

Thanks again.
--
Chip


"danis" wrote:

> It happend to me also, if I installed Visual Studio after Embedded
> tools.
> What you should start is MSSQLSERVER and not SQLSERVER. MSSQLSERVER is
> the one that manages Embedded data. That is the one that is installed
> when you install Embedded tools.
> Or uninstall MSSQLSERVER and install it again.
>
>
> Chip wrote:
> > Hi,
> >
> > I have a retail version of FP2007 XPE development tools. Everything worked
> > pretty well (from development to deployment) until now I got "Cannot connect
> > to the database at 'xxxxx'. Please verify your database connection" error
> > message when I launched Component Database Manager. I never had a remote
> > database connection and I always have the database in the XPE development
> > machine. I suspect this could be related to my recent installation of
> > "Microsoft Visual C# 2008 Express Edition"
> >
> > Here are the error messages I got from event log.
> >
> > The CMI encountered the following error: 0x80042335 (-2147212491) Method
> > CMI.OpenDB failed.
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> > The CMI encountered the following error: 0x80042335 (-2147212491) A database
> > error occurred within the CMI. For more information see the application event
> > log.
> >
> > \utilc-481
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> > The CMI encountered the following error: 0x80004005 (-2147467259) Error
> > occurred in CMI.
> > HRESULT: 0x80004005 (-2147467259)
> > Source: Microsoft OLE DB Provider for SQL Server
> > Source IID: Interface IID not available
> > Description: [DBNETLIB][ConnectionOpen (Initialize()()).]General network
> > error. Check your network documentation.
> > Help file: Help file not available
> > Help context: 0
> > Database Errors:
> > ************************************************** ******************************
> > ADO Error Number: 0x80004005 (-2147467259)
> > Source: Microsoft OLE DB Provider for SQL Server
> > Native Error: 0x0000000B (11)
> > SQL State: 08001
> > Help Context: 0
> > Description: [DBNETLIB][ConnectionOpen (Initialize()()).]General network
> > error. Check your network documentation.
> >
> >
> > For more information, see Help and Support Center at
> > http://go.microsoft.com/fwlink/events.asp.
> >
> > I have tried to reboot the computer, restart SQL Server(SQLEXPRESS), and SQL
> > Server Browser and still I got the same error. I would appreciate if you can
> > provide me info to resolve this.
> > --
> > Chip
>