Hi i have a single system in which i develop my project using visual studio 2010 and sql server 2008 R2. I am the administrator of the system.
Now i have created a local user account, i want to run the same project when login as a local user account but there are two issues coming out:
1) when open sql server management studio in a local user account, it is not showing the project database.
2) if i open sql server management studio as an administrator using Run as Administrator on the local user account, then if i run visual studio and run the project it shows login failed error on the page where database access is there.
The solution to both the problem i think is to run both the application as administrator on a local user account
I tried to create administrator mode shortcuts using scheduled task and other method but failed each time.
Well for the first issue, Instead of running ssms as administrator i created a new sql server login and created a new user for that login, i have also set windows and sql server authentication instead of windows authentication. But when i login to local
user account and try to connect with new sql login i got Sql Server Error 233 ( shared memory ). But when i run ssms as administrator on local user account and connect with same sql login it connected successfully.
well i got another way to work done. First i changes windows authentication to forms and windows authentication in sql server. After that i create a sql login and corresponding user for that login. I give appropriate roles to the user and all works well.
Thanks
Marked as answer by rajesh saharan on Nov 10, 2012 03:14 AM
rajesh sahar...
Member
225 Points
554 Posts
how to run visual studio 2010 and sql server management studio on a local user account
Nov 08, 2012 09:31 AM|LINK
Hi,
Hi i have a single system in which i develop my project using visual studio 2010 and sql server 2008 R2. I am the administrator of the system.
Now i have created a local user account, i want to run the same project when login as a local user account but there are two issues coming out:
1) when open sql server management studio in a local user account, it is not showing the project database.
2) if i open sql server management studio as an administrator using Run as Administrator on the local user account, then if i run visual studio and run the project it shows login failed error on the page where database access is there.
The solution to both the problem i think is to run both the application as administrator on a local user account
I tried to create administrator mode shortcuts using scheduled task and other method but failed each time.
Its urgent so please refer a solution
Thanks
rajesh sahar...
Member
225 Points
554 Posts
Re: how to run visual studio 2010 and sql server management studio on a local user account
Nov 09, 2012 07:00 AM|LINK
Well for the first issue, Instead of running ssms as administrator i created a new sql server login and created a new user for that login, i have also set windows and sql server authentication instead of windows authentication. But when i login to local user account and try to connect with new sql login i got Sql Server Error 233 ( shared memory ). But when i run ssms as administrator on local user account and connect with same sql login it connected successfully.
What is the problem here ?
Thanks
tdmca
Contributor
2396 Points
661 Posts
Re: how to run visual studio 2010 and sql server management studio on a local user account
Nov 09, 2012 07:11 AM|LINK
http://www.sevenforums.com/tutorials/11841-run-administrator.html
rajesh sahar...
Member
225 Points
554 Posts
Re: how to run visual studio 2010 and sql server management studio on a local user account
Nov 09, 2012 07:43 AM|LINK
need to run application as an administrator on a local user account without prompting for the administrative password....
rajesh sahar...
Member
225 Points
554 Posts
Re: how to run visual studio 2010 and sql server management studio on a local user account
Nov 10, 2012 03:14 AM|LINK
well i got another way to work done. First i changes windows authentication to forms and windows authentication in sql server. After that i create a sql login and corresponding user for that login. I give appropriate roles to the user and all works well.
Thanks