Creating/Connecting to a New Instance

[SendSpam]

Hi,

How do I get a server setup (i.e. create the instance of a server and connect to it?) The Enterprise Mgr asks me for login information that I was never asked to provide, so what am I missing? I think I installed an instance, but it won't connect? Everything is on one computer. Thank you.

 

[BountyBob]

Just to clarify what I think you are doing...

You are selecting a server group and then either right-clicking and selecting "New SQL Server Registration" or selecting "New SQL Server Registration" from the Action menu.
You are then selecting the server you want to register and either connecting using integrated security or selecting the option that prompts you for login information.

That being the case, if you are using integrated security, and the connection is failing, it probably means that you are not registered as a user on that server.

Is your SQL Server installation on a network at your place of employment? If so, try to get hold of valid login detains from your System Administrator. If it is your personal home copy, try entering sa in the username field with no password.