sql server registration

[shivkumar]

hi,

I installed sql server on my PC. I am running windows server 2003 enterprise eddition

the sql server entriprise manager is showing all the database like master, northwind etc.

I created a new group, and i want to connect this group with already running sql server. I used new sql server registration but it failed showing an error 'time out'

How can I short out this problem.


I am waiting for ur reply
with best regards
shiv

[exterminator]

...I created a new group, and i want to connect this group...Where is this located? On a network computer? I could not understand what you are trying to do.

[shivkumar]

thanks exterminator,
here I am giving u all the steps which i tried.

I installed sql server 2000 on a hachine running windows server 2003.
I started sql server enterprise manager.
I clicked right mouse button on Microsoft sql servers and created a new server group named 'sql server group'.

then I clicked right mouse button on 'sql server group' and clicked on 'new sql server registration'

I selected server (sql_shiv) from the dialogbox, and choosed Windows authentication for connection, and checked all the checkboxex under options
these are 'display sql server in console. show system databases and objects and automatically start sql server when connecting'.

and I got a message that "sql server registered successfully' with a new icon under the 'sql server group tree' named 'skp\sql_shiv' where 'skp' is the name of my computer.

I expand 'skp\sql_shiv' and i saw the databases master, notthwind,pubs etc.

now I have an other server machine already running 'sql server' successfully. The name of this sql server is 'SERVER_SQL'.
This is the machine where we keep our database.
I got the SERVER_SQL register on my PC also. and now I have two icons under 'SQl Server Group' one named 'skp\sql_shiv' and the other one is 'SERVER_SQL'. I got all the tables like master pubs, northwind ect under 'skp\sql_shiv' but when I clicked on SQRVER_SQL I found an error saying
'the SQL Server SERVER_SQL is not known to be running. Are you sure You ant to connect' with three buttoon, "yes, no and Cancel"' when I pressed yes it again generates message saying "Action could not be accomplished
reason:time out expired".

My problem is this that I want to list bothe sql servers(skp\sql_shiv and SERVER_SQL) on my PC under the same group(sql server group), so that I can brows databases on both servers(skp\sql_shiv and SERVER_SQL).


Can I do this work, if yes then how.
regards.

shiv

[shivkumar]

hi every body.

the problem is unanswered till now

[exterminator]

See if this helps - SQL Server 2000 Management Tools (http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=177&rl=1) or this - Installation and Setup (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/modadmin/html/deconchangingsqlserveradministratorlogin.asp).

Actually, I don't think its very tough to get it going. Try different Ps and Cs and see if that works for you. I don't have a SQL Server at hand and hence won't be able to guide step by step. Haven't seen the face of MS SQL server in last 8-9 months.. Hope it works for you. Cheer up! All the best :) :thumb: . Regards.

[shivkumar]

thanks exterminator, but it did not helped me.


Actually I want to register two sql servers(both are of different name) on a single PC, runing windows server 2003. One which is installed on local machine was registered successfully , but the other which is a network PC and also running windows server2003, was registered but the conection failed. I mean the server is registered successfully but connection is not generated( databases of the network PC are not listed). I have tried what I could but I am unable to do.




I hope some one will reply
shiv

[ITGURU]

Dear Shiv,

I think the problem with your registration is that you did not have access right to the server to which u want to connect using SQL Server.

To Solve your problem, please try to check following:
1. Is both server belong to different Domain? If yes then create trust relationship between two Window Server 2003.

2. Do you have access right on second Window Server 2003?

3. Do you have access right to SQL Server of Second window server 2003 i.e. your name appearing in the list of second machine SQL Server Security->Login option.

If all the above is correct then please send me some screen shot of step you follow to configure second SQL Server in your machine.