Best Practices Analyzer

Why do I keep getting a login error box when I try to login to the BPA? I am
logging in with the same ID as I used to create the repository.
Hi Jim
BPA just tunnels through the connection information.
Can you connect from query analyzer?
Can you please provide more info on the error that you are getting?
Thanks,
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"JimW" <anonymous@.discussions.microsoft.com> wrote in message
news:E9D0888C-B01E-426A-9A74-E27E3C4113FE@.microsoft.com...
> Why do I keep getting a login error box when I try to login to the BPA? I
am
> logging in with the same ID as I used to create the repository.
|||Yes I can get in with Query Analyzer. All I get is a pop up window that says Login Error with a red x and a button to click ok.
-- Christian Kleinerman [MS] wrote: --
Hi Jim
BPA just tunnels through the connection information.
Can you connect from query analyzer?
Can you please provide more info on the error that you are getting?
Thanks,
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"JimW" <anonymous@.discussions.microsoft.com> wrote in message
news:E9D0888C-B01E-426A-9A74-E27E3C4113FE@.microsoft.com...
> Why do I keep getting a login error box when I try to login to the BPA? I
am
> logging in with the same ID as I used to create the repository.
|||From your post seems that repository database was created successfully
during setup. This would tell me that your managed stack is working well.
(i.e. SqlClient)
Can you try to login with profiler attached capturing logon and error
events, and verify 1) whether a connection is being established and 2)
whether any error is being reported?
Thanks,
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"JimW" <anonymous@.discussions.microsoft.com> wrote in message
news:DB5F277F-6FFC-4C3B-902B-E1885A884A4C@.microsoft.com...
> Yes I can get in with Query Analyzer. All I get is a pop up window that
says Login Error with a red x and a button to click ok.
> -- Christian Kleinerman [MS] wrote: --
> Hi Jim
> BPA just tunnels through the connection information.
> Can you connect from query analyzer?
> Can you please provide more info on the error that you are getting?
> Thanks,
> - Christian
>
> --
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "JimW" <anonymous@.discussions.microsoft.com> wrote in message
> news:E9D0888C-B01E-426A-9A74-E27E3C4113FE@.microsoft.com...
BPA? I
> am
>
>
|||This is what I get from profiler with all error possibilities and other things.
10NULLNULLNULLNULLNULLNULLNULL2004-05-19 08:53:32.880NULLNULLNULL
211exec sp_reset_connectionjweber0SQL Best Practices AnalyzerWPSR\jweber51NULL2004-05-19 08:53:36.940NULLNULLNULL
310exec sp_reset_connectionjweber0SQL Best Practices AnalyzerWPSR\jweber5102004-05-19 08:53:36.940000
440select * from sysobjects where name = N'bpa_active_connections' or name =N'bpa_bestpractices' or name =N'bpa_files' or name =N'bpa_instance_results' or name =N'bpa_managed_types' or name =N'bpa_properties' or name =N'bpa_bestpractice_sqlservers' or
name jweber0SQL Best Practices AnalyzerWPSR\jweber51NULL2004-05-19 08:53:36.940NULLNULLNULL
5114select * from sysobjects where name = N'bpa_active_connections' or name =N'bpa_bestpractices' or name =N'bpa_files' or name =N'bpa_instance_results' or name =N'bpa_managed_types' or name =N'bpa_properties' or name =N'bpa_bestpractice_sqlservers' o
r name jweber0SQL Best Practices AnalyzerWPSR\jweber51NULL2004-05-19 08:53:36.957NULLNULLNULL
612select * from sysobjects where name = N'bpa_active_connections' or name =N'bpa_bestpractices' or name =N'bpa_files' or name =N'bpa_instance_results' or name =N'bpa_managed_types' or name =N'bpa_properties' or name =N'bpa_bestpractice_sqlservers' or
name jweber0SQL Best Practices AnalyzerWPSR\jweber51162004-05-19 08:53:36.940374016
715NULLjweber0SQL Best Practices AnalyzerWPSR\jweber511929232004-05-19 08:50:24.033413016
814-- network protocol: TCP/IP set quoted_identifier on set implicit_transactions off set cursor_close_on_commit off set ansi_warnings on set ansi_padding on set ansi_nulls on set concat_null_yields_null on set language us_english set dateformat mdy set
datefjweber0SQL Best Practices AnalyzerWPSR\jweber51NULL2004-05-19 08:53:37.003NULLNULLNULL
95NULLNULLNULLNULLNULLNULLNULLNULLNULLNULLNULL
-- Christian Kleinerman [MS] wrote: --
From your post seems that repository database was created successfully
during setup. This would tell me that your managed stack is working well.
(i.e. SqlClient)
Can you try to login with profiler attached capturing logon and error
events, and verify 1) whether a connection is being established and 2)
whether any error is being reported?
Thanks,
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"JimW" <anonymous@.discussions.microsoft.com> wrote in message
news:DB5F277F-6FFC-4C3B-902B-E1885A884A4C@.microsoft.com...
> Yes I can get in with Query Analyzer. All I get is a pop up window that
says Login Error with a red x and a button to click ok.[vbcol=seagreen]
> BPA just tunnels through the connection information.
> Can you connect from query analyzer?
> Can you please provide more info on the error that you are getting?
> ___________________________
> Christian Kleinerman
> Program Manager, SQL Engine
rights.[vbcol=seagreen]
> news:E9D0888C-B01E-426A-9A74-E27E3C4113FE@.microsoft.com...
BPA? I[vbcol=seagreen]
> am

Best practice analyer

what login permissions should I have to run best practice
analyser tool? DO I have to be a sql server sysadmin?
I use mixed mode.
Some rules (e.g. syntax analysis, queries on the system catalog) will
succeed without sysadmin privileges, but some others (e.g. those that use
sp_configure) will require sysadmin privileges.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ann" <anonymous@.discussions.microsoft.com> wrote in message
news:796e01c4950f$0b640990$a301280a@.phx.gbl...
> what login permissions should I have to run best practice
> analyser tool? DO I have to be a sql server sysadmin?
> I use mixed mode.

beginner: "Login failed for user sa."

Hello,
(sorry for my English...)
Could you help me with a SQL Server 2005 problem?
I had installed SQL Server 2005 and then I tried to setup some application
using SQL Server. Unfortunatelly setup fails because the application cannot
logon to SQL Server in SQL Server Authentication mode (user 'sa', password
'sa'). I checked Server Management Studio Express: I have sa/sa account
(because I've prepared it), but although I can logon in Windows
Authentication mode, I cannot logon in SQL Server Authentication (sa/sa)
because of:

Login failed for user 'sa'. The user is not associated with a trusted SQL
Server connection (Microsoft SQL Server, Error: 18452).

Could you help me plase? I suspect that solution is simple but my experience
is not enough.
Thank you very much.
/RAMtake a look here
http://sqlservercode.blogspot.com/2...reason-not.html|||Andrzej Magdziarz (andrzej.magdziarz@.wp.pl) writes:
> Could you help me with a SQL Server 2005 problem? I had installed SQL
> Server 2005 and then I tried to setup some application using SQL Server.
> Unfortunatelly setup fails because the application cannot logon to SQL
> Server in SQL Server Authentication mode (user 'sa', password 'sa').

That is not a very good password. :-)

> I checked Server Management Studio Express: I have sa/sa account
> (because I've prepared it), but although I can logon in Windows
> Authentication mode, I cannot logon in SQL Server Authentication (sa/sa)
> because of:
> Login failed for user 'sa'. The user is not associated with a trusted SQL
> Server connection (Microsoft SQL Server, Error: 18452).
> Could you help me plase? I suspect that solution is simple but my
> experience is not enough.

By default, SQL Server accepts only logins through Windows authentication,
and you must explicitly permit SQL authentication. Your first chance
to so is during setup, but you can also do this from Mgmt Studio.
Right-click the server itself in the Object Explorer, select Properies
and then find the Security page.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx