Adding database access to existing account prompts password change confirmation dialog

Running SQL Server 2000, Service Pack 3a, Hotfix MS03-031 (8.00.818)
on Windows 2000 Server, Service Pack 3:
Whenever I try to add or change the attributes of an existing SQL
Server-authenticated login, I'm prompted to "Confirm new password"
even though I'm not changing the password. Windows-authenticated
logins don't seem to do this.
Any ideas?
Thanks!
Michael Brule
Database Administrator
The Phoenix CompaniesFrom my understanding the hotfix you mentioned should of
fixed that issue.
Here's more info
http://support.microsoft.com/?id=826161
Quoting from that knowledge base article:
==============SYMPTOMS
After you install MS03-031: Cumulative Security Patch for
SQL Server, when you make changes to a standard SQL Server
login by using Enterprise Manager, you are prompted for a
password, even if you did not change the password. If you
did not change the password, you cannot successfully close
the dialog box, regardless of the entry that you use.
>--Original Message--
>Running SQL Server 2000, Service Pack 3a, Hotfix MS03-031
(8.00.818)
>on Windows 2000 Server, Service Pack 3:
>Whenever I try to add or change the attributes of an
existing SQL
>Server-authenticated login, I'm prompted to "Confirm new
password"
>even though I'm not changing the password. Windows-
authenticated
>logins don't seem to do this.
>Any ideas?
>Thanks!
>Michael Brule
>Database Administrator
>The Phoenix Companies
>.
>|||Thanks, Bob! That took care of it!
Michael Brule
Database Administrator
The Phoenix Companies

Adding BI Templates to Visual Studio 2005 - 2008

After installing SQL Server (both 2005 and 2008) sometimes the BI Templates are missing from the new project dialog. Is there a way to find those templates and add them after a SQL Server install? I have searched the web and Microsoft MSDN, but found no information. Thank you if you can help me.

Hi,

From your description, do you mean the Business Intelligence project template disappear in the create project dialogue?

Based on my understanding, you can try to open "SQL Server Business Intelligence Development Studio" from SQLServer 2005 menu group instead of starting Visual Studio designer. If you still can't find the business intelligence project template. Please make sure that if you have choose the "SQLServer Reporting Service" to be installed while you installing the SQLServer2005.

Thanks.

|||

No, the problem is that they do not appear in VS/BIDS even if SSRS is installed. The templates must be available on the web somewhere and the correct folder location and configuration to add them to the VS/BIDS interface must exist somewhere.