vinayak.y - Friday, September 14, 2012 8:36 AM:
I have updated SQL 2008 to SQL 2008 R2 then i resotore the previous database from old SQL 2008 so now i am faceing problem when i enter username it gives error as 'invalid object name USER'
Please reply
Thank Vinayak
PeterSchroer - Friday, September 14, 2012 8:46 AM:
Sounds like the SQL user "innovator" is no longer recognized.
Try running a SQL script:as user="sa"
use {your-database-name}
go
exec sp_change_users_login 'Update_One', 'innovator', 'innovator'
go
exec sp_grantdbaccess 'innovator','innovator'
go
exec sp_addrolemember 'db_owner','innovator'
go
vinayak.y - Friday, September 14, 2012 9:03 AM:
Thanks
problem solved ...
