Thursday, March 8, 2012

Add new user at SQL Server Express Manager

I am unable to add a new user like 'xxx\ASPNET' to the Users under Security from AdventureWorks Database. I edited the SQL query which is "sp_grantlogin 'XXXX\ASPNET' " . It was completed successfully but was not able to add it to the Users.

We are still in beta so use the link below to download the developer edition and use the OLTP(online transaction processing) management studio to creat the user. Hope this helps.

http://www.microsoft.com/sql/2005/productinfo/ctp.mspx#EBAA

No comments:

Post a Comment