Post reply

SQL Server Does not exist or access denied. Connection Open(ConnectionI())

  • May 10, 2006 at 4:28 am

    #113425

    I am using Windows XP Home Service Pack 2 Edition and installed SQL Server 2000 Client. When i tried to register NEW SQL Server registration i am getting the following message

    SQL Server Does not exist or access denied. Connection Open(ConnectionI()). In the same machine i could run primavera engineering/construction version 5.0 software with Microsoft SQL server Desktop Engine(PRIMAVERA) as backend without any problem.

    Can someone assist me how to resolve the above issue. My main purpose is to open an accounts software using the SQL server 2000.

    Thanking in anticipation.

    Daya

     

  • May 10, 2006 at 5:12 am

    #636955

    Hi Daya,

    What kind of user account are you using to register the SQL server?

    As it is a MSDE version of SQL maybe you need to have admin rights to register it.

    regards,

    Holger

  • May 10, 2006 at 5:48 am

    #636964

    You are probably using Windows Firewall. If so, it blocks the SQL Server ports by default (1433 and 1434).

    Check that first. Next do you have a login on the SQL Server that you are trying to access? Is it Windows Authentication or SQL Server Authentication?

    -SQLBill

  • May 10, 2006 at 6:16 am

    #636975

    Thanks for all to reply.

    I am using Windows XP Home (Service Pac 2), got Administrator type account, so i can install programs etc.,

    1. I checked the windows firewall, it has been turned off already

    2. I tried with both options but no use, i use "sa" as login for SQL Server Authentication.

    I could run SQL server MSDE which comes as built-in package for Primavera 5.0 which runs very well. but when i tried to install SQL server 2000 client only option and when i tried to configure/ register the server i have got the error message, SQL server doesn't exist or access denied.........

    i need further help from this point.

    thanking in anticipation.

    daya

  • May 10, 2006 at 6:25 am

    #636978

    Dear SQLBill,

    Before the installation of SQL Server 2000, i installed Offline exploer trial version in my laptop, which has caused all the folders as read-only type in the local disk C: (Hard Disk). even after uninstallation i could not remove the read-only option for folders. whether this will cause any trouble to new SQL server registration???.

    if you leave me your email id to d_dayanidhi@hotmail.com i could contact you or else, you can leave your email id in this forum so that i could send some screen shots to explain my situation.

    Best Regards

    Daya

     

  • May 10, 2006 at 7:09 am

    #636986

    This message is very generic and can happen because of many reason. I would start troubleshooting this by:

    1. Service is up and running?

    2. What name you are giving while connecting to server?

    3. Which protocol you are using to connect to SQL.

    4. Whether SQL is listening on that Protocol?

    Any many more...

    meet me at bmlakhani@yahoo.com if you can...

     

     

  • May 10, 2006 at 7:55 am

    #637001

    Dear Balmukund,

    I have sent the screen shot to your email id, pls go through it and advise me further.

    Thanks

    Daya

  • May 10, 2006 at 11:48 pm

    #637155

    Place your Windows CD in the drive, choose the <cd drive>:\VALUEADD\MSFT\NET\NETBEUI folder, right-click NETNBF.INF and choose install. You will be limited in connecting to SQL Server using the named pipes network library, which is not routable outside of the LAN.

    Your only other option is to upgrade to XP Pro as XP Home has none of the network features found in the Pro edition.

    Andy

  • May 11, 2006 at 1:55 am

    #637171

    Thanks for your reply, i have installed NETNBF.INF file as you said, but i could not still find the server running. anyhow i will try to upgrade to XP pro and let me inform you the situation.

  • May 11, 2006 at 5:51 am

    #637197

    I have upgraded to Windows XP Pro SP2, but the problem still persists..............

  • May 11, 2006 at 5:56 am

    #637199

    1. You say you installed the client tools...do you have a database installed somewhere?

    2. Where is the database installed? Can you go to that system and log into the database?

    3. What version of MDAC do you have installed? The latest version is MDAC 2.8.1. Microsoft has a tool called Component Checker that you can run to find the MDAC version. Run this on your client machine and the SQL Server machine, they should match.

    4. Have you tried to register the server by using the IP address?

    -SQLBill

  • May 11, 2006 at 8:34 am

    #637273

    Try using the cliconfg utility to add an entry for the server you want to use and set its network library to multiprotocol.  I needed to do that to use a msde on my xp pc.  If that's your issue, you'll also need to always select (local) when using dts.

  • May 11, 2006 at 11:51 am

    #637355

    Can you ping the server either by server name or ip?

    Check to see if the domain is in your dns list.

  • July 4, 2007 at 4:34 am

    #717113

     i have similar problem i am trying to run P% on a standalone computer running windows 2000

    i can see the server running in the task bar but i could not connect to the server

    i have an administative account

    please help

    rohininilayam@yahoo.com

     

     

     

  • July 4, 2007 at 6:26 am

    #717136

    Check what is the type of authentication that is being used. Might be you are running in windows mode and trying to use sql ids.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 15 posts - 1 through 15 (of 16 total)

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