Saving passwords in Management Studio

Hi there,
can anyone tell me why that every time I use SQL Server
Management Studio I get presented with a login dialog with the password
blanked out. Every time I login, I click the Save Password checkbox to no
avail.On 30 May, 14:01, "Waldy" <some...@.microsoft.com> wrote:
> Hi there,
> can anyone tell me why that every time I use SQL Server
> Management Studio I get presented with a login dialog with the password
> blanked out. Every time I login, I click the Save Password checkbox to no
> avail.
What SP do you have? There were some problems with saving passwords in
RTM. You may need to upgrade your client tool install, which isn't
necessarily the same as your server version. Check the version number
under Help/About in Management Studio.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||The version is 9.00.2047.00.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1180561374.107796.247460@.o5g2000hsb.googlegroups.com...
> On 30 May, 14:01, "Waldy" <some...@.microsoft.com> wrote:
> What SP do you have? There were some problems with saving passwords in
> RTM. You may need to upgrade your client tool install, which isn't
> necessarily the same as your server version. Check the version number
> under Help/About in Management Studio.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||I too am having this problem. Every time I connect to a server, open
a query, or create a new query, I am prompted for my username and
password, and every time I select the remember password checkbox. Why
is it that I have to type it in each time?
I have discovered that if I select the database server that I want to
connect to from the drop down list, even if it is already selected,
that my username and password will sometimes get populated. If it
knows my password, why does it not just populate it when the login
window opens?
I am running SP2.
On May 30, 8:01 am, "Waldy" <some...@.microsoft.com> wrote:
> Hi there,
> can anyone tell me why that every time I use SQL Server
> Management Studio I get presented with a login dialog with the password
> blanked out. Every time I login, I click the Save Password checkbox to no
> avail.|||I too am having this problem. Every time I connect to a server, open
a query, or create a new query, I am prompted for my username and
password, and every time I select the remember password checkbox. Why
is it that I have to type it in each time?
I have discovered that if I select the database server that I want to
connect to from the drop down list, even if it is already selected,
that my username and password will sometimes get populated. If it
knows my password, why does it not just populate it when the login
window opens?
I am running SP2.
On May 30, 8:01 am, "Waldy" <some...@.microsoft.com> wrote:
> Hi there,
> can anyone tell me why that every time I use SQL Server
> Management Studio I get presented with a login dialog with the password
> blanked out. Every time I login, I click the Save Password checkbox to no
> avail.|||Yes, same problem here (remember passwords are cleared) -- in fact, this
problem has become more serious because after running the following Microsof
t
Updates:
Office 2003 Update for Outlook 2003 Junk Email Filter (KB936030) Thursday,
June 14, 2007 Automatic Updates
Windows XP Cumulative Security Update for Outlook Express for Windows XP
(KB929123) Thursday, June 14, 2007 Automatic Updates
Windows XP Security Update for Windows XP (KB935840) Thursday, June 14,
2007 Automatic Updates
Windows XP Windows Malicious Software Removal Tool - June 2007 (KB890830)
Thursday, June 14, 2007 Automatic Updates
Windows XP Security Update for Windows XP (KB935839) Thursday, June 14,
2007 Automatic Updates
Office 2003 Security Update for visio 2003 (KB931281) Thursday, June 14,
2007 Automatic Updates
Windows XP Cumulative Security Update for Internet Explorer 7 for Windows XP
(KB933566) Thursday, June 14, 2007 Automatic Updates
My established user accounts password are NOW corrupted!! I've had to
remove the accounts and re-add them.
I've established a bug on feedback, but as usual Microsoft have closed it
within hours with no resolution.
My version info:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
Rob.
"Waldy" wrote:

> Hi there,
> can anyone tell me why that every time I use SQL Server
> Management Studio I get presented with a login dialog with the password
> blanked out. Every time I login, I click the Save Password checkbox to no
> avail.
>
>