Professional Web Applications Themes

SQL Server does not exist or access denied. - ASP.NET General

Here is a new error I am getting. I have a development computer (Server 2000, SQL2000, .NET 1.1) I have a production computer (Server 2003, SQL2000, .NET 1.1) When I run my solution on the development box pointing to the database on the development box - no problem. When I run my solution on the production box pointing to the database on the production box - no problem. When I run my solution on the production box pointing to the database on the development box - no problem. When I run my solution on the development box pointing to the ...

  1. #1

    Default SQL Server does not exist or access denied.

    Here is a new error I am getting.

    I have a development computer (Server 2000, SQL2000, .NET 1.1)
    I have a production computer (Server 2003, SQL2000, .NET 1.1)

    When I run my solution on the development box pointing to the database on
    the development box - no problem.
    When I run my solution on the production box pointing to the database on the
    production box - no problem.
    When I run my solution on the production box pointing to the database on the
    development box - no problem.

    When I run my solution on the development box pointing to the database on
    the production box - problem.

    Here is the error message:
    Exception Details: System.Data.SqlClient.SqlException: SQL Server does not
    exist or access denied.

    Here is my connection string in the web.config file:
    <add key="ConnectionString" value="user id=ssboot; password=pwd; initial
    catalog=archi; data source=scics-dotnet1,1433; Network Library =dbmssocn;
    Connect Timeout=5; pooling=true"/>

    I have am out of ideas on what to try to fix this problem. From my
    development box I have no problem connecting to the production database
    through server explorer in the .NET IDE.

    Any help would be appreciated.

    Thanks,
    Marc.



    Marc Guest

  2. #2

    Default SQL Server does not exist or access denied.

    Hi

    first check whether r u able to connect to sql server
    using enterpraise manager. if so you should be able to
    connect to sql server using .NET.

    Ravikanth

     
    SQL2000, .NET 1.1) 
    1.1) 
    to the database on 
    the database on the 
    the database on the 
    to the database on 
    SQL Server does not 
    password=pwd; initial 
    Library =dbmssocn; 
    problem. From my 
    production database 
    Ravikanth[MVP] Guest

  3. #3

    Default SQL Server does not exist or access denied.

    Yes, I can connect to the database through server manager
    in the .NET IDE, sql enterprise manager and query yzer.

    Thanks,
    Marc.
     
    >SQL2000, .NET 1.1) 
    >1.1) 
    >to the database on 
    >the database on the 
    >the database on the 
    >to the database on 
    >SQL Server does not 
    >password=pwd; initial 
    >Library =dbmssocn; 
    >problem. From my 
    >production database 
    >.
    >[/ref]
    Marc Guest

  4. #4

    Default Re: SQL Server does not exist or access denied.

    Marc,

    I was getting same error (not in .NET) but it came down to security setting
    for the SQL.
    Instead of using mixed mode authentication I had Windows authentication
    only.

    regards,
    Filip

    "Marc" <com> wrote in message
    news:phx.gbl... 
    the 
    the 


    Filip Guest

Similar Threads

  1. SQL Server does not exist or access denied.
    By John Toop in forum ASP.NET Security
    Replies: 12
    Last Post: August 31st, 01:57 PM
  2. Error: SQL Server does not exist or access denied
    By Dave Navarro in forum ASP Database
    Replies: 14
    Last Post: April 14th, 04:39 PM
  3. Replies: 3
    Last Post: February 20th, 11:57 AM
  4. SQL Server does not exist or access denied
    By Bassel Tabbara [MSFT] in forum ASP.NET General
    Replies: 8
    Last Post: August 28th, 02:28 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139