Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  MSDE to SQL Server Express - User issue

Author  Topic  din112 Starting Member 6 Posts Posted - 2005-12-14 : 11:39:25 Hi, I am in the process of moving our website databases from MSDE to SQL Server 2005 Express. The only way I have found of doing this while keeping all the stored procedures and functions etc. is to restore to the SQL Express instance from a MSDE backup. This works fine (I think), but the users are not working correctly. I cannot see where to add a new user who would have access to the new SQL Express instance. I am using Sql Server 2005 Management Studio (Not express edition). I am connecting to the databases with a connection string from asp.net pages that use the old MSDE user name and password to connect. Any help on this is greatly appreciated. Cheers, Din