You are probably logged on to Vista as a member of the local administrators
group. As a security measure, Vista does not automatically provide your
administrator rights when you start a program.
You probably only have access to SQL Server because of your membership in
BUILTIN\Administrators which has a SQL Server Login (added during setup).
But without membership in the local Administrators group (blocked by Vista)
you don't have a login.
To resolve this:
1) Right-click SQL Server Management Studio and then click Run as
Administrator. This will provide you will your admin priveliges so you can
connect as a member of BUILTIN\Administrators.
2) Add yourself (domain\Nigel) as a login. (In Object Explorer under
Security\Logins). Make yourself a sysadmin (I presume).
Now you should be able to connect, without using Vista Administrator
privelges, but still be recognized as a sysadmin on the SQL Server instance.
All this will be doc'd in the next web release of Books Online along with a
tutorial walking people through this.
--
Rick Byham, MS
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view] "Nigel S" <NigelS@discussions.microsoft.com> wrote in message
news:8BC1705E-5F23-4880-9893-398DA896E944@microsoft.com...
> Hi
> I just tried to log on to SQL 2005 managment studio using windows
> authentication.
>
> It keeps giving me a logon failure with Error No 18456.
>
> I am logged on as administrator and the greyed-out user name shows
> administrator, this has only started happening since upgrading to Vista
> RC1.
>
> what's going on???
> --
> NS
