Need Assistance: Trying to run jobs and getting nowhere/SQLServerAgent

I've gone through hundreds of posts here and on the Net. I'm creating an ssis package to access my db on my desktop. I then save a copy as "Test" on the msdb database on our sql 2005 box.

Try to create a job and I'm getting nowhere. My SQL Server Agent account is a member of local Administrator group and a member of the domain.

Now what I noticed is if I run the dtsexec from the command prompt and use the command line string then it works. Just seems like I'm not able to run anything from the SQL Server>>Jobs interface.

Please Help :)

What errors do you get? Have you seen http://support.microsoft.com/kb/918760?|||

I have it working with the set password but I'd like not to do this in case other developers create packages and then forget. I'd like to use the below method but how do you do this --> "SQL Server Agent run the job as the account that created the package or as an account that has the required permissions.
"

Method 1: Use a SQL Server Agent proxy account

Create a SQL Server Agent proxy account. This proxy account must use a credential that lets SQL Server Agent run the job as the account that created the package or as an account that has the required permissions.

This method works to decrypt secrets and satisfies the key requirements by user. However, this method may have limited success because the SSIS package user keys involve the current user and the current computer. Therefore, if you move the package to another computer, this method may still fail, even if the job step uses the correct proxy account.

|||Books online have topic Creating SQL Server Agent Proxies under Administering the Database Engine > Automating Administrative Tasks (SQL Server Agent) > Implementing SQL Server Agent Security >

Need Assistance: Trying to run jobs and getting nowhere/SQLServerAgent

I've gone through hundreds of posts here and on the Net. I'm creating an ssis package to access my db on my desktop. I then save a copy as "Test" on the msdb database on our sql 2005 box.

Try to create a job and I'm getting nowhere. My SQL Server Agent account is a member of local Administrator group and a member of the domain.

Now what I noticed is if I run the dtsexec from the command prompt and use the command line string then it works. Just seems like I'm not able to run anything from the SQL Server>>Jobs interface.

Please Help :)

What errors do you get? Have you seen http://support.microsoft.com/kb/918760?|||

I have it working with the set password but I'd like not to do this in case other developers create packages and then forget. I'd like to use the below method but how do you do this --> "SQL Server Agent run the job as the account that created the package or as an account that has the required permissions.
"

Method 1: Use a SQL Server Agent proxy account

Create a SQL Server Agent proxy account. This proxy account must use a credential that lets SQL Server Agent run the job as the account that created the package or as an account that has the required permissions.

This method works to decrypt secrets and satisfies the key requirements by user. However, this method may have limited success because the SSIS package user keys involve the current user and the current computer. Therefore, if you move the package to another computer, this method may still fail, even if the job step uses the correct proxy account.

|||Books online have topicCreating SQL Server Agent Proxies under Administering the Database Engine > Automating Administrative Tasks (SQL Server Agent) > Implementing SQL Server Agent Security >

NDF and MDF data backup

