10-29-2010, 02:29 PM
Hi,
Though this is database query, i'm running this as part of my vb script, i've created sqldatabase user using
SQL = "Create Login sample1 WITH PASSWORD = 'Welcome1' , DEFAULT_DATABASE = DEMO "
The database user gets created successfully, however it is not mapped with the database when i verify.
using sql server 2005 sp1, i've verified in sql management studio after database user creation whether the user is mapped or not, and its not.
Though this is database query, i'm running this as part of my vb script, i've created sqldatabase user using
SQL = "Create Login sample1 WITH PASSWORD = 'Welcome1' , DEFAULT_DATABASE = DEMO "
The database user gets created successfully, however it is not mapped with the database when i verify.
using sql server 2005 sp1, i've verified in sql management studio after database user creation whether the user is mapped or not, and its not.