Post reply

MS SQL Express......and connecting to it...

  • January 30, 2006 at 1:51 pm

    #115979

    I've installed MS SQL Express, created a new db, and created a new system login with sysadmin rights and a new user for the database I created....and assigned my new system login to it. (all in the MS SQL Express Mgmnt GUI)

    Trying to connect via ASP:

    MyConn.Open "Provider=sqloledb;Network Library=DBMSSOCN;Data Source=HOST;Initial Catalog=HelpDesk;User Id=bmdxtreme1;Password=password"

    Continually getting failed message:

    2006-01-30 17:39:15 W3SVC21984 HOST 67.43.5.218 POST /helpdesk/program/admin/index.asp REF_URL=|94|80004005|Cannot_open_database_requested_in_login_'HelpDesk'._Login_fails. 80 - 69.14.190.28 HTTP/1.1 Mozilla/5.0+(Windows;+U;+Windows+NT+5.1;+en-US;+rv:1.8)+Gecko/20051111+Firefox/1.5

  • January 30, 2006 at 2:09 pm

    #617826

    They say that Express listens on the local connections by default (shared memory) . You have to enable TCP/IP or Named Pipes, especially if you specify the network library explicitly.

    Use SQL Server Configuration Manager OR Surface Area Configuration tool to enable protocols

     

    Also see a bug

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q315159

    and:

    http://support.microsoft.com/kb/328383

    SQL Server clients may change protocols when the client computers try to connect to an instance of SQL Server

     

    Regards,Yelena Varsha

  • January 30, 2006 at 2:13 pm

    #617829

    Hi....

    Yes...i had enabled all protocols....just to see if it would work...and getting the same result.

    -Brian

  • January 30, 2006 at 2:15 pm

    #617830

    I just updated my post above

    Regards,Yelena Varsha

  • January 30, 2006 at 2:27 pm

    #617833

    Thanks...

    we have specified the network protocol as "DBMSSOCN", which means we only want to use TCP/IP.

    Still no luck.

Viewing 5 posts - 1 through 5 (of 5 total)

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