I have a new SQL 2012 install and I'm trying to setup an ODBC connection to it. I am unable to connect to it on a number of PCs so I don't believe it's PC related. I type in the data source and server name and enter the sa credentials and then it tells me that the SQL server does not exist or access denied. I can ping the SQL server successfully so I know I have a connection to it, I'm just not sure what's blocking it. Any suggestions?
two things to check:
1. make sure sql server is configured to allow remote connections (in SSMS, right-click on the server and go to properties, then click on 'connections')
2. make sure the appropriate
Sometimes drives fill up and we don't know why. If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left! Here's how you can find out...
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.