2005 to 2005 cluster

Hi,

is it possible simply restore db(s) and copy SSIS packages and legacy DTS from

server running sql 2005 to sql2005 running cluster ?

Since our cluster configuration not ready ,we plan migrate production to sql2005 stand alone server and few month later move -copy everything from this server to cluster.

Thanks

Yes, you can do it as you imaged. What you may notice is you have to restore the database into a cluster disk drive (cluster resources).

2005 restored msdb, cant see SSIS packages ?

We recently rebuilt a dev server, and as part of that process, I restored
msdb (successfully) from backup.
But now I can't see any SSIS packages from Management Studio !
If I run this query ->
use msdb
select *
from sysdtspackages90
then I can see them all !
How do I get Management Studio to see them as well ?
TIAHi Jim
My guess this is possibly related to ownership. Did you restore the master
database as well?
John
"Jim Trowbridge" wrote:
> We recently rebuilt a dev server, and as part of that process, I restored
> msdb (successfully) from backup.
> But now I can't see any SSIS packages from Management Studio !
> If I run this query ->
> use msdb
> select *
> from sysdtspackages90
> then I can see them all !
> How do I get Management Studio to see them as well ?
> TIA|||John,
I didn't restore master. It turned out to be a problem with the registry
setting that points to the (cluster resource copy of the ) MsDtsSrvr.ini.xml
file had the wrong address. Thats why the tree didn't even have the usual
File System and MSDB sub-tree entries.
Once that registry setting was fixed and the Integration Services service
was bounced, everything behaved properly.
"John Bell" wrote:
> Hi Jim
> My guess this is possibly related to ownership. Did you restore the master
> database as well?
> John
> "Jim Trowbridge" wrote:
> > We recently rebuilt a dev server, and as part of that process, I restored
> > msdb (successfully) from backup.
> > But now I can't see any SSIS packages from Management Studio !
> > If I run this query ->
> > use msdb
> > select *
> > from sysdtspackages90
> > then I can see them all !
> >
> > How do I get Management Studio to see them as well ?
> > TIA|||Hi Jim
Thanks for the information, it's good to know you found the solution.
John
"Jim Trowbridge" wrote:
> John,
> I didn't restore master. It turned out to be a problem with the registry
> setting that points to the (cluster resource copy of the ) MsDtsSrvr.ini.xml
> file had the wrong address. Thats why the tree didn't even have the usual
> File System and MSDB sub-tree entries.
> Once that registry setting was fixed and the Integration Services service
> was bounced, everything behaved properly.
> "John Bell" wrote:
> > Hi Jim
> >
> > My guess this is possibly related to ownership. Did you restore the master
> > database as well?
> >
> > John
> >
> > "Jim Trowbridge" wrote:
> >
> > > We recently rebuilt a dev server, and as part of that process, I restored
> > > msdb (successfully) from backup.
> > > But now I can't see any SSIS packages from Management Studio !
> > > If I run this query ->
> > > use msdb
> > > select *
> > > from sysdtspackages90
> > > then I can see them all !
> > >
> > > How do I get Management Studio to see them as well ?
> > > TIA

2005 Express / DTS equivalent

This ought to be a real simple question. I've been creating DTS packages in 2000 Standard under Enterprise Manager. I've downloaded 2005 Express and I don't see any way to do DTS-like stuff (now called SSIS) with this edition. Is this correct or have I missed something?

This is correct. SSIS is not included with SQL Server Express.

-Jamie

2005 CTP Connection error

When I try to connect to the 2005 CTP SQL server in any of the VBexpress software packages I get the gfollowing error
user instance login flag not supported in this version of SQL
I am not sure what to check or what I may have missed in the SQL server setupThe User Instance flag is only supported in the express SKU, are you connected to Express or another version of SQL Server? You can check by running select @.@.version

-Euan|||I am trying to connect to the sql 2005 version CTP [not the express version]|||All versions(SKUs) are part of CTP.

But if you are convinced that you are not connecting to express then this is the problem you need to remove the User Instance from the connection string.

-Euan|||Yes I am sure I am using the non-express version. However, to connect I am using the wizards that come with the Visual Studio Express products...I hate be sound ignorant but this is not my area of expertise...how do I remove that user instance from the wizard?
and from the the SQL server management studio It tell me SQL Server 9.0.1187|||Actually I saw in the advanced area where to change that. But if I do I get this message
"Unable to open Phycical file...The process cannot access the file because is it in use by another process..."|||SQL Server 9.0.1187|||Ah ok there is another setting that is used by express that you need to remove and thats the AttachDBFilename.

I suspect you you selected in the Wizard to connect to database file, try connecting the database instead.

-Euan|||I would lvoe to but the only connection options I have are
Microsoft Access Databse File
Microsoft SQL server Database File|||

I had the same problem and it was solved choosing the appropriate MDF file to the field "AttachDBFileNAme" and inserting the logical name of DB (the name that appears on SQL Server Man. Studio) in the field "InitialCatalog".

No other configurations were needed on SQL Server

2005 CTP Connection error

When I try to connect to the 2005 CTP SQL server in any of the VBexpress software packages I get the gfollowing error
user instance login flag not supported in this version of SQL
I am not sure what to check or what I may have missed in the SQL server setupThe User Instance flag is only supported in the express SKU, are you connected to Express or another version of SQL Server? You can check by running select @.@.version

-Euan|||I am trying to connect to the sql 2005 version CTP [not the express version]|||All versions(SKUs) are part of CTP.

But if you are convinced that you are not connecting to express then this is the problem you need to remove the User Instance from the connection string.

-Euan|||Yes I am sure I am using the non-express version. However, to connect I am using the wizards that come with the Visual Studio Express products...I hate be sound ignorant but this is not my area of expertise...how do I remove that user instance from the wizard?
and from the the SQL server management studio It tell me SQL Server 9.0.1187|||Actually I saw in the advanced area where to change that. But if I do I get this message
"Unable to open Phycical file...The process cannot access the file because is it in use by another process..."|||SQL Server 9.0.1187|||Ah ok there is another setting that is used by express that you need to remove and thats the AttachDBFilename.

I suspect you you selected in the Wizard to connect to database file, try connecting the database instead.

-Euan|||I would lvoe to but the only connection options I have are
Microsoft Access Databse File
Microsoft SQL server Database File|||

I had the same problem and it was solved choosing the appropriate MDF file to the field "AttachDBFileNAme" and inserting the logical name of DB (the name that appears on SQL Server Man. Studio) in the field "InitialCatalog".

No other configurations were needed on SQL Server

2005 and Packages?

I was just curious, in the new features of SS2K5, is there anything
which will be akin to Oracle's concept of Packages? allowing to
group related code together into a single object?
Thanks in advance,
- Arthur DentNo, nothing like that.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:u$7T4cdnFHA.3312@.TK2MSFTNGP12.phx.gbl...
>I was just curious, in the new features of SS2K5, is there anything
> which will be akin to Oracle's concept of Packages? allowing to
> group related code together into a single object?
> Thanks in advance,
> - Arthur Dent
>|||Thats too bad... helps keep the database code a lot more organized.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:ekYcdKfnFHA.2916@.TK2MSFTNGP14.phx.gbl...
> No, nothing like that.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
> news:u$7T4cdnFHA.3312@.TK2MSFTNGP12.phx.gbl...
>