connect to remote server - SQL Server Forums

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.

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?

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.

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)

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?

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.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-02 : 08:01:15

Ask your DBA to give you permissions

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/

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?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources