What does this message mean?
Hi,
We have a new install of SQL 2000 and I am trying to transfer a DB to the new server (DTS transfer DTS task).
Everything points to where it should and I have all the required SQL and NTFS permissions but when I try to execute the task I get "failed - unspecified error"
When I check the event viewer on the (new) destination server I see these entries (below). I have no idea what they mean, how to fix, what to fix? The event icon is information as opposed to warning/error.
I really want to get this understood and fixed before transferring the DB across - as a bonus I'd also like to get the transfer DB task working too!
Error: 15457, Severity: 0, State: 1
Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
We have a new install of SQL 2000 and I am trying to transfer a DB to the new server (DTS transfer DTS task).
Everything points to where it should and I have all the required SQL and NTFS permissions but when I try to execute the task I get "failed - unspecified error"
When I check the event viewer on the (new) destination server I see these entries (below). I have no idea what they mean, how to fix, what to fix? The event icon is information as opposed to warning/error.
I really want to get this understood and fixed before transferring the DB across - as a bonus I'd also like to get the transfer DB task working too!
Error: 15457, Severity: 0, State: 1
Configuration option 'allow updates' changed from 1 to 0. Run the RECONFIGURE statement to install.
Irwin Santos
are you logged in as the administrator?
ASKER
I am logged in as myself (non WINNT admin) and I am SA on both source and destination boxes.
I've tried transfer login tasks same thing.
I've tried copy DB wizard and only have the objects suceed!
I go to the new server properties and tick the box (server settings) that says to allow mods to be made to system catalogues. I re-run the transfer DB task (fails again). I revisit the allow mods setting and it's unticked itself!
I've tried transfer login tasks same thing.
I've tried copy DB wizard and only have the objects suceed!
I go to the new server properties and tick the box (server settings) that says to allow mods to be made to system catalogues. I re-run the transfer DB task (fails again). I revisit the allow mods setting and it's unticked itself!
login as the administrator
ASKER
NT administrator?
To perform a SQL task when I am SA on both SQl servers and have 'full control' over the data and log folders on the destination?
ok I'll give it a go and post back.
To perform a SQL task when I am SA on both SQl servers and have 'full control' over the data and log folders on the destination?
ok I'll give it a go and post back.
Yeah... you want to be GOD on the machine when you do this procedure.
ASKER
ok I RDP'd to the new server logged in as admin and tried again - exact same thing unspecified error.
1 thing I have noticed is that regardless of whether I am me or I am admin.... when I go and look it appears to have done it!
So... what is the error? Did one get left behind? (too many to check with the naked eye!)
Can I trust the process? I don't feel too comfortable transferring the DB over and putting it into production if there are any nasty surprises waiting for me.
1 thing I have noticed is that regardless of whether I am me or I am admin.... when I go and look it appears to have done it!
So... what is the error? Did one get left behind? (too many to check with the naked eye!)
Can I trust the process? I don't feel too comfortable transferring the DB over and putting it into production if there are any nasty surprises waiting for me.
How about reviewing the contents of the database...does it look ok?
you may want to test with a simple .csv file.
you may want to test with a simple .csv file.
ASKER
There is no DB to view I am trying to run (initially) the "transfer logins task"
It reports failure but when I look at the destination server there are a whole list of users.
I don't know what/why it is reporting failure and I don't know if I can trust what it does appear to have achieved.
It reports failure but when I look at the destination server there are a whole list of users.
I don't know what/why it is reporting failure and I don't know if I can trust what it does appear to have achieved.
let's back this up...
go to services in CONTROL PANEL.. and see if any AUTOMATIC services have NOT started. also review your event viewer and post back anything that doesn't look right
go to services in CONTROL PANEL.. and see if any AUTOMATIC services have NOT started. also review your event viewer and post back anything that doesn't look right
ASKER
All services started. Only entries in the event viewers are that posted in the original post.
They re-appear every time I attempt to do a login or db transfer
They re-appear every time I attempt to do a login or db transfer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
created that .csv to test?
ASKER
When I first saw this in the event logs I manually switched 'allow modifications' under sql server settings.
Then when I ran it I got 3 events instead of the previous 2. When I checked back in server settings the box had unticked itself.
csv to use as a datasource or create an ActiveX task to see if I can successfully copy it to the file system on the new server?
Then when I ran it I got 3 events instead of the previous 2. When I checked back in server settings the box had unticked itself.
csv to use as a datasource or create an ActiveX task to see if I can successfully copy it to the file system on the new server?
use as your sample datasource... export out to SQL
just a few records like,
1, apple
2, banana
3, orange
just a few records like,
1, apple
2, banana
3, orange
ASKER
sorry - it's been a long day - I'm not with you.
Export out to SQL?
Export out to SQL?
create text file, name it mytest.csv and inside type
1,apple
2,banana
3,orange
save the file.
in DTS, the source is mytest.csv and the destination is a SQL database
1,apple
2,banana
3,orange
save the file.
in DTS, the source is mytest.csv and the destination is a SQL database
ASKER
Yep no problem - DTS'd 3 fruits from csv file on my desktop to a db/table on the brand new server
>I go to the new server properties and tick the box (server settings) that says to allow mods to be made to system >catalogues. I re-run the transfer DB task (fails again). I revisit the allow mods setting and it's unticked itself!
You have to restart sql services inorder for changes to take place.
You have to restart sql services inorder for changes to take place.
@QPR..how are you doing with this?
@Venabili...the question "What does this message mean? Error: 15457, Severity: 0, State: 1" has been answered in the Wkimeria solution for Error: 15457 that I provided.
In addition, I offered all the procedures to make the DTS work except the last item which imran_fast statee to restart the SQL services.
This should be a split points between imran_fast and myself (select the Wkimeria comment as the accepted answer)
In addition, I offered all the procedures to make the DTS work except the last item which imran_fast statee to restart the SQL services.
This should be a split points between imran_fast and myself (select the Wkimeria comment as the accepted answer)
ASKER
Apologies I've been away on vacation for a while.
I'm posting from home so am unable to try out the suggestion until tomorrow.
I'm posting from home so am unable to try out the suggestion until tomorrow.
5 days later - any news?