I'm using Visual Studio 2005 Pro and SQLExpress that comes with it.
I have my program running fine in XP Pro OS using a window user "Glen" (Computer administrator) with Administrator rights.ÃÂ This means that I installed VS 2005 using this window user "Glen"
I created anotherÃÂ windows user "TestUser" (Limited account) in the same physical PC.
I tried to run theÃÂ programÃÂ and on the part that I need to access SQL table, I got the error [CREATE DATABASE permission denied in database 'master']
At the same time while using "TestUser" and running sqlcmd (to check if I can connect to SQL), I also got errorÃÂ HResult 0x2, Level 16, State 1.
I read alot on MSDN discussions and related links but it seems that I can't get the solution that I need.
SO HERE ARE MY QUESTIONS :
1.ÃÂ Am I allowed to run my programÃÂ using user "TestUser" since SQL is installed using "Glen" windows user?
2.ÃÂ Do I need to add access rights to "TestUser" to allow the user to have CREATE rights? (Note : for security reason, I can add other access rights except Administrator)
Thanks in advance for all you help.
View Complete Post