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!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
db restore doesn't work
I restored a SQL db to another server (not the server where backup was performed). Now my application fails to connect to target server since 2 SQL accounts that application looks for have inappropriate permissions after the restore. How can I reinstate SQL users and roles on the restored db...- mbs611
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Setup and Administration
-
SQL 2000 db restore
I restored a SQL db to another server (not the same server where backup was performed). I noticed that the users and roles asssiged to db on the source server are missing after db restore on target server. The way I found is the application failed to connect to target server since 2 SQL...
