Posted by antonyliu2002@yahoo.com on 03/20/07 04:09

On Mar 19, 3:44 pm, "Razvan Socol" <rso...@gmail.com> wrote:
> > [...] I cannot connect to .\SQLEXPRESS with Database Engine selected,
> > using Windows Authentication.
>
> What error message do you get (below "Cannot connect to .
> \SQLEXPRESS") ?
> a) "An error has occurred while establishing a connection to the
> server [...] Error Locating Server/Instance Specified"
> b) "Login failed for user 'COMPUTERNAME\username'"
>
> I guess that a). In this case, go to Start / Programs / SQL Server
> 2005 / Configuration Tools / SQL Server Configuration Manager. Under
> "SQL Server 2005 Services" do you have any entry with the "SQL Server"
> as the "Service Type" ?
>
> If yes, try to connect to the instance name specified there (if it's
> the default instance, just try to connect to ".").
>
> If no, then the Database Engine seems to be not installed; when you
> reinstall SQL Server, make sure that "Data files" and "Shared tools"
> under "Database Services" are selected. Then remember what choice you
> make in the Instance Name screen.
>
> Razvan

Hey, Razvan, you really rock!

Exactly that was the problem. I checked the configuration manager.
It looks like that I don't have SQLEXPRESS. The instance name seems
to be MSSQLSERVER.

My computer name is EMACHINEXPPRO and I can connect to the SQL Server
by typing in this computer name as the Database Engine or like you
said, simply put a dot (.) instead.

Connecting to MSSQLSERVER or .\MSSQLSERVER results in error (error
code 53 or error code 87). See the screen snapshot below.

http://farm1.static.flickr.com/175/427696305_48f5145e32_o.png

Good that I can connect to it using my computer name now. Many
thanks.

AL

[Back to original message]