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
 server ip

Author  Topic 

pnpsql
Posting Yak Master

246 Posts

Posted - 2011-12-31 : 00:53:09
hi team, i need to login with a server from my system to execute a query,but i forgot the ip to connect with, i only remember some of it
last time i connect with same server a week ago, how can i find the ip, my connection window does not shows it in combo box. please help.


challenge everything

Sachin.Nand

2937 Posts

Posted - 2011-12-31 : 01:54:56
Dont you maintain an inventory of your servers and databases ?

PBUH

Go to Top of Page

pnpsql
Posting Yak Master

246 Posts

Posted - 2011-12-31 : 01:57:06
we maintain but this time we connect to a server that is new.

challenge everything
Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2011-12-31 : 02:29:41
Ask the networking or the infrastructure team as they should be aware of the servers they have added in last few days.

I am not sure SQL server maitains any history of the servers in some kind of log that you tried connecting in the past.

PBUH

Go to Top of Page
   

- Advertisement -