Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Transfer Users

Status
Not open for further replies.
Bell1991

Bell1991

Programmer
Aug 20, 2003
386
US
I am in the process of migrating everything to 2005. I detached all the databases on one sever and attached them on the new server. I am not attempting to transfer the logins from the old server to the new server and i get an error:

Property DefaultDatabase is not available for Login [LoginName]. This property may not exist for the object, or may not be retrievable because due to insufficient rights

The database this user has access to is on the new server.

Any suggestions?
 
Status
Not open for further replies.

Similar threads

mahi2016
  • Locked
  • Question
SSIS FTP transfer date and timestamp filename
Replies
1
Views
109
jjefferson
jjefferson
Savil
  • Locked
  • Question
Transfer DB Task Drops Triggers
Replies
0
Views
40
Savil
Savil
cbw971
  • Locked
  • Question
Transfer Database Task Error - Number of files must be the same/Index
Replies
0
Views
49
cbw971
cbw971
wanderingaround
  • Locked
  • Question
multiple users running the same SSIS package simultaneously- possible?
Replies
1
Views
131
fredericofonseca
fredericofonseca
McGurk
  • Locked
  • Question
SSIS 2008 Transfer Database Task failed
Replies
2
Views
97
McGurk
McGurk

Part and Inventory Search

Sponsor

Back
Top