RE: ShapePoint database upgraded to SQL Server 2K - change sa password?
- From: v-branee@xxxxxxxxxxxxxxxxxxxx ("Brandy Nee [MSFT]")
- Date: Fri, 10 Feb 2006 09:15:54 GMT
Hello Andrew,
Thank you for posting to the SBS Newsgroup.
I understand that you want to know if you need to input the SA Password
when upgrading to the SQL Server 2K. If I have misunderstood your concern,
please let me know.
Andrew, please understand this issue appears to be related to SQL Server.
This inquiry would best be posted to the
<microsoft.private.directaccess.sqlserver> Newsgroup. In the SQL newsgroup
our SQL Support Engineers will help you solve the issue in a more timely
and efficient manner, and the other customers who read the newsgroups
regularly can either share their knowledge or learn from your interaction
with us.
Thank you for your understanding!
Having said that, I am still glad to be provide following information for
you, please see:
1. Locate at:
HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\
-or-
HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\ Instance Name
\MSSQLServer\
2. In the right pane, double-click the LoginMode subkey.
3. In the DWORD Editor dialog box, the SA Password is to be set according
to the value of this subkey.
For more detail information, please see:
322336 How to verify and change the system administrator password in MSDE
or SQL Server 2005 Express Edition
http://support.microsoft.com/default.aspx?scid=kb;EN-US;322336
325022 MSDE security and authentication
http://support.microsoft.com/default.aspx?scid=kb;EN-US;325022
Hope it helps!
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: ShapePoint database upgraded to SQL Server 2K - change sa
Date: 9 Feb 2006 09:23:23 -080017:23:28 GMT)
Organization: http://groups.google.com
Lines: 6
Message-ID: <1139505803.156143.102520@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>
NNTP-Posting-Host: 70.126.45.238
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1139505808 13241 127.0.0.1 (9 Feb 2006
X-Complaints-To: groups-abuse@xxxxxxxxxx..NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
NNTP-Posting-Date: Thu, 9 Feb 2006 17:23:28 +0000 (UTC)
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: g47g2000cwa.googlegroups.com; posting-host=70.126.45.238;
posting-account=MWj-zw0AAABafw4r1aEmDwYweqJkWrLo
Path:
ne.de!news.glorb.com!postnews.google.com!g47g2000cwa.googlegroups.com!not-fo
r-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:243359
X-Tomcat-NG: microsoft.public.windows.server.sbs
I have not changed anything as far at authentication methods. I was
getting ready to change the SA password but it looked like there may
already be a password set. This is a clean install, so if there is a
password, SBS install did it, not me. Should I change this SA account
password or leave it alone? Thanks!
.
- Follow-Ups:
- Re: 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?
- References:
- 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: Companyweb appears installed but isn't?
- Next by Date: Group policy dissapears!
- Previous by thread: ShapePoint database upgraded to SQL Server 2K - change sa password?
- Next by thread: Re: ShapePoint database upgraded to SQL Server 2K - change sa password?
- Index(es):
Relevant Pages
|
Loading
