Moving Sql Server logins
Posted on 2013-01-12
I am in the midst of moving a sql server db from a GoDaddy hosting environment to Amazon Web Services. I have successfully moved the tables, stored procedures, and UDF's. The .Net application using this db is mostly running and displaying records from the new hosting environment.
However some functionality requires a user to login, and the logins were not moved. The scripts suggested by articles in the Microsoft Knowledge Base all use the "master" db, and I don't have permission to access that, so the scripts fail.
I also get a connection string problem on login attempts, which is puzzling b/c the correct fields are displayed for the functions that don't require login.
I mostly moved the tables using Import/Export from Sql Server Management Studio, and moved the stored procs using scripts from Management Studio.
I'm over my head on the logins, however, and crossing my fingers on the roles getting sorted out too.