PFAW: Senator Bennet Caved to the Far Right by Returning his Blue Slip on Allison Eid FOR IMMEDIATE RELEASE: September 6, 2017 Contact: Courtney Neale at People For the American Way
View the SQL Server error log by using SQL Server Management Studio or any text editor. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.
When you move a database from one server that is running SQL Server to another server that is running SQL Server, a mismatch may occur between the security identification numbers (SIDs) of the logins in the master database and the users in the user database. To add an integrated SQL Server login, see the sp_grantlogin topic in SQL Server Books Online. 2  Download the MapSids.exe file, and then extract the Sp_sidmap.sql and Readme.txt files. 3  Log on to the server that is running SQL Server as a system administrator, and then run the Sp_sidmap.sql file in the user database.