Using SQL Server 2005 CE Embedded In Desktop Applications
Jan 3, 2007
Is it ok to use SQL Server 2005 CE as an embedded DBMS inside a desktop (Windows XP / w2k3 / Vista) application?
The whitepaper available here: http://download.microsoft.com/download/A/4/7/A47B7B0E-976D-4F49-B15D-F02ADE638EBE/Compact_Express_Comparison.doc describes this as one of the primary usages of the product. However, I've seen information elsewhere on this forum that seems to imply that SQL Server 2005 CE is not allowed in desktop applications.
Can you please clarify this, and specify any limitations of this usage?
Also, the whitepaper refers to an online redistribution agreement that needs to be signed in order to freely redistribute SQL Server 2005 CE inside a commercial application. Can you please point to this agreement?
Thanks,
IonWarp
View 7 Replies
ADVERTISEMENT
Mar 21, 2007
Do you believe that SqlServer Express can work absolutely without any administration?
That is to say: my clients are people without any technical knowledge and they usually communicate never with me.
Is SSE the correct database for this status, or should I use a desktop database like VFP or Access?
View 4 Replies
View Related
Mar 29, 2007
What is the feature Matrix for the recent SQL Server 2005 for SBS update? I specificly had the update installed to get SQL Server 2005 and utilize the new Database Mail, and the CLR functions. Where is it that it says.. btw, no Database Mail for you SBS chump!... Oh.. and well, you have to buy a new server and a full license of SQL Server 2005 to access smtp and send html email. I'm a little irrate about this, I advocate for MS technology every day and don't like getting bit in the *** reading SQL Server 2005 marketing materials and then recieving its retarded cousin for my SBS server. Hey,, charge me a little more money. Just put in a reasonable feature set. So, as far as can tell so far. No CLR coding and no Database mail, its like the body with no arms and no legs, but a better heart, pumping blood to nowhere.
Someone please tell me I'm ignorant and lazy and point me to how I can get these features working with investing 10,000 for a simple html email trigger.
View 2 Replies
View Related
Nov 13, 2007
Hi ,
We want to install 2 applications that run on SQL server 2005 but the requirement of database installation are different Collation setting ( One require Dictionary order, case-insensitive, for use with 1252 Character Set and other require Dictionary order, case-sensitive, for use with the 437 (US English) Character set).
So the question here could I install both two applications successfully on same platform ? and if yes how?
Thanks and regards,
Quinh
View 5 Replies
View Related
Aug 10, 2007
Hello Everyone,
I'm trying to connect to Desktop SQL Server 2000 from Windows mobile PC Emulator (VS 2005). I need a direct connection using connection string to SQL Server 2000 through local wireless network without IIS.
Bellow is the code that I use. After executing this code I get an error on line Conn.Open(). Error says SQL Server does not exist or access denied.
SQL is un and running, and I can log in using SA username from the desktop. Even if I chance IP for another SQL server in my connection string I still get the same error. There is no firewall of any kind running.
Dim connectionSTR As String = "Persist Security Info=False;Integrated Security=False;Server=192.168.0.202,1433;initial catalog=MyDB;user id=sa;password=;"
Dim Conn As SqlConnection
Conn = New SqlConnection(connectionSTR)
Conn.Open()
If Conn.State = ConnectionState.Open Then
MessageBox.Show("Open")
End If
About my environment: SQL Server 2000 is running on Desktop PC with Windows XP SP2. Application which I need to connect to SQL Server is in Visual Studio 2005. I execute the application in Windows Mobile PC Emulator and try to connect to SQL Server from emulator.
Your advice and help is very appreciated
Thank you
Ika
View 3 Replies
View Related
Nov 16, 2007
Hello all,
I€™m looking for some help to get my Windows SharePoint Services 3.0 back on-line running without losing the documents stored on it..
Configuration basics: Microsoft Windows SharePoint Services 3.0 on member Server 2003 Std w/ SP2 using the Windows Internal Database (MS SQL Server 2005 Embedded Edition)
I had the SharePoint Services site operating on a member server.
I used the Manager the Server wizard to Install Active Directory on the member server. (Ouch! My Mistake)
I broke the SQL Server 2005 Embedded Edition Service. It would not restart. The System Evt code was 7024 error 3417.
I researched and found KB 929665 which describes my symptoms perfectly.
http://support.microsoft.com/kb/929665
I tried the recommended command (see Note1) and the configuration failed.
I discovered the following errors in the log file:
GetServiceUserGroup failed for MICROSOFT##SSEE, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No mapping between account names and security IDs was done.
Source File Name: sqlcasqlcax.cpp
Compiler Timestamp: Mon Feb 27 02:04:14 2006
Function Name: SetInstanceProperty
Source Line Number: 1223
Error Code: 1332
MSI (s) (2C!4C) [19:08:50:678]: Product: Microsoft SQL Server 2005 Embedded Edition (Windows) -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
<Failure Type='Fatal' Error='1332'>
<EndFunc Name='LaunchFunction' Return='1332' GetLastError='0'>
Action ended 19:08:50: SetInstanceProperty.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
Action ended 19:08:50: INSTALL. Return value 3.
Note 1: Msiexec <MSI_File_Name> CALLERID=OCSetup.exe REINSTALL=ALL REINSTALLMODE=omus /qn REBOOT=ReallySupress /l*v <Log_File_Path>
(Note: the line is missing the switch €ś/i€? after MSIEXEC)
How can a get my SharePoint working again?
Thank you!
Mike
View 3 Replies
View Related
Dec 31, 2007
Hi,
what is the distribution fee for SQL Server 2005 Desktop Engine distribution? Where can I find this information? I don't need it for development only for distribution.
Thanks,
LearningWPFnDotNet
View 7 Replies
View Related
Aug 3, 2006
I have got SQL Server Desktop Engine running with 2 database and I need
to install the evaluation version of SQL Server 2005 instead. A
straight upgrade does not seem to be possible. Does someone know if
backing up the databases, uninstalling the desktop engine, installing
SQL Server 2005 and then importing/restoring the databases would be an
option to look into?
View 1 Replies
View Related
Jun 14, 2006
Hi,
Does anyone know if it's at all possible to install SQL Server Express 2005 over a Remote Desktop on a Windows XP machine.
I know there are problems running SQL over Remote Desktop, in that it won't start up a User Instance, but I wasn't sure if we can install over Remote Desktop.
If it's not possible, can anyone point me to an official document stating this fact?
Thanks
Sam
View 3 Replies
View Related
Dec 17, 2005
Hello Everybody
I want to create SQL server 2005 mobile database on desktop programmatically with some inital data for my application and load it into device. We can create database only in VS2005 server explorer or SQL server 2005 application.
Anybody having this solution for this prob.
Regards
Chikuu
View 7 Replies
View Related
Nov 20, 2006
hi dear developers;
i just finished my program and i am making a setup for it but the db is MSSQL SERVER 2005. the home users how will they use sql server 2005? is there any thing like sql server 2000 desktop engine? something like that... shortly the user don't have to know sql server and settings of it so how will we do it???
thank you very much...
View 5 Replies
View Related
Dec 6, 2007
Hi,
I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that under the default settings SQL Server does not allow remote connections.
But my SQL Server allows remote connection, and I am able to do a select statement.
But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?
View 1 Replies
View Related
Mar 8, 2008
Hi,
I€™ve developed a BI system using the SQL Server 2005 Developer€™s Edition.
SSAS, SSIS and SSRS have been added to a SQL Server 2005 Standard Edition Server in preparation for delivering the developed database to this live environment.
So I am able to connect directly to the Database Engine, SSAS, SSIS and SSRS successfully from the actual SQL Server 2005 Standard Edition box which is sat on a Windows 2003 Server operating system.
However when I launch SQL Server Management Studio from a desk top PC which is connected to the SQL Server Standard Edition box I can€™t connect to either SSIS or SSRS, however I can connect to the Database Engine and it also seems that I can connect to SSAS OK.
I am using Windows Authentication where the I used a SQL Server account which exists with €śsysadmin€? permissions and this SQL Server account has the same login name as the Windows Server 2003 desktop login.
What do I do next please?
View 4 Replies
View Related
Feb 5, 2006
ProblemWhen Remote Desktop to my main office machine, and when trying toconnect to SQL Express, I was becoming increasingly frustrated with thefollowing error:Error: 'Failed to generate a user instance of SQL Server due to afailure in starting the process for the user instance. The connectionwill be closed.'What is the solution?Solutions: ( pick any of the 3)1. Obtain and apply the patch http://support.microsoft.com/?id=8966132. Wait for the next Windows Service pack3.Of course if you can not get the patch, you can always do this (Note:You must have WinVnc server running in your remote computer)1. In the remote desktop session, reboot your computer.Click Start->Windows Security->Shutdown->Restart.Wait for some time to get machine up.2. Use your vncviewer to login to your remote computer. You can chooseto do all work via VNC or go to next step.3. Use remote desktop to login (this automatically closes the winvncsession).There you go, You did not create a remote session, but reused yourlocal session.
View 1 Replies
View Related
Aug 21, 2007
I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!
View 11 Replies
View Related
Jul 3, 2006
I am having a nightmare getting an answer about what type of licensing I will need for the standard addition of SQL Server 2005 for my asp.net application and wonder if anyone has any advice.
As I see it its very simple, I have a web app that makes a connection to SQL via a connection string using a single username and password, no impersonation just straight SQL authentication.
For this simple scenario I figured I would need to get a SQL 2005 license and then 1 Client access license (CAL), this being a nice affordable way of doing things BUT I am being told by different sources, that I may need to license on a per processor basis as any user of my web application, anonymous or otherwise needs a client access license and given that I don’t know how many users are going to access my website I would need to go for the larger outlay and purchase two standard processor license (my sql server is a dual processor machine).
Can anyone tell me if this is the case, is a connection from a ASP.Net website to a SQL server for my website visitors regarded as a new client and therefore needs a client access license or the large investment of a per processor license?
I would stick with SQL Express but at 4gigs max it won’t do the job.
Thanks in advance.
View 17 Replies
View Related
May 11, 2007
Hi,
I have a problem that seems impossible to resolve in RS but i need to be sure.
I'm creating an Embedded Code in VB of course, and i need to run a query within my code to be able to continue the rest of the code depending on the result of my query.
The problem is there is no adodb.recordset or adodb.connection like in normal VB.
So i created my query like as string:
Dim Sql as String
Sql="Select ..." into "from ........where...."
At this point if it was in normal VB,
i would do
MyConnection.Execute(SQL)
and then i will get the answer in my recordset.
I need to know if there is a way in RS to run my query since I cannot use use adodb ....
If it's not really possible, is there way to go around this problem????
Thanks for the Help
Mike
View 1 Replies
View Related
Jun 7, 2006
I want to physically move my .SDF file to my desktop and then access this file from VS 2005 VB.NET. Ideally, I would want to access this .SDF file from MS Access 2003 but I undersand this is not possible.
Here are my VS 2005 VB.NET statements....
Dim ConnPPC As New System.Data.SqlClient.SqlConnection("Data Source = C:Documents and SettingsG014436My DocumentsSQL
MobileActMgr6CE.sdf")
Dim mySqlDataAdapter2 As New SqlDataAdapter("select * from T0002_AE_Activity_Entry", ConnPPC)
mySqlDataAdapter2.Fill(myDataSet2)
On executing the last statement(fill)...I get the following error.
function failed: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Does anyone have any suggestions?
View 6 Replies
View Related
Aug 18, 2007
My coworker tried install SQL server 2005 on a server. The server already has a desktop engine running as "MSSQLServer". Because the new sql server 2005 need running as a default instance. So he still using "MSSQLServer" as the instance name.
After installation, the service's running file seems still point to the old location. When view the properties on Management studio, it still report as "desk top engine" and the version is 8.xx..xxxx.
My question is,
1. What has been done during the installation? Is current desktop engine was upgraded?
2. In current situation, what can we do to install the SQL server 2005 as a default instance. Is there way to rename the desktop engine to a named instance?
Thanks
View 4 Replies
View Related
Nov 16, 2006
Hi Folks,
I am unable to install SQL 2005 Express on my XP desktop. I receive following error:
SQL Server 2005 setup has detected incompatible components from beta versions of Visual Studio .............
- I have uninstalled and reinstalled the Visual Studio 2005 Express many times
- I do not see any version of SQL installed on my machine from Add/Remove Program
- I checked the running processes and there is no instance of SQL running
I do not know where this incompatible version of SQL is on my machine. I am getting ready to format my machine but I want to see if someone can help me install 2005 express without having to format my PC.
Thanks in advance!
- Aaron
View 1 Replies
View Related
Nov 2, 2000
If there are 2 different web application connecting to a sql server database through ODBC connection, both of them have full privilege to update , create , add column etc. Would there any issues of SQL server impacts when actually on live.
View 2 Replies
View Related
Jan 11, 2008
Hi all,
Can anyone tell about impact of SQL server in web applications
Thanks in advance
View 2 Replies
View Related
Jul 6, 2006
I am running SQL Server 2005 Dev x86 with SSRS SP1 on Windows2003 Svr SP1.
My SQL Server is running and SSRS is working. When I come to run certain installs though, my Server name is not present in the dropdowns or in the browse for installed server lists.
I entered the name of my SQL server manually, but when I ran the application, it gave me an error: 00250 unable to run dtabase locator service.
Any ideas?
View 2 Replies
View Related
Aug 25, 2005
I was wondering if anyone had tried to embed sql server express in a .net application. Specifically, I want to use it from within the app only, similar to embedded mysql (libmysqld) or firebird. I've seen some articles on sql server express saying this can be done, however there is no info on how do to this. Anyone know how it might be done?
View 1 Replies
View Related
Feb 5, 2002
Our company wants to run web based application
in folowing way.
Browser --> WebServer -->Sql Server
Sql server is part part of corporation domain and has about 25 more databases
Should we dedicate extra SQL server to run Web apps , or it would be safe to run web apps on corporation Sql Server?
or
If any one can point on links on this subject?.
Thank you
View 1 Replies
View Related
Jul 23, 2005
Hi All,During the past couple of years I have been maintaining the company'sAccess databases, in the coming weeks I will be migrating data to SQLserver, I will be using the Access forms as a frontend to access datawhile we developed a new front end through VB.Net.I was wondering if anyone will recommend an application that makes anexact replica or backup of the SQL server in the case the SQL serverfails. With MS Access, if a record is corrupted we needed to go backto the previous day backup of the database, we cant afford to havethis issue any longer.Regards,John
View 3 Replies
View Related
Dec 26, 2006
Hi,my problem is the following
I can not completely understand how to deploy sse with my application
To some degree I understand the explaning in Mikes Documentation
Things I don't get:
1)Do I not check the prerequisite server express because when I did and run the setup.exe that I build the thing that happens is that the sql package gets unpacked over and over along with a little message that it's taking a little longer then expected. I gues this is the fallpit where the actual setup.exe for sse is nothing being done with hence the wrapper.
A quote from Mikes document "If the VS Bootstrapper isn't flexible enough for you then". Well, I don't know what I'am doing wrong but it doesn't work at all. I had no problem with the other prerequisites (Framework, installer)
Back to the first question: if so do I manually add the SQLEXP.EXE (downloaded from the internet) or is it the sqlexpr32.exe in the same folder as the setup.exe for the application?
2) How is the wrapper invoked? I don't see that mentioned. I thought when you start the application itself, but that hardly seems logical.
Please anyone, give me some clear directions or additional expanatory
Thanks,
Richard
View 6 Replies
View Related
Apr 28, 2008
Good morning,After long hours of search on the subject, I could not find a clear answer to my question.I understand what are ths physical limit fo the express version (1Gb or Ram, 4Gb database, 64 bit WOW).My configuration is as follow, windows webserver 64bit, I have 4 database of 10Mb each for 4 web-application. The maximum concurent connection is a total fo about 8 for all the web-application together.Therefore due to the cost of buying a workgroup of standard license, I was hoping to be able to use the express edition.Please let me know your thought.ThanksArno
View 6 Replies
View Related
Jun 10, 2015
I need to get the application lists calling our DB. I need both dormant and current. I thought profiler can give only active ones.
View 7 Replies
View Related
Nov 22, 2006
Hello All,
Can someone tell me the actual significance of SQL Server Embedded Edition? How is it different from SQL Express edition?
I understood that WSUS 3.0 version uses (installs) the latter when it could not find any SQL 2k or SQL 2k5 other than SP1 release (please see Issue 33 in: http://technet2.microsoft.com/WindowsServer/en/library/94d1385f-4872-4c29-8822-3a4ec5e45ae41033.mspx?mfr=true) on the host machine.
Besides, when i installed WSS v30 release version, i saw this instance being installed (during the configuration of the Sharepoint products and technologies wizard just after the installation is done). Now with this instance installed, i tried opening this instance (instance name being Microsoft#SSEE) through SQL Server Management Studio, i get the following error
"TITLE: Connect to Server
------------------------------
Cannot connect to BANAPPS01MICROSOFT##SSEE.
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
"
Please let me know if there's any workaround in getting through this database.
Since i'm not able to open this database, i'm not quite sure if the Sharepoint Central Administration tool is adding the content DBs in the same.
PS: I'm able to create the new webapplication using the Central Administration tool but not able to access the site created. I'm getting site not found errors.
I followed the KB article mentioned in http://support.microsoft.com/default.aspx?scid=kb;en-us;914277, but in vain.
This is what i have in my System:
MS SQL SERVER 2k5 (Release version)+SP1
MS VS 2k5, Developer Edition
Windows 2k3 Standard + SP1
Office 12 beta (I dont think this is an issue as i got the same issue even after uninstalling office12 beta version)
View 31 Replies
View Related
Nov 6, 2015
I had a small requirement i had a table with embedded attachments and attachments are uploaded to the table and saved in varbinary field from front end. Want i want is i want to download particular embedded files in that table within SQL Server itself. I have tried googling but none of seems to be within SQl Server T-SQL. all are linked to Asp.NET how i can do?
View 6 Replies
View Related
Aug 17, 2000
Hello....
Does anyone know if two different database belong to two different applications stay in the same physical SQL server 7.0 with one server license would affect their performance?
Would the performance be better off if each database stored in different physical SQL Server 7.0 with different server license?
Thank you in advance!
View 1 Replies
View Related
Feb 3, 2006
Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express?
View 3 Replies
View Related
