Moving the ASPNETDB.MDF file to another computer

Hi all!

I have some problems with asp.net windows authentication.
Asp made the file ASPNETDB.MDF. But I dont have SQL Server on the machine where the application will be deployed...
So I have to move this file to another server, but I couldnt find any information about ASPNETDB.MDF connection string or somenthing like this.
Is it possible to move this file or I have to make the authentication on my own, with my own database? I hope there is a solution to this problem!
Many thanks! Regards!

Certainly there is The connection string can be found somewhere, check this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

moving sql database

What is the procedure for moving a database from one c:\
to D:\ on the same computer.
I figure I have to use sql analyzer but once there what
are the steps.
Thanks
You could refer to this article on Microsoft's website.
http://support.microsoft.com/?kbid=224071
This should get you started.
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

moving sql database

What is the procedure for moving a database from one c:\
to D:\ on the same computer.
I figure I have to use sql analyzer but once there what
are the steps.
ThanksYou could refer to this article on Microsoft's website.
http://support.microsoft.com/?kbid=224071
This should get you started.
sanchans@.online.microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Moving Reports to another computer Connection String

Hello
I created several Reports using SSRS and SSAS. now i have to move them to another PC, which name is different. is there a way to do this without having to open each report in BIDS and changing the connection string for each Data Source ?
thanks

There are several ways to do this, although it is probably too late for you now to do some of them:

1) use a shared datasource so that you can change only one place

2) use an expression as your connection string, as described here http://msdn2.microsoft.com/en-us/library/ms156450.aspx
... look for the section on "expression-based DataSources" or DataSource Expressions or something like that.

as I said it is too late for those now, you already created the reports, right?

3) write a script that loads each RDL/RDLC as an XML document and fixes the connection string -- or if there are only a handful of reports, just open the XML and do it manually... even manually it is probably faster than loading every report in the designer. But writing such a script to iterate over the contents of a folder and fix the one item you want to fix in each one shouldn't be very hard -- might come in handy later.

4) deploy the reports as-is to the new server and then manually fix their connection strings in the Report Manager interface, again depending on how many this might be pretty quick.

5) deploy the reports as-is to the new server and then use the SQL Studio Management interface to drill down to the Data Sources node for each report and fix it there -- might be faster than the BIDS way since you're not opening the reports

.... ?

>L<

Moving Report Manager

I need to move the report manager from one computer to another computer.
Currently the RS database is on a db server, separate from the report
manager. This will stay the same. I need to know what the steps are for
moving the Report Manager to this new server, and keep all my
folders/schedules intact.Hello dachrist,
The first step would be to install Reporting Services on the new server. If
you are installing Standard Edition you can not choose the database during
the installation, however, you can use a combination of two command line
utilities to connect to the existing database post install. These are:
rsconfig and rsactivate. rsconfig sets the connection information to the
database and a basic syntax would be:
rsconfig -c -s DBServerName -d ReportServer -a SQL -u SQLUsername -P
Password
The "-d" option specifies the ReportServer database and "-a" sets the
authentication type to SQL authentication. rsconfig will be run on the new
Reporting Services Server.
You then run rsactivate on the dbserver to activate the new Reporting
Services Server you just installed, what you referred to as the Report
Manager. .
rsactivate -m NewReportingServicesServer -u Username -p Password
Username and Password will be the Windows account with administrative
priveleges to the Reporting Services Web Service.
I hope this helps.
Rodney Landrum
Author : "Pro SQL Reporting Services" (Apress)
www.apress.com
"dachrist" <dachrist@.discussions.microsoft.com> wrote in message
news:5FAE2190-1179-4FE6-BA4D-FB552C6D9D8F@.microsoft.com...
>I need to move the report manager from one computer to another computer.
> Currently the RS database is on a db server, separate from the report
> manager. This will stay the same. I need to know what the steps are for
> moving the Report Manager to this new server, and keep all my
> folders/schedules intact.

Moving my SQL Server to another computer

I will moving my SQL Server to another server. The plan is to stop SQL Server copy database file to a temp netwokr location, Switch off this server. Configure the new server with the same name and IP, install SQL to the same paths and service pack to the same level (SQL 2000 sp3). Then start and stop the SQL server. Once stop I will then copy the old database file over the new ones.

I know in general this works as I have doen this many times before expect this time round there is a replicaiton database which is new, I am expecting this will work the same but has any one else tried this before?

Unfortunately, you have to disable the publication before you can detach and move the database.

BTW, I recommend you to detach the database before you move the database file to another server, this ensure you can attach it to the new server even though it is missing the transaction log file.

moving MSDE database to SQL...