Our server crashed. I was able to boot up in safe mode and copy the data
onto an external USB harddrive, all except our MDF file - i was able to
copy the 9 other NDF files and the LDF file. Our MDF file has very
little of our data, but i know it has SQL information in it.
What are my options on a restore? Can i create a new DB on the new HD
(which will create all NDF, LDF, and MDF), and then stop SQL, copy the
NDF and LDF from our USB drive, and then start up SQL again, and will
that work?
Remember, the files are just copied, not any kind of SQL backup.
TIA
Darin
*** Sent via Developersdex http://www.codecomments.com ***As far as I know you have any luck to get your database back using only ldf
and ndf files.
Are you sure you do not have a backup of your database anywhere in the
cabinets in your room, hmm?
You didn't mention what kind of a crash it is, however have you tried some
kind of File Recovery software to try to recover that mdf file?
I hope another friend of mine here has to say something to recover it...
Ekrem nsoy
"Darin" <darin_nospam@.nospamever> wrote in message
news:%23YFrJRiIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> Our server crashed. I was able to boot up in safe mode and copy the data
> onto an external USB harddrive, all except our MDF file - i was able to
> copy the 9 other NDF files and the LDF file. Our MDF file has very
> little of our data, but i know it has SQL information in it.
> What are my options on a restore? Can i create a new DB on the new HD
> (which will create all NDF, LDF, and MDF), and then stop SQL, copy the
> NDF and LDF from our USB drive, and then start up SQL again, and will
> that work?
> Remember, the files are just copied, not any kind of SQL backup.
> TIA
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***|||we do have a backup, but it is to a DAT drive that this other server
doesn't have a drive on. I am getting a new HD to put in the original
server, where that HD crashed, just trying to get up and running now.
I do have a backup of older data (MDF, NDF, and LDF) on my machine and i
tried to do what i wanted and couldn't get it to work. After creating
the new database, and then coping over the old MDF, when i restarted
MSSQLSERVER, the enterprise manager showed the database, but there isn't
a + sign next to it, so there are tables, views, etc. strange.
Darin
*** Sent via Developersdex http://www.codecomments.com ***|||>. After creating
> the new database, and then coping over the old MDF, when i restarted
> MSSQLSERVER, the enterprise manager showed the database, but there isn't
> a + sign next to it, so there are tables, views, etc. strange.
If you have the mdf, ndf and ldf files, you can try to do an "attach". More
info: http://msdn2.microsoft.com/en-us/library/ms190209.aspx
/Sjang|||that is my problem, i don't have the MDF. I created a new DB and tried
to copy just the NDF and LDF and keep the new MDF and attach the DB and
it didn't work.
I have a new HD and will hopefully be able to restore from the tape
backup.
Darin
*** Sent via Developersdex http://www.codecomments.com ***|||My guess is that the master db is in your .mdf file. Without that, you're
kinda toast.
"Darin" <darin_nospam@.nospamever> wrote in message
news:usJ7KgkIIHA.4296@.TK2MSFTNGP04.phx.gbl...
> that is my problem, i don't have the MDF. I created a new DB and tried
> to copy just the NDF and LDF and keep the new MDF and attach the DB and
> it didn't work.
> I have a new HD and will hopefully be able to restore from the tape
> backup.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***|||Yes, the mdf is the primary database file, the "root" file for the database.
It contains references
to all other database files.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospam@.nospam.org> wrote in message news:%23$bwV7kIIHA.588@.TK2MSFTNGP05.phx.gbl...[vb
col=seagreen]
> My guess is that the master db is in your .mdf file. Without that, you're
kinda toast.
> "Darin" <darin_nospam@.nospamever> wrote in message news:usJ7KgkIIHA.4296@.T
K2MSFTNGP04.phx.gbl...
>[/vbcol]|||In a message of yours you have MDF file of your database and in another you
say you do not have it.
Creating a database from scratch and copying your other databases NDF and
LDF files and using the new database's MDF file would not work. It doesn't
work like that. You need the MDF file of your original database. If not,
then you have to use your backup to restore your database.
Ekrem nsoy
"Darin" <darin_nospam@.nospamever> wrote in message
news:usJ7KgkIIHA.4296@.TK2MSFTNGP04.phx.gbl...
> that is my problem, i don't have the MDF. I created a new DB and tried
> to copy just the NDF and LDF and keep the new MDF and attach the DB and
> it didn't work.
> I have a new HD and will hopefully be able to restore from the tape
> backup.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***

NDF and MDF data backup

Our server crashed. I was able to boot up in safe mode and copy the data
onto an external USB harddrive, all except our MDF file - i was able to
copy the 9 other NDF files and the LDF file. Our MDF file has very
little of our data, but i know it has SQL information in it.
What are my options on a restore? Can i create a new DB on the new HD
(which will create all NDF, LDF, and MDF), and then stop SQL, copy the
NDF and LDF from our USB drive, and then start up SQL again, and will
that work?
Remember, the files are just copied, not any kind of SQL backup.
TIA
Darin
*** Sent via Developersdex http://www.developersdex.com ***As far as I know you have any luck to get your database back using only ldf
and ndf files.
Are you sure you do not have a backup of your database anywhere in the
cabinets in your room, hmm?
You didn't mention what kind of a crash it is, however have you tried some
kind of File Recovery software to try to recover that mdf file?
I hope another friend of mine here has to say something to recover it...
--
Ekrem Önsoy
"Darin" <darin_nospam@.nospamever> wrote in message
news:%23YFrJRiIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> Our server crashed. I was able to boot up in safe mode and copy the data
> onto an external USB harddrive, all except our MDF file - i was able to
> copy the 9 other NDF files and the LDF file. Our MDF file has very
> little of our data, but i know it has SQL information in it.
> What are my options on a restore? Can i create a new DB on the new HD
> (which will create all NDF, LDF, and MDF), and then stop SQL, copy the
> NDF and LDF from our USB drive, and then start up SQL again, and will
> that work?
> Remember, the files are just copied, not any kind of SQL backup.
> TIA
> Darin
> *** Sent via Developersdex http://www.developersdex.com ***

NDF and MDF data backup

that is my problem, i don't have the MDF. I created a new DB and tried
to copy just the NDF and LDF and keep the new MDF and attach the DB and
it didn't work.
I have a new HD and will hopefully be able to restore from the tape
backup.
Darin
*** Sent via Developersdex http://www.codecomments.com ***
My guess is that the master db is in your .mdf file. Without that, you're
kinda toast.
"Darin" <darin_nospam@.nospamever> wrote in message
news:usJ7KgkIIHA.4296@.TK2MSFTNGP04.phx.gbl...
> that is my problem, i don't have the MDF. I created a new DB and tried
> to copy just the NDF and LDF and keep the new MDF and attach the DB and
> it didn't work.
> I have a new HD and will hopefully be able to restore from the tape
> backup.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
|||In a message of yours you have MDF file of your database and in another you
say you do not have it.
Creating a database from scratch and copying your other databases NDF and
LDF files and using the new database's MDF file would not work. It doesn't
work like that. You need the MDF file of your original database. If not,
then you have to use your backup to restore your database.
Ekrem nsoy
"Darin" <darin_nospam@.nospamever> wrote in message
news:usJ7KgkIIHA.4296@.TK2MSFTNGP04.phx.gbl...
> that is my problem, i don't have the MDF. I created a new DB and tried
> to copy just the NDF and LDF and keep the new MDF and attach the DB and
> it didn't work.
> I have a new HD and will hopefully be able to restore from the tape
> backup.
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***

NDF and MDF data backup

Our server crashed. I was able to boot up in safe mode and copy the data
onto an external USB harddrive, all except our MDF file - i was able to
copy the 9 other NDF files and the LDF file. Our MDF file has very
little of our data, but i know it has SQL information in it.
What are my options on a restore? Can i create a new DB on the new HD
(which will create all NDF, LDF, and MDF), and then stop SQL, copy the
NDF and LDF from our USB drive, and then start up SQL again, and will
that work?
Remember, the files are just copied, not any kind of SQL backup.
TIA
Darin
*** Sent via Developersdex http://www.codecomments.com ***
As far as I know you have any luck to get your database back using only ldf
and ndf files.
Are you sure you do not have a backup of your database anywhere in the
cabinets in your room, hmm?
You didn't mention what kind of a crash it is, however have you tried some
kind of File Recovery software to try to recover that mdf file?
I hope another friend of mine here has to say something to recover it...
Ekrem nsoy
"Darin" <darin_nospam@.nospamever> wrote in message
news:%23YFrJRiIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> Our server crashed. I was able to boot up in safe mode and copy the data
> onto an external USB harddrive, all except our MDF file - i was able to
> copy the 9 other NDF files and the LDF file. Our MDF file has very
> little of our data, but i know it has SQL information in it.
> What are my options on a restore? Can i create a new DB on the new HD
> (which will create all NDF, LDF, and MDF), and then stop SQL, copy the
> NDF and LDF from our USB drive, and then start up SQL again, and will
> that work?
> Remember, the files are just copied, not any kind of SQL backup.
> TIA
> Darin
> *** Sent via Developersdex http://www.codecomments.com ***
|||we do have a backup, but it is to a DAT drive that this other server
doesn't have a drive on. I am getting a new HD to put in the original
server, where that HD crashed, just trying to get up and running now.
I do have a backup of older data (MDF, NDF, and LDF) on my machine and i
tried to do what i wanted and couldn't get it to work. After creating
the new database, and then coping over the old MDF, when i restarted
MSSQLSERVER, the enterprise manager showed the database, but there isn't
a + sign next to it, so there are tables, views, etc. strange.
Darin
*** Sent via Developersdex http://www.codecomments.com ***