Re: SQL server 2005 login issure 2
- From: "Rick Byham [MS]" <rickbyh@xxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 3 Jan 2006 09:12:15 -0800
My programming knowlege is pretty rusty, but if you installed SQL Server
with only Windows authentication, then don't supply sa as the login
name.Maybe something like:
new sqlconnection( "server=p3xp;uid=;pwd=;database=master
On the other hand, if you installed with Windows Authentication and then
switched to mixed mode authentication and want to use the sa account you
must both enable the account, and set the password.
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<password>' ;
GO
--
Rick Byham
MCDBA, MCSE, MCSA
Lead Technical Writer,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Shaun R." <ShaunR@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A1BB26B-2EDE-4466-B633-8E3D3AB52D5C@xxxxxxxxxxxxxxxx
> Hello All,
>
> If by any change you have read my original post titled "SQL Server 2005
> login issue and also the post from "Jens"..... This message is in
> regaurds
> to those two posts.
>
> First of all Jens thank you for your reply.
>
> I am still having the same trouble despite the post from "Jens". I know
> that there are some great ideas in the post from "Jens" on how to solve my
> original issue, however I do not know the procedure's to follow to carry
> out
> any of the instructions "Jens" suggested in the post dated 12-31-05 P.S.
> Happy New Year again Everyone.
>
> As I said previously My system is giving me a error message when I attempt
> to change the SA password..
>
> Also I do not know the steps to go about changing the ASP.NET Account to a
> service account which is privileged on SQL Server.
>
> Lastly As I said in my original Post I am using XP Pro Sevice Pak 2 so
> based
> on what "Jans" Said I won't get the advantage of the new policies for
> possword complexity requirements.
>
> I know that "Jans" means very well, however I am unable to use any of the
> advice "Jans" has given me because I do not comprehend and how to
> implement
> it.
>
> If anyone can help me to get to the bottom of my problem discribed in my
> original post dated 12-31-05 I am all ears...
>
> Thank You,
>
> Everyone.....
>
>
.
- Prev by Date: Re: Single User mode is the solution ?
- Next by Date: Re: New Installation can't connect to default database
- Previous by thread: Re: Single User mode is the solution ?
- Next by thread: Re: New Installation can't connect to default database
- Index(es):
Relevant Pages
|
