Specifying ODBC user/pass for Performance Logs and Alerts sql logging

[Chris Back]

Hi,

I am having an impossible time trying to determine how to specify a
user/pass for the System DSN connection I have selected for recording
performance data using "Performance Logs and Alerts". Whenever I try to
start the counter, it attempts to connect to the database with a blank
username and pass.

I am trying to use SQL Server 2005 Express as the data repository. The
setup for the system DSN also does not allow me to specify a global
user/password.

Any help would be greatly appreciated.

Thanks,
Chris Back

 

[Dave Patrick]

Try using windows integrated authentication.

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hi,
|
| I am having an impossible time trying to determine how to specify a
| user/pass for the System DSN connection I have selected for recording
| performance data using "Performance Logs and Alerts". Whenever I try to
| start the counter, it attempts to connect to the database with a blank
| username and pass.
|
| I am trying to use SQL Server 2005 Express as the data repository. The
| setup for the system DSN also does not allow me to specify a global
| user/password.
|
| Any help would be greatly appreciated.
|
| Thanks,
| Chris Back
|

 

[Dave Patrick]

Don't forget to ADD nt_authority\system as a db_datareader and db_datawriter

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect