Not using express version. I will probably uninstall and install again.

Thanks a lot for your time Emmanuel.

>>I've been trying all along to connect with windows authentication.
>>
>>The thing is that I never really got to install it completely. I mean I installed it from the CD but I haven'nt been able to connect even only once to it.
>>
>
>Not even with SQL Server Management Studio? BTW, are you using the express version?
>
>If you're not sure it was installed properly, try running setup again and it will give you the steps to repair the installation, if after doing so you still can't connect try uninstalling and reinstalling.
>
>
>
>>
>>>Ok then, are you connecting with SQL Server authentication? If not check for the user name and password on your connection string.
>>>
>>>Also, did you restart the server after installation?
>>>
>>>>Connecting from the computer acting as the server.
>>>>
>>>>So I should'nt have to bother with blocked ports.
>>>>
>>>>And also I saw that all protocols are enabled (shared memory, TCP/IP and Named Pipes). Only one is disabled and it's VIA.
>>>>
>>>>
>>>>>Ok, I should've asked this first. Are you connecting from the computer acting as the server or are you connecting from a client computer?
>>>>>
>>>>>
>>>>>
>>>>>>Hi Emmanuel!
>>>>>>
>>>>>>
>>>>>>>Hi Denis!
>>>>>>>
>>>>>>>First off check that remote connections are available. You can do it with SQL Server Configuration Manager. Just click Start -> All Programs -> Microsoft SQL Server 2005 ->Configuration Tools
>>>>>>
>>>>>>I don't see where I could change anything related to remote connections in the SQL Server Configuration Manager.
>>>>>>
>>>>>>
>>>>>>>
>>>>>>>And Second check the firewall is not blocking the ports used by SQL Server (usually TCP 1433 and UDP 1434).
>>>>>>
>>>>>>Do I check that in SQL Server Configuration Manager also? If it's the case I did'nt see anything related to ports configuration in there.
>>>>>>
>>>>>>
>>>>>>>>Here's the error message that I got after trying to connect for the first time.
>>>>>>>>
>>>>>>>>
>>>>>>>>TITLE: Connect to Server
>>>>>>>>------------------------------
>>>>>>>>
>>>>>>>>Cannot connect to ULTIMAX.
>>>>>>>>
>>>>>>>>------------------------------
>>>>>>>>ADDITIONAL INFORMATION:
>>>>>>>>
>>>>>>>>An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
>>>>>>>>
>>>>>>>>For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
>>>>>>>>
>>>>>>>>------------------------------
>>>>>>>>BUTTONS:
>>>>>>>>
>>>>>>>>OK
>>>>>>>>------------------------------
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>What do I have to do to connect to SQL Server after that message?