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.
| Author |
Topic |
|
Domini1116
Starting Member
3 Posts |
 Posted - 2009-04-11 : 01:53:47
|
| Hello Everyone,I am new as a DBA. I would like to learn the administration side of it and I am doing so. I have 3 computers acting and containing SQL Server 2005.Somehow I am having alot of difficulty conecting from one server to another server...I would like to have\See all 3 servers under registered servers. But I can not connect to any of them!Under Object Explorer -> Connect to database engine.Under Server Name ->Browse to Network server*** at this point all servers show ***Select targeted Server and It will prompt for credentials (Log In and Password)...But when I enter the information...I am getting a time out error.I am learning SQL 2005 and this is stoping me from learning or followring my tutorialThis is what I have so far...1- Log-In Credential has administrative priveledge.2- Every server has remote connection checked on (Under Connection)Any help will be appreciated.Wellingthon Gonzalez |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-04-11 : 07:49:33
|
| 1)Are you sure that you are pointing to the right server (including instance name ,if relevant such as SERVER\INSTANCE_NAME2)Can you ping to the server?3)Are all the relevant services turned on? such as SQL browser?Jack Vamvas--------------------http://www.ITjobfeed.com |
 |
|
|
Domini1116
Starting Member
3 Posts |
Posted - 2009-04-14 : 00:41:37
|
| Jack,Thanks for responding...I have 3 computer acting\having SQL server 2005. Under the connection property...there is not instance name in either of them.I pinged all the server and they all working properly.SQL Browser was not running...now is in automatic start and I still can not log in remotely.Just to add more information...because my back up\restore tutorial is backing up the DB into a network drive...All the services are running under an user name\password created by me in window for this purpose and these account have all administrative access. Services are working under this created acct.Thanks,Wellingthon Gonzalez |
|
|
|
|
|
|
Connecting to SQL Server Remotely