32-64 bit versions issue

I uninstalled the 32-bit Standard version but during install of the 64-bit trial version I got an error that the integration services could not install because the 32-bit version of COM+ was already registered and you can't have both. Need some help how to resolve this issue. Thanks

I suspect there is a conflict, I always format partitions and reload from a Ghost backup when trying stuff out. Might need to check to see where the 32-bit version installed some extras that did not get removed with uninstall.

I document every step when I set up a machine, so I can learn from problems and how to avoid them in the future.

|||OK, make sense. Now, how to fix it? Manually unregister? Thanks|||That might work, but I found it was more expedient making a hard disk full of backups and being able to roll back has so many advantages.

2005 Reporting Services - Trial version

Where can I get a trial/evaluation version of Sql Server 2005 Reporting Services?

I assumed it's not included in the SQL Server 2005 installation.

Thanks,Yes, it is included in the SQL Server 2005 Evaluation Edition. With 2005, there is a single setup for both RS and the relational database (as well as AS and IS).

2005 express elements?

hey there
can someone pls confirm whether 2005 express (the free version, not the
trial version) comes with all the usual stuff that i know from sql2000? i
need all the usual stuff, dts, em, query analyzer etc...
thanks!It's not the same as 2000 and has different options. Have a look here:
http://www.microsoft.com/sql/editions/express/default.mspx
Andrew J. Kelly SQL MVP
"moishie" <moishie@.discussions.microsoft.com> wrote in message
news:6B2B17A6-5D3C-44A3-B355-CE71B258107D@.microsoft.com...
> hey there
> can someone pls confirm whether 2005 express (the free version, not the
> trial version) comes with all the usual stuff that i know from sql2000? i
> need all the usual stuff, dts, em, query analyzer etc...
> thanks!|||Thank you!
"Andrew J. Kelly" wrote:
> It's not the same as 2000 and has different options. Have a look here:
> http://www.microsoft.com/sql/editions/express/default.mspx
>
> --
> Andrew J. Kelly SQL MVP
> "moishie" <moishie@.discussions.microsoft.com> wrote in message
> news:6B2B17A6-5D3C-44A3-B355-CE71B258107D@.microsoft.com...
> > hey there
> >
> > can someone pls confirm whether 2005 express (the free version, not the
> > trial version) comes with all the usual stuff that i know from sql2000? i
> > need all the usual stuff, dts, em, query analyzer etc...
> >
> > thanks!
>
>

2005 Enterprise Trial to 2005 Standard Edition

We want to licence a trail version 2005 Enterprise with an full version of MS Sql server 2005 standard. Is this possible?

Yes, it will require an uninstall and reinstall of SQL Server 2005 however.

After the install you will need to attach your user databases and recreate your logins.

2005 Enterprise Edition Upgrade to Developer Edition ?

I installed the Enterprise Edition Trial, which expired two days ago. I
need to know how to upgrade Enterprise Ediction to Developer Edition.
I appreciate any help. The expired EE won't even allow you to open
Management Studio to do an up-to-date backup. I have my most recent
changes on another system, but want to check to see if there is
anything else on the system with EE that I want to keep.
Ideas?I discovered that the database files can be recovered using attach on
another system. Still, there is no apparent upgrade option to allow you
to simply enter your purchased package software key to validate this
upgrade.

2005 Enterprise Edition Upgrade to Developer Edition ?

I installed the Enterprise Edition Trial, which expired two days ago. I
need to know how to upgrade Enterprise Ediction to Developer Edition.
I appreciate any help. The expired EE won't even allow you to open
Management Studio to do an up-to-date backup. I have my most recent
changes on another system, but want to check to see if there is
anything else on the system with EE that I want to keep.
Ideas?I discovered that the database files can be recovered using attach on
another system. Still, there is no apparent upgrade option to allow you
to simply enter your purchased package software key to validate this
upgrade.

2005 dts package question

