SSL SQL 2005
Thu, 15 May 2008 05:15:31 -0400
Is there any way to tell if a SQL 2005 has SSL enabled?
Thanks,
Eric Sabo ...
|
Minimum OS Permissions
Tue, 13 May 2008 07:01:02 -0700
I've been trying to find guidance to set my OS permissions. What are the
minimum OS permission to allow a user to run SQL Enterprise Manager?
I'd also like the suggested setting for SQL 2005 as well.
Any help would be appreciated.
Thanks. ...
|
Reporing service failure
Sun, 11 May 2008 21:12:01 -0700
we have setup up reporting server and while configuring database
Database setup > domain account is provided
It fails here @ grant rights. with following error
------------------------------------------------------------------------------------------------
w3wp!library!c!5/12/2008-00:25:22:: e ERROR: Throwin ...
|
DTS Package
Sun, 11 May 2008 00:39:04 +0800
A DTS package is created to select and convert data by SQL Query command to
a .csv file.
Error:
When i schedule the package, it doesn't work. When i excute the package
itself, it works.
Checked that the job schedule was already assigned a user with domain admins
right.
Any body got an idea?
...
|
Setting SQL Server Agent Account without being part of a domain
Fri, 9 May 2008 08:50:30 -0700 (PDT)
I am running SS 2000 and am trying to set up the SS Agent account. The
machine that the db server runs on is not setup to be part of a
domain. How can I do this?
TIA! ...
|
Configuring Windows Server 2008 to allow Remote SQL Server 2000 co
Thu, 8 May 2008 14:32:17 -0700
I have a MSDE 2000 instance installed on a 2008 Server. I am using I am using
SQL Server Management Studio Express to do the configuration. At the server,
I can login to the instance using the sa account, but the same type of login
attempt to the running instance on the 2008 server by on another computer on
...
|
Lesson 7: Understanding Security and Network Connectivity
Thu, 8 May 2008 15:23:02 +1000
Hi,
I would like to watch the video "Lesson 7: Understanding Security and Network Connectivity". But It seem corrupt on the web site http://msdn.microsoft.com/en-us/express/aa718391.aspx#7. Where can I download the video.
Thanks a lot.
Qin
...
|
|
|
non-local admin - reporting service access
Wed, 7 May 2008 11:39:35 -0400
How does one give a non-local admin the necessary permissions for reporting
services, when trying to connect to the server they are getting access
denied. This is on an windows 2003 Standard running SQL 2005 Service Pack
2.
thanks in advance,
Eric Sabo
...
|
How to disable dangerous extended stored procedures In SQL2005
Wed, 7 May 2008 19:40:31 +0800
Hi,
I have a question about SQL2005 security enhancing.
In SQL2005, I need disable some dangerous extended stored procedures, such
as xp_dirtree, xp_regread .
I got a method from Internet to achieve that:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
exec sp_config ...
|
Set Sql Agent Proxy Account to Local Account
Tue, 6 May 2008 16:12:01 -0700
Hi- I'm trying to set the Proxy Account for Sql Server agent to a local
windows account. The account is NOT in a domain; yet a domain is required to
set the proxy. I have tried machine name, workgroup name, ., \, etc. to no
avail. We have tried from Enterprise Manager / Agent properties, and via sql
using
...
|
