Re: ShapePoint database upgraded to SQL Server 2K - change sa password?
- From: v-branee@xxxxxxxxxxxxxxxxxxxx ("Brandy Nee [MSFT]")
- Date: Mon, 20 Feb 2006 10:06:53 GMT
Hello Andrew,
Thank you for posting back!
I am sorry for the delayed response due to the weekend. Please understand
that the newsgroups are staffed weekdays by Microsoft Support professionals
to answer your systems and applications questions. Your understanding is
greatly appreciated!
From your reply, I understand you have completed the upgrade. Your questionis if changing the SA password will break the SharePoint. If I have
misunderstood your concern, please let me know.
No, it will not break. SharePoint uses Windows Authentication, thus, change
SA password will not break SharePoint.
If you have any further questions or concern, please feel free to let me
know. I am looking forward to hearing from you!
Best regards,
Brandy Nee
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
From: "Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+"<ameador1@xxxxxxxxxxxxxxx>
Newsgroups: microsoft.public.windows.server.sbspassword?
Subject: Re: ShapePoint database upgraded to SQL Server 2K - change sa
Date: 17 Feb 2006 07:41:23 -080015:41:28 GMT)
Organization: http://groups.google.com
Lines: 22
Message-ID: <1140190883.177466.15880@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
References: <1139505803.156143.102520@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<1139583967.717378.22830@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
<TbWFnkEMGHA.3052@xxxxxxxxxxxxxxxxxxxxx>
NNTP-Posting-Host: 70.126.45.238
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1140190888 14610 127.0.0.1 (17 Feb 2006
X-Complaints-To: groups-abuse@xxxxxxxxxx..NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
NNTP-Posting-Date: Fri, 17 Feb 2006 15:41:28 +0000 (UTC)
In-Reply-To: <TbWFnkEMGHA.3052@xxxxxxxxxxxxxxxxxxxxx>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
Complaints-To: groups-abuse@xxxxxxxxxxTK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
Injection-Info: g14g2000cwa.googlegroups.com; posting-host=70.126.45.238;
posting-account=MWj-zw0AAABafw4r1aEmDwYweqJkWrLo
Path:
ne.de!news.glorb.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-fo
r-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:245314
X-Tomcat-NG: microsoft.public.windows.server.sbs
Brandy, I don't know how to word this any differently but you are
not getting the point of my post. The upgrade has been completed
(SharePoint on MSDE to SharePoint on SQL Server 2000). This has been
done. Completed. Smoothly as described by your test. I understand that
there is no prompt to change the SA password during the upgrade. Please
read this post carefully to understand my question. It is a standard
best practice to change the SA password on SQL Server to a complex
password so others cannot access the database server and databases
easily. Now, if I simply wanted to change the SA password, then I
agree, this would be a post for the SQL Server newsgroup. However, this
is not the concern - I know how to change the SA password. My question
is - if I change the SA password, is that going to cause SharePoint to
break? If Sharepoint is using the SA account/password to access the
SharePoint database and I change the password to one that SharePoint
does not know, then SharePoint may stop working. Since I cannot tell
what, if any, the current password is, I can't simply write it down,
change it, and see what happens, as I won't be abe to change it back to
its original value. So again, if I change the SA password for the
SharePoint instance of SQL Server - will this break anything, or is
this ok to do without consequence (other than making the server more
secure)?
.
- References:
- ShapePoint database upgraded to SQL Server 2K - change sa password?
- From: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+
- Re: ShapePoint database upgraded to SQL Server 2K - change sa password?
- From: Andrew Meador - ASCPA, MCSE, MCP+I, Network+, A+
- ShapePoint database upgraded to SQL Server 2K - change sa password?
- Prev by Date: Re: Trend Micro CSM Suite OfficeScan Management Console (HTML) Woes
- Next by Date: Re: Companyweb/employee time card question
- Previous by thread: Re: ShapePoint database upgraded to SQL Server 2K - change sa password?
- Next by thread: Folder contents are different when logged in remotely?
- Index(es):
Relevant Pages
|
Loading
