SQL server 2055 remote connection problem, cannot solve it help please thank you
- by user287745
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