It sure sounds like you installed a named instance instead of the default
instance. Try running "sqlcmd" from a cmd window. Also try using the SQL
are enabled. Also check the error log at: C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG to see if there are any errors. If the Windows
This posting is provided "AS IS" with no warranties, and confers no rights.
"NWO" <NWO@discussions.microsoft.com> wrote in message
news:01318E09-32F2-401F-9660-887275F0DC3A@microsoft.com...
> Error 40: cannot conect to server.
>
> Here are the steps that I follow:
>
> * Open Server Management Studio
> * Server type defaults to Database Engine
> * Server name: . or localhost dosn't work
> * Auth: Windows Auth.
> * Press Connect
> Error ocurs after about 30 seconds.
>
> I installed the full product last night and didn't receive any install
> errors.
>
> Nothing seems to be working for me!
>
> NWO :(
>
> "Roger Wolter[MSFT]" wrote:
>
>> dot, localhost, or the hostname of your server should all work for a
>> local
>> connection. I assume you have something else going on. What kind of
>> error
>> do you get and what is in the error log?
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>>
http://www.microsoft.com/info/cpyright.htm >>
>> "NWO" <NWO@discussions.microsoft.com> wrote in message
>> news:D0F54FA0-4E6B-46E1-B116-4D4960EB4355@microsoft.com...
>> > Thank you Roger.
>> >
>> > I'm using SQL Servor Enterprise Edition (Eval 180 days).
>> >
>> > The period did not work and I am running SQL 2005 on the same box as
>> > XP.
>> >
>> > Any other ideas to get me going here?
>> >
>> > Mark :)
>> >
>> >
>> > "Roger Wolter[MSFT]" wrote:
>> >
>> >> If you are trying to connect to the SQL Server running on the same box
>> >> as
>> >> you are running the tool, the server name is . if SQL Server is
>> >> running
>> >> as
>> >> the default instance and .\sqlexpress if you installed the SQL Express
>> >> edition.
>> >>
>> >> --
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >> Use of included script samples are subject to the terms specified at
>> >>
http://www.microsoft.com/info/cpyright.htm >> >>
>> >> "NWO" <NWO@discussions.microsoft.com> wrote in message
>> >> news:F4AC4A94-6B93-4B61-A230-CEA4D6C4F739@microsoft.com...
>> >> > Hello.
>> >> >
>> >> > I installed SQL Server 2005 on my XP Professional personal PC last
>> >> > night.
>> >> > Everything loaded OK. But when I tried to access some of the
>> >> > servces,
>> >> > I
>> >> > was
>> >> > prompted to connect to a server and the Server Name was blank. I
>> >> > guess
>> >> > my
>> >> > question is how do I set up my XP Professional to run as a server?
>> >> > I'm
>> >> > loading the SQL Server 2005, in addtional to Visual Studio 2005, as
>> >> > a
>> >> > test
>> >> > to
>> >> > learn the products. Is there another way around this - please
>> >> > advise
>> >> > (keep
>> >> > it simple please).
>> >> >
>> >> > Thank you.
>> >>
>> >>
>> >>
>>
>>
>>