I know a minute amount of SQL. I was asked to help with some reports by using the queries that were created in an online database and exported the data to Excel. I pull the data into MS Access and create the reports. I would like to work with the SQL queries
and the program in general. The primary user has a SQL Server 2012 Express edition on her computer (Windows 7).
I have the same thing on mine. I was given the database name, login, and password to connect. This doesn't work. I can see connection information on her computer, but cannot get to it. On my computer, I can't even get that part of the program to appear.
I do know that in the past, when I set up a SQL database, I can connect to that one. When I log in again, I use the same name and password and I get connected. This one has SQL Authentication.
Here is my dilemna. That's all I know. I need to connect to the database. The company that supports it couldn't help. The IT Department here could not help. ...
Go to the complete details ...