安装时通过Windows 身份验证时 提示无效的登录信息,一个或多个实例未通过验证。
但是我通过SQL Server Management Studio却可以通过Windows 身份验证成功登陆安装sp2时也是一样的。。
求高手帮忙!!都花了一天时间了!
但是我通过SQL Server Management Studio却可以通过Windows 身份验证成功登陆安装sp2时也是一样的。。
求高手帮忙!!都花了一天时间了!
10/15/2009 18:15:29.375 SQL Service MSSQLServer was previously running, ready for authentication
10/15/2009 18:15:29.437 SQL Agent Service SQLSERVERAGENT was not previously running
10/15/2009 18:15:29.609 Authenticating user using Windows Authentication
10/15/2009 18:15:29.640 Validating database connections using Windows Authentication
10/15/2009 18:15:29.812 Pre-script database connection check was successful - proceeding with script execution
10/15/2009 18:15:29.984 Received sysadmin status for instance: MSSQLSERVER
10/15/2009 18:15:30.015 Validating database connections using Windows Authentication
10/15/2009 18:15:30.171 Pre-script database connection check was successful - proceeding with script execution
10/15/2009 18:15:30.187 User authentication was successful
10/15/2009 18:15:30.234 Error, cannot determine sysadmin status for instance: MSSQLSERVER
10/15/2009 18:16:07.515 Registry: Opened registry key "System\CurrentControlSet\Control\Session Manager"
10/15/2009 18:16:07.546 Registry: Cannot read registry key value "PendingFileRenameOperations"
10/15/2009 18:16:08.125 Authenticating user using Windows Authentication
10/15/2009 18:16:08.156 SQL Service MSSQLServer was previously running, ready for authentication
10/15/2009 18:16:08.218 SQL Agent Service SQLSERVERAGENT was not previously running
10/15/2009 18:16:08.390 Authenticating user using Windows Authentication
10/15/2009 18:16:08.406 Validating database connections using Windows Authentication
10/15/2009 18:16:08.562 Pre-script database connection check was successful - proceeding with script execution
10/15/2009 18:16:08.734 Received sysadmin status for instance: MSSQLSERVER
10/15/2009 18:16:08.781 Validating database connections using Windows Authentication
10/15/2009 18:16:08.937 Pre-script database connection check was successful - proceeding with script execution
10/15/2009 18:16:08.953 User authentication was successful
10/15/2009 18:16:09.000 Error, cannot determine sysadmin status for instance: MSSQLSERVER这是出错的log
以下是sql身份登录报错:10/15/2009 18:29:57.703 Authenticating user using SAPWD
10/15/2009 18:29:57.765 SQL Service MSSQLServer was previously running, ready for authentication
10/15/2009 18:29:57.812 SQL Agent Service SQLSERVERAGENT was not previously running
10/15/2009 18:29:58.031 Authenticating user using SAPWD
10/15/2009 18:29:58.062 Validating OSQL connections using SAPWD
10/15/2009 18:29:58.218 Pre-script database connection check was successful - proceeding with script execution
10/15/2009 18:29:58.375 Received sysadmin status for instance: MSSQLSERVER
10/15/2009 18:29:58.406 Validating OSQL connections using SAPWD
10/15/2009 18:29:58.562 Pre-script database connection check was successful - proceeding with script execution
10/15/2009 18:29:58.578 User authentication was successful
10/15/2009 18:29:58.625 Error, cannot determine sysadmin status for instance: MSSQLSERVER
10/15/2009 18:15:30.234 Error, cannot determine sysadmin status for instance: MSSQLSERVER
10/15/2009 18:16:07.515 Registry: Opened registry key "System\CurrentControlSet\Control\Session Manager"
10/15/2009 18:16:07.546 Registry: Cannot read registry key value "PendingFileRenameOperations" 从错误信息上看安装时的身份验证是成功的,问题在于无法确定 sysadmin 固定服务器角色状态。经过 baidu、google、technet 搜索“cannot determine sysadmin status”关键字后,发现有人出现过这样的问题,但都没有解决。有人也将这个错误也被反映给了微软(可能是 bug),但至今没有答复。建议楼主也搜索一下,看看有没有解决方法。祝好运。
重新创建了reporting server 数据库,处理数据库名外,配置全部选择默认,然后成功了!呵呵
原来我的数据库安装语言选择的是简体中文(默认的是Enlish),一路下来,ok!
太难找了,呵呵。。
希望对遇到同样问题的朋友有所帮助!!