SQL server 2005 remote connection problem, cannot solve it help please thank you

Posted by user287745 on Stack Overflow See other posts from Stack Overflow or by user287745
Published on 2010-06-14T14:35:05Z Indexed on 2010/06/15 0:32 UTC
Read the original article Hit count: 140

Filed under:
|
|
|

note:- if this question does not fit this site please do not just close it but also redirect the question to the fitting sister site, thank you"

the steps taken and the error are mentioned please help, i am stuck here!
installed sql server 2005 express on both computers
installed sql server management studio express on both computers
ran each management studio and connect to instance sqlserver using windows authentication ( one computer connection example "A-63A9D4D7E7834\SQLEXPRESS" ) created a database in the databases named as "test1" created a few tables with data saved and exit.

did everything what this site says
"
How to configure SQL Server 2005 to allow remote connections"
[add h t t p here as spam prevention] ://support.microsoft.com/kb/914277/en-us"

but i have just disable the firewalls completely :turn off

connecting to A-63A9D4D7E7834
started "SQL Server Management Studio Express" on computer A-63A9D4D7E7834
sever name: "ALL-E425BE6C41D\SQLEXPRESS"
authentication: "windows authentication"
and CONNECT

I GET THE FOLLOWING ERROR

Cannot connect to ALL-E425BE6C41D\SQLEXPRESS.


ADDITIONAL INFORMATION:

Login failed for user 'ALL-E425BE6C41D\Guest'. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476


BUTTONS:

OK


HELP

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2005