create new user on MS SQL 2005 Professional edition problem

Hi Everyone,

Can you please kindly tell me how to create a new user on the MS SQL 2005 Professional edition for accessing the existing database called VCalendar?

thanks for your time and help!

Jiimmy

1. Create a login: Open Management Studio->MySQLInstance->Security->Logins->New Login, type the name for the new login, and select a default database for the new login.

2. In the 'User Mapping' panel, check the 'Map' checkbox for the databases (VCalendar) that you want the login to access. Make sure the new login has user mapping to its default database.

3. Click 'OK' to save the new login. You can press F1 for help in the process.

|||

Iori_Jay:

1. Create a login: Open Management Studio->MySQLInstance->Security->Logins->New Login, type the name for the new login, and select a default database for the new login.

2. In the 'User Mapping' panel, check the 'Map' checkbox for the databases (VCalendar) that you want the login to access. Make sure the new login has user mapping to its default database.

3. Click 'OK' to save the new login. You can press F1 for help in the process.

Thank you very much for you help! I will try it tonight.

Jimmy

|||

Iori_Jay:

1. Create a login: Open Management Studio->MySQLInstance->Security->Logins->New Login, type the name for the new login, and select a default database for the new login.

2. In the 'User Mapping' panel, check the 'Map' checkbox for the databases (VCalendar) that you want the login to access. Make sure the new login has user mapping to its default database.

3. Click 'OK' to save the new login. You can press F1 for help in the process.

No it does not work. I am using MS SQL Server 2005 Professional edition. Thanks,

Jimmy

|||

Go to the new security section inside VCalendar database and create the User but that just creates the database login, then go to the Management section of Management Studio and then create the server login for the User. The reason is there are two permissions in SQL Server database permissions in the new security section within the database and the Server permissions in the Security section in the management section of Management Studio. Another option is to use System Stored Procssp_adduser and sp_addlogin, try the links below for details. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms181422.aspx

http://msdn2.microsoft.com/en-us/library/ms173768.aspx

|||

Caddre:

Go to the new security section inside VCalendar database and create the User but that just creates the database login, then go to the Management section of Management Studio and then create the server login for the User. The reason is there are two permissions in SQL Server database permissions in the new security section within the database and the Server permissions in the Security section in the management section of Management Studio. Another option is to use System Stored Procssp_adduser and sp_addlogin, try the links below for details. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms181422.aspx

http://msdn2.microsoft.com/en-us/library/ms173768.aspx

First, thanks for your time and help! I try two ways and both of the ways don't work.

1st way I try:

Right click on Security of VCalendar -> select New -> select User (Database User - New window open) Now I enter jimmy_user into the User name: box and I enter jimmy_login into the Login name: box. And I got an error message such as: "Create failed for User 'jimmy_user'. .... 'jimmy_login' is not a valid login or you do not have permission."

2nd way I try:

expand SBTOR101EV\SQLEXPRESS -> expand Security -> Right click on Logins -> Choose New Login (Login - New window open) Now enter jimmy_login into the Login name: box -> And then select Windows authenticaion -> click on OK. And I got an error message such as:

"Create failed for Login 'jimmy_login'. .... 'jimmy_login is not a valid Windows NT name. Give the complete name:
<domain\username>."

Please just let me know if you find a way to solve me problem. Thanks again!

I am not 100% understand the following two links so that I didn't try it.

http://msdn2.microsoft.com/en-us/library/ms181422.aspx

http://msdn2.microsoft.com/en-us/library/ms173768.aspx

Jimmy

|||

MayLam:

2nd way I try:

expand SBTOR101EV\SQLEXPRESS -> expand Security -> Right click on Logins -> Choose New Login (Login - New window open) Now enter jimmy_login into the Login name: box -> And then select Windows authenticaion -> click on OK. And I got an error message such as:

"Create failed for Login 'jimmy_login'. .... 'jimmy_login is not a valid Windows NT name. Give the complete name:
<domain\username>."

Look at the error message, which indicates that you choose Window Authentiaction (should be something like domain\account) as the login type and that's why 'jimmy_login' is no valid. So please select SQL Server Authentication for the new login 'jimmy_login', and do remember to add necessary database mapping for the new login. For more information about Authentication Modes, you can take a look at this article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp

|||

I think the error means SQL Server wants the login created before the database permissions. So you can use the gui or modify the code in the links below for your server and database. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms189751.aspx

http://msdn2.microsoft.com/en-us/library/ms173463.aspx

|||

Iori_Jay:

MayLam:

2nd way I try:

expand SBTOR101EV\SQLEXPRESS -> expand Security -> Right click on Logins -> Choose New Login (Login - New window open) Now enter jimmy_login into the Login name: box -> And then select Windows authenticaion -> click on OK. And I got an error message such as:

"Create failed for Login 'jimmy_login'. .... 'jimmy_login is not a valid Windows NT name. Give the complete name:
<domain\username>."

Look at the error message, which indicates that you choose Window Authentiaction (should be something like domain\account) as the login type and that's why 'jimmy_login' is no valid. So please select SQL Server Authentication for the new login 'jimmy_login', and do remember to add necessary database mapping for the new login. For more information about Authentication Modes, you can take a look at this article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp

No this way does now work. Thanks for letting me know.

Jimmy

|||

Caddre:

I think the error means SQL Server wants the login created before the database permissions. So you can use the gui or modify the code in the links below for your server and database. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms189751.aspx

http://msdn2.microsoft.com/en-us/library/ms173463.aspx

No this way does not work. Thanks for letting me know.

Jimmy

|||

How about I uninstall MS SQL Server 2005 and then re-install MS SQL Server 2005. And I hope that it will ask me to choose a username and choose a password during the installation. Will it ask me choosing a username and choosing a password during the installation?

Thanks,

Jimmy

|||

MayLam:

Iori_Jay:

MayLam:

2nd way I try:

expand SBTOR101EV\SQLEXPRESS -> expand Security -> Right click on Logins -> Choose New Login (Login - New window open) Now enter jimmy_login into the Login name: box -> And then select Windows authenticaion -> click on OK. And I got an error message such as:

"Create failed for Login 'jimmy_login'. .... 'jimmy_login is not a valid Windows NT name. Give the complete name:
<domain\username>."

Look at the error message, which indicates that you choose Window Authentiaction (should be something like domain\account) as the login type and that's why 'jimmy_login' is no valid. So please select SQL Server Authentication for the new login 'jimmy_login', and do remember to add necessary database mapping for the new login. For more information about Authentication Modes, you can take a look at this article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_47u6.asp

No this way does now work. Thanks for letting me know.

Jimmy

Sorry I mean this way does not work. Thanks.

Jimmy

|||

How about I uninstall MS SQL Server 2005 and then re-install MS SQL Server 2005. And I hope that it will ask me to choose a username and choose a password during the installation. Will it ask me choosing a username and choosing a password during the installation?

Thanks,

Jimmy

|||

MayLam:

How about I uninstall MS SQL Server 2005 and then re-install MS SQL Server 2005. And I hope that it will ask me to choose a username and choose a password during the installation. Will it ask me choosing a username and choosing a password during the installation?

Thanks,

Jimmy

What is did is that

- uninstall the MS SQL Server 2005 Professional edition

- and then install the MS SQL Server 2005 Express edition.

And it works.

Thanks for all your time and all your help!

Jimmy