SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


not able to connect to server from different domain


not able to connect to server from different domain

Author
Message
mandavli
mandavli
SSC-Addicted
SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)

Group: General Forum Members
Points: 452 Visits: 224
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.
Igor Micev
Igor Micev
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10659 Visits: 5158
Is there a Login in the instance for the domain user you cannot log in with?

Igor Micev,
My blog: www.igormicev.com
mandavli
mandavli
SSC-Addicted
SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)SSC-Addicted (452 reputation)

Group: General Forum Members
Points: 452 Visits: 224
yes user I am trying does have login credential has rights to other domain server.
Igor Micev
Igor Micev
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10659 Visits: 5158
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
Perry Whittle
Perry Whittle
SSC Guru
SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)SSC Guru (56K reputation)

Group: General Forum Members
Points: 56825 Visits: 17747
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" ;-)
@SQLFRNDZ
@SQLFRNDZ
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2269 Visits: 1222
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.


--SQLFRNDZ

lkennedy76
lkennedy76
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3600 Visits: 919
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.

MCSA SQL Server 2012
hdr-696805
hdr-696805
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 447
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search