blogsnsa.blogg.se

SQL Server installs with the BUILTIN\Administrators group as the default system administration group. Programs that do require administrator permissions, such as tools to administer the system, are started with administrator permissions after the user provides consent. Using the Standard User account helps protect the system because all applications that are run by administrators in Windows Vista do not have full administrator permissions. Windows user accounts that are members of the local Administrators group can run most applications as if they using the Standard User account. User Account Control lets users perform common tasks as non-Administrators.

"The Windows Vista operating system provides a new security feature named User Account Control (UAC). I accepted the defaults to use Windows Authentication, thinking that would be easiest since I will be the only person using the computer.Īccording to the How To article I referenced earlier,

It did not "force" me to enter an "sa" account. The article also says that SQL Server installs with the BUILTIN\Administrators group, but I don't see that anywhere. This is going to be primarily used for my self-education (assuming I can get it installed before 2008 is released!) I used "Custom" installation to install all of the sample databases. This is a brand new installation of SQL Server on a single stand-alone machine. Click Security, right-click Logins, and then click New Login.ĭUH! Connecting to an instance of SQL server is precisely what I *cannot* do! Click the Start button, point to All Programs, click Microsoft SQL Server 2005, and then click SQL Server Management Studio.ģ. I found an article on MSDN titled, "How to: Connect to SQL Server from Windows Vista," which had this advice:ġ. There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base (Microsoft SQL Server, Error: 18456)Ĭlicking on the help link yields the following helpful information: We're sorry. When I go into Management Studio and try to connect, I get the following message: I finally got SQL Server Developer Ed to install, after upgrading to Vista Ultimate.