Hi I am working with the trial ms2005 SQL Server measurement studio. I could
not find how to create and schedule a DTS package, guess this is done with
Enterprise Manager with mssql2000. JUst wondering if someone could point me
in the right direction, thanks.
Paul G
Software engineer.
SQL Server Integration Services (SSIS) is the replacement
for DTS in SQL Server 2005. You create SSIS packages using
the Business Intelligence Development Studio. That's where
you find the designer you are used to in 2000.
To schedule the package, create a job and for the step type,
use SQL Server Integration Services Package.
There are How To help topics in books online that give step
by step instructions on how to do this.
For creating packages, refer to:
How To: Create a Package Using SSIS Designer
For scheduling as a job, refer to:
How To: Run a Package Using a SQL Server Agent Job
There are many other How To topics for SSIS. Open up books
online and you will see a How Do I button on the tool bar.
Select that and chose SQL Server Integration Services.
There is also a decent tutorial on using SSIS. From the help
contents, go to SQL Server Tutorials node. Select
Integration Services Tutorials.
You can also find information on SSIS at:
http://www.sqlis.com/
-Sue
On Fri, 17 Mar 2006 12:45:27 -0800, Paul
<Paul@.discussions.microsoft.com> wrote:

>Hi I am working with the trial ms2005 SQL Server measurement studio. I could
>not find how to create and schedule a DTS package, guess this is done with
>Enterprise Manager with mssql2000. JUst wondering if someone could point me
>in the right direction, thanks.
|||they destroyed DTS. and replaced it with a very complicated software called
Integration Services.
Just so you know, you had 4 steps to create an import from a text file. now
you will have no less than 12 steps to do the same. It sucks but what
there's nothing we can do about it.
d.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> Hi I am working with the trial ms2005 SQL Server measurement studio. I
could
> not find how to create and schedule a DTS package, guess this is done with
> Enterprise Manager with mssql2000. JUst wondering if someone could point
me
> in the right direction, thanks.
> --
> Paul G
> Software engineer.
|||Ok thanks for the information, will take a look at it.
Paul G
Software engineer.
"Sue Hoegemeier" wrote:

> SQL Server Integration Services (SSIS) is the replacement
> for DTS in SQL Server 2005. You create SSIS packages using
> the Business Intelligence Development Studio. That's where
> you find the designer you are used to in 2000.
> To schedule the package, create a job and for the step type,
> use SQL Server Integration Services Package.
> There are How To help topics in books online that give step
> by step instructions on how to do this.
> For creating packages, refer to:
> How To: Create a Package Using SSIS Designer
> For scheduling as a job, refer to:
> How To: Run a Package Using a SQL Server Agent Job
> There are many other How To topics for SSIS. Open up books
> online and you will see a How Do I button on the tool bar.
> Select that and chose SQL Server Integration Services.
> There is also a decent tutorial on using SSIS. From the help
> contents, go to SQL Server Tutorials node. Select
> Integration Services Tutorials.
> You can also find information on SSIS at:
> http://www.sqlis.com/
> -Sue
> On Fri, 17 Mar 2006 12:45:27 -0800, Paul
> <Paul@.discussions.microsoft.com> wrote:
>
>
|||ok thanks for the information. I like the way the DTS packages can be easily
designed and scheduled with 2000 Enterprise manager, hopefully these extra
steps will be straight forward (no to difficult or complicated to remember).
Paul G
Software engineer.
"d" wrote:

> they destroyed DTS. and replaced it with a very complicated software called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file. now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>
>
|||Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"d" <d@.d.com> wrote in message news:kAZSf.1312$I7.999@.trnddc03...
> they destroyed DTS. and replaced it with a very complicated software
> called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file.
> now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>
|||<quote>
Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
</quote>
You can actually still do this. (Took me a little while to find it.)
You just need to right click on the database name and then select Tasks.
Import and Export are options under that. There is also an option to
save the SSIS package.
Hope this helps,
Matt
*** Sent via Developersdex http://www.codecomments.com ***

2005 dts package question

