ASPNET login

• yaip

  SSCrazy

  Points: 2656

  More actions

  August 22, 2004 at 1:04 pm

  #162446

  I have both SSE 2005 Beta and VS.NET 2005 Beta. I have a mdf file in c:\intetpub\wwwroot\....So I do the following:

  try

  sp_grantlogin [newdell\apsnt]

  go

  use databasename

  go

  sp_grantdbacces [newdell\aspnet]

  it doesn't like the second command (use databasename). It tells me entry not found. What am I doing wrong?

• Blackdogit

  SSC Rookie

  Points: 46

  More actions

  August 23, 2004 at 9:53 pm

  #520266

  If you have a database named "yaip"

  then you need to say ...

  use database yaip

  You aren't telling SQLServer what database to use.

  HTH

  B.