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.