Installting sqlserver 2005 on the client machine for windows application

Hi
I developed a windows application in Visual studio 2005 and the database is sqlexpress.
I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver.
Is there any solution for this.

Thanks

hi,

yes... you have to separately download and install SQL Server Management Studio Express... http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

regards

|||SQL Server Express does not come with EM or Query Analyzer. These two components have been merged into the SQL Server Managment Studio. The SQL Server Management Studio Express (which actually is a stripped of SQL Server Managment Studio (aka SSMS)) can be downloaded separately from Microsoft or is already included in the Express Advanced Edition (which actually includes some other cool features like Reporting Services for SQL Server Express).

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.desql

Installing SQL Server 2005 DB via .NET application

Hello all,

I've developed a visual basic .net (2005) application that uses sql server 2005 (express edition) as a database and I created a setup project that installes my application. Now, my question is how can I create a "all-in-one" installation procedure/file that will install both the SQL server (engine + db) and my application?

I've found the following link:

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp#sqlexpuser_topic10

That mentions under: "Distribution and Deployment" section, something that sounds like what I'm looking for, but I didn't find any further information on how to do that. Can anyone help?

Thanks in advanced!

Tom.

I have the same question...bump...

_ANY_ resources out there?

|||

Hi,

SQL Server Express doesn′′t use merge modules anymore. It uses now the msi pakcage functionalty which is described in the help of Visual Studio, its like configuring any other MSI package within a setup project to deploy.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Installing SQL Server 2005 DB via .NET application

Hello all,

I've developed a visual basic .net (2005) application that uses sql server 2005 (express edition) as a database and I created a setup project that installes my application. Now, my question is how can I create a "all-in-one" installation procedure/file that will install both the SQL server (engine + db) and my application?

I've found the following link:

http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp#sqlexpuser_topic10

That mentions under: "Distribution and Deployment" section, something that sounds like what I'm looking for, but I didn't find any further information on how to do that. Can anyone help?

Thanks in advanced!

Tom.

I have the same question...bump...

_ANY_ resources out there?

|||

Hi,

SQL Server Express doesn′′t use merge modules anymore. It uses now the msi pakcage functionalty which is described in the help of Visual Studio, its like configuring any other MSI package within a setup project to deploy.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de