I have installed MS SQL Server 2008 R2 with authentication mode but when now when I click to the connect I gives such kind of error:
A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or not accessible. Verify that the instance name is correct.
Best Answer
You haven't mentioned what authentication method you have selected when installing SQL Server. I'm assuming it was Windows authentication. Make sure you're authenticating with a correct account (the one you've choosen when installing SQL Server). If you have changed your mind and want to use another account to connect to your server, you can do it by starting the installer again and choosing to perform maintenance on existing instance of the server.
Check your server name. These are example values that let me connect to my local server, assuming my computer name is GRON, I'm using Windows auth and my username is gronostaj: (it's SQL Server 2012 but it doesn't matter)
Third thing to check is if your server is actually running. Check if the SQL Server service is enabled and running:
services.msc
, press EnterThis is how the service configuration window looks like when you want to start the server manually and it's already up and running:
Now you should be able to connect to the server using settings mentioned above. If it still doesn't work, you can try to verify if the server is running on the expected port 1433.
cmd
and confirm with Enter. A command line will appear.telnet localhost 1433
, press Enter.