![]() Logon to SSMS from the server itself - no password required. Stop the "SQL Server" service and run "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -m" (as described in to start SQL Server in Local Only mode. I was able to solve this issue by doing the following (NOTE: I only have Windows Authentication enabled, not mixed) 1. It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.īefore I do so, does anyone know of a better approach? ![]() Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode). The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Reason: Token-based server access validation failed with an infrastructure error. Windows Authentication for the Database Engine gives the following error: The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine! Since this is a development machine, I saw no need for Mixed Mode when I did the install. I installed SQL Server 2008 Developer Edition (-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |