...is not a valid login or you do not have permission

Question

I created a database on colleagues laptop [jimmyjoe1] as the 'USER'

I have moved a database from his server to my own, now i cannot connect, only getting - ...is not a valid login or you do not have permission.

 

I have tried changing to USER to the name of my laptop but i understand it could have something to do with SIDs?

 

Im pretty much a noob in the use of mysql so laymans terms very welcome :p

 

 

Thanks

Answer 1

Check this script which will fix the orphan users http://gallery.technet.microsoft.com/Orphan-Users-FIX-82f5c6df

---

http://uk.linkedin.com/in/ramjaddu

Answer 2

HI Ritchie !

Make sure your user has  'dbcreator' pemission when you are restoring the Database to destination. Please see the bewlo article;

http://blog.sqlauthority.com/2007/02/25/sql-server-restore-database-backup-using-sql-script-t-sql/

http://msdn.microsoft.com/en-us/library/ms186858.aspx

 

Also, you can add new user to new database by right clicking database, go to Security -> Users -> New User and assign roles to your user.

Please let me know if this doesn’t work for you. Hope I have answered you correctly.
 
Thanks,
Hasham

Answer 3

It sounds like you might be having trouble connecting to SQL Server, not just the database. If so, see Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty