SQL Server 2008 set up

External Since: Sep 29, 2008 Posts: 19

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?Fee...ckID=36
> 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 DeleteThis @compecta.com> wrote in message
> news:4DB85365-EC6E-4604-A254-FF72AACBADA8@microsoft.com...
> > 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 DeleteThis @online.microsoft.com> wrote in message
> > news:uAHIhQOJJHA.4240@TK2MSFTNGP03.phx.gbl...
> >>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 DeleteThis @online.microsoft.com> wrote in message
> >> news:u4onf8$IJHA.728@TK2MSFTNGP03.phx.gbl...
> >>> 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 DeleteThis @discussions.microsoft.com> wrote in message
> >>> news:354901F2-A548-495C-954B-73929EF07EF5@microsoft.com...
> >>>> 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...7A-B628
> >>>>>
> >>>>>
> >>>>> --
> >>>>> 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 DeleteThis @compecta.com> wrote in message
> >>>>> news:BCC53ED2-7A93-4BB8-A8BD-EF003EB25718@microsoft.com...
> >>>>> > 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?Fee...ckID=36
> >>>>> >
> >>>>> > 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 DeleteThis @online.microsoft.com> wrote in
> >>>>> > message
> >>>>> > news:A3N3FlqIJHA.4172@TK2MSFTNGHUB02.phx.gbl...
> >>>>> >> 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 DeleteThis @microsoft.com.
> >>>>> >> ===========================================================
> >>>>> >> Get notification to my posts through email? Please refer to
> >>>>> >> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx...tificat
> >>>>> >>
> >>>>> >> 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.
> >>>>> >> =========================================================
> >>>>> >>
> >>>>> >>
> >>>>> >>
> >>>>> >
> >>>>>
> >>>>>
> >>>>>
> >>>
> >>>
> >>
> >>
> >
>
>
>

External Since: Jan 10, 2008 Posts: 190

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.TakeThisOut@newsgroup.nospam> wrote in message
news:7B7DD9C7-E5F7-4C22-885E-E7468FDCCCF4@microsoft.com...
> 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?Fee...ckID=36
>> 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.TakeThisOut@compecta.com> wrote in message
>> news:4DB85365-EC6E-4604-A254-FF72AACBADA8@microsoft.com...
>> > 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.TakeThisOut@online.microsoft.com> wrote in message
>> > news:uAHIhQOJJHA.4240@TK2MSFTNGP03.phx.gbl...
>> >>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.TakeThisOut@online.microsoft.com> wrote in message
>> >> news:u4onf8$IJHA.728@TK2MSFTNGP03.phx.gbl...
>> >>> 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.TakeThisOut@discussions.microsoft.com> wrote in message
>> >>> news:354901F2-A548-495C-954B-73929EF07EF5@microsoft.com...
>> >>>> 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...7A-B628
>> >>>>>
>> >>>>>
>> >>>>> --
>> >>>>> 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.TakeThisOut@compecta.com> wrote in message
>> >>>>> news:BCC53ED2-7A93-4BB8-A8BD-EF003EB25718@microsoft.com...
>> >>>>> > 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?Fee...ckID=36
>> >>>>> >
>> >>>>> > 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.TakeThisOut@online.microsoft.com> wrote in
>> >>>>> > message
>> >>>>> > news:A3N3FlqIJHA.4172@TK2MSFTNGHUB02.phx.gbl...
>> >>>>> >> 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.TakeThisOut@microsoft.com.
>> >>>>> >> ===========================================================
>> >>>>> >> Get notification to my posts through email? Please refer to
>> >>>>> >> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx...tificat
>> >>>>> >>
>> >>>>> >> 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.
>> >>>>> >> =========================================================
>> >>>>> >>
>> >>>>> >>
>> >>>>> >>
>> >>>>> >
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>
>> >>>
>> >>
>> >>
>> >
>>
>>
>>