running backup and restore...

I had my IT dept. install sql server 2005 enterprise edition on a new windows server 2003. All other machines are running sql 2000 server on windows server 2000. I am a sa and local admin on all servers. I tried performing copy database, backup and restore and detach and attach to upgrade the sql server 2000 databases to 2005 and all fail. They also installed sql server 2005 sp2. I followed all steps. It's like the servers dont talk to each other. Their all on the company's domain. I am wondering if something happen with the install but the IT dept. insist that everything went fine. It's strange that I can't perform a simple backup and restore it on the new server buy when I click on restore it doesn't let me browse to get the backup file on the 2000 server. I never had a problem in Sql 2000 with backup. Can it be the installation was corrupted somehow. It seems fine. I haven't created any new databases because I wanted to move the databases from sql 2000. Can anyone help me get a clue of what the problem is please?

ThanksSounds like the service account for the SQL Server 2005 service has no network rights. Try copying the backup file locally, then doing the restore.

Running 2000 and 2005 Reporting services on a single server

I've got SQL server 2000 running on a W2003 server and I want to install SQL Server 2005 and reporting services. Is there a way to run both of then. I'd like to have access to both for development purposes.
Thanks,
Just be sure to install in a different instance.
I am running both on same server. SQL 2005 instance is referenced by localhost\SQL2005 & http://localhost/reportserver$sql2005/
Virtual PC is a good option for this too.
There's a section in Books On Line called Working with Multiple versions of SQL Server that could help.|||Thanks I'll give it a shot

Run SQL2k SE 32-bit on 64-bit machine?

Is this possible? If so, are there any OS configurations that need to be se
t
ahead of time? When attempting to install, I am getting an error that says:
The image file autorun.exe is valid, but for a machine type other than the
current machine.
Thanks!Try running setup ipv autorun; autorun is likely a 16 bit app, which
will not run on x64.
Mitch wrote:
> Is this possible? If so, are there any OS configurations that need to be
set
> ahead of time? When attempting to install, I am getting an error that say
s:
> The image file autorun.exe is valid, but for a machine type other than the
> current machine.
> Thanks!

Run SQL2k SE 32-bit on 64-bit machine?

Is this possible? If so, are there any OS configurations that need to be set
ahead of time? When attempting to install, I am getting an error that says:
The image file autorun.exe is valid, but for a machine type other than the
current machine.
Thanks!Try running setup ipv autorun; autorun is likely a 16 bit app, which
will not run on x64.
Mitch wrote:
> Is this possible? If so, are there any OS configurations that need to be set
> ahead of time? When attempting to install, I am getting an error that says:
> The image file autorun.exe is valid, but for a machine type other than the
> current machine.
> Thanks!

Run SQL Server 7.0 in Windows 2003

Dear all,
Lately, we bought a new server to replace existing old one. After
installation of SQL7, we followed to install the service pack 4 into it.
During the installation, we found SQL7 didn't support in 2003. And we
continued the process until it finished. Is there any problem on using SQL7
in windows server 2003? Since we have some application supported in SQL7
only, we have to keep using SQL7. Anyone know there's any impact using SQL7
in windows 2003? Please help
Best Rdgs
EllisIs there a technical reason your applications can't use SQL Server 2000?
SQL Server 7.0 will run, it just won't be a supported configuration. So if
you run into a problem with *ANY* software on that box, and try to call MS
product support, they'll tell you good luck and have a nice day...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eI0hUG20EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> Lately, we bought a new server to replace existing old one. After
> installation of SQL7, we followed to install the service pack 4 into it.
> During the installation, we found SQL7 didn't support in 2003. And we
> continued the process until it finished. Is there any problem on using
SQL7
> in windows server 2003? Since we have some application supported in SQL7
> only, we have to keep using SQL7. Anyone know there's any impact using
SQL7
> in windows 2003? Please help
> Best Rdgs
> Ellis
>

Run SQL Server 7.0 in Windows 2003