Hi I am working with the trial ms2005 SQL Server measurement studio. I could
not find how to create and schedule a DTS package, guess this is done with
Enterprise Manager with mssql2000. JUst wondering if someone could point me
in the right direction, thanks.
--
Paul G
Software engineer.SQL Server Integration Services (SSIS) is the replacement
for DTS in SQL Server 2005. You create SSIS packages using
the Business Intelligence Development Studio. That's where
you find the designer you are used to in 2000.
To schedule the package, create a job and for the step type,
use SQL Server Integration Services Package.
There are How To help topics in books online that give step
by step instructions on how to do this.
For creating packages, refer to:
How To: Create a Package Using SSIS Designer
For scheduling as a job, refer to:
How To: Run a Package Using a SQL Server Agent Job
There are many other How To topics for SSIS. Open up books
online and you will see a How Do I button on the tool bar.
Select that and chose SQL Server Integration Services.
There is also a decent tutorial on using SSIS. From the help
contents, go to SQL Server Tutorials node. Select
Integration Services Tutorials.
You can also find information on SSIS at:
http://www.sqlis.com/
-Sue
On Fri, 17 Mar 2006 12:45:27 -0800, Paul
<Paul@.discussions.microsoft.com> wrote:
>Hi I am working with the trial ms2005 SQL Server measurement studio. I could
>not find how to create and schedule a DTS package, guess this is done with
>Enterprise Manager with mssql2000. JUst wondering if someone could point me
>in the right direction, thanks.|||they destroyed DTS. and replaced it with a very complicated software called
Integration Services.
Just so you know, you had 4 steps to create an import from a text file. now
you will have no less than 12 steps to do the same. It sucks but what
there's nothing we can do about it.
d.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> Hi I am working with the trial ms2005 SQL Server measurement studio. I
could
> not find how to create and schedule a DTS package, guess this is done with
> Enterprise Manager with mssql2000. JUst wondering if someone could point
me
> in the right direction, thanks.
> --
> Paul G
> Software engineer.|||Ok thanks for the information, will take a look at it.
--
Paul G
Software engineer.
"Sue Hoegemeier" wrote:
> SQL Server Integration Services (SSIS) is the replacement
> for DTS in SQL Server 2005. You create SSIS packages using
> the Business Intelligence Development Studio. That's where
> you find the designer you are used to in 2000.
> To schedule the package, create a job and for the step type,
> use SQL Server Integration Services Package.
> There are How To help topics in books online that give step
> by step instructions on how to do this.
> For creating packages, refer to:
> How To: Create a Package Using SSIS Designer
> For scheduling as a job, refer to:
> How To: Run a Package Using a SQL Server Agent Job
> There are many other How To topics for SSIS. Open up books
> online and you will see a How Do I button on the tool bar.
> Select that and chose SQL Server Integration Services.
> There is also a decent tutorial on using SSIS. From the help
> contents, go to SQL Server Tutorials node. Select
> Integration Services Tutorials.
> You can also find information on SSIS at:
> http://www.sqlis.com/
> -Sue
> On Fri, 17 Mar 2006 12:45:27 -0800, Paul
> <Paul@.discussions.microsoft.com> wrote:
> >Hi I am working with the trial ms2005 SQL Server measurement studio. I could
> >not find how to create and schedule a DTS package, guess this is done with
> >Enterprise Manager with mssql2000. JUst wondering if someone could point me
> >in the right direction, thanks.
>|||ok thanks for the information. I like the way the DTS packages can be easily
designed and scheduled with 2000 Enterprise manager, hopefully these extra
steps will be straight forward (no to difficult or complicated to remember).
--
Paul G
Software engineer.
"d" wrote:
> they destroyed DTS. and replaced it with a very complicated software called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file. now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> > Hi I am working with the trial ms2005 SQL Server measurement studio. I
> could
> > not find how to create and schedule a DTS package, guess this is done with
> > Enterprise Manager with mssql2000. JUst wondering if someone could point
> me
> > in the right direction, thanks.
> > --
> > Paul G
> > Software engineer.
>
>|||Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"d" <d@.d.com> wrote in message news:kAZSf.1312$I7.999@.trnddc03...
> they destroyed DTS. and replaced it with a very complicated software
> called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file.
> now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
>> Hi I am working with the trial ms2005 SQL Server measurement studio. I
> could
>> not find how to create and schedule a DTS package, guess this is done
>> with
>> Enterprise Manager with mssql2000. JUst wondering if someone could point
> me
>> in the right direction, thanks.
>> --
>> Paul G
>> Software engineer.
>

2005 dts package question

