[Newbie] Access denied on concurrent connection

• .pd.

  SSC Rookie

  Points: 29

  More actions

  June 28, 2004 at 4:35 am

  #162172

  Hello,

  I'm pretty new to SqlServer 2000.  I have a database I'm designing in enterprise manager and I'm using Iron Speed Designer to throw together a test application.

  If I'm connected to SqlServer thru Enterprise Manager, Iron Speed can't connect to read the db schema.  And vice versa.  I've checked the db properties and Single User is disabled.

  Thanks for any help,

  Cheers,

  .pd.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 28, 2004 at 6:43 am

  #512146

  DO you get an error message? ANd have you tried connecting with QA to DB while in the DB in EM to see if it gives you issues querying the DB?

• .pd.

  SSC Rookie

  Points: 29

  More actions

  June 28, 2004 at 7:01 am

  #512157

  When I have the database connected in Iron Speed and I try to connect to the Sql server from EM, I get:

  A connection could not be established to <server>\<sqlserver>

  Reason: Sql server does not exist or access denied.  ConnectionOpen.Connect()

  If I shut down Iron Speed, I can connect thru EM but then Iron Speed gives a similar error.

  Cheers,

  .pd.