SQL Server - want to embedd a database in sqlexpress edition

please tell me how

thanks in advance

If you need an embedded database, you should consider the SQL Server 2005 Compact Edition because it might be the better choice over the SQL Server 2005 Express Edition. The Compact Edition is not a released product yet, but is at the release candidate stage. With the price point of being free, it becomes a relative "no brainer" solution when you need a small embeddable database on the client side for your applications.

I should also make one last comment &md; MSDE won't be supported on Vista. If you are still using MSDE, then you might want to start seriously considering SQL Server 2005 Express Edition or Compact Editions

Hi,

Someone with administrator privileges on the machine, would need to sign in the SQL Server Express and add you as a member of the sysadmin server role.  You would then be a "SQL Administrator" and perfrom below tasks.

1. If you don't have a database, you must create it on local computer in Visual Studio (Add new item to App_Data directory) or in SQL Server Management Studio (Create database). Before you copy this file you must detach your database from your SQL Server.

2. You must be sure, when you copy the .mdf file(s), don't copy the log files to the FTP. (If you did, then you must delete them). All databases files must be placed in the App_Data directory.

3. On the freehosting server you can use User Instances only.

4. You may have to remove the LocalSqlServer name:

i configured my express to login as suggested from the site and create user name and password but got this error

Cannot connect to SUNI\SQLEXPRESS.

===================================

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

------------------------------
Server Name: SUNI\SQLEXPRESS
Error Number: 233
Severity: 20
State: 0

------------------------------
Program Location:

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
   at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
   at System.Data.SqlClient.TdsParserStateObject.ReadByte()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
   at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

The MS links says: Do below

Also see below links to configure the server to allow remote connections:

http://support.microsoft.com/kb/914277

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://www.specifysoftware.org/specifyforums/procedures/sql2005RemoteConfig

Regards,

Megha

i am using windows xp with service pack 3 and

Microsoft SQL Server Management Studio Express      9.00.3042.00
Microsoft Data Access Components (MDAC)      2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML      2.6 3.0 6.0
Microsoft Internet Explorer      6.0.2900.5512
Microsoft .NET Framework      2.0.50727.42
Operating System      5.1.2600

regards,

Suny

First i create a back up data of Northwind from my sql 2000.then i create a database named Northwind in my sql express edition. then restore that from the backup data of Northwind database. after that i detach it. So I could succeed attaching that through my vb application

this is the code:

 cn.ConnectionString = "Provider=SQLNCLI.1;Integrated Security=SSPI;Server=SUNI\SQLEXPRESS;" & _
        "Persist Security Info=False;User ID=sa;Password=holsoft;Database=Northwind; " & _
        " AttachDBFileName=" & App.Path & "\Northwind.mdf;"

cn.Open

But my doubt is when i try to installe my exe in clients system..should i manaully create the Database in his system.and should i install sql express seperately...

I found in MSDN that Sql express installation can be done through Custom application

Is these three methods are enough for embedding

IsExpressInstalled, EnumSQLInstances, and InstallExpress these

or should i manually do it all

please give my suggestions

regards

Suny