Currently, I am using the SQL Server 2012 Express version and it is installed on Windows Server 2012 R2. Now I just want to connect to this database from a Windows 7 client. The Windows 7 computer already has its own SQL Server 2012 Express.
When I browse the database from the client, I only see client database's instance name only. There is no server's instance.
I already enabled the Named Pipes and TCP/IP on the server and I am new in that kind of business. So please let me know how can I connect to the SQL Server on the server from the client.