Cannot open .sdf file in QA3.0

Hi,

We are using VS 2005 with SQL Server Mobile Edition. We created the .sdf file on the desktop and added this file to our VS project and set the Build Action to content. Next we deployed our app on Symbol PDA which has Windows CE 5.0 as the OS. We followed the following steps:

1. Deploy the app.

2. Install .NET CF 2.0

3. System_SR_ENU.CAB

4. sqlce30.wce5.armv4i.CAB

5. sqlce30.dev.ENU.wce5.armv4i.CAB

6. sqlce30.repl.wce5.armv4i.CAB

We now tried to double-click the .sdf file in PDA to open in QA3 but we get error.:

Error: 0x80004005 E_FAIL

Native Error (0)

Description: Interface defining error: IID_IDBInitialize

Param. 0:0

Param. 1:0

Param. 2:0

Param. 3:

Param. 4:

Param. 5:

What could be the issue?

Because of this, we unable to run the app since in our login form, this database is not available and hence we cannot proceed.

Regards,

Vilas

Please make sure that sqlceoledb30.dll is on the device and registered. The easiest way to do this is to install the repl cab (which you have done). In this case I suggest that you reinstall it and try again.

I usually install the dev cab last, but this should have no effect...

|||

I did as you said. Also found that my .sdf file was created on SQL Mobile Server and therefore did not work on PDA which has CE OS. Now I created the .sdf file on SQL CE and deployed on PDA. I can now open the .sdf file in QA 3.0 of PDA. Now when I try to access the same .sdf file via VS 2005 C# app, I get the error again. But I can run the same on Emulator without any problems. Any reason why?

Regards,

vnj

|||When you refer to a VS2005 C# application do you mean a desktop application? If so, please make sure you install SQL Compact Edition 3.1 on the desktop.

Cannot Login as sa

SQL 2000 on Windows2003
When we remote desktop to our SQL server we cannot login using the “sa”
user. We get a message saying the user name or password is in error.
The “sa” has permissions to do anything on the database (Not my idea).
The
password is correct as I can login to Query Analyzer from my desktop using
“sa” and password.
The only user we can login as is administrator.
This issue seems to have caused an application to fail, as it uses the “sa
”
account.
Interestingly, we can log on to the original SQL Server, on Windows 2000,
using the “sa” user. The app works fine there. We migrated everything
to
w2003 last November. We could never login as “sa” but the app was okay.
During some vender work on the app, the "sa” password was changed, that br
oke
the app. We changed the password back, app is still broke. Vendor says it
is because we can’t log on as “sa”.
CrystalJimYou shouldn't be logging in as 'sa' anyway - it's a mark of laziness of
the developer that created the app. Anyway, <stepping down off my
hobby-horse> is the server in Windows Authentication mode or mixed
mode? You should be able to tell by executing this statement:
SELECT SERVERPROPERTY('IsIntegratedSecurityOnly
')
*mike hodgson*
http://sqlnerd.blogspot.com
CrystalJim wrote:

>SQL 2000 on Windows2003
>When we remote desktop to our SQL server we cannot login using the “sa”
>user. We get a message saying the user name or password is in error.
>The “sa” has permissions to do anything on the database (Not my idea).
The
>password is correct as I can login to Query Analyzer from my desktop using
>“sa” and password.
>The only user we can login as is administrator.
>This issue seems to have caused an application to fail, as it uses the “s
a”
>account.
>Interestingly, we can log on to the original SQL Server, on Windows 2000,
>using the “sa” user. The app works fine there. We migrated everything
to
>w2003 last November. We could never login as “sa” but the app was okay
.
>During some vender work on the app, the "sa” password was changed, that b
roke
>the app. We changed the password back, app is still broke. Vendor says it
>is because we can’t log on as “sa”.
>
>|||You shouldn't be logging in as 'sa' anyway - it's a mark of laziness of
the developer that created the app. Anyway, <stepping down off my
hobby-horse> is the server in Windows Authentication mode or mixed
mode? You should be able to tell by executing this statement:
SELECT SERVERPROPERTY('IsIntegratedSecurityOnly
')
*mike hodgson*
http://sqlnerd.blogspot.com
CrystalJim wrote:

>SQL 2000 on Windows2003
>When we remote desktop to our SQL server we cannot login using the “sa”
>user. We get a message saying the user name or password is in error.
>The “sa” has permissions to do anything on the database (Not my idea).
The
>password is correct as I can login to Query Analyzer from my desktop using
>“sa” and password.
>The only user we can login as is administrator.
>This issue seems to have caused an application to fail, as it uses the “s
a”
>account.
>Interestingly, we can log on to the original SQL Server, on Windows 2000,
>using the “sa” user. The app works fine there. We migrated everything
to
>w2003 last November. We could never login as “sa” but the app was okay
.
>During some vender work on the app, the "sa” password was changed, that b
roke
>the app. We changed the password back, app is still broke. Vendor says it
>is because we can’t log on as “sa”.
>
>

Cannot Login

VB express and SQL express are on the same desktop. I have an application in VB that works fine.The issue I have is if I go into SQL Management to work on the DBand then close SQL Management Express. When I go back to execute my VB application I get a message like this " Login failed for "user name" file is in use by another application". If I reboot my system and then run the VB application it works OK. I've tried doing a disconnect before I exit SQL Management but this had no affect on the problem. Is there something I need to do when I exit SQL Management Express so I can immediatley run my VB applicaton without having to reboot?

You probably have open transactions.

Before closing SQL EE, Comit Transaction a few times, then close it.

Adamus

|||

i guess you are using User Insatance. this is a common problem in userinstance of sql server express

Refer this link :

http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx

if you are not aware of User Instance , post back the connection string used in your application. I think , you don't really need to use Userinstance. in that case you can use normal connection string.

Madhu

cannot install sql server 2005 developer over sql server 2000 desktop edition

It will not install the database components it refuses to install over the older desktop edition... what are we supposed to do.. we have many registered servers to all the customers and servers we use so we don't want to remove the older one... but we are developers and develop applications that our customers use and need the new version on these machines....

thanks

Larry,

Can you provide more details on what you mean by "it will not install..."

Cheers,
Dan

|||I assumed you knew it will install everything but the database component complaining about something to the regards of not be able to install developer over version 8.0.0.x.x or something due to licensing..|||I
f this is not enought I will run it again and give you the exact wording.. but it just disables installation of the database component and lets you go ahead with the rest. what is the point of installing the other stuff without the database component?|||

So you're trying to upgrade MSDE to what SQL Server 2005 Edition?

The supported upgrade paths for MSDE are:

SQL Server Desktop Engine (MSDE) 7.0 SP4

SQL Server 2005 Express Edition

SQL Server Desktop Engine (MSDE) 2000¹

SQL Server 2005 Workgroup Edition

SQL Server 2005 Express Edition

For the full matrix of supported upgrade paths look at: http://msdn2.microsoft.com/en-us/library/ms143393(en-US,SQL.90).aspx

Cheers,
Dan

|||

I don't think this covers it.. desktop edition is not the same as desktop engine... desktop edition is a special version on enterprise edition or standard cd's that can install on windows 2000 profesional instead of server...

I did what you say and express installed.. but it does not have the management studio which we need to connect to our various development servers.. for our workstations..

any ideas.. thanks

|||

what a pain I had to remove everything.. express edition and sql server 2000 and then install...

there should be an upgrade path from desktop edition to developr...

anyway in the future when I do this I can backup databases... as I did but the big thing we loose is we have about 50 remote database connections in enterprise manager..

is there a way to save these and then reimport them once 2005 is intalled...

thanks..

Cannot Install SQL Server 2005 after running Uninstall

After going through "Add and Remove Programs" and removing all components of SQL Server 2005 Standard Edition on my desktop I get an error telling me there is a copy already installed and to remove it before continuing. Well nothing shows up under "Add and Remove Programs"; Windows cleanup shows none of the SQL Server components; a check of the register (HOTKEYS.../unistall) have no SQL Server entries; under services all SQL Server services are disabled and not running.

I have followed all the steps in http://support.microsoft.com/kb/909967 (Describes how to uninstall an instance of SQL Server 2005 manually).

Anyone out there got a solution? (Visual Studio 2005 eval is loaded on the box)

Hi,

You this utility to uninstall clearly. Microsoft cleanup Utility. Download this, install and clean up SQL.|||

I had already ran this prgram plus many others. I am now able to install after I removed the Microsoft Sql Server directory under "Programs".

|||

Or you can try to manually uninstall SQL Server 2005 later. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".

Cannot Install SQL Server 2005 after running Uninstall

After going through "Add and Remove Programs" and removing all components of SQL Server 2005 Standard Edition on my desktop I get an error telling me there is a copy already installed and to remove it before continuing. Well nothing shows up under "Add and Remove Programs"; Windows cleanup shows none of the SQL Server components; a check of the register (HOTKEYS.../unistall) have no SQL Server entries; under services all SQL Server services are disabled and not running.

I have followed all the steps in http://support.microsoft.com/kb/909967 (Describes how to uninstall an instance of SQL Server 2005 manually).

Anyone out there got a solution? (Visual Studio 2005 eval is loaded on the box)

Hi,

You this utility to uninstall clearly. Microsoft cleanup Utility. Download this, install and clean up SQL.|||

I had already ran this prgram plus many others. I am now able to install after I removed the Microsoft Sql Server directory under "Programs".

|||

Or you can try to manually uninstall SQL Server 2005 later. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".