"anibakore" <ani.bakore@gmail.com> wrote in message
news:1162272568.028079.227760@k70g2000cwa.googlegroups.com...
> Hi,
> The instance is a named instance.There is a separate service called
> "MSSQL$Appname".
> Where Appname is the name of the application I am using.
> Thanks,
> Anirudh
>
> Arnie Rowland wrote:
>
>> That may present a bit more of a challenge.
>>
>> First, it is important to determine if the MSDE is the 'default' instance
>> of
>> SQL Server, or if it is a 'named instance'.
>>
>> Go to [Administrative Tools], and select the [Services] applet.
>> How many services that start with MSSQL do you find?
>> If more than MSSQLSERVER, what are the names?
>>
>> Gather and report that information and someone here can help you further.
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>>
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>> You can't help someone get up a hill without getting a little closer to
>> the
>> top yourself.
>> - H. Norman Schwarzkopf
>>
>>
>> "anibakore" <ani.bakore@gmail.com> wrote in message
>> news:1162270303.823821.177750@m73g2000cwd.googlegroups.com...
>> > That's the main problem.. I dont have an access to the
>> > connectionstring. It is embedded in the application.
>> > Hari Prasad wrote:
>> >
>> >> Hi,
>> >>
>> >> You could.. All you have to do is:-
>> >>
>> >> 1. back up the databases in MSDE
>> >> 2. Restore the database in SQL 2005
>> >> 3. Create the logins
>> >> 4. Change the application connection string to point to SQL server
>> >> 2005
>> >>
>> >> Thanks
>> >> Hari
>> >>
>> >>
>> >> "anibakore" <ani.bakore@gmail.com> wrote in message
>> >> news:1162202124.621048.175580@e3g2000cwe.googlegroups.com...
>> >> > Hello ,
>> >> > I have an application that uses MSDE internally. Now I want to
>> >> > replace
>> >> > that MSDE database by full SQL Server 2005. I have SQL server 2005
>> >> > installed.
>> >> > Is it possible to replace the MSDE instance that the application is
>> >> > using, by SQL server instance without changing the application's
>> >> > configurations?
>> >> >
>> >> >
>> >> > Thanks,
>> >> > Anirudh Bakore.
>> >> >
>> >
>