Hi I am working with the trial ms2005 SQL Server measurement studio. I coul
d
not find how to create and schedule a DTS package, guess this is done with
Enterprise Manager with mssql2000. JUst wondering if someone could point me
in the right direction, thanks.
--
Paul G
Software engineer.SQL Server Integration Services (SSIS) is the replacement
for DTS in SQL Server 2005. You create SSIS packages using
the Business Intelligence Development Studio. That's where
you find the designer you are used to in 2000.
To schedule the package, create a job and for the step type,
use SQL Server Integration Services Package.
There are How To help topics in books online that give step
by step instructions on how to do this.
For creating packages, refer to:
How To: Create a Package Using SSIS Designer
For scheduling as a job, refer to:
How To: Run a Package Using a SQL Server Agent Job
There are many other How To topics for SSIS. Open up books
online and you will see a How Do I button on the tool bar.
Select that and chose SQL Server Integration Services.
There is also a decent tutorial on using SSIS. From the help
contents, go to SQL Server Tutorials node. Select
Integration Services Tutorials.
You can also find information on SSIS at:
http://www.sqlis.com/
-Sue
On Fri, 17 Mar 2006 12:45:27 -0800, Paul
<Paul@.discussions.microsoft.com> wrote:

>Hi I am working with the trial ms2005 SQL Server measurement studio. I cou
ld
>not find how to create and schedule a DTS package, guess this is done with
>Enterprise Manager with mssql2000. JUst wondering if someone could point m
e
>in the right direction, thanks.|||they destroyed DTS. and replaced it with a very complicated software called
Integration Services.
Just so you know, you had 4 steps to create an import from a text file. now
you will have no less than 12 steps to do the same. It sucks but what
there's nothing we can do about it.
d.
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> Hi I am working with the trial ms2005 SQL Server measurement studio. I
could
> not find how to create and schedule a DTS package, guess this is done with
> Enterprise Manager with mssql2000. JUst wondering if someone could point
me
> in the right direction, thanks.
> --
> Paul G
> Software engineer.|||Ok thanks for the information, will take a look at it.
--
Paul G
Software engineer.
"Sue Hoegemeier" wrote:

> SQL Server Integration Services (SSIS) is the replacement
> for DTS in SQL Server 2005. You create SSIS packages using
> the Business Intelligence Development Studio. That's where
> you find the designer you are used to in 2000.
> To schedule the package, create a job and for the step type,
> use SQL Server Integration Services Package.
> There are How To help topics in books online that give step
> by step instructions on how to do this.
> For creating packages, refer to:
> How To: Create a Package Using SSIS Designer
> For scheduling as a job, refer to:
> How To: Run a Package Using a SQL Server Agent Job
> There are many other How To topics for SSIS. Open up books
> online and you will see a How Do I button on the tool bar.
> Select that and chose SQL Server Integration Services.
> There is also a decent tutorial on using SSIS. From the help
> contents, go to SQL Server Tutorials node. Select
> Integration Services Tutorials.
> You can also find information on SSIS at:
> http://www.sqlis.com/
> -Sue
> On Fri, 17 Mar 2006 12:45:27 -0800, Paul
> <Paul@.discussions.microsoft.com> wrote:
>
>|||ok thanks for the information. I like the way the DTS packages can be easil
y
designed and scheduled with 2000 Enterprise manager, hopefully these extra
steps will be straight forward (no to difficult or complicated to remember).
--
Paul G
Software engineer.
"d" wrote:

> they destroyed DTS. and replaced it with a very complicated software calle
d
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file. no
w
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>
>|||Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"d" <d@.d.com> wrote in message news:kAZSf.1312$I7.999@.trnddc03...
> they destroyed DTS. and replaced it with a very complicated software
> called
> Integration Services.
> Just so you know, you had 4 steps to create an import from a text file.
> now
> you will have no less than 12 steps to do the same. It sucks but what
> there's nothing we can do about it.
> d.
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:9C9124A5-E6E5-46AD-83D2-A373423CC225@.microsoft.com...
> could
> me
>|||<quote>
Yeah,
I'm going to miss right clicking on a database in EM and choosing
"export/import data..." to fire up the DTS Wizard.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
</quote>
You can actually still do this. (Took me a little while to find it.)
You just need to right click on the database name and then select Tasks.
Import and Export are options under that. There is also an option to
save the SSIS package.
Hope this helps,
Matt
*** Sent via Developersdex http://www.codecomments.com ***