Unanswered: Unable to create a new file data source: "SQL Server Does Not Exist or Access Denied"
I have just downloaded an evaluation version of SQL server from the microsoft website and installed it in my PC.
Now I want to create file data source.
I followed these steps:
-From the control panel, ODBC datasource admin
-click the DSN tab
-click the add button
-select the sql server driver, enter the data source file name
-enter "local" in the server text box as I installed the sql server in my standalone PC.
After that I had this error.
"Connection failed. SQL server does not exist or access denied."
But The sql server service is running.
Can anyone help me where did my configuration go wrong??
It could be that the evaluation edition installed itself as a named instance. Check in the Services applet to see if the service is named MSSQLService or MSSQL$blah. If it is the later, then you will need to address the server as (local)\blah. Hope this helps.