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: 318
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