SSMS connect to another server => How to ?

Question

SSMS connect to another server => How to ?

christophe.bernard 47659

Ten Centuries

Points: 1169
More actions
January 31, 2018 at 1:01 am

#343176

Hello all,
before where i worked, it's was possible in sql server management studio to connect to a sql server by right click on the root node and choose connect.
I've change my job, and where i work actually if i want to make some change in the database i need to CONNECT with a remote desktop connection, open SSMS make my change and so on ...
The problem and i'm sure you can understand after 3 connections in same time the server is FULL and it's not possible to obtain a connection ...and of course it's very slow !
My question is , how i can ENABLE the server for to arrive at connect to with my local Sql Server Management System ?
Someone can explain me the step ?
thanks for your time

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

HappyGeek SSCoach Points: 18729 More actions · Answer 1

An rdp session is not a good place from which to run SSMS, that said is it not possible to simply register the server from within SSMS: As here.

...

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 2

christophe.bernard 47659 - Wednesday, January 31, 2018 1:01 AM
Hello all,
before where i worked, it's was possible in sql server management studio to connect to a sql server by right click on the root node and choose connect.
I've change my job, and where i work actually if i want to make some change in the database i need to CONNECT with a remote desktop connection, open SSMS make my change and so on ...
The problem and i'm sure you can understand after 3 connections in same time the server is FULL and it's not possible to obtain a connection ...and of course it's very slow !
My question is , how i can ENABLE the server for to arrive at connect to with my local Sql Server Management System ?
Someone can explain me the step ?
thanks for your time

What happens when you try to connect to a server from SSMS running on your desktop? Maybe there's a firewall stopping you, or maybe you're using the wrong network library. Is the instance you're trying to connect to running on the default port? If not, is the SQL Server Broswer service running? If not, you'll need to supply the port number.

John

christophe.bernard 47659 Ten Centuries Points: 1169 More actions · Answer 3

Hello all,
HappyGeek => thanks yeah right ...

John Mitchell-245523 => thanks when i try to REGISTER => sorry i have an error when i post my initial message.
when i try to register the server with SSMS => i type this :
server name : IPADDRESS
authentification : my login my password

i receive every time :
testing the registered server failed, verify the server name, login credentials, and database, and then click test again.
Login failed for ..... sql server error 18456

Last word i can ping the server by a command dos

Sean Pearce SSCoach Points: 15999 More actions · Answer 4

Confirm the server is configured for SQL Server Authentication. You will not be able to login with a username and password unless this is enabled.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 5

If you're getting a login failed error, you can check the errorlog on the server to find out why the login failed (that's assuming that the instance is configured to capture failed logins in the errorlog). Are you trying to make a connection with SQL authentication, or Windows?

John

christophe.bernard 47659 Ten Centuries Points: 1169 More actions · Answer 6

Hello all,
Sean Pearce => i've check on the server and it's well enable => sql server and windows authentication mode
On my local pc, when i try to REGISTER this server i've try with both mode ...but never works ...
On the server, sql server i have a login with my account => domain\username
This login is parameterize as public in server roles options

John Mitchell-245523 => i've try to check the errorLog on the sql server => management / sql server logs but every time i receive :
failed to retrive data for this request.(microsoft sqlserver management sdk sfc ....)

Pretty bad ...and actually nobody can help me in my job ...

I'm not an expert and prefer wait my colleague before to change something and destroy something !

thanks for your time
i validate the post because i'm sure your way is correct just the server isn't well configured.

Sean Pearce SSCoach Points: 15999 More actions · Answer 7

Is your client machine on the domain? If not you can launch SSMS from command prompt with your domain credentials.
runas /netonly /user:YourDomain\UserName "C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 8

christophe.bernard 47659 - Thursday, February 1, 2018 12:58 AM
i've try to check the errorLog on the sql server => management / sql server logs but every time i receive :
failed to retrive data for this request.(microsoft sqlserver management sdk sfc ....)
Pretty bad ...and actually nobody can help me in my job ...
I'm not an expert and prefer wait my colleague before to change something and destroy something !
thanks for your time
i validate the post because i'm sure your way is correct just the server isn't well configured.

Well, yes - since you can't log on to SQL Server, you won't be able to do it through SSMS. You'll need to RDP to the server, or map a drive to the disk that the errorlog is on, and use a text editor to read it.

John