Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 connect to remote server

Author  Topic 

gorashy
Starting Member

15 Posts

Posted - 2015-02-28 : 20:41:39
can anyone "expert" explains what are the exact steps to connect to remote server from management studio.log shipping, database mirroring and replication depend on this connection.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-01 : 03:17:40
click on connect to database, enter the connection parameters and click connect.
Go to Top of Page

gorashy
Starting Member

15 Posts

Posted - 2015-03-01 : 06:59:33
the matter not easy as you wroe, I got many error messages
there should be steps to connect to remote server
what are the steps?
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-01 : 09:28:22
in ssms:

1. click on View/ Object Explorer
2. In OE, in the left pane, click on Connect and chose Database Engine from the dropdown
3. In the Connect to Server dialog, fill in the Server Name field
4. Choose the correct type of Authentication and fill in the Userid/Password for SQL Server Authentication
5. Click "Connect"

If you get error messages, post them here.
Go to Top of Page

gorashy
Starting Member

15 Posts

Posted - 2015-03-01 : 16:07:17
thank you gbritton for your reply
I got the following message:
A connection was successfully established with the server,but then an error occurred during the login process(provider TCP provider,Error:0- an existing connection was forcibly closed by the remote host)
microsoft sql server,Error:10054

by the way, I opened port in configuration manager and I enabled tcp protocol, the firewall was turned off(the port I used was also used by database mirroring)
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-02 : 04:02:56
so, you don't have permission to connect to the database, or you have the wrong password. Windows or Sql Server authentication?
Go to Top of Page

gorashy
Starting Member

15 Posts

Posted - 2015-03-02 : 06:56:09
I tried windows authentication and sql server authentication and password was correct, but the message persisted.
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-02 : 08:01:15
Ask your DBA to give you permissions
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-03-02 : 12:00:35
You can not have database mirroring and the database engine listen on the same port.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

gorashy
Starting Member

15 Posts

Posted - 2015-03-03 : 12:31:39
I changed the port, but the message persisted.I know from this message that I am near to accomplish the connection.
any further suggestions?
Go to Top of Page
   

- Advertisement -