Re: MSDE questions for SharePoint and Project Server
From: Andrea Montanari (andrea.sqlDMO_at_virgilio.it)
Date: 10/14/04
- Next message: Andy Walldorff: "Complex query with IN"
- Previous message: Dejan Sarka: "Re: Create login account"
- In reply to: xfile: "MSDE questions for SharePoint and Project Server"
- Next in thread: xfile: "Re: MSDE questions for SharePoint and Project Server"
- Reply: xfile: "Re: MSDE questions for SharePoint and Project Server"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 14 Oct 2004 13:14:04 +0200
hi,
"xfile" <cou-cou@remove.nospam.com> ha scritto nel messaggio
news:%23JlIhmdsEHA.2720@TK2MSFTNGP12.phx.gbl
> Hi:
>
> Appreciate if anyone can help me on the following questions:
>
> (1) Is MSDE necessary if we wish to install Windows SharePoint Team
> service and/or MS Project Server?
yes... I do think SharePoint installs it' own instance of a modified MSDE
release...
> (2) MSDE installation problems -- please read below.
>
> Followed article
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_84xl.asp
> for many many times and never succeeded -- maybe just because I am
> new to this.
>
> Using example of the article - setup SAPWD="AStrongSAPwd"
>
> What exactly show we put inside " "? A real strong password, or as
> literally the same as in the example -- AStrongSAPwd?
your own strong password for the special SQL Server account known as "sa",
an administrative account that can not be dropped...
> Do we include " " or not?
yes
> I tried once with the exact thing as - setup SAPWD="AStrongSAPwd",
> word by word, and the best thing that I could get from testing (based
> on
> http://support.microsoft.com/default.aspx?scid=kb;en-us;322336&Product=sql
> ) is to have the following result: 1>
>
:-|
if you resulted in oSql.exe output
1>
that means you do not have a password for "sa" Login
else you'd would have been pompted for a password like
c:\>osql -Usa
Password: [here caret blinks]
> And there is no instructions for what to do next in the article. I
> pressed Enter, it will become 2> and go on. I typed something else,
> no response at all.
if you want to (and should) set a strong password for your "sa" login,
please repeat the described steps as above..
then at the 1> prompt, type
1>sp_password @old = NULL , @new = 'yourStrongPassword' , @loginame =
'sa' --hit return
2>GO -- hit return
GO is a special word that will execute all the statements preceding it as a
single batch...
obviously change
'yourStrongPassword'
with your own password...
> Other times, it will become as the following - which i changed to the
> mixed mode but still failed.
>
> ----------------
> The following error message indicates that the computer that is
> running SQL Server is set to Windows Authentication only:
> Login failed for user 'sa'. Reason: Not associated with a trusted SQL
> Server connection.
> ---------------------
this must be managed via Windows registry modification, as described in
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q285097....
stop and restart the MSDE instance service
-- Andrea Montanari (Microsoft MVP - SQL Server) http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1 (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface) --------- remove DMO to reply
- Next message: Andy Walldorff: "Complex query with IN"
- Previous message: Dejan Sarka: "Re: Create login account"
- In reply to: xfile: "MSDE questions for SharePoint and Project Server"
- Next in thread: xfile: "Re: MSDE questions for SharePoint and Project Server"
- Reply: xfile: "Re: MSDE questions for SharePoint and Project Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
