still can't connect to database server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've just upgraded the eval XPe development tools and database to the latest
version desinated as SP2 and Feature Pack 2007. I'm running on Win XP Pro. I
uninstalled the eval development tools and eval component database before the
new install. The component database is on the same computer.

When I open the Component Database Manager with the correct server location
(local) I get the message "cannot connect to database" - database in
exclusive mode or not added as a database user. No other apps are using the
database.

Since this problem has been encountered by many, I reviewed the forum posts
and have confirmed the following as mentioned in the previous posts:


1. MSSQLServer is running (shown in tray); server is the correct name and
services is SQL Server. System is set for file sharing.

2. I've restarted the system

3. Permissions are set for full control in the Windows Embedded Data and
Respositiories dir; running as administrator

How do I set the database to non-exclusive control or be added as a database
user if that's the problem? What might be other reasons for the problem?

Thanks,

Art
 
I've just upgraded the eval XPe development tools and database to the latest
version desinated as SP2 and Feature Pack 2007. I'm running on Win XP Pro. I
uninstalled the eval development tools and eval component database before the
new install. The component database is on the same computer.

When I open the Component Database Manager with the correct server location
(local) I get the message "cannot connect to database" - database in
exclusive mode or not added as a database user. No other apps are using the
database.

Since this problem has been encountered by many, I reviewed the forum posts
and have confirmed the following as mentioned in the previous posts:

1. MSSQLServer is running (shown in tray); server is the correct name and
services is SQL Server. System is set for file sharing.

2. I've restarted the system

3. Permissions are set for full control in the Windows Embedded Data and
Respositiories dir; running as administrator

How do I set the database to non-exclusive control or be added as a database
user if that's the problem? What might be other reasons for the problem?

Thanks,

Art
Click to expand...

Art,

Open the SQL Server Enterprise Manager app and add yourself as a user
to the SQL Server database. The default DB name is "Mantis".

Desi
 
Thanks for the quick response. I looked for Enterprise Manager thru

Start > Programs > Microsoft SQL Server > Enterprise Manager

but there is no such item. There's a Program Files\Microsoft SQL Server
directory but it isn't clear which exe is the Enterprise Manager - do you
know which one it is in bin.

I'm puzzled because all this worked with the eval version. Do I need to
reinstall a database engine. (I don't know much about database issues).

Thanks,

Art
 
SQL Enterprise manager needs to be installed separately. When you
install SQL 2000 version it will be part of Client tools. So you need
to ensure you have chosen both database and client tools. If you have
SQL 2000 CD's you can try the same.

If you have access installed on the machine you can connect to SQL
2000 or MSDE databases.

Thanks,
Sobhan
 
Thanks. It turned out that the reason it can't connect is that the component
database was never installed correctly to begin with (see the post I did
yesterday). I'm using MSDE from the XPe install disks, including the database
upgrade on Disk 3.

When I install the licensed component database (after backing up and
uninstalling the eval version of the component database), it goes to the end
of the progress bar ,but as it sets cmiRepRootPath, I repeatedly get an error
dialog saying that setup has detected that another application is using the
component database - it then rolls back the install. I don't see another app
using the component - no antivirus is running. It smells like there's some
problem with a security/permissions setting?

Thanks,

Art
 
Back
Top