Post reply

Access denied

  • April 18, 2009 at 11:09 pm

    #136795

    I need to move data from my test envirnoment in a MS SQL Server 2000 database to a staging envirnoment, also a MS SQL Server 2000 database. I created a linked server and tried to use import, export, and insert command, but both failed. I get an Access Denied error.

    Does anyone know why I would receive this message, and how I can fix it?

    Thanks

  • April 19, 2009 at 5:10 am

    #980330

    soofy21 (4/18/2009)

    I need to move data from my test envirnoment in a MS SQL Server 2000 database to a staging envirnoment, also a MS SQL Server 2000 database. I created a linked server and tried to use import, export, and insert command, but both failed. I get an Access Denied error.

    Does anyone know why I would receive this message, and how I can fix it?

    Thanks

    Do you have the required permissions. The easiest way is to go for backup and restore method? What permissions have you got on both the servers?

  • April 19, 2009 at 10:28 am

    #980358

    Hi Krishna,

    Yes, I have the required permission. I used my domain login and also I tried with my SQL Login. I have to transfer only few tables and not the entire database, so I can't do backup and restore.

    Thanks,

    Soofy

  • April 19, 2009 at 10:40 am

    #980364

    Could you post the exact error for me please?

  • April 19, 2009 at 11:54 am

    #980374

    Here it is-

    ERROR CODE: Microsoft OLE DB provider for SQL Server

    ERROR DESCRIPTION: [DEBNITLIB] Connection open (connect)) SQL Server doesn’t exist or access denied

    Context: Error during the initialization of SQL SERVER

    Thanks,

  • April 19, 2009 at 12:30 pm

    #980378

    soofy21 (4/19/2009)

    Hi Krishna,

    Yes, I have the required permission. I used my domain login and also I tried with my SQL Login. I have to transfer only few tables and not the entire database, so I can't do backup and restore.

    Thanks,

    Soofy

    sounds like a job for dts or possibly bcp.

    ---------------------------------------------------------------------

  • April 19, 2009 at 9:18 pm

    #980502

    That error means you can't connect. It could be the server is down or you cannot connect from the machine you're trying to connect.

    If you use SSMS, can you connect directly to both servers to administer them?

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

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

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