December 8, 2013 at 9:03 am
remote connection is turned on that sql server. also it is from trusted domain.
In server name if I give domain\servername and sql server credentials
(not windows) then it does not allow me to connect.
I am able to connect to sql server from the domain that I am on. but not to the sql srver from other domain.
What I am doing wrong.
December 8, 2013 at 11:44 am
Is there a Login in the instance for the domain user you cannot log in with?
Igor Micev,My blog: www.igormicev.com
December 8, 2013 at 11:48 am
yes user I am trying does have login credential has rights to other domain server.
December 8, 2013 at 12:02 pm
Check values for all the following
remote access
remote admin connections
remote login timeout (s)
remote proc trans
remote query timeout (s)
in sp_configure to ensure in case something is not set up well.
Igor Micev,My blog: www.igormicev.com
December 9, 2013 at 4:56 am
mandavli (12/8/2013)
yes user I am trying does have login credential has rights to other domain server.
The account has been added to sql server as a login?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 9, 2013 at 11:29 am
you can use something like this
If you have the sql server hosted in different domain than from where you are trying to connect then it is one of the way
In CMD, type runas /netonly /user:domain\username ssms and it promts for the password and give the password for that domain account of the sql server.
December 9, 2013 at 1:22 pm
you cannot login to SQL with just domain rights to a domain account, you have to add the account to SQL under security, have you done that? It sounds like you have not.
MCSE SQL Server 2012\2014\2016
December 10, 2013 at 7:47 am
Hi,
Two things,
1. When connecting to the SQL instance from 1 domain to the other using windows authentication , what is the error you getting?
2. Did you try to use FQDN (Fully Qualified Domain Name) yet?
Regards
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply