All Questions
Tagged with authentication sql-server-2008
20 questions
-3
votes
1
answer
2k
views
The login is from an untrusted domain and cannot be used with Windows authentication
I am facing this issue after trying to run a Windows application on sharing client side in a workgroup environment, while this application working on server machine fine.
3
votes
2
answers
679
views
SQL Server 2008 Authentication mode changed on its own
This morning we experienced an issue where our production server seemed to decide to change from Mixed authentication mode to Windows only authentication of its own volition. I was curious to know if ...
- 304
1
vote
1
answer
77
views
Managing Security for a Log Shipped db across two (unconnected) domains
SQL Server 2008 (soon to be 2012).
We have a vendor that is providing us with log shipped backups of our production database. We use this log shipped database for BI staging, reporting, etc. I've ...
- 764
3
votes
1
answer
836
views
Should Service Broker use SQL or Windows Authentication?
I was curious what the best practice would be, for properly setting up Service Broker in SQL Server 2008. Should I use a SQL authenticated user, or should I use a Windows NT Authenticated user based ...
- 39
1
vote
3
answers
5k
views
Mapping a Login to a User
On my production system I login to SQL Server with CPSDOM\mconnors. When I execute SELECT CURRENT_USER; it returns CPSDOM\mconnors.
We use Windows authentication on our DBs.
On my test system I ...
- 141
15
votes
12
answers
207k
views
Error: Cannot Generate SSPI context
When someone tries to connect to a SQL Server instance, the error shows up:
It's not possible do generate SSPI context.
Yesterday we had a blackout (don't know how to say this expression in English) ...
- 7,546
2
votes
3
answers
10k
views
How to enable windows authentication on server that is not part of domain
We have an SQL server instance running on a standalone server (not part of the organizations domain network). Is there any way that we can use windows authentication to logon to sql server without ...
- 63
1
vote
0
answers
207
views
Cross Server and Instance Login SSIS SID or ID Issues
I have some challenging login/SID/ID issues with authentication between databases on separate instances and servers. We have a Development, Test, Pre-Production and Production server/instance ...
- 11
3
votes
0
answers
1k
views
How to set up users in SQL Server 2008 Express over workgroup? (no domain)
The situation is this: simple network, one server not a domain controller, running SQL Server 2008 Express (64bit). 8 workstations running windows 7 pro connected to it. Last week after Windows ...
25
votes
2
answers
98k
views
How can I get my linked server working using Windows authentication?
I'm trying to get a linked server to ServerA created on another server, ServerB using "Be made using the login's current security context" in a domain environment. I read that I'd need to have SPNs ...
6
votes
4
answers
18k
views
Re enable Windows Authetication in SQL Server [duplicate]
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 ...
- 161
2
votes
1
answer
4k
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 ...
- 131
2
votes
1
answer
527
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 ...
- 23
2
votes
1
answer
30k
views
user "sa" cannot connect to SQL Server Express 2008 R2
Goal: connect to SQL Server Express 2008 database using SQL Server authenticated account "sa", rather than my Windows authenticated account.
When installing SQL Server 2008 Express, I took all ...
- 2,116
1
vote
2
answers
5k
views
Login Failed for User
I have written code in Visual Studio.NET and used data from SQL Server 2008. After debugging, it says:
Login failed for user 'sunny'.
When I try to set the user as something else, it keeps on ...
SunnY