rI have an end-use that created a database on MSDE and is housing it on
his local computer. We want to move/copy it to our SQL server so it
can be backed up etc. What are the appropriate steps in doing so?
Thanks in advance,
KenIf they have both the same (and probably latest) service packs, the
compatibility is 100% and you don't have to take any special step (excerpt
maybe for authentification and login information). So a Backup/Restore or a
Detach/Reattach operation will be the easiest way.
S. L.
"Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> rI have an end-use that created a database on MSDE and is housing it on
> his local computer. We want to move/copy it to our SQL server so it
> can be backed up etc. What are the appropriate steps in doing so?
> Thanks in advance,
> Ken
>|||Thanks for the reply, but I have no idea what the command lines are for MSDE
in order to backup etc. Where would I find those that I need in order to
backup and then restore to the SQL server?
Thanks,
Ken
"Sylvain Lafontaine" wrote:

> If they have both the same (and probably latest) service packs, the
> compatibility is 100% and you don't have to take any special step (excerpt
> maybe for authentification and login information). So a Backup/Restore or
a
> Detach/Reattach operation will be the easiest way.
> S. L.
> "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
>
>|||Well, look up BACKUP DATABASE in Books Online, and to execute it against
MSDE, you can use
osql -S(local)\instancename -E -Q"BACKUP DATABASE ..."
or
osql -S(local)\instancename -E -Q"EXEC sp_detachcb ..."
http://www.aspfaq.com/
(Reverse address to reply.)
"Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
news:17196A2A-FC3F-4B6C-AC32-BF41E842AB48@.microsoft.com...
> Thanks for the reply, but I have no idea what the command lines are for
MSDE[vbcol=seagreen]
> in order to backup etc. Where would I find those that I need in order to
> backup and then restore to the SQL server?
> Thanks,
> Ken
> "Sylvain Lafontaine" wrote:
>
(excerpt[vbcol=seagreen]
or a[vbcol=seagreen]
on[vbcol=seagreen]|||Mr. Aaron,
The problem with this is going to be the users password which Ken needs to
recreate after restoring the db.
v/r
ktf
"Aaron [SQL Server MVP]" wrote:

> Well, look up BACKUP DATABASE in Books Online, and to execute it against
> MSDE, you can use
> osql -S(local)\instancename -E -Q"BACKUP DATABASE ..."
> or
> osql -S(local)\instancename -E -Q"EXEC sp_detachcb ..."
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> news:17196A2A-FC3F-4B6C-AC32-BF41E842AB48@.microsoft.com...
> MSDE
> (excerpt
> or a
> on
>
>|||> The problem with this is going to be the users password which Ken needs to
> recreate after restoring the db.
And he can't do:
osql -S(local)\instancename -E -Q"EXEC sp_password ..."
?
http://www.aspfaq.com/
(Reverse address to reply.)

moving MSDE database to SQL...

rI have an end-use that created a database on MSDE and is housing it on
his local computer. We want to move/copy it to our SQL server so it
can be backed up etc. What are the appropriate steps in doing so?
Thanks in advance,
Ken
If they have both the same (and probably latest) service packs, the
compatibility is 100% and you don't have to take any special step (excerpt
maybe for authentification and login information). So a Backup/Restore or a
Detach/Reattach operation will be the easiest way.
S. L.
"Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> rI have an end-use that created a database on MSDE and is housing it on
> his local computer. We want to move/copy it to our SQL server so it
> can be backed up etc. What are the appropriate steps in doing so?
> Thanks in advance,
> Ken
>
|||Thanks for the reply, but I have no idea what the command lines are for MSDE
in order to backup etc. Where would I find those that I need in order to
backup and then restore to the SQL server?
Thanks,
Ken
"Sylvain Lafontaine" wrote:

> If they have both the same (and probably latest) service packs, the
> compatibility is 100% and you don't have to take any special step (excerpt
> maybe for authentification and login information). So a Backup/Restore or a
> Detach/Reattach operation will be the easiest way.
> S. L.
> "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
>
>
|||Well, look up BACKUP DATABASE in Books Online, and to execute it against
MSDE, you can use
osql -S(local)\instancename -E -Q"BACKUP DATABASE ..."
or
osql -S(local)\instancename -E -Q"EXEC sp_detachcb ..."
http://www.aspfaq.com/
(Reverse address to reply.)
"Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
news:17196A2A-FC3F-4B6C-AC32-BF41E842AB48@.microsoft.com...
> Thanks for the reply, but I have no idea what the command lines are for
MSDE[vbcol=seagreen]
> in order to backup etc. Where would I find those that I need in order to
> backup and then restore to the SQL server?
> Thanks,
> Ken
> "Sylvain Lafontaine" wrote:
(excerpt[vbcol=seagreen]
or a[vbcol=seagreen]
on[vbcol=seagreen]
|||Mr. Aaron,
The problem with this is going to be the users password which Ken needs to
recreate after restoring the db.
v/r
ktf
"Aaron [SQL Server MVP]" wrote:

> Well, look up BACKUP DATABASE in Books Online, and to execute it against
> MSDE, you can use
> osql -S(local)\instancename -E -Q"BACKUP DATABASE ..."
> or
> osql -S(local)\instancename -E -Q"EXEC sp_detachcb ..."
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> news:17196A2A-FC3F-4B6C-AC32-BF41E842AB48@.microsoft.com...
> MSDE
> (excerpt
> or a
> on
>
>
|||> The problem with this is going to be the users password which Ken needs to
> recreate after restoring the db.
And he can't do:
osql -S(local)\instancename -E -Q"EXEC sp_password ..."
?
http://www.aspfaq.com/
(Reverse address to reply.)

moving MSDE database to SQL...

rI have an end-use that created a database on MSDE and is housing it on
his local computer. We want to move/copy it to our SQL server so it
can be backed up etc. What are the appropriate steps in doing so?
Thanks in advance,
KenIf they have both the same (and probably latest) service packs, the
compatibility is 100% and you don't have to take any special step (excerpt
maybe for authentification and login information). So a Backup/Restore or a
Detach/Reattach operation will be the easiest way.
S. L.
"Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> rI have an end-use that created a database on MSDE and is housing it on
> his local computer. We want to move/copy it to our SQL server so it
> can be backed up etc. What are the appropriate steps in doing so?
> Thanks in advance,
> Ken
>|||Thanks for the reply, but I have no idea what the command lines are for MSDE
in order to backup etc. Where would I find those that I need in order to
backup and then restore to the SQL server?
Thanks,
Ken
"Sylvain Lafontaine" wrote:
> If they have both the same (and probably latest) service packs, the
> compatibility is 100% and you don't have to take any special step (excerpt
> maybe for authentification and login information). So a Backup/Restore or a
> Detach/Reattach operation will be the easiest way.
> S. L.
> "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> > rI have an end-use that created a database on MSDE and is housing it on
> > his local computer. We want to move/copy it to our SQL server so it
> > can be backed up etc. What are the appropriate steps in doing so?
> >
> > Thanks in advance,
> >
> > Ken
> >
>
>|||Well, look up BACKUP DATABASE in Books Online, and to execute it against
MSDE, you can use
osql -S(local)\instancename -E -Q"BACKUP DATABASE ..."
or
osql -S(local)\instancename -E -Q"EXEC sp_detachcb ..."
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
news:17196A2A-FC3F-4B6C-AC32-BF41E842AB48@.microsoft.com...
> Thanks for the reply, but I have no idea what the command lines are for
MSDE
> in order to backup etc. Where would I find those that I need in order to
> backup and then restore to the SQL server?
> Thanks,
> Ken
> "Sylvain Lafontaine" wrote:
> > If they have both the same (and probably latest) service packs, the
> > compatibility is 100% and you don't have to take any special step
(excerpt
> > maybe for authentification and login information). So a Backup/Restore
or a
> > Detach/Reattach operation will be the easiest way.
> >
> > S. L.
> >
> > "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> > news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> > > rI have an end-use that created a database on MSDE and is housing it
on
> > > his local computer. We want to move/copy it to our SQL server so it
> > > can be backed up etc. What are the appropriate steps in doing so?
> > >
> > > Thanks in advance,
> > >
> > > Ken
> > >
> >
> >
> >|||Mr. Aaron,
The problem with this is going to be the users password which Ken needs to
recreate after restoring the db.
v/r
ktf
"Aaron [SQL Server MVP]" wrote:
> Well, look up BACKUP DATABASE in Books Online, and to execute it against
> MSDE, you can use
> osql -S(local)\instancename -E -Q"BACKUP DATABASE ..."
> or
> osql -S(local)\instancename -E -Q"EXEC sp_detachcb ..."
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> news:17196A2A-FC3F-4B6C-AC32-BF41E842AB48@.microsoft.com...
> > Thanks for the reply, but I have no idea what the command lines are for
> MSDE
> > in order to backup etc. Where would I find those that I need in order to
> > backup and then restore to the SQL server?
> >
> > Thanks,
> >
> > Ken
> >
> > "Sylvain Lafontaine" wrote:
> >
> > > If they have both the same (and probably latest) service packs, the
> > > compatibility is 100% and you don't have to take any special step
> (excerpt
> > > maybe for authentification and login information). So a Backup/Restore
> or a
> > > Detach/Reattach operation will be the easiest way.
> > >
> > > S. L.
> > >
> > > "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> > > news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> > > > rI have an end-use that created a database on MSDE and is housing it
> on
> > > > his local computer. We want to move/copy it to our SQL server so it
> > > > can be backed up etc. What are the appropriate steps in doing so?
> > > >
> > > > Thanks in advance,
> > > >
> > > > Ken
> > > >
> > >
> > >
> > >
>
>|||> The problem with this is going to be the users password which Ken needs to
> recreate after restoring the db.
And he can't do:
osql -S(local)\instancename -E -Q"EXEC sp_password ..."
?
--
http://www.aspfaq.com/
(Reverse address to reply.)