•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 402,519 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,710 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 3001 | Replies: 2 | Solved
 |
•
•
Join Date: Sep 2007
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hello,
I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005.
I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it created a new schema and took the old db user which doesn't exist in the new server. and now i have authentication problem accessing the database from the web and from Plesk. I'm a newbie and I don't know hot to handle db users in MSSQL Express 2005.
Please help.
I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005.
I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it created a new schema and took the old db user which doesn't exist in the new server. and now i have authentication problem accessing the database from the web and from Plesk. I'm a newbie and I don't know hot to handle db users in MSSQL Express 2005.
Please help.
•
•
Join Date: Sep 2007
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hello,
I just wanted to say that I was able to fix it with the stored procedure:
sp_change_users_login
I just wanted to say that I was able to fix it with the stored procedure:
sp_change_users_login
EXEC sp_change_users_login 'Auto_Fix', 'username', NULL, 'password'
•
•
Join Date: Jul 2008
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
•
•
•
•
Originally Posted by oracio 
Hello,
I recently bought a new server and I'm trying to move the MSSQL database from the old mssql (MSSQL 2000) to the new system MSSQL Express 2005.
I made a .bak file in the old server and restored it succesfuly in the new server. the thing is that it created a new schema and took the old db user which doesn't exist in the new server. and now i have authentication problem accessing the database from the web and from Plesk. I'm a newbie and I don't know hot to handle db users in MSSQL Express 2005.
Please help.
To add a new user into a database when it been removed, I have found that you need to goto.
Mssqlserver/security/logins
then right click and click add new login, if you set the default database ownership for this user to your database, it will automatically be installed into your database.
Hope this helps.
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- sql server 2005 express i need help<<<? (MS SQL)
- MS SQL server 2005 Express Edition (C#)
- Visual C++ 2005 Express Edition (C++)
- localtime_s, C++ 2005 Express (C++)
- Visual C++ 2005 Express Edition (C++)
- Sub Forms using VB 2005 Express Edition (VB.NET)
Other Threads in the MS SQL Forum
- Previous Thread: deleting rows
- Next Thread: database design
