SQL Server Performance

Error [DBMSLPCN]SQL Server does not exist

Discussion in 'General DBA Questions' started by TruthArmed, Mar 16, 2006.

  1. TruthArmed New Member

    I'm studying C#. I also have a copy of SQL Server 2005, but don't have my Server set up and ready for it yet, so I'm using 2000 Desktop version on XP Home Edition to learn VStudio.Net2003 w/databases. I followed the MS Press Book's C# instructions to open Northwind in SQL, but got the error above. I have the right directory- C:program FilesMicrosoft Visual Studio .Net 2003SDKv1.1SamplesSetup>, I'm using a laptop as my server (local) and entered:

    osql -S FRYWVSdotNET2003 -E -iinstnwnd.sql.

    I got the error:
    [DBMSLPCN]SQL Server does not exist or access denied
    [DBMSLPCN]ConnectionOpen (Connect()).

    What am I doing wrong?

    TruthArmed
    fry@wustl.edu
  2. dineshasanka Moderator

    http://support.microsoft.com/kb/827204/en-us
    says
    work around this problem, follow these steps:
    1.Disable the server network libraries.
    2.Start the Server Network Utility from the command line and use the Server Network Utility to enable the required server network libraries.

    Note Do not use the Server Network Utility from SQL Server Enterprise Manager to enable the server network libraries.
    To start the Server Network Utility from the command line and to enable the server network libraries by using the Server Network Utility, follow these steps:


    ----------------------------------------
    http://spaces.msn.com/members/dineshasanka
  3. TruthArmed New Member

    quote:Originally posted by dineshasanka

    http://support.microsoft.com/kb/827204/en-us
    says
    work around this problem, follow these steps:
    1.Disable the server network libraries.
    2.Start the Server Network Utility from the command line and use the Server Network Utility to enable the required server network libraries.

    Note Do not use the Server Network Utility from SQL Server Enterprise Manager to enable the server network libraries.
    To start the Server Network Utility from the command line and to enable the server network libraries by using the Server Network Utility, follow these steps:


    ----------------------------------------
    http://spaces.msn.com/members/dineshasanka


    thank you, so much dineshasanka!

    TruthArmed
    fry@wustl.edu
  4. dineshasanka Moderator

  5. TruthArmed New Member

    quote:Originally posted by dineshasanka

    welcome, it that the problem you had

    ----------------------------------------
    http://spaces.msn.com/members/dineshasanka


    Well, I disabled and enabled the Pipes and TCP/IP, restarted the service (I don't know if I restarted the instance, I restarted the SQL Service in computer management, but same result.

    Not sure about next step, thanks, again!

    TruthArmed
    fry@wustl.edu
  6. Twan New Member

    Hi ya,

    What is shown in Enterprise Manager as the name of your server and sql isntance?

    presumably FRYW is the name of your laptop? if so try -S FRYW,1433

    Cheers
    Twan
  7. satya Moderator

  8. TruthArmed New Member

    Thanks,so much! That did it. The KBA support file showed me how to put in (local)VSDOTNET in my cmd line. I started the service first from the C:program FilesMicrosoft SQL Server80Binn directory in a CMD window with the suggested command: osql -E -S (local)VSDOTNET
    which is osql -E -S (local)[InstanceName]. I found my "InstanceName" is VSDOTNET

    Then I went in the CMD window to the suggested directory C:program FilesMicrosoft Visual Studio .Net 2003SDKv1.1SamplesSetup and used what I learned in the above code line. (The C# Step by Step book said to use: osql -S YourServerVSdotNET2003 -E -iinstnwnd.sql.)
    So I wrote this command and it worked! Hallelujah!:
    osql -E -S (local)VSDOTNET -iinstnwnd.sql.

    Thank you so much for all your help!!!! You all are great! I'm glad I signed up with this group.

    God Bless

    Wendell Fry

    TruthArmed
    fry@wustl.edu
  9. satya Moderator

    Good to know the resolution and appreciate your feedback too.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page