SQL Server Compact Edition Server Tools Setup Error On Vista
Oct 21, 2007
SQL Server 2005 SP2 Replication
I am having problems installing the SQL Server Compact Server Tools on my
Vista laptop to allow me to connect my Mobile Device running SQL Server
Compact directly to my SQL Server 2005 database through IIS.
I have done this successfully with an XP machine so I'm not sure if it is
Vista problem or not.
I have installed SQL Server 2005 SP2. When I try to install the replication
server tools (Sqlce30setupen.msi), in "System Configuration Check" window I get a failure on "SQL Server requirement" that says: "You must first install the Replication Components for SQL Server 2000 SP 3a
or higher or the SQL Server 2005 Replication Components" and the client components are full instaled in my computer.
I need help for detect and correct the problem.
Sincereously,
Alonso Junior
View 4 Replies
ADVERTISEMENT
May 5, 2008
Hello,
we've got a SQL Server 2005 which replicates with an SQL Server Compact 3.5. Every 10 to 20 synchronisations we're getting the error mentioned above. A Soft reset of the device helps to make the synchronization working again.
Why is this error happening and how can we resolve this?
BTW, we've also running system that replicates with an SQL Server Compact 3.0 without having this problems.
Thanks,
Markus
View 1 Replies
View Related
May 26, 2007
Hi,
I am using SQL Express 2005 server and sql compact edition for my PDA. For synchronization, which SQL Server 2005 Compact Edition Server Tools installation package do I use?
Is it Sqlce30setupen.msi or sql2kensp4.msi or sql2kensp3a.msi? I know for sql server 2005 its Sqlce30setupen.msi. Is it the same for the SQL Express 2005?
Thanks
View 4 Replies
View Related
Mar 20, 2007
Hi,
We are currently having a problem with a client running Vista business for a mobile application that uses SQLCE RDA with the Web Synchronization on IIS7.
I have run through the Configure Web Synchronization Wizard and it doesn't create a virtual directory. I manually create the virtual dir and point it to the new folder the Configure Web Synchronization Wizard created.
Browsing to the url "http://localhost/sqlce/sqlcesa30.dll" gives a valid test string.
Here is the ?diag response...
SQL Server Mobile Server Agent Diagnostics
2007/03/20 15:39:49
General Information
Item
Value
Server Name
localhost
URL
/sqlce/sqlcesa30.dll
Authentication Type
Anonymous
Server Port
80
HTTPS
off
Server Software
Microsoft-IIS/7.0
Replication
Allowed
RDA
Allowed
Logging Level
3
Impersonation and Access Tests
Action
Status
ErrorCode
Impersonate User
SUCCESS
0x0
ReadWriteDeleteMessageFile
SUCCESS
0x0
SQL Server Mobile Modules Test
Module
Status
ErrorCode
Version
SQLCERP30.DLL
SUCCESS
0x0
3.0.5300.0
SQLCESA30.DLL
SUCCESS
0x0
3.0.5206.0
Reconciler Test
Reconciler
Status
ErrorCode
9.0 Database Reconciler
SUCCESS
0x0
8.0 Database Reconciler
SUCCESS
0x0
SQL Server Module Versions
Module
Version
sqloledb.dll
6.0.6000.16386
9.0 replrec.dll
2005.90.3042.0
9.0 replprov.dll
2005.90.3042.0
9.0 msgprox.dll
2005.90.3042.0
8.0 replrec.dll
2000.80.2039.0
8.0 replprov.dll
2000.80.2039.0
8.0 msgprox.dll
2000.80.2039.0
When a Windows Mobile or Pocket PC device tries to do a ServerExecute or Push or Pull it gets this error message with SQLOLEDB ...
HResult = -2147467259
Message = " [ 600 ]"
NativeError = 29022
numericErrorParameters = {600,0,0}
Source = "Microsoft SQL Server 2005 Mobile Edition"
Which roughly translates to from the header file ...
#define SSCE_M_INCORRECTPROVIDERVERSION 29022 // The version of the Microsoft OLE DB Provider for SQL Server is not correct. Install MDAC 2.8 or later. [,,,Version,,]
When a Windows Mobile or Pocket PC device tries to do a ServerExecute
or Push or Pull it gets this error message with SQLNCLI ...
HResult = -2147467259
Message = " [ 9 ]"
NativeError = 29022
numericErrorParameters = {9,0,0}
Source = "Microsoft SQL Server 2005 Mobile Edition"
A very similar error.
From this it seems that both SQLCE 2 and 3 seem to want MDAC 2.8+ drivers. The drivers installed with Vista for SQL Native client seem to be versioned 6.0.* and the required versioning would seem to need to be in line with MDAC 2.8.
Are there installable drivers to bump the versioning of SQLNCLI or SQLOLEDB upto MDAC 2.8+ levels?
Or is there an alternative that will make it possible to run SQLCE RDA apps with Vista as the SQLCE server (i.e. sqlcesa30.dll)?
Cheers,
Jonathan
View 5 Replies
View Related
Mar 11, 2008
Hi there,
everything is ok for first run. but i leave the program relogin
than that error occured ppc2003 second edition devices. Windows mobile 5.0 device works fine.
can anybody help me?
VS2005 ver 8.0.50727
SSCE31VSTools-ENU.exe loaded
SSCE31SDK-ENU.msi loaded
machine 1
SQL 2005 loaded
machine 2
http://192.168.20.22/ssce/sqlcesa30.dll
"Microsoft SQL Server Compact Edition Server Agent" looks fine
pocket pc side
C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce400armv4
.net cf 2.0 sp2
sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB installed too.
my code
---------------------------------------------
Dim RdaStr As String = "Provider=SQLOLEDB; Data Source=" + Server + ";Initial Catalog=" + DataBase + ";Integrated Security=SSPI"
Dim rda As SqlCeRemoteDataAccess
Try
rda = New SqlCeRemoteDataAccess "THIS LINE GIVES ME THAT ERROR
Catch ex As Exception
MsgBox(ex.ToString)
Application.Exit()
End Try
Try
rda.InternetLogin = [String].Empty
rda.InternetPassword = [String].Empty
rda.InternetUrl = "http://" + IP_no + "/ssce/sqlcesa30.dll"
rda.LocalConnectionString = ConnectString
Catch ex As Exception
MsgBox("Bağlantı hatası..")
Application.Exit()
End Try
------------------------------------------------------------------------------
i added the following code to very beginning of my code too.
that code lock my device
Declare Function LoadLibrary Lib "coredll" Alias "LoadLibrary" (ByVal lpLibFileName As String) As IntPtr
Dim pt As IntPtr
pt = LoadLibrary("\windowssqlceca30.dll")
pt = LoadLibrary("\windowssqlceoledb30.dll")
pt = LoadLibrary(\windowssqlcecompact30.dll)
-----------------------------------------------------------------------------
View 4 Replies
View Related
Feb 27, 2007
Hi
I am trying to complete sql server compact edition book online walkthrough "Creating a Mobile Application with SQL Server Compact Edition". I am successful to complete it as guided using all default settings (e.g. anonymous access, windows authenticaion etc.) and the sample run on both emulator and my pocket pc svc5000. I have following configuration..
Windows 2000 professional sp4
Sql server 2005 standard edition sp1
VS 2005 profesional edition (sp1 not installed)
Sql server compact edition
Sql server compact edition server tools
But the problem is that in production environment i will not be able to connect to the sql server using named instance (e.g machine_nameinstance_name). i have to use ip address in that situation. so i tried to modify the sample to use ip address in place of named instance and then the problem starts.. I have configued my sql server to allow remote connections using tcp/ip and named pipes using sql surface area config tool.
When using named instance i used following code to Synchronize with sqlserver 2005 with and it worked perfectly :
Dim filename As New String("Program FilesTestTest.sdf")
Dim repl As New SqlCeReplication()
repl.InternetUrl = http://machine_name/Test/sqlcesa30.dll
repl.Publisher = "machine_nameinstance_name"
repl.PublisherDatabase = "Test"
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.Publication = "Test"
repl.Subscriber = "Test"
repl.SubscriberConnectionString = "Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';"
Try
repl.AddSubscription(AddOption.CreateDatabase)
repl.Synchronize()
Catch err As SqlCeException
MessageBox.Show(err.ToString)
End Try
When i tried to do replication using ip address it shows following error:
System.Data.SqlServerCe.SqlCeException was unhandled
HResult=-2147467259
Message="Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect."
NativeError=29061
Source="Microsoft SQL Server Compact Edition"
StackTrace:
at System.Data.SqlServerCe.SqlCeReplication.Synchronize()
at TEST.MainModule.Sync()
at Test.MainModule.Main()
I am using following code to connect using ip address:
Dim repl As New SqlCeReplication()
repl.InternetUrl = http://XXX.XXX.XXX.XXX/test/sqlcesa30.dll
repl.PublisherNetwork = NetworkType.TcpIpSockets
repl.PublisherAddress = "XXX.XXX.XXX.XXX,XXXX"
repl.Publisher = "SQL2005" 'instance name of sql in sql2005
repl.PublisherSecurityMode = SecurityType.NTAuthentication
repl.PublisherDatabase = "Test"
repl.Publication = "Test"
repl.Subscriber = "Test"
repl.SubscriberConnectionString = "Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';"
repl.AddSubscription(AddOption.CreateDatabase)
repl.Synchronize()
I have give rights to iuser_manchine_name in the public access list of publication and on database also.
I don't have any idea on where i am wrong... Please help soon..
Many thanks in advance..
View 1 Replies
View Related
Aug 27, 2007
HI friends,
i m working on device application ..i m using sql server ce 2005 with c#.net ... but when i m trying to connect to database it shows me error that
"the database path not found ... please check the path [,,,filename,,,]"
my code is as below
private string ConnStr = "Data Source =\My Documents\Employee.sdf;";
private void cmdCheckConnecton_Click(object sender, EventArgs e)
{
try
{
cn = new System.Data.SqlServerCe.SqlCeConnection(ConnStr);
cn.Open();
MessageBox.Show(cn.State.ToString());
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
i have my database in My Documents and the path is right still it shows the error
pls help if any one have a solution regarding this problem
thanxx
Zalak Shah
View 4 Replies
View Related
May 20, 2007
Hello dear all.
I am using a Compact Framework 2.0 on a mobile 5.0 with a local Microsoft SQL Compact Edition 2005 database. The backend database is a Microsoft SQL Server 2005 and I am trying to pull a 45000 rows table (the table has 2 varchars(8) forming a primary key and an INTEGER column).
The statement I issue is the following:
rda.Pull(table.TableName, table.TableQuery, Program.RdaOleDbConnectionString, RdaTrackOption.TrackingOnWithIndexes, table.TableName + "Errors");
The application works perfectly when I am pulling smaller tables (up to 15000 rows) but when I try to pull this one I get the following error details:
sqlCeEx
{""}
base {System.SystemException}: {""}
Errors: {System.Data.SqlServerCe.SqlCeErrorCollection}
errors: {System.Data.SqlServerCe.SqlCeErrorCollection}
HResult: -2147024882
Message: ""
NativeError: 0
Source: "Microsoft SQL Server Compact Edition"
Please have in mind that the handheld on which I deploy does not have an extra storage card.
I have done a thorough internet search and I have found no solution to this problem. I truly rely on you to find the solution.
Thanks in advance,
Steliosvcy.
View 5 Replies
View Related
Jul 24, 2007
I am using VB2005 , Windows CE 5.0 , SQL server 2005 compact edition
and using XML reader, but it will show the empty SQLCeException ,
why does it occur?
The source it show at the follow :
-----------------------------------------------------------------------------------------------------------------
Imports System.Data.SqlServerCe
Imports System.Xml
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim DBPath As String
Dim mydr As XmlTextReader = New XmlTextReader(m_sXMLFileName)
mydr.WhitespaceHandling = WhitespaceHandling.None
While mydr.Read()
' Look for the <configuration> section
' This lets us add several peices in the config file
If mydr.Name = "DBPath" Then
DBPath = mydr.Name
End If
End While
mydr.Close()
Me.MobileDataTableAdapter.Connection.ConnectionString = "Data Source =""Program FilesCEdatabaseMobileDatabase.sdf"";"
Try
If MobileDatabaseDataSetUtil.DesignerUtil.IsRunTime Then
'TODO: Delete this line of code to remove the default AutoFill for 'MobileDatabaseDataSet.MobileData'.
Me.MobileDataTableAdapter.Fill(Me.MobileDatabaseDataSet.MobileData)
End If
Catch ex As SqlCeException
MessageBox.Show(ex.Message)
End Try
End Sub
End Class
View 4 Replies
View Related
Jul 31, 2007
Should I be able to use a SQL Server Compact Edition sdf file as the data source for the SSIS Import and Export Wizard?
When I select the .net Framework Provider for compact Edition from the data source drop down, I get a message box with "An error occured which the SSIS Wizard was not prepared to handle. Exception has been thrown by the target of an invocation. (mscorlib) Specified method is not supported. (System.Data.SqlServerCe)"
We have a user with a sdf file that will no longer sync, so we wanted to get her data from sdf file tables into SQL Server tables quickly and easily. Since the SSIS wizard wouldn't work with the sdf data source, we copied SQL Server Mgmt Studio query results into an Excel spreadsheet via the Clipboard, them imported those records with SSIS. But we need a repeatable process in case this happens in the future.
We tried to reinitialize her merge replication subscription with SQL Server Mgmt studio, and with C# code, but none of that would work.
How many MS data provider options are available for SQL Server compact edition? I see ".Net Framework Data Provider for Microsoft SQL Server Compact Edition" in the SSIS data source drop down, but shouldn't I also see an OLE-DB Provider for SQL Server Compact Edition?
This is all on my XP workstation where I can successfully write C# code for SQL Server Compact data access with Assembly = System.Data.SqlServerCe = C:Program FilesMicrosoft Visual Studio 8Common7IDEPublicAssembliesSystem.Data.SqlServerCe.dll. So I think I have the proper tools installed.
Thanks.
View 1 Replies
View Related
Feb 5, 2007
Hi Every One,
I would like to install the Sql Server 2005 on Vista RTM. prevoiusly I had Vista RC1 on which it was working fine.
Now, as the installation starts, the Vista Error dialog box gets appeared and the asks for the debugging, close or Online solution.
Please help me to install that.
Thanking you
gaurav gupta
View 1 Replies
View Related
May 23, 2007
I've successfully installed SQL Server 2005 Standard Edition on an Enterprise edition of Windows Server 2003 x64. I'm now (and also tried & failed during the install of the database engine) attempting to install the "Management Tools" component on the same server. However, in all my attempts to do so, I receive the following error:
---
The feature(s) specified are not valid for this edition of SQL Server
---
The message box does not list the features that are not valid but since the only item I've selected to install is the "Management Tools" option under "Client Components" it obviously points to something with that.
Am I missing something or are the Management Tools not supported in my config - most notably SQL Server 2005 Standard edition running on Windows Server 2003 x64?
Thanks.
- Lance
Colorado State University
View 6 Replies
View Related
Feb 14, 2007
I have a brand new Visual Studio 2005 box that set up correctly until I tried to install SQL Server. I get get this script error when I insert the cd - "ClassFactory cannot supply the requested class" How do I work around this?
View 2 Replies
View Related
Oct 1, 2007
fistly i'm sorry for my bad english
my computer includes winxp pro, .net framework 2.0, .net framework sdk 2.0, msxml 6.0, msdac 2.8
i have sql server 2005 express edition.
i want to upgrade it to sql server 2005 enterprise edition. but setup (enterprise edition) was beginning i had an error
/
SQL Server Edition Operating System Compatibility
"Some components of this edition of SQL Server are not supported on this operating system"
/
i had read on msdn about this problem. http://technet.microsoft.com/en-us/library/ms403393.aspx
and tried the upgrade on command line with this two code
/
-setup.exe SKUUPGRADE=1
@
-start /wait setup.exe ADDLOCAL=SQL_Engine,RS_Server PIDKEY=ABCDE12345FGHIJ67890KLMNO INSTANCENAME=SQLEXPRESS UPGRADE=SQL_Engine,RS_Server SKUUPGRADE=1 /qb
/
but i got again same error.
my last attempt was uninstall all sql express 2005 express edition and components then i tried setup again enterprise editon but same error
how can i solve this problem?
have a nice day
View 3 Replies
View Related
Apr 17, 2008
Hi,
I have Vista Home premium edition and trying to install SQL Server developer edition 2005 as local administrator. I have already enabled IIS 7 and have Office Ultimate 2007 installed. When I run the set up program, I get a warning titled "Program Compatibility Assistant" that my Operating system may not be compatible with the version of sql server I am installing. It says after setup is complete, I should run SP2 of SQL Server 2005 with 3 buttons as "Check for solutions online", "run this program" and "cancel"...
My question, should I select "run this program" and after the setup completes, download SP2 and apply the patch?
I read some articles in forums that sounds like lot of issues to get sql server working on vista. Can some one direct me to correct options. This is my wife's machine so I dont want to experiment too much and blow her machine away. Please help.
Thanks,
Gaja
View 7 Replies
View Related
Oct 25, 2007
I have:
A server computer running SQL Server 2005 Enterprise Edition.
A industrial computer running SQL Server 2005 Express Edition.
And now also a Psion WorkAboutPro with CE 5 that should run SQL Server Compact Edition.
The industrial computer syncs its data with the server, basically saying "this has happened".
Now I want the Psion to sync with the industrial computer, but this sync must two-way.
I have tried to find a guide or something that can tell me "do this to sync" but the information i have found is sketchy at best.
If someone could point me in the right direction of a guide or something else it would be much appreciated.
Regards,
Björn
View 9 Replies
View Related
Apr 1, 2007
Hi,
I have SQL Mobile 2005 server tools installed on my server and also my development PC. I started working with SQL Compact on a mobile application I'm developing so I downloaded the SQL Compact Server Tools and installed on my laptop and it added folders "syncSQL" to my "Program FilesSQL Mobile" folder. I used the configure web sync wizard to create a sync folder for SQL Compact and it added the file sqlcesa30.dll version 3.0.5300.0 to the new folder. The previous sync folders set up using SQL Mobile have version 3.0.5214.0 of the same file.
I then went to install the Compact Server Tools on my server (downloaded the file). When it was installing it asked if I wanted to repair or remove SQL Mobile Server Tools (it didn't do this on the laptop install). I selected "repair" and it apparently successfully installed. I checked the Program FilesSQL Mobile folder and there was no "syncSQL" folder. I created a new web sync folder and the version of sqlcesa30dll added is 3.0.5223.0.
My laptop is running XP Professional and the server is Server 2003. Both are running SQL Server 2005 SP2. It looks like it hasn't installed the server tools correctly on the server, what am I doing wrong? I'm also getting a lot of sync errors and wonder if it has something to do with Compact/Mobile incompatibility.
Some extra information: when I install the SQL Compact Server Tools on my XP Pro computer, the installer window title says "Microsoft SQL Server Compact Edition - English". When I run the same install file on Windows Server 2003 the window title is "Microsoft SQL Server 2005 Mobile SP1 [ENU] Server Tools". It seems to install different versions of the software depending on the operating system. Could someone from Microsoft please confirm that this is the case, and advise how I can get the correct SQL Compact Server Tools for my server.
Regards,
Greg
View 4 Replies
View Related
Aug 26, 2007
I have a question about a problem that I cannot seem to tackle. I have installed the following programs on Windows Vista:
- SQL Server 2005
- Visual Studio 2008
- SQL Server Compact Edition 3.5
- SQL Server Compact Edition 3.5 Server Tools
I want to do the following:
1. I want to create a SQL Server Compact Edition 3.5 database in the SQL Server Management Studio
2. I want my SQL Express server in SQL Server 2005 to be a distributor and publisher
About 1. In SQL Server Management Studio I cannot choose SQL Server Compact Edition 3.5 .
ABout 2. I tried to setup my server to be a distrubutor by running a stored procedure with the following name: sp_adddistributor. I get the following error: This edition of SQL Server cannot act as a Publisher or Distributor for replication.
Does anyone have a solution to both problems.
View 1 Replies
View Related
Apr 3, 2007
Trying to learn how to use Sql Server CE, Tutorial says to open server explorer, add connection, new connection, select data source as .net sql ce (words to that effect). On my visual studio, it ain't there and I can't figure out how to get it there. I have uninstall all of the Sql Ce stuff and reinstalled it. So I'm missing some key link. What are the magic incantations to get to first base?
Ed Warren
View 4 Replies
View Related
Jul 26, 2007
Hello,
I just installed SQL Server Compact Edition, since I am considering using it instead of SQL Server Express for a local database in my application. The documentation mentioned that I could use SQL Server Management Studio Express to connect to the Compact Edition and create and manipulate databases.
To try to connect, I run Management Studio and bring up the "Connect to Server" dialog. Unfortunately, the pull-down list of "Server name"s does not include the SQL Server Compact Edition server. I do not know how to type in the server name manually, so I cannot connect.
To install Compact Edition, I downloaded it and ran "SQLServerCE31-EN.msi". This installed, and I assume registered, a number of DLLs in "C:Program FilesMicrosoft SQL Server Compact Editionv3.1".
Is there perhaps an additional step that I left out to complete the installation?
Might I need an upgrade to some other components? My Management Studio Version is:
- Microsoft SQL Server Management Studio Express 9.00.2047.00
I would appreciate any help you can provide.
Thank you,
WTW
View 7 Replies
View Related
Jan 21, 2008
Does Sql Server Compact Edition 3.5 support RDA synchronization with Sql Server 2000 database?
View 4 Replies
View Related
Jan 15, 2007
Hi,
I've got a big problem reinstalling the just released VS2005 Tools:
I've installed them, but then I've deinstalled them to first deinstall RC1 and install the just released RTM/W(?) of the runtime.
But since then I was not able to reinstall the VS2005 Tools: The installer just says, that a required program for the upgradepatch is missing or another version is installed.
I've also tried to reinstall SP1 of VS 2005, with the same result.
BTW, I just wanna mention, that it is very complex to look through the new released Compact Edition releases. For example for the runtime it is required that the english release is installed before another localized release. But the localized releases are not called "Language Packs" (what they are) and do not verify that the english version is already installed. Also I'm interested what the recommended installation order is for installing on a developer computer eg. in German. First the VS2005 Tools or the SDK or the runtime?
Thanks in advance,
Klaus
View 3 Replies
View Related
Aug 18, 2007
I am having problems installing the Sql server compact 3.5 server tools beta 2 onto a Windows Vista 64 bit system. It keeps saying that either I don't have IIS installed, or I have IIS7 installed but don't have the "backward compatibility" components installed. Id so infact have IIS 7 installed, and I've installed all the IIS6 bits. There are no features named "backward compatibility", so I assumed the IIS6 bits were the right ones. Anyone get this to work? I thought I read somewhere that beta 2 doesn't support 64 bit yet - but now I can't find any mention of it.
View 10 Replies
View Related
Apr 16, 2008
Hello all,
I have 2 networked PC's both running vista ultimate
1st is Laptop and is running its own SQL Server at laptoplaptopSQL
2nd is Desktop and is running its own SQL Server at desktopdesktopSQL
Now both machines have seperate windows login accounts.
When I go SQL Server management studio I go to browse and each machine can see the other machines SQL Server, but when I go to login I get SQL Login falied for users" The user is not associaed with a trusted SQL server connection".
So I then go to logins new login and try to add my other pc's user account.
The problem I see is that when I go to search and then location it only shows its own PC's location and not the location of my other networked pc? So if I am on Desktop and in my theory want to add laptopuser to the desktop SQL Server logins I get:
"create failed for login laptopuser
An exception occurred while executing Transact SQL statement laptopuser is not a valid windows NT name. give the complete name
Not sure on where to go from here.
Any help would be great
View 10 Replies
View Related
Mar 26, 2008
I have visual studio 2008 sql express, vista ultimate is on my computer however I have not installed sql express on my computer
I wish to install sql standard 2005 sp1 I have read microsoft's article 934164 before installing sql standard
I have a couple of questions installing sql server standard edition see sql-articles.com -installing
sql 2005
sql instances screen- can I choose default installation?
sql services screen do I need to choose domain name(I am a small business, I do not own a server, I wish to
use a third party to use sql reporting services . I have not registered my domain name
Windows authentication- I wish to use mixed mode.
I wish to configure user account later by stopping sql services and then installing sql sp2 (after windows
authentication screen)
described in microsoft article 934164
do I need to configure the server?(next screen after windows authentication)
I want to avoid a system reboot......
Is there anyway that I can make sure all the parts are installed on sql server and sql sp2?
Is it adviseable to configure my administrative account at the end of sql sp2?
How do this work? I just want to be prepared......
Thank you
View 1 Replies
View Related
Mar 13, 2008
I'm trying to upgrade from the SCE 3.0 server tools to the 3.5 server tools. I've uninstalled the 3.0 tools and while trying to install the 3.5 tools I get an error on the IIS requirement indicating that with IIS 7.0 I need to install the backward compatibily components and can not proceed with the install.
Searching Microsoft I get hits that mention the IIS backward compatibility components, but no links on where to download them. This might be a useful link to add to the sticky with the downloads for SCE 3.5. Also, one of the requirements referneces on the SCE3.5 server tools download, indicates that the backward IIS compatibility components were supported on 32 bit OSs, no mention of 64; this also has me concerened.
I'm running Visual Studio 2008 and SQL Server 2005 on my workstation. My device has SCE 2.0, 3.0 & 3.5 on it; these all are working fine. I'm trying to upgrade everything to 3.5 so I can get rid of prior versions. From within VS2008 I can connect to SCE3.5 SDFs and have updated a couple of databases to 3.5. What I want to do is connect to the 3.5 SDFs from SQL Server 2005; which is why I am trying to install the server tools.
I've got SQL 2008 installed on a VM and am able to connect to 3.5 SDFs but I'm trying to avoid the hassle of firing the VM and schlepping files across the VM boundary to work with the 3.5 SDFs. It's becoming a pain. Which is why I am trying to install the server tools.
Is there a resolution to this? Can I get the server tools installed on a 64 bit Vista box? Is there a link for the backward compatibility tools?
Steve
View 8 Replies
View Related
Sep 25, 2007
I am writing an application that is designed for the desktop, or small group (3 or less) desktops. The application is being deployed using the Cassini web server as a complete "embedded" solution. I wanted to use SQL Server Compact because of its small footprint and because of the synchronization capabilities with SQLServer. Also, it is very easy to deploy vs. SQL Server Express. The idea behind this APP is that someone might use it locally and then decide to subscribe to the service and then connect the same application to a web services application.
That being said, and with knowledge of Microsoft's stance on SQL Compact under ASP.NET, I have most everything working and it works great except for one thing. When I add a SQLDataSource to the page and set the connection string to my file and the DataProvider to System.Data.SqlServerCe and then bind a data grid to the SQLDataSource, it runs fine on my development machine, but when I deploy to my clean test machine, I get an error when the page loads saying:
Unable to find the requested .Net Framework Data Provider. It may not be installed.
I can create a dataset in code (in fact,in several other places I do) and it works fine. It is just the SQLDataSource(s) that are throwing this error. I have a copy of System.Data.SqlServerCe.dll in the bin folder and I have all of the compact DLL's in the bin folder as well. I can't figure out what I need to do. I also have a reference to the System.Data.SqlServerCe in the web.config file.
Can anyone help?
View 3 Replies
View Related
Jan 9, 2007
Does the new SQL server Compact edition RC1 (release in Dec 2006) replace the Microsoft SQL Server 2005 Mobile Edition Device SDK?
OR is this an additional database for specific requirements.
Currently developing against MS SQL Server 2005 Mobile Edition Device SDK;; if I switch to the Compact edition; is there a migration wiarzrd or Upgrade wizard available?
-jawahar
View 1 Replies
View Related
Apr 25, 2008
Hopefully a simple question: Is it possible to use Maintenance Plans created on SQL Server Management Studio (installed as part of an instance of SQL Server 2005 Standard Ed.) to back up databases running on an instance of SQL Server Express Edition with Advanced Services? I don't need directions, just whether or not it is permitted.
I've been able to create the plans including establishing connections to from SSMS to the the SQL Express instance, but they keep erroring out. I just need to know if this is actually permitted since Maintenance Plans are not available on Management Studio Express Edition.
Thank you in advance for your help.
View 7 Replies
View Related
Jan 11, 2008
I've been trying to run through the Microsoft example at http://msdn2.microsoft.com/en-us/library/bb226707.aspx entitled "Configuring IIS for SQL Server 2005 CE Remote data access and Merge replication" but I'm having issues. The first time I ran through it I tried to use IIS on a server that was not the same as the SQL server and it didn't work at all. So I ran through it a second time and used the SQL servers IIS for testing and when I went to access the webpage I got a HTTP 500 Internal Error. After a while of playing I got a "Service Unavailable" message but still not the "Microsoft SQL Server CE server agent" screen I should have gotten. So my first question is how do I get this to work with a seperate IIS server? Which step do I change because I did put the right IIS and made a site there but it didn't work? I thought changing step 5 under the "To configure IIS for SQL Server CE Sync" to my IIs server would do it but it didn't. Maybe because in step 8 of the same section you have to use the share name and not a local directory even though its the same directory on the IIs server?
Also I just want to make sure I'm going down the right path with this. I have a VB.Net 05 application that connects to a database on a SQL 2005 server internally. I also have a seperate IIS server that is serving some web pages. Network is protected by both a hardware firewall then to a ISA box which I can control and allow http access to the internal IIS for whatever subdomain I end up choosing. I would like to create a mobile version of the application for some Mobile 6 devices we have and have them able to sync there data. In fact they don't even need to sync, just be able to download the server data once a week or on command. I've gotten the SDK for mobile devices, the "How to pull data using the RDA object", written the framework for the program, and now I need to figure out how to push the data out so it can be retrieved by my mobile devices over the internet. I've tried searching for answers, I thought this would be a popular thing to do, but I'm having trouble finding anything.
-Allan
View 4 Replies
View Related
Nov 7, 2006
Dear Community,
The SQL Server Compact Edition RC1 has been released and is now available at download center http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en
Please note that the RC1 page link is the same as CTP page link, we have updated it for RC1. This doesn€™t have ClickOnce files (Zip file) as the same is available with Tools for VS 2005 sp1 beta at download center at http://www.microsoft.com/downloads/details.aspx?FamilyID=61289b5d-af86-45dd-8962-e7dcc5221796&displaylang=en
We have blogged about it at http://blogs.msdn.com/sqlservereverywhere/ .
Please check out the RC1 bits.
Thanks
Sachin, Program Manager, SQL Server CE Team
View 10 Replies
View Related
Oct 23, 2007
Hi, Is there a special jdbc driver for SQL Server Compact Edition (2005) available? I'm getting error messages when trying to run java application on Pocket PC (Mobile 5.0):
java.lang.UnsatisfiedLinkError: java/sql/DriverManager.getCallerClassLoader()Ljava/lang/ClassLoader;
at java.sql.DriverManager.getConnection(Unknown Source)...
Mixxo
View 1 Replies
View Related
Apr 10, 2008
Is there a way to import the table definitions and data from an Access database into the 3.5 compact edition? I have no clue where to start. I have a .Net application that uses an Access database to store data. I want to create a windows mobile application for collecting the data and syncing with the PC application. Is the 3.5 compact edition the way to go? How do I get started? I don't even know how to open the interface for the database.
I'm certainly no newbie to programming, but the SQL Server and Windows Mobile stuff is like starting all over in some ways.
View 3 Replies
View Related