Re: SQL Server 2008 set up

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Probably you did not install your SQL Server 2008 Instance under this ("Test") Windows User Account and probably you did not add this user to the "SQL Server System Administrators" list during SQL Server 2008 Setup. So, you can't connect to your SQL Server 2008 instance using this user's Windows account.

To accomplish this, connect to your SQL Server instance under a Windows account which was added to the SQL Server System Administrators list by you during installation. Then create a Login for this Windows user ("Test") or for a Windows Group which includes this Windows user account.

Note:
The list I'm talking about is in the SQL Server 2008 Setup's: Database Engine Configuration pane's Account Provisioning tab.

--
Ekrem Önsoy




"Alex. O. Koranteng" <AlexK@xxxxxxxxxxxxxxxx> wrote in message news:7B7DD9C7-E5F7-4C22-885E-E7468FDCCCF4@xxxxxxxxxxxxxxxx
Gail,

Thanks for response. I went ahead and installed SQL 2008 Dveloper edition.
The install completed successfully. When i open Management Studio, I get this
message Login failed for user Alex-PC\TEst;(SQL Server error:18456)
Any ideas



"Gail Erickson [MS]" wrote:

Hi Ekrem,
Yes, I misunderstood the original problem. Please re-activate your connect
bug
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=363151
and state that the documentation is wrong in this area. That way the bug
will get assigned to the writer.

