Please help to connect SQL server 2000 on different domain.
Please correct if I m wrong.
System details as follows
Client
Domain : DomainA
System: System1
IP Address : 10.10.225.19
SQL server 2000 installed
SQL Server
Domain : DomainB
System: System2
IP Address : 10.108.22.19
SQl Server : System2\inst2 ( My database is under inst2 instance)
SQL login : TestUser1
Password : Users123
I have Opened firewall port to access 10.108.22.19 from 10.10.225.19
While connecting the SQL server “System2\inst2” from the client machine enterprise manager with the SQL authentication, I am getting error Login failed for user “TestUser1”
And I have noticed in the SQL server log the login attempt shows under System2 default instance ( no instance). Actually I want to connect system2\inst2.
Please let me know the steps to connect.
Thanks in advance.
For named instance, you also need to open UDP port 1434 for firewall on 10.108.22.19(the server). This is requried to find named instances. You said "default instance (no instance)", which errorlog were you checking?|||Thanks for your reply,
I got solution and i am able to connect all my SQL servers from my domain.
It is a firewall issue , buy default they opened for 1433 it is goes to Default instance , but i need to connect a different SQL server instance.
then i opened firewall for that port it is connecting .
Thanks
No comments:
Post a Comment