Login fail problem after new install - Newbie

[karaokegalore]

Just installed SQL Server Enterprise - Evaluation. Server JJ1 is running, but no server appears in the list of servers in Query Analyzer. And no list of folders are below the server JJ1 in Enterprise Manager. User "Administrator" fails to login. Going round in circles. Any help would be appreciated.

 

[MartinCroft]

Hi

In enterprise manager under the sql server group have you
tried right clicking and selecting New SQL Server registration? If you click next on the first window it should give you the option to select a server, is the server in the list? If so add it then you should be able to view through EM, the other thing to check is that the MSSQL service is up and running, right click my coumputer and manage then you should be able to access service, find the MSSQL service and check that the status is status started ( its found under Services and applications

MysticMart

 

[SQLBill]

Did you set it up for Windows Authentication Only or for Mixed Mode?

When you loaded SQL Server did you create a login called Administrator? If not, then there isn't one by that name.

If you set it up as Mixed Mode authentication:
Try logging in as SA and leave the password blank. That's the default.

-SQLBill