--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of SQL Server 2005 Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
Download the latest version of SQL Server 2008 Books Online from
http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
news:4DB85365-EC6E-4604-A254-FF72AACBADA8@xxxxxxxxxxxxxxxx
> Hello Gail,
>
> I think you did not follow this thread from the first message. The > problem
> with the System Requirements is that, on the Operating System > Requirements
> list of SQL Server 2008 Enterprise Edition (at least the x86's, because > my
> test was on this architecture), Client Operating Systems (XP, Vista) > are
> not listed. However, Enterprise Edition of SQL Server 2008 can be
> installed on Client OSs.
>
> If you take a look at my first port under this thread, you'll see that > an
> MS guy from Connect confirms this.
>
> -- > Ekrem Önsoy
>
>
>
>
> "Gail Erickson [MS]" <gaile@xxxxxxxxxxxxxxxxxxxx> wrote in message
> news:uAHIhQOJJHA.4240@xxxxxxxxxxxxxxxxxxxxxxx
>>I just verified that the updated (August 2008) Books Online topics are >>now
>>on MSDN. So http://technet.microsoft.com/en-us/library/ms143506.aspx >>has
>>the corrected OS information.
>> -- >> Gail Erickson [MS]
>> SQL Server Documentation Team
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights
>> Download the latest version of SQL Server 2005 Books Online from
>> http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
>> Download the latest version of SQL Server 2008 Books Online from
>> http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
>>
>> "Gail Erickson [MS]" <gaile@xxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:u4onf8$IJHA.728@xxxxxxxxxxxxxxxxxxxxxxx
>>> Yes, it looks like the MSDN topics haven't been updated yet, but that
>>> should be happening soon (the next day or so I believe). The folks >>> that
>>> can confirm this are not in the office today, but I'll repost when I
>>> can get some more concrete information from them.
>>>
>>> -- >>> Gail Erickson [MS]
>>> SQL Server Documentation Team
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights
>>> Download the latest version of SQL Server 2005 Books Online from
>>> http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
>>> Download the latest version of SQL Server 2008 Books Online from
>>> http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
>>>
>>> "Ekrem Önsoy" <Ekremnsoy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>>> news:354901F2-A548-495C-954B-73929EF07EF5@xxxxxxxxxxxxxxxx
>>>> Hi Gail,
>>>>
>>>> Yep, I was talking about you =) It's nice to see you around.
>>>>
>>>> However, I've checked out this link:
>>>> http://technet.microsoft.com/en-us/library/ms143506.aspx and I still
>>>> see
>>>> it's wrong. Besides, I'm not sure if you were talking about this >>>> link
>>>> when
>>>> you were saying "corrected". But as you know, as everybody do not
>>>> download
>>>> BOL's offline version, this link is the most popular thing to check >>>> for
>>>> system requirements. I hope it's going to be corrected ASAP so that
>>>> people
>>>> would not be confused.
>>>>
>>>> -- >>>> Ekrem Önsoy
>>>>
>>>>
>>>> "Gail Erickson [MS]" wrote:
>>>>
>>>>> > There was an MS guy around here who works about documentation, I
>>>>> > hope he
>>>>> > realizes our discussions about this mistake and take necessary
>>>>> > action to
>>>>> > correct it.
>>>>>
>>>>> Wrong gender, but I'll reply anyway :>) The topic has been >>>>> corrected
>>>>> and
>>>>> is available in the most recent update to SQL Server 2008 Books
>>>>> Online. You
>>>>> cn download the updated release from here:
>>>>> http://www.microsoft.com/downloads/details.aspx?FamilyId=765433F7-0983-4D7A-B628-0A98145BCB97&displaylang=en
>>>>>
>>>>>
>>>>> -- >>>>> Gail Erickson [MS]
>>>>> SQL Server Documentation Team
>>>>> This posting is provided "AS IS" with no warranties, and confers no
>>>>> rights
>>>>> Download the latest version of SQL Server 2005 Books Online from
>>>>> http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
>>>>>
>>>>> "Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message
>>>>> news:BCC53ED2-7A93-4BB8-A8BD-EF003EB25718@xxxxxxxxxxxxxxxx
>>>>> > Hi Charles,
>>>>> >
>>>>> > I believe that there's something wrong with the mentioned
>>>>> > documentation.
>>>>> >
>>>>> > After SQL Server 2008 RTM was released, I tested it installing on >>>>> > a
>>>>> > Client
>>>>> > OS and the result is: you can install SQL Server 2008 Enterprise
>>>>> > Edition
>>>>> > on Client OSs (XP\Vista). As this was not something usual, we
>>>>> > discussed
>>>>> > about this in "public.sqlserver.tools" NG under "Replace SSMS >>>>> > 2005
>>>>> > with
>>>>> > SSMS 2008" topic. I reported this in Connect and here's the >>>>> > answer:
>>>>> >
>>>>> > By Peter Saddow [Microsoft]:
>>>>> > Thanks for contacting us. For SQL Server 2008, we did not >>>>> > implement
>>>>> > rules
>>>>> > to
>>>>> > prevent you from installing an higher-level SQL editions on lower
>>>>> > level OS
>>>>> > editions, such as SQL ENT on a client OS.
>>>>> >
>>>>> > https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=363151
>>>>> >
>>>>> > There was an MS guy around here who works about documentation, I
>>>>> > hope he
>>>>> > realizes our discussions about this mistake and take necessary
>>>>> > action to
>>>>> > correct it.
>>>>> >
>>>>> > -- >>>>> > Ekrem Önsoy
>>>>> >
>>>>> >
>>>>> >
>>>>> >
>>>>> > ""Charles Wang [MSFT]"" <changliw@xxxxxxxxxxxxxxxxxxxx> wrote in
>>>>> > message
>>>>> > news:A3N3FlqIJHA.4172@xxxxxxxxxxxxxxxxxxxxxxxxx
>>>>> >> Hi Alex,
>>>>> >> Thank you for using Microsoft MSDN Managed Newsgroup. My name is
>>>>> >> Charles
>>>>> >> and I will assist you on this issue.
>>>>> >>
>>>>> >> Based on your description, I understand that you would like to >>>>> >> know
>>>>> >> if
>>>>> >> your laptop OS conditions satisfy the installation requirements >>>>> >> of
>>>>> >> SQL
>>>>> >> Server 2008 Enterprise Edition.
>>>>> >> If I have misunderstood, please let me know.
>>>>> >>
>>>>> >> For Windows Vista system, you can only install SQL Server 2008
>>>>> >> Developer
>>>>> >> Edition or Express Edition or Enterprise Evaluation Edition. It
>>>>> >> does not
>>>>> >> support SQL Server 2008 Enterprise Edition.
>>>>> >> For more information, you can refer to this article:
>>>>> >> Hardware and Software Requirements for Installing SQL Server >>>>> >> 2008
>>>>> >> http://technet.microsoft.com/en-us/library/ms143506.aspx
>>>>> >>
>>>>> >> To install SQL Server 2008 Enterprise Edition, you need to >>>>> >> install
>>>>> >> Windows Server 2003 or 2008. You can also find the list of
>>>>> >> supported OS
>>>>> >> in the above article.
>>>>> >>
>>>>> >> Hope this helps. If you have any other questions or concerns,
>>>>> >> please feel
>>>>> >> free to let me know.
>>>>> >>
>>>>> >> Best regards,
>>>>> >> Charles Wang
>>>>> >> Microsoft Online Community Support
>>>>> >> ===========================================================
>>>>> >> Delighting our customers is our #1 priority. We welcome your
>>>>> >> comments and suggestions about how we can improve the
>>>>> >> support we provide to you. Please feel free to let my manager
>>>>> >> know what you think of the level of service provided. You can
>>>>> >> send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
>>>>> >> ===========================================================
>>>>> >> Get notification to my posts through email? Please refer to
>>>>> >> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.
>>>>> >>
>>>>> >> Note: The MSDN Managed Newsgroup support offering is for
>>>>> >> non-urgent issues where an initial response from the community
>>>>> >> or a Microsoft Support Engineer within 1 business day is
>>>>> >> acceptable.
>>>>> >> Please note that each follow up response may take approximately
>>>>> >> 2 business days as the support professional working with you may
>>>>> >> need further investigation to reach the most efficient >>>>> >> resolution.
>>>>> >> The offering is not appropriate for situations
>>>>> >> that require urgent, real-time or phone-based interactions or
>>>>> >> complex
>>>>> >> project analysis and dump analysis issues. Issues of this nature
>>>>> >> are best
>>>>> >> handled working with a dedicated Microsoft Support Engineer by
>>>>> >> contacting Microsoft Customer Support Services (CSS) at
>>>>> >> http://msdn.microsoft.com/subscriptions/support/default.aspx.
>>>>> >> ============================================================
>>>>> >> This posting is provided "AS IS" with no warranties, and confers >>>>> >> no
>>>>> >> rights.
>>>>> >> =========================================================
>>>>> >>
>>>>> >>
>>>>> >>
>>>>> >
>>>>>
>>>>>
>>>>>
>>>
>>>
>>
>>
>




.

Relevant Pages

  • 2000k connect from outside domain
    ... Trying to log into a 2000K SQL Server using a windows user account when not ... I want to use query manager to log into the box or enterprise manager 2000K. ...
    (microsoft.public.sqlserver.connect)
  • AUTHENTICATION TO APPLY SP3
    ... a problem with SP3? ... > SQL Server 2000 RTM Standard Edition ... >windows user. ... >These accounts and passwords are good because I can get ...
    (microsoft.public.sqlserver.security)
  • Re: ASP.NET Forms Authentication Via A SQL Server Database With Windows User types?
    ... we have decided to go with SQL Server security vs Windows (using ... Standard SQL Users, not the Windows Users) - it just seems to be the ideal ... The Windows user type in SQL Server uses the security context of the ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Copy User permission
    ... We are migrating Windows user to amnother domain, ... server windows users have sid, and name hard coded to the ... SQL Server ... login id to a new login id? ...
    (microsoft.public.sqlserver.security)
  • Re: Using a specific user as PublisherLogin
    ... This is based upon whether your replication SecurityType is set to ... Windows User on the machine or has DB privileges on the SQL server. ... NTAuthentication settings are the easiest to setup for users who have ...
    (microsoft.public.sqlserver.ce)