install sql server 2008

I install sql server 2008 tools and DB
SQLEXPRWT_x86_ENU.EXE

I just click defaults and it connects to a remote DB.

However how do i connect locally ?
In server management studio I cant login with any login.

I have found sql config manager and SQL server agent wont start.

HOW DO I LOGIN?
jagguyAsked:
Who is Participating?
 
jagguyConnect With a Mentor Author Commented:
yes i can login now  and maybe  i need another post
0
 
ragnarok89Commented:
Open sql manager and when you are prompted to log in, press ESC.

Now try an open a connection manually.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
have you tried the Windows user or SA user you specified?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Daniel_PLDB Expert/ArchitectCommented:
You should use SQL Server Management Studio Express - you'll find it under start->all programs->SQL Server 2008
In server name type your_machine_name\SQLEXPRESS, e.g. Win-srv-01\SQLEXPRESS
0
 
jagguyAuthor Commented:
I am using  SQL Server Management Studio Express

I type FGSC\SQLEXPRESS as FGSC is computer name
I use windows authentication  and I also tried sql auth.

have you tried the Windows user or SA user you specified?
in the setup i didnt specify any user
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
try the Windows user you were logged on with when you did the installation?
0
 
jagguyAuthor Commented:
once i login windows i set up a sql authorization  account?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
does the Windows Account you used to install SQL, not allow you to login to the SQL server?
0
 
jagguyAuthor Commented:
Yes I cannot login at all. I have tried everything I know.

I login 08659543 on windows but this doesnt work on sql server management system.

I just installed the defaults and enabled TCP/IP with sql server.

What is going on?
0
 
jagguyAuthor Commented:
last post
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.