Help i get error T_T.

[zellelfreak]

Hey guys, Im trying to do my own server for some friends and me, and I need help.
Because when i try to connect to database i get this error.

http://img223.imageshack.us/my.php?image=dibujofgj.jpg

[I have windows XP, my background is only an skin XD]

thanks to all.

[MentaL]

[zellelfreak]

Some1 can help plz? T_T.

[Trilest]

Maybe you;ve entered the wrong password ?

[zellelfreak]

Maybe you;ve entered the wrong password ?

Where i get my password? :S

[Geowil]

did you run the Surface Area Tool after installing mssql?

if not:

Click on Start > all programs > microsoft sql server 2005 > configuration tools > surface area configuration

then click on Surface Area Configuration for Services and Connections.

Next under Database Engine, click on the Remote Connections option, then select the second radio button, and the last radio button on the list that will become selectable.

Click on apply, then click on the Service option, then click on stop, then on start. Click ok and close any other windows.

If you already have done that, then try logging into the Management studio with Windows Authentication instead of SQL auth.

your password is what you set it up to be when you installed mssql, if you didnt choose to setup the password, its probably set to the default admin password, dont know what that would be though, try googling for it.

[zellelfreak]

@Geowil
Nope, i cant i get other error.. :S

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine

Some guys says i need do this: put this in notepad.
@echo on
cd /d c:\temp
if not exist %windir%\system32\wbem goto TryInstall
cd /d %windir%\system32\wbem
net stop winmgmt
winmgmt /kill
if exist Rep_bak rd Rep_bak /s /q
rename Repository Rep_bak
for %%i in (*.dll) do RegSvr32 -s %%i
for %%i in (*.exe) do call :FixSrv %%i
for %%i in (*.mof,*.mfl) do Mofcomp %%i
net start winmgmt
goto End

:FixSrv
if /I (%1) == (wbemcntl.exe) goto SkipSrv
if /I (%1) == (wbemtest.exe) goto SkipSrv
if /I (%1) == (mofcomp.exe) goto SkipSrv
%1 /RegServer

:SkipSrv
goto End

:TryInstall
if not exist wmicore.exe goto End
wmicore /s
net start winmgmt
:End
and run in CMD. (BAT)
I do that and my problem doesnt solves...T_T



Thanks :S

[JuanMedina]

uninstall the MSQL and install it again..

[wesman2232]

did you run the Surface Area Tool after installing mssql?

if not:

Click on Start > all programs > microsoft sql server 2005 > configuration tools > surface area configuration

then click on Surface Area Configuration for Services and Connections.

Next under Database Engine, click on the Remote Connections option, then select the second radio button, and the last radio button on the list that will become selectable.

Click on apply, then click on the Service option, then click on stop, then on start. Click ok and close any other windows.

If you already have done that, then try logging into the Management studio with Windows Authentication instead of SQL auth.

your password is what you set it up to be when you installed mssql, if you didnt choose to setup the password, its probably set to the default admin password, dont know what that would be though, try googling for it.

what? I don't think I have ever used the Surface Area thing, what is it?
man, why is everybody doing unnecessary steps nowadays?

[zellelfreak]

uninstall the MSQL and install it again..

I tryed that...
T_T

[zellelfreak]

so, nobody know how to fix it? ._.

[Zewa]

try username sa

[Arcelor]

Do NOT install MSSQL under Windows Authentication. Reinstall with Mixed Mode.