I am an experienced Oracle DBA with no prior experience on SQL Server. Could someone please give me some guidance how to connect to SQL Server database for the first time? The database was already created. I tried to create a new data source from administrative tools to connect to SQL server but the connection test failed.
What is the equivalent of SQL*Plus (Oracle) in SQL Server?
Any instructions to get started would be greatly appreciated.
I have installed the client tools, launched enterprise mgr.
What to do in new sql server registration to select a new sql server?
I know the ip address and the instance name I want to connect to. How to add the sql server when the available server box given on the left do not list the one I want to add? Am I missing any steps? Please help.... Thanks!