Dear all,
Lately, we bought a new server to replace existing old one. After
installation of SQL7, we followed to install the service pack 4 into it.
During the installation, we found SQL7 didn't support in 2003. And we
continued the process until it finished. Is there any problem on using SQL7
in windows server 2003? Since we have some application supported in SQL7
only, we have to keep using SQL7. Anyone know there's any impact using SQL7
in windows 2003? Please help
Best Rdgs
Ellis
Is there a technical reason your applications can't use SQL Server 2000?
SQL Server 7.0 will run, it just won't be a supported configuration. So if
you run into a problem with *ANY* software on that box, and try to call MS
product support, they'll tell you good luck and have a nice day...
http://www.aspfaq.com/
(Reverse address to reply.)
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eI0hUG20EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> Lately, we bought a new server to replace existing old one. After
> installation of SQL7, we followed to install the service pack 4 into it.
> During the installation, we found SQL7 didn't support in 2003. And we
> continued the process until it finished. Is there any problem on using
SQL7
> in windows server 2003? Since we have some application supported in SQL7
> only, we have to keep using SQL7. Anyone know there's any impact using
SQL7
> in windows 2003? Please help
> Best Rdgs
> Ellis
>
|||Do you have a test environment where you could test the application as a SS 2K installation but running in 7.0 compatibility mode? I'd try it with a full blown upgrade but, if you run into problems, try again in the old 7.0 compatibility.
Sincerely,
Anthony Thomas

"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message news:OeIJSk20EHA.1204@.TK2MSFTNGP10.phx.gbl...
Is there a technical reason your applications can't use SQL Server 2000?
SQL Server 7.0 will run, it just won't be a supported configuration. So if
you run into a problem with *ANY* software on that box, and try to call MS
product support, they'll tell you good luck and have a nice day...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eI0hUG20EHA.1296@.TK2MSFTNGP10.phx.gbl...

> Dear all,
>
> Lately, we bought a new server to replace existing old one. After
> installation of SQL7, we followed to install the service pack 4 into it.
> During the installation, we found SQL7 didn't support in 2003. And we
> continued the process until it finished. Is there any problem on using

SQL7

> in windows server 2003? Since we have some application supported in SQL7
> only, we have to keep using SQL7. Anyone know there's any impact using

SQL7

> in windows 2003? Please help
>
> Best Rdgs
> Ellis
>
>

Run SQL Server 7.0 in Windows 2003

Dear all,
Lately, we bought a new server to replace existing old one. After
installation of SQL7, we followed to install the service pack 4 into it.
During the installation, we found SQL7 didn't support in 2003. And we
continued the process until it finished. Is there any problem on using SQL7
in windows server 2003? Since we have some application supported in SQL7
only, we have to keep using SQL7. Anyone know there's any impact using SQL7
in windows 2003? Please help
Best Rdgs
EllisIs there a technical reason your applications can't use SQL Server 2000?
SQL Server 7.0 will run, it just won't be a supported configuration. So if
you run into a problem with *ANY* software on that box, and try to call MS
product support, they'll tell you good luck and have a nice day...
http://www.aspfaq.com/
(Reverse address to reply.)
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eI0hUG20EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Dear all,
> Lately, we bought a new server to replace existing old one. After
> installation of SQL7, we followed to install the service pack 4 into it.
> During the installation, we found SQL7 didn't support in 2003. And we
> continued the process until it finished. Is there any problem on using
SQL7
> in windows server 2003? Since we have some application supported in SQL7
> only, we have to keep using SQL7. Anyone know there's any impact using
SQL7
> in windows 2003? Please help
> Best Rdgs
> Ellis
>|||Do you have a test environment where you could test the application as a SS
2K installation but running in 7.0 compatibility mode? I'd try it with a fu
ll blown upgrade but, if you run into problems, try again in the old 7.0 com
patibility.
Sincerely,
Anthony Thomas
--
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message new
s:OeIJSk20EHA.1204@.TK2MSFTNGP10.phx.gbl...
Is there a technical reason your applications can't use SQL Server 2000?
SQL Server 7.0 will run, it just won't be a supported configuration. So i
f
you run into a problem with *ANY* software on that box, and try to call MS
product support, they'll tell you good luck and have a nice day...
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ellis Yu" <ellis.yu@.transfield.com> wrote in message
news:eI0hUG20EHA.1296@.TK2MSFTNGP10.phx.gbl...
> Dear all,
>
> Lately, we bought a new server to replace existing old one. Afte
r
> installation of SQL7, we followed to install the service pack 4 into it.
> During the installation, we found SQL7 didn't support in 2003. And we
> continued the process until it finished. Is there any problem on using
SQL7
> in windows server 2003? Since we have some application supported in SQL7
> only, we have to keep using SQL7. Anyone know there's any impact using
SQL7
> in windows 2003? Please help
>
> Best Rdgs
> Ellis
>
>

Run simultaneously msde 2000 instance and one of 2005 express, possible?

Hi,
I got on my developer computer one instance of msde 2000. I want to test sql server express 2005, can I install it without "scrap" my other instance of 2000?

Strange question maybee, but it's what I wanna do!

Thanks all!

You can run these side by side as long as you give them different instances names.

Mike

|||Thanks Mike, I was waiting for an answer like that to launch the setup! :P

Bye

Run DTS packages

I have users who need to run DTS packages but I don't want to put the full
SQL toolset on their machine. Is there a way to just install the ability to
run a DTS package?Take a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtssql/dts_tools_other_8reb.asp
I think you can simply install client connectivity and dtsrun.exe... You
can even encrypt the connection information so they will not even know the
login stuff.
Also take a look at DTSRUNui...which will give your end user a little gui
interface to run packages.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark Polino" <mpolino@.earthlink.net> wrote in message
news:uifNMo9VEHA.3696@.TK2MSFTNGP10.phx.gbl...
> I have users who need to run DTS packages but I don't want to put the full
> SQL toolset on their machine. Is there a way to just install the ability
to
> run a DTS package?
>
>|||There are dts specific resource files as well as dlls that
need to be registered for users to be able to execute
packages. You can find the list of these in the following
article:
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?225
-Sue
On Mon, 21 Jun 2004 17:54:02 -0400, "Mark Polino"
<mpolino@.earthlink.net> wrote:
>I have users who need to run DTS packages but I don't want to put the full
>SQL toolset on their machine. Is there a way to just install the ability to
>run a DTS package?
>

Run DTS packages

I have users who need to run DTS packages but I don't want to put the full
SQL toolset on their machine. Is there a way to just install the ability to
run a DTS package?
Take a look at
http://msdn.microsoft.com/library/de...other_8reb.asp
I think you can simply install client connectivity and dtsrun.exe... You
can even encrypt the connection information so they will not even know the
login stuff.
Also take a look at DTSRUNui...which will give your end user a little gui
interface to run packages.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark Polino" <mpolino@.earthlink.net> wrote in message
news:uifNMo9VEHA.3696@.TK2MSFTNGP10.phx.gbl...
> I have users who need to run DTS packages but I don't want to put the full
> SQL toolset on their machine. Is there a way to just install the ability
to
> run a DTS package?
>
>
|||There are dts specific resource files as well as dlls that
need to be registered for users to be able to execute
packages. You can find the list of these in the following
article:
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?225
-Sue
On Mon, 21 Jun 2004 17:54:02 -0400, "Mark Polino"
<mpolino@.earthlink.net> wrote:

>I have users who need to run DTS packages but I don't want to put the full
>SQL toolset on their machine. Is there a way to just install the ability to
>run a DTS package?
>

Run DTS packages

