encrypted network traffic
Sun, 05 Sep 2010 19:25:41 +0100
I have an MSSQL 2000 server that has an SSL certificate. In the SQL
Server network utility, 'Force protocol encryption' is checked.
Looking at the traffic with Wireshark, it's no longer in plain text.
However, the certicicatee is issued to say a.mydomain.com.
If I create a dns record such that b.mydomain.com r ...
|
permissions for OPENROWSET
Thu, 2 Sep 2010 08:41:47 -0700 (PDT)
I'm using SQL Server 2008 and with sa, this works fine
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel
12.0;Database=q:\teste.xlsx', [zz$])
Succeeds for sa, but not a domain user. I've started morphing the
domain user login and db user into an sa-type creature, but before I
get too far and then ...
|
Users without logins
Tue, 31 Aug 2010 12:24:44 -0700 (PDT)
Hi all,
I stumbled across some behavior in SQL2005 that I consider odd and
surprising, and I'm looking for help understanding more about it.
According to BOL, when you run "CREATE USER user_name LOGIN
login_name", the login_name must be a valid login in the server. I
found this is not the case when you creat ...
|
Reminder - Microsoft Responds to the Evolution of Community
Tue, 31 Aug 2010 11:27:47 -0700
What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
Why?
As you may know, newsgroups have existed for many years now; however, the
traffic in the Microsoft newsgroups has been steadily decreasing for the
past ...
|
Report on table level permissions
Mon, 30 Aug 2010 11:06:21 -0400
We have a SQL 2000 database setup a while ago when we were a much smaller
company. The security on the tables in the database was done at the table
level so if you were in the group sqlSales you would get read/write access
to the Sales tables, and so on.
I can get reports out of AD easy enough to show who ...
|
protect my data base
Mon, 30 Aug 2010 10:08:59 GMT
Dear All
is there a way to protect my data base i mean no one can open the tables or
change them ??
pls any idea ??
best regards
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-security/201008/1
...
|
Active Directory Groups vs. using SQL Server Groups.
Fri, 27 Aug 2010 21:39:52 GMT
Which is better in use. Setting up Active Directory groups and using it to
guide your security in the sense that you create a read and a read/write
group and just move users in and out of these security groups and manage
security for SQL Server from Active Directory. Or use SQL Server and move
all users into s ...
|
|
|
User rights on moving database
Fri, 27 Aug 2010 10:57:45 +0300
Hi
I recently moved SQL database from server1 to server2 using detach/attach
database files.
I made the following steps:
1. Install SQL Server 2005 on server2
2. Create login "Asig" (user with limited rights for conecting to
application)
3. Detach files (database and transaction log) on server1
4. Copy ...
|
SE2008: Turning Off Column Headings in SSMS Results
Wed, 25 Aug 2010 15:03:23 -0700
Hello:
I am working through the documentation. Some of the programs
iterate to give results. In each case, they display the column
headings. How can I turn that off?
Sincerely,
Gene Wirchenko ...
|
Roles Question
Tue, 24 Aug 2010 14:23:32 -0400
I have a new app I am working on that allows general managers to view
a dashboard of data from multiple databases across multiple severs.
I've created a role 'GMs' in each db they need to access (currently).
When I create a new stored proc I grant exec on NewProc to GMs
from the hosting db.
I also grant selec ...
|