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 8, 2013 9:03 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 11:15 AM
Points: 52, Visits: 146
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 8, 2013 11:44 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:30 AM
Points: 3,084, Visits: 3,195
Is there a Login in the instance for the domain user you cannot log in with?



Igor Micev,
SQL Server developer at Seavus
www.seavus.com
Post #1520875
Posted Sunday, December 8, 2013 11:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, October 30, 2014 11:15 AM
Points: 52, Visits: 146
yes user I am trying does have login credential has rights to other domain server.
Post #1520876
Posted Sunday, December 8, 2013 12:02 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:30 AM
Points: 3,084, Visits: 3,195
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,
SQL Server developer at Seavus
www.seavus.com
Post #1520878
Posted Monday, December 9, 2013 4:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:43 AM
Points: 6,641, Visits: 14,226
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 9, 2013 11:29 AM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 2:29 PM
Points: 477, Visits: 1,050
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 9, 2013 1:22 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 14, 2014 8:28 AM
Points: 301, Visits: 597
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: Wednesday, October 29, 2014 7:54 AM
Points: 63, Visits: 333
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