Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

not able to connect to server from different domain Expand / Collapse
Author
Message
Posted Sunday, December 08, 2013 9:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, December 08, 2013 11:46 AM
Points: 50, Visits: 141
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.
Post #1520869
Posted Sunday, December 08, 2013 11:44 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 2,728, Visits: 2,645
Is there a Login in the instance for the domain user you cannot log in with?
Post #1520875
Posted Sunday, December 08, 2013 11:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Sunday, December 08, 2013 11:46 AM
Points: 50, Visits: 141
yes user I am trying does have login credential has rights to other domain server.
Post #1520876
Posted Sunday, December 08, 2013 12:02 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 7:45 AM
Points: 2,728, Visits: 2,645
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.
Post #1520878
Posted Monday, December 09, 2013 4:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:51 AM
Points: 5,958, Visits: 12,839
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"
Post #1521022
Posted Monday, December 09, 2013 11:29 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, March 27, 2014 6:04 PM
Points: 450, Visits: 991
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
Post #1521245
Posted Monday, December 09, 2013 1:22 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, March 14, 2014 10:32 AM
Points: 215, Visits: 444
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
Post #1521286
Posted Tuesday, December 10, 2013 7:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:33 AM
Points: 55, Visits: 298
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
Post #1521525
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse