sql server 2008 - Problems In Connection String with different Users in System for Windows Authentication -


hi connection string:

windows authentication:

<add name="strconnection" connectionstring="data source=murali\sqlexpress;initial catalog=ecowhisk28113;integrated security = true" providername="system.data.sqlclient;"/> 

i run applications in system's administrator means working correctly same application run in system's users means error.

'cannot open database "ecowhisk28113" requested login. login failed. login failed user 'murali\murali'. '

i want know whether connection string error or system settings problem...

please solve bug....

thanks.....

you need login ssms , grant users accessing database proper permissions database. can check opening ssms connecting sql server expanding security folder right click on logins , create new login 'murali\murali'and add new login access ecowhish28113 database. depending on type of access required need add login database roles in db well.


Comments

Popular posts from this blog

jquery - How can I dynamically add a browser tab? -

node.js - Getting the socket id,user id pair of a logged in user(s) -

keyboard - C++ GetAsyncKeyState alternative -