I have users who need to run DTS packages but I don't want to put the full
SQL toolset on their machine. Is there a way to just install the ability to
run a DTS package?Take a look at
other_8reb.asp" target="_blank">http://msdn.microsoft.com/library/d...
other_8reb.asp
I think you can simply install client connectivity and dtsrun.exe... You
can even encrypt the connection information so they will not even know the
login stuff.
Also take a look at DTSRUNui...which will give your end user a little gui
interface to run packages.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mark Polino" <mpolino@.earthlink.net> wrote in message
news:uifNMo9VEHA.3696@.TK2MSFTNGP10.phx.gbl...
> I have users who need to run DTS packages but I don't want to put the full
> SQL toolset on their machine. Is there a way to just install the ability
to
> run a DTS package?
>
>|||There are dts specific resource files as well as dlls that
need to be registered for users to be able to execute
packages. You can find the list of these in the following
article:
Redistributing DTS with your program
http://www.sqldts.com/default.aspx?225
-Sue
On Mon, 21 Jun 2004 17:54:02 -0400, "Mark Polino"
<mpolino@.earthlink.net> wrote:

>I have users who need to run DTS packages but I don't want to put the full
>SQL toolset on their machine. Is there a way to just install the ability to
>run a DTS package?
>

RTM install order with VS2005 ?

With the RTM versions of SQL 2005 and VS 2005, does it matter which order they are installed in, or now that they are all on the same version of the .NET framework, does installation order no longer matter ?

Also, are there any issues/gotchas with installing SQL 2005 Developer edition and SQL 2005 Express from the VS2005 RTM on the same machine ?

During the betas, there were all sorts of hoops you had to jump through, and do things in certain orders, but with RTM will the standard installs of SQL 2005 Developer, VS 2005 and SQL 2005 Express all work regardless of install order ?

Thanks,
Andy Mackie.Order shouldn't matter at all any more, nor should there be any gotchas with the SxS scenario you describe.|||It shouldn't matter, but I stuck with the MS recommendations of VS2005 first - using a custom install so it did not install SQL Express - then SQL 2005 all up.
No problems at all
HTH,
Richard
|||Hello Richard,
I was wondering if you or anyone has had success installing VS2005 first, including Express Edition of SQL Server, and then installing the whole SQL Server on top of that. It seems to have problems installing the management tools - notably SQL Server Managemetn Studio - when I do it in that order.

What I'm really asking is if it's possible to install SSMS if you already have SQL Express 2005 installed?|||

Hi Robert,

I installed VS2005, but explicitly excluded SQL Express edition. I then did a full install of SQL Server 2005.

In theory I don't see why you should not be able to install JUST the client tools onto your machine, using the SQL server disks. I did an install a while back with no client tools on the server, then realised I needed to add them in. I was able to add them in OK.

I have a feeling that VS2005 puts it's own set of client tools on when you put Enterprise edition on, which may give you problems. Presumably you can Uninstall the EE components using the VS2005 disks, then put on SQL server?

Hope this helps,

Richard

RTM install order with VS2005 ?

With the RTM versions of SQL 2005 and VS 2005, does it matter which order they are installed in, or now that they are all on the same version of the .NET framework, does installation order no longer matter ?

Also, are there any issues/gotchas with installing SQL 2005 Developer edition and SQL 2005 Express from the VS2005 RTM on the same machine ?

During the betas, there were all sorts of hoops you had to jump through, and do things in certain orders, but with RTM will the standard installs of SQL 2005 Developer, VS 2005 and SQL 2005 Express all work regardless of install order ?

Thanks,
Andy Mackie.Order shouldn't matter at all any more, nor should there be any gotchas with the SxS scenario you describe.|||It shouldn't matter, but I stuck with the MS recommendations of VS2005 first - using a custom install so it did not install SQL Express - then SQL 2005 all up.
No problems at all
HTH,
Richard
|||Hello Richard,
I was wondering if you or anyone has had success installing VS2005 first, including Express Edition of SQL Server, and then installing the whole SQL Server on top of that. It seems to have problems installing the management tools - notably SQL Server Managemetn Studio - when I do it in that order.

What I'm really asking is if it's possible to install SSMS if you already have SQL Express 2005 installed?|||

Hi Robert,

I installed VS2005, but explicitly excluded SQL Express edition. I then did a full install of SQL Server 2005.

In theory I don't see why you should not be able to install JUST the client tools onto your machine, using the SQL server disks. I did an install a while back with no client tools on the server, then realised I needed to add them in. I was able to add them in OK.

I have a feeling that VS2005 puts it's own set of client tools on when you put Enterprise edition on, which may give you problems. Presumably you can Uninstall the EE components using the VS2005 disks, then put on SQL server?

Hope this helps,

Richard

RTM install order with VS2005 ?

With the RTM versions of SQL 2005 and VS 2005, does it matter which order they are installed in, or now that they are all on the same version of the .NET framework, does installation order no longer matter ?

Also, are there any issues/gotchas with installing SQL 2005 Developer edition and SQL 2005 Express from the VS2005 RTM on the same machine ?

During the betas, there were all sorts of hoops you had to jump through, and do things in certain orders, but with RTM will the standard installs of SQL 2005 Developer, VS 2005 and SQL 2005 Express all work regardless of install order ?

Thanks,
Andy Mackie.Order shouldn't matter at all any more, nor should there be any gotchas with the SxS scenario you describe.|||It shouldn't matter, but I stuck with the MS recommendations of VS2005 first - using a custom install so it did not install SQL Express - then SQL 2005 all up.
No problems at all
HTH,
Richard
|||Hello Richard,
I was wondering if you or anyone has had success installing VS2005 first, including Express Edition of SQL Server, and then installing the whole SQL Server on top of that. It seems to have problems installing the management tools - notably SQL Server Managemetn Studio - when I do it in that order.

What I'm really asking is if it's possible to install SSMS if you already have SQL Express 2005 installed?|||

Hi Robert,

I installed VS2005, but explicitly excluded SQL Express edition. I then did a full install of SQL Server 2005.

In theory I don't see why you should not be able to install JUST the client tools onto your machine, using the SQL server disks. I did an install a while back with no client tools on the server, then realised I needed to add them in. I was able to add them in OK.

I have a feeling that VS2005 puts it's own set of client tools on when you put Enterprise edition on, which may give you problems. Presumably you can Uninstall the EE components using the VS2005 disks, then put on SQL server?

Hope this helps,

Richard

RSWebParts.cab won't install on 64-bit server

Hi
This article
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
explains how to install Report servicess WebPart for Sharepoint.
I write reports to be posted on sharepoint - using SQL Reportig Services.
However I am getting command line error when executing properly stsadm.exe.
I tried hundreds of times checking the syntax and it's 100% correct
so why there's an error. The server OS is 64-bit Windows Storage Server
I am using MS SQL Business Inteligence Dev Studio for SQL 2005.
Thanks for help
aspcoder64 bit windows storage server?
is that supported?
-Aaron
aspcoder wrote:
> Hi
> This article
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
> explains how to install Report servicess WebPart for Sharepoint.
> I write reports to be posted on sharepoint - using SQL Reportig Services.
> However I am getting command line error when executing properly stsadm.exe.
> I tried hundreds of times checking the syntax and it's 100% correct
> so why there's an error. The server OS is 64-bit Windows Storage Server
> I am using MS SQL Business Inteligence Dev Studio for SQL 2005.
> Thanks for help
> aspcoder

RSWebParts.cab install and Command Line Error

Hi all,
I have SQL Server 2005 installed on one server and WSS 3.0 installed
on another server. I would like to install the reporting services wbe
parts (RSWebParts.cab) to my WSS Server. I have copied the file across
and am using the following command:
:: ***********PARAMS***********
:: stsadm tool
SET STSADMTOOL="C:\Program Files\Common Files\Microsoft Shared\web
server extensions\12\bin\stsadm.exe"
GOTO STOP
:STOP
%STSADMTOOL% -help addwppack
pause;
echo using STSADMTOOL at %STSADMTOOL%
%STSADMTOOL% -o addwppack -force -filename C:\ReportingServices
\RSWebParts.cab
When I run it I get a Command Line Error and it points me in the
direction of stsadm help. I can guarantee you the files are in the
correct location as per the parameters passed in and that I am a local
admin on the server.
This is driving me nuts, can anybody help asap?
Cheers
JimskiI have the same problem.  I am losing faith in Microsoft.  Have you ever found a solution?