Installing MSDE using VS.NET

Hi all,
I want to create setup/Installer project in Visual
Studio.NET 2003 that will detect MSDE. If MSDE already
installed then setup will not install MSDE , If not then
setup will install MSDE.
So please tell me have will i installed MSDE
using /Installer project in Visual Studio.NET 2003.
Thx in Advance
Amit
Hi Amit,
You can download MSDE toolkit, that is a plug-in to Microsoft Visual Studio
that automates the process of creating an integrated package with both the
application and the MSDE database, from
http://www.microsoft.com/downloads/d...403-c4ba-4d98-
bb0b-2c9d6414071f&DisplayLang=en
This toolkit will help you in customizing and designing a setup for MSDE
that can be integrated with your application.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Thank you ashish great link. I installed on my system
working fine .
My next question is how i can add my database file in MSDE
using same VS.Net installer.
Amit

>--Original Message--
>Hi Amit,
>You can download MSDE toolkit, that is a plug-in to
Microsoft Visual Studio
>that automates the process of creating an integrated
package with both the
>application and the MSDE database, from
>http://www.microsoft.com/downloads/details.aspx?
FamilyID=6e9a7403-c4ba-4d98-
>bb0b-2c9d6414071f&DisplayLang=en
>
>This toolkit will help you in customizing and designing a
setup for MSDE
>that can be integrated with your application.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
You can go through the following technical article that helps in designing
classes for MSDE installation.
http://msdn.microsoft.com/library/de...us/dnmsde/html
/msdedepl.asp
According to that you can use the "AfterInstall" event to add the database
to the MSDE server.
According to my understanding, you will have to include the database files
in your setup and extract it to the desired location, and then execute the
"attachdb" function or the sp_attach_db stored procedure from the object.
HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Ashish,
Thank you my installation nightmare is over.
But i have still one problem.
I am using trusted connection to connect my web site with
MSDE database.
In command line i use
osql -S myserver\Instancename -E connected successfully.
while connecting with my website it will give following
error.
"Login failed for user "servername\ASPNET"
i also use SQL connection in which i provide user id and
password but the result is same an error occurs.
"Login failed for user "sa". Reason: Not associated with
trusted SQL server Connection"
please tell me where i am wrong.
Thanks
Amit

>--Original Message--
>Hi Amit,
>You can go through the following technical article that
helps in designing
>classes for MSDE installation.
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnmsde/html
>/msdedepl.asp
>
>According to that you can use the "AfterInstall" event to
add the database
>to the MSDE server.
>According to my understanding, you will have to include
the database files
>in your setup and extract it to the desired location, and
then execute the
>"attachdb" function or the sp_attach_db stored procedure
from the object.
>HTH
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi Amit,
The user servername\ASPNET is the default user name that the ASP.NET process
runs as within the operating system. It is configured in the machine.config
file. By default, it has no access to your databases.
You have three basic options:
1. Grant appropriate database access to the ASPNET user.
2. Use impersonation on the site - configured in your web.config file (ie
impersonate the windows user that the end user is connecting as - not great
for public sites of any type)
3. Have your application log on as a specific user and grant that user
access to the database.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Amit" <anonymous@.discussions.microsoft.com> wrote in message
news:213c01c42794$69f54020$a101280a@.phx.gbl...[vbcol=seagreen]
> Hi Ashish,
> Thank you my installation nightmare is over.
> But i have still one problem.
> I am using trusted connection to connect my web site with
> MSDE database.
> In command line i use
> osql -S myserver\Instancename -E connected successfully.
> while connecting with my website it will give following
> error.
> "Login failed for user "servername\ASPNET"
> i also use SQL connection in which i provide user id and
> password but the result is same an error occurs.
> "Login failed for user "sa". Reason: Not associated with
> trusted SQL server Connection"
>
> please tell me where i am wrong.
>
> Thanks
> Amit
>
> helps in designing
> url=/library/en-us/dnmsde/html
> add the database
> the database files
> then execute the
> from the object.
> confers no rights.
sql