Tagged Questions
1
vote
0answers
42 views
how can Audit All Login To SQL Server BY ODBC Connection
I MAke Report By Access Form On SQL database
I make ODBC Connection For login To Update the data From Database
Now I want Audit All logins To know who make Update today Or who make Update Now ?
...
0
votes
1answer
29 views
Add user to sql server with the required permission
In my sql server express 2008 r2 i have about 15 login account. Now i want some about 5 users have full permission while some other 5 users with limited access to some database, and other users only ...
4
votes
1answer
439 views
The login already has an account under a different user name
When I execute this SQL:
USE ASPState
GO
IF NOT EXISTS(SELECT * FROM sys.sysusers WHERE NAME = 'R2Server\AAOUser')
CREATE USER [R2Server\AAOUser] FOR LOGIN [R2Server\AAOUser];
GO
I get the ...
3
votes
1answer
196 views
SQl Server 2008 R2 - sa can login but not access database
Up until this morning I had no problems accessing our database.
This morning, something has changed and I can no longer access our database (called EMS_Main) using the sa login. I can log into the ...
4
votes
4answers
575 views
SQL Server script to delete accounts no longer in Active Directory
We have a SQL Server 2000 that will shortly be migrated to SQL Server 2005. It has years of Windows Authentication accounts created that no longer exist in Active Directory, which prevent the Copy ...
2
votes
2answers
137 views
How to login in database if we have lost password? [duplicate]
Possible Duplicate:
gain admin access to sql express 2008
Is there any idea if we lost our password to login in database using sql express management studio?
Is there any place where ...
3
votes
1answer
135 views
How to link users and logins in an Availability Group?
I've got an Availability Group going and need to map some logins to database users on an active secondary replica. (Node2) Unfortunately, when I try to exec sp_change_users_login or alter user with ...
5
votes
2answers
324 views
How to handle sql server database logins when using AlwaysOn. (they aren't syncing)
We have 2 servers in an AlwaysOn group.
While the user accounts within each syncronized database exist on both servers, the database instance level logins only exist on one of the servers. Ie ...
4
votes
1answer
2k views
Login failed for user - Error 18456 - Severity 14, State 38
Message that SQL Server Log File Viewer shows:
Login failed for user [User]
Error: 18456, Severity: 14, State 38
What it actually means:
Failed to open the explicitly specified database
My ...
3
votes
2answers
137 views
Integrated Security Success on Master, Fails on Other Database
I'm a bit perplexed as to why my connection string is selectively succeeding on the master database in SQL Server 2005. Here are the details of my app. Any ideas where to look? I'm clearly missing ...
4
votes
4answers
373 views
T-SQL command to log in as a different user?
Is there a T-sql command, like the Oracle "Connect" which lets me change the user that I am logged in as?
