Click here to Skip to main content
15,610,563 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Dear mentors,

I am using the following connection string to connect my database server-
"Data Source='\SQLEXPRESS,2301'; Initial Catalog=BMDA; Integrated Security=SSPI; Timeout=60;"

when i am connecting from the same PC it works nice. But when i try to connect from remote pc on LAN, it shows "... Login failed foruser MYCOMP\Guest... ",

i have enabled tcp/ip on sql.

am i missing something?

Please guide me.


SQL Server Express does not accept remote connections by default. You have to enable that on the SQL Server machine. It may also help if you verified it will accept TCP/IP connections too.

SQL Server Express Remote Connections[^]
Share this answer
Share this answer
Saumitra Kumar Paul 29-May-11 8:23am    
Thank you thatraja. I have learnt a lot from the links.
thatraja 29-May-11 8:55am    
Glad to hear that man. BTW Keep posting....we are here. Cheers. :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900