Microsoft SQL Server Desktop Engine - Replacing MSDE by SQL Server 2005

Author

Replacing MSDE by SQL Server 2005

anibakore

2006-10-31, 12:24 am

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.

Hari Prasad

2006-10-31, 12:24 am

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.
>

anibakore

2006-10-31, 7:15 pm

That's the main problem.. I dont have an access to the
connectionstring. It is embedded in the application.
Hari Prasad wrote:
[color=darkred]
> 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...

Arnie Rowland

2006-10-31, 7:15 pm

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:
>
>

anibakore

2006-10-31, 7:15 pm

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:
[color=darkred]
> 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...

Arnie Rowland

2006-10-31, 7:15 pm

I would recommend that you first install SQL 2005 on a test computer and
test the application against the test server.

This article seems to be complete about the 'in-place' upgrade process.

http://www.microsoft.com/technet/pr...sqlexpress.mspx

--
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: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:
>
>

Sponsored Links