at first i login using Windows Integrated option and created an account for sql login.
but when i tried to login using newly created account i get the following error.
Invalid username and/or password, you are using a windows login that is not your own, or server does not exist.
i am using XP SP2.Is MSDE on the same machine as Microsoft SQL Web Data Administrator?|||yes, they are on the same machine.|||Is your MSDE set up to use Mixed Mode?
By default, it will use Windows Authentication. You would have had to change this default when you installed MSDE, or after installation, through manually updating a registry setting (see this KB article:MSDE security and authentication).
You should be able to use Windows Authentication pretty readily since you are working off of your local machine.
No comments:
Post a Comment