I have installed Sql Server 2008 R2(express edition) on my server and now I want to connect to that server from my client.
But it shows the following error:
cannot connect to SMSERVER\SMTECH
How can I solve this?
If you can connect locally but you cannot connect remotely there are a few things that you can try.
Enable TCP/IP connections
Check other firewalls between client and server
Due to my experiences with Microsoft SQL Server there are two things that might have to be set up to get SQL Server work with clients: