Post reply

access denied

  • September 8, 2003 at 2:20 am

    #59008

    Hi,

    I have the following problem.

    I have a SQL server 2000 which 2 catalogs.

    I can reach the first one but not the second.

    I can create an ODBC connexion to the both.

    The message is :

    Microsoft OLE DB Provider for SQL Server error '80004005'

    [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

    I do my tests with sa account.

    Thierry

  • September 8, 2003 at 2:40 am

    #472976

    Hi there

    Do you mean... "i have 2 named instances on a single server and can only connect to one?" not sure what you mean by "catalog" thats all. The second is probably listening on a different that you expect, check this via the sql server instances log, or, the server network manager properties. Once confirmed, check the protocols used, ports in use and re-try from there. YOu may need to configure up an alias to connect with.

    Also - all instances running ok? (just checking)

    Cheers

    Ck

    Chris Kempster

    http://www.chriskempster.com

    Author of "SQL Server 2k for the Oracle DBA"


    Chris Kempster
    www.chriskempster.com
    Author of "SQL Server Backup, Recovery & Troubleshooting"
    Author of "SQL Server 2k for the Oracle DBA"

  • September 8, 2003 at 2:59 am

    #472977

    Hi,

    I have an instance and 2 DB.

    So is it possible to have different network configuration here ? I hope not !

  • September 8, 2003 at 6:16 am

    #473003

    U mean to say that, both the Databases are on one server and you are able to access one and not the other? Also, just your user id has access permissions on the database that u can't access. I guess u need to be more descriptive about u'r problem.

  • September 9, 2003 at 2:37 am

    #473159

    hi, like satishbt said, you need to provide more info... but try this.

    in Enterprise Manager, expand the node for the database that does work and then expand the Users node.

    Check the Users that you have for that database and check to see what permissions they have.

    Now... make sure the database that does not work has the same Users and permissions.

    let us know how you get on. if the above is the same for both databases are you using the same connection string?

    sho

  • September 9, 2003 at 2:44 am

    #473160

    thank you for your answers.

    Both DB uses the same connection string.

    I use sa to be sure that it's not an autorization problem.

  • September 9, 2003 at 7:21 am

    #473204

    Do the objects in second database owned by DBO? I guees they are not.

  • September 16, 2003 at 2:10 am

    #474323

    I found !!!

    This is a problem on the cluster. The 1433 isn't listening on the virtual server but only the physical server.

    And the application doen't use the same mode of connexion with the two db !

    I didn't write this one...

    Thanks a lot !

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply