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
Post a Comment