The process of identifying the party logging into a system.
0
votes
0answers
22 views
Is there any way to connect to one server and utilize a linked server using Windows authentication and NTLM?
I currently have MSSQLS 2005 (Server A) that has a SSAS 2005 linked server (Server B). The powers that be do not want to enable Kerberos authentication, so I'm stuck with NTLM. The problem is that ...
1
vote
0answers
45 views
Re enable Windows Authentication [closed]
My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.
4
votes
2answers
99 views
Re enable Windows Authetication in SQL Server
My old employee has disabled Windows Authentication in our server. Now I'm not able to access the SQL Server even though I have Administrator access to the server. I need to reset the sa password.
I ...
2
votes
1answer
51 views
The Login is from an untrusted domain - domain setup with computer level login
I have a Sql Server 2008 R2 database I'm attempting to connect to using ADO.NET using integrated security in the connection string.
The database resides on a 64 bit Windows Server 2003 machine. The ...
2
votes
1answer
115 views
Cannot connect to SQL Server after setting sa password to blank
I have installed SQL Server 2008 R2 on a Windows 2008 server. I need to set the sa password to blank for some reasons to make an application works; but it seems like the password changes automatically ...
2
votes
1answer
68 views
If the users need INSERT/UPDATE/DELETE permissions, is Windows auth still more secure than SQL Server auth?
Some background first:
The problem described below wouldn't exist at all if the database in question would have been built with a DBA's mindset:
Data access only through views and stored procs --> ...
0
votes
0answers
11 views
Vote to a db server using session key
I do not know if this is the right stackexchange site to ask this question, but I believe that is relevant.
I am trying to implement an e-voting protocol. At some point the protocol says that server 1 ...
0
votes
2answers
53 views
Error log - What does this mean and what can I do about it?
I have the following repeated errors in my error.log and I don't know what it means or what I should/can do about it:
Access denied for user 'root'@'[some IP]' (using password: YES)
There are ...
2
votes
1answer
79 views
SQL 2008: Why is *any* user, with minimal permissions able to restart/stop the SQL instance through Management Studio
So I'm on a project that I need to help admin SQL 2008 .
I'm coming from a MySQL background.
Why is it that a basic user, with the most basic/default permissions, through Management Studio is able to ...
1
vote
0answers
70 views
connect sql server using windows authentication in another pc
I am having sql server 2008 r2 express installed in a PC. I have some other PC which are connected to this pc in a local network.Now those PC connect to my pc's sql server using sql authentication. ...
0
votes
3answers
138 views
SQL server ODBC connection for Active Directory user who doesn't log in to the windows
Do you think it is possible to create a SQL server ODBC Connection for an active directory user who doesn't log in into the windows.
Ideally this type of users will be used in the batch process. So, ...
2
votes
2answers
74 views
Logging only mySQL logins on heavily used system
I have an audit requirement where they want all database access (logins) logged. We have a very large distributed system of hundreds of mySQL servers (shards, slaves, slaves of slaves) that are ...
3
votes
1answer
83 views
Domain group hierarchical group membership and SQL Logins mapped to AD groups [closed]
SQL Version: Microsoft SQL Server 2005 - 9.00.4035.00 (X64)
Nov 24 2008 16:17:31
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: ...
0
votes
0answers
291 views
SQL Server 2012 SSIS\SharePoint Kerberos auth
I have some issues setting up Kerberos together with SQL Server and SharePoint. Any help will be much appreciated! =)
GOAL:
Use Kerberos to avoid double-hop issue.
USAGE:
User logs onto ...
3
votes
2answers
289 views
DB2 to require password each time
I am using db2inst1 to connect to a database in DB2 which I have installed on my machine. Therefore, db2inst1 user does not require username/password authentication (borrows them from the OS). I would ...
