Unable to connect SSMS to SQL Server 2012 - Beginner Question
Posted on 2014-02-15
First time user of EE and MS stack.
I have a remote development installation of SQL Server 2012 set up on a remote server.
I know the IP address of the server.
If I am sat on the server then I am able to access the server no problem using Windows Authentication.
However, I wish to access the server from my Windows 7 machine. I have installed SSMS on this machine.
However, upon trying to access the machine I do not get the option for Windows authentication. I have tried accessing it using SQL Server authentication but I am not sure I am doing this correctly.
I have punched a hole in the server firewall for the default port of 1433 (Incoming TCP).
My steps for creating a SQL Server login was to go to SSMS on the server and expand the node Logins under Security under the server name. Not sure if this was the right move?
Please can someone either tell me:
1. How to use Windows Authentication from my remote SSMS
2. How to create a SQL Server authentication on my SQL Server that will work from my remote SSMS