We have an installation of SQL Server 2005 that allows windows
authentication only. None of our windows users have been explicitly
granted sysadmin rights, but my understanding was that if you are a
member of the windows administrator group you will automatically have
sysadmin rights to sql server. This does not appear to be the case.
Is there a way to get our sysadmin rights back or will we have to do a
re-installation?
Re: permissions not working ... at the windows NT level they have sysadmin rights because I did not ... It is likely that the user in question is a member of the Windows... Administrators group on the SQL Server.... (microsoft.public.sqlserver.security)
Re: Remote connection failed ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows...authentication won't work. ... (microsoft.public.sqlserver.connect)
Getting to the bottom of MSDE network connection problems ... ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ... (microsoft.public.sqlserver.msde)
Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109) ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ...SQL Server Database Services 2005 ENU SP2 ... (microsoft.public.windowsupdate)
Re: SBS Client Connection Problem ... The application that is connecting to SQL server gives "object doesn't ... In Windows Explorer I get "an error ... What's the exact problem symptom of the problematic workstation cannot ... Click the Services tab, click to check the "Hide All Microsoft ... (microsoft.public.windows.server.sbs)
