Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
naughtytoon123
Starting Member
3 Posts |
 Posted - 2009-09-05 : 02:48:49
|
| Hi i am migrating from sql 2000 to sql 2008 i backed up my database without any issues with compatibility of 80 but the schema is showing the old user details in thae user and if i am creating a new user i am getting error while logging in with the user please help what needs to be done nextNaman Thakral |
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-09-05 : 03:13:58
|
| How did you migrate your database, did you migrate the logins/users? What's the error you are getting? |
 |
|
|
naughtytoon123
Starting Member
3 Posts |
Posted - 2009-09-05 : 03:49:37
|
| i just backed up the .bak file and then restored it to the new server and created a same user name as it was there on sql 2000 and gave select execute take ownership view database state and view definition permissions then tried to connect to sql remotely i was getting error"ERROR 229: SELECT Permission Denied On Object 'sysobjects', Database "While reading the databaseNaman Thakral |
|
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-09-05 : 12:43:22
|
| Are you sure you haven't granted db_denydatareader? |
|
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-09-05 : 12:43:33
|
| Are you sure you haven't granted db_denydatareader? Please check. |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-05 : 13:01:20
|
I hope that Tara will come to see this.I can imagine this has to do with the SID (or SSID?) but I am not sure.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
naughtytoon123
Starting Member
3 Posts |
Posted - 2009-09-05 : 22:25:58
|
| yes i checked it twice but i havent given any permission to db_denyreaderNaman Thakral |
|
|
|
|
|
|
Sql backup issue