January 21, 2010 at 3:58 pm
I'm using SQL 2008 copy database wizard and getting a weird situation. At the very end of the copy, I get a login error. I'm using windows authentication for both source (network server) and destination (local machine) databases. Upon looking at it further, the copy process is sending my machine name as login instead of my windows login thus the error. Is there a setup that I have to change somewhere? Below are contents of the message in event log:
Event Type:Error
Event Source:SQLISPackage100
Event Category:None
Event ID:12550
Date:1/21/2010
Time:4:49:14 PM
User:NT AUTHORITY\SYSTEM
Computer:LOCALSRV
Description:
Event Name: OnError Message: Failed to connect to server NETWORKSRV.
StackTrace: at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect()
at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp)
InnerException-->Login failed for user 'XXX\ LOCALSRV$'.
StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)...
Operator: NT AUTHORITY\SYSTEM
I'm copying from sql 2000.
Thanks.
January 22, 2010 at 7:07 am
What account is your SQL service running on both machines?
-Roy
January 22, 2010 at 8:36 am
Roy,
If I understand your question correctly, it's running as LocalSystem account on my destination server. Not sure how to find out on my sql 2000
January 22, 2010 at 8:45 am
That is probably why you are not able to do data export over the network. I am not sure about it though but for the first handshake, I think it will use the service account to authenticate. Your user will be used for permissions checking.
-Roy
January 25, 2010 at 10:04 am
I had to set up the Sql Service acct with my domain ID and my copy database wizard worked like a charm. Thanks for your help.
January 25, 2010 at 10:21 am
Glad we could help and thanks for letting us know that it worked.
-Roy
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply