![]() The SQL Server FullText Search service, for some reason, cannot be started. When log into Database engine, login failed for machinename\theWinLogin, which has the admin right.The application log basically indicates the SQL Server Service account (local system account) does not have the permission to run the service. After installation, I encounter the following issues: I decided to install SQL Server 2005 (64-bit) to the same box as well. In order to check if the undocumented function sys.fn_PhysLocFormatter runs in SQL Server 2005. A seemly trivial change may eat up hours of your time if not done appropriately. Pause, think, backup, test before making any changes in SQL Server. Login into SQL Server in Windows authentication, it worked! create a login based on the Windows login with the correct PC name (a windows admin) with sysadmin roleĥ. ![]() Login to SQL server with the new login created in the SQLCMDĤ. (2) try newly created SQL server login to start the SQL Server service, wow, it worked!ģ. (1) get an error for time out using the local system account when starting the service (4) create a SQL Server login, add it to the sysadmin role. (3) use SQLCMD -E (yes, I logged into as a local windows admin) So they cannot create new sysadmin logins or enable the sa account. Unfortunately, although they log into SQL Server, but they did not have the sysadmin rights. ![]() I switched to other windows logins with admin rights. ![]() I cannot be back to SQL Server anymore with any existing logins. So I was completely locked out off the box. Bad for me, the deleted login was the only one with sysadmin rights in SQL Server. But the login in SQL Server still uses the old pc name. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |