i choose 'sql server authentication' as the option for destination but my username / password is not accepted. user failed error. i presume this would be a username / password within the 'security/logins' of the destination server? i have access to this server so know the username / password is set up in there.
why is this not working? i have also tried an import from the destination server, but this creates the same login failed error.
how can i connect between these 2 servers and run this export?
--
Message posted via http://www.sqlmonster.comMark
What is amount of data you are moving?
Have a look at BACKUP/RESTORE commands.
Have you specified an output file to see what is exactly the error?
"Mark Evans via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8aeb166002c84fa382c7595cae5484b7@.SQLMonster.com...
> Im having trouble trying to export data from one sql server instance to
another on a separate server.
> i choose 'sql server authentication' as the option for destination but my
username / password is not accepted. user failed error. i presume this would
be a username / password within the 'security/logins' of the destination
server? i have access to this server so know the username / password is set
up in there.
> why is this not working? i have also tried an import from the destination
server, but this creates the same login failed error.
> how can i connect between these 2 servers and run this export?
> --
> Message posted via http://www.sqlmonster.com|||im only moving a table with about 150 entries, hence trying to selectively export this table rather than backup / restore the whole database, which i would rather not do as im unsure the data in every table has been kept up to date.
not sure what you mean by output file but error i get when i click on refresh is -
Error Description: Login failed for user 'EVANSM'
Context: Error during initialization of the provider.
i presume that when i click refresh the login should be verified and i can select the server / database names from the dropdowns?
--
Message posted via http://www.sqlmonster.com|||Mark
Does this user have login on desination server, does he/she exist there?
"Mark Evans via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:663fad94a4154d2dbd1d79e600338f64@.SQLMonster.com...
> im only moving a table with about 150 entries, hence trying to selectively
export this table rather than backup / restore the whole database, which i
would rather not do as im unsure the data in every table has been kept up to
date.
> not sure what you mean by output file but error i get when i click on
refresh is -
> Error Description: Login failed for user 'EVANSM'
> Context: Error during initialization of the provider.
> i presume that when i click refresh the login should be verified and i can
select the server / database names from the dropdowns?
> --
> Message posted via http://www.sqlmonster.com|||Yes, within enterprise manager... security / logins, or do you mean as a windows nt user?
--
Message posted via http://www.sqlmonster.com|||Does the user have any permissions on the table?
Look, I try get more info because I think it is matter of user's permission
or something wrong with a connection.
"Mark Evans via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:ca8ffd6abbee4d229dfca4252a329070@.SQLMonster.com...
> Yes, within enterprise manager... security / logins, or do you mean as a
windows nt user?
> --
> Message posted via http://www.sqlmonster.com|||yes, this user has access to the relevant database and all admin roles are ticked.
is there anything within sql server that i need to alter to allow remote connections via dts import / export?
--
Message posted via http://www.sqlmonster.com|||This is a multi-part message in MIME format.
--=_NextPart_000_0735_01C4F23C.763D39A0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 7bit
Unless you have correctly configured for Kerberos Delegation in the Active
Directory, you will have to create a SQL Server Authenticated login account
on the destination SQL Server to use, not the Windows Account. Also, the
destination SQL Server will have to be configured for mixed-mode
authentication.
Check with your DBA/AD Admin about the current configurations.
Sincerely,
Anthony Thomas
"Mark Evans via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8aeb166002c84fa382c7595cae5484b7@.SQLMonster.com...
Im having trouble trying to export data from one sql server instance to
another on a separate server.
i choose 'sql server authentication' as the option for destination but my
username / password is not accepted. user failed error. i presume this would
be a username / password within the 'security/logins' of the destination
server? i have access to this server so know the username / password is set
up in there.
why is this not working? i have also tried an import from the destination
server, but this creates the same login failed error.
how can i connect between these 2 servers and run this export?
--
Message posted via http://www.sqlmonster.com
--=_NextPart_000_0735_01C4F23C.763D39A0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Unless you have correctly configured =for Kerberos Delegation in the Active Directory, you will have to create a SQL Server =Authenticated login account on the destination SQL Server to use, not =the Windows Account. Also, the destination SQL Server will have to be configured for mixed-mode authentication.
Check with your DBA/AD Admin about =the current configurations.
Sincerely,
Anthony Thomas
--
"Mark Evans via SQLMonster.com"
--=_NextPart_000_0735_01C4F23C.763D39A0--|||it is configured for mixed mode authentication already.
in security there is a 'start and run sql server in the following account' option that has a username and password entered.
is this what you mean by a SQL Server Authenticated login account?
--
Message posted via http://www.sqlmonster.com
No comments:
Post a Comment