any1 can help me for this problem?
Printable View
any1 can help me for this problem?
you need create a new user SQL Login
user = a3serial
Password = dkdlxpawprhdnpc
and set DB Owner = A3ItemEvent
Enjoy !!!
If ID already exists, then delete it and create one again.
Please do look around before posting.
How to creat a NEW LOGIN and PASSWORD WHERE TO CREAT PLEASE INFORMATION IN DETAIL
lolz ..
open enterprice manager
go to security tab (found in left hand side)
press Action>New Login
[this is the process where many do a mistake ..... do this process carefully]
put
name = a3serial
Password = dkdlxpawprhdnpc
Database = A3ItemEvent
select the database access tab & tick the a3ItemEvent, then tick the db_owner
& press ok
it will ask for the password again put dkdlxpawprhdnpc & press ok
(some times it gives an error "Login serial already exists" .. if u too get this error message then go to Databases>A3itemEvent>users & delete the a3serial there... then again do the process mentioned above)
& damn cant u search a little bit before posting??????
its posted atleast 15 times inthe forum still......
Refer to a manual on SQL Server 2000. You should know.Quote:
Originally Posted by abhishek
Thank You.