Connecting to MS SQL Express Database...

• Brian Dittmer

  Grasshopper

  Points: 16

  More actions

  January 30, 2006 at 12:30 pm

  #68642

  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:

  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

• bledu

  SSChampion

  Points: 12335

  More actions

  February 2, 2006 at 8:18 am

  #618411

  i think if you remove the network library it should work.

  ---

  Everything you can imagine is real.
  

• vadba

  SSChampion

  Points: 11133

  More actions

  February 2, 2006 at 10:38 am

  #618449

  DBMSSOCN was part of SQL Server 7. It is not used with later versions of SQL Server. Since the default library is TCP/IP, the above suggestion should work.

   

• V.Kadal Amutham

  Old Hand

  Points: 363

  More actions

  February 4, 2006 at 8:19 am

  #618849

  If you use SQL Server 2005 and Visual Studio 2005 you meed not write any connection string

  V.Kadal Amutham

  vkadal@gmail.com