Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    6

    Unhappy Unanswered: Unable to create a new file data source: "SQL Server Does Not Exist or Access Denied"

    Hi ,

    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.
    -click next
    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??
    Thanks...

    Nov

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    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.

  3. #3
    Join Date
    Jun 2004
    Posts
    6
    Thanks a lot.
    After I add the "server name" behind "local\", it is ok now.
    thanks.

    Nov

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •