Friday, April 15, 2011

How to set Windows Authentication on database imported into SQL Server 2000

Database cannot be seen when creating datasource in .NET - pre-existing databases can be seen.

How do I set the permissions on the imported database?

From stackoverflow
  • If you imported the database from another instance of SQL Server, the users in the database are probably not being mapped correctly to the login on server. Even though they may have the same name, SQL Server will give each user a unique ID for that specific server.

    The fastest way to resolve the issue is to delete and recreate the users for your database using SQL or Enterprise Manager.

    mmcglynn : Thank you. Never easy, I guess.

0 comments:

Post a Comment