Create New User

[arpan]

I am using the following ConnectionString in an ASP file so that the ASP application can communicate with SQL Server 7:

CONNECTIONSTRING="Provider=SQLOLEDB;
                  User ID=SoGuest;
                  Password=SoGuest;
                  Persist SecurityInfo=True;
                  Initial Catalog=ForestDB;
                  Data Source=MyServer"

In order to ensure that my ASP page interacts with the DB ForestDB, I have to create a new user named SoGuest having the password SoGuest. To do this, I went to 'Users' under the ForestDB tree, right-clicked it & then clicked 'New Database User'. A dialog box opened up. Next when I clicked the drop-down list for assigning a login name, I find that there's not a single login name in the drop-down list as a result of which I am not being allowed to proceed forward to create the new user SoGuest. How do I create this new user? Please note that when I try to create a new user in some other database like Pubs, Northwind etc. the drop-down list of the login name shows 'BUILTIN\Administrators' as an option (there is yet another database named BillsDB wherein when I try to create a new user, the drop-down list of the login name shows 'BUILTIN\Administrators' as well as 'sa' as the options; I login to the BillsDB using 'sa' as the login name & no password). The authentication mode I am using is SQL Server & Windows NT (I am working on Windows 2000 Professional). While logging on to my machine, I use 'Administrator' (& not 'Administrators') as the username & 'ade' as the password.

Thanks,

Arpan

 

[JamesLean]

You have to create a new server login first and then map that to a user within the necessary database.

Easiest way is to use Ent Mgr, drill down to Security - Logins under your server. Right-click and choose New Login...

Enter the name, select SQL Authentication and enter the password. You can also then give that access to the database using the Database tab.

--James

 

[fireant]

Are the user logins case-sensitive?

Thanks,


Louie C.