No announcements
Found 3894488 threads
-
0 Votes
Remote login IN SQL Server 202
But the issue cannot be reproduced as both login way will succeed or fail at the same firewall setting.Answered | 4 Replies | 1306 Views | Created by Prem Shah - Saturday, January 23, 2016 4:46 AM | Last reply by Sam Zha - Wednesday, January 27, 2016 3:13 PM -
0 Votes
Automatic login for Remote Desktop
MonkeyMark I need Hack that can give Remote desktop ConnectionAnswered | 3 Replies | 18975 Views | Created by MonkeyMark - Thursday, December 13, 2007 2:48 AM | Last reply by pompido - Wednesday, May 13, 2009 8:44 AM -
0 Votes
SQLServer 2012 users Last Login
As others have said, this is nothing that is tracked by default in SQL Server, but you need to cater for it yourself, by one of these means: 1) ...Answered | 6 Replies | 8584 Views | Created by malikasad - Sunday, May 17, 2015 7:36 AM | Last reply by teebag1 - Wednesday, May 22, 2019 8:56 PM -
1 Votes
WMI RESTART REMOTE COMPUTER
You should install some listener on target computer which listen to your commands via TCP/IP and run them in target computer.Answered | 2 Replies | 3635 Views | Created by vitalParsley - Saturday, January 16, 2010 8:33 AM | Last reply by avaNate - Tuesday, January 19, 2010 5:51 PM -
0 Votes
There can be only one!!!
This can be done with a trigger or with an indexed view.Answered | 4 Replies | 1176 Views | Created by Brian Aborg Weje - Friday, September 5, 2014 1:53 PM | Last reply by Louis Davidson - Tuesday, September 9, 2014 3:40 AM -
0 Votes
remote login issue
The linked server were created by replication again and again select isremote from sys.sysservers where srvname='servername' returns 1 for the remote server.Answered | 3 Replies | 2295 Views | Created by oleolehoohoo - Monday, August 1, 2016 6:22 PM | Last reply by Lin Leng - Friday, August 5, 2016 6:40 AM -
0 Votes
One user with two login name
If the issue was resolved, you can mark the helpful post as answer to help other community members find the helpful information quickly.Answered | 4 Replies | 914 Views | Created by Ameneh.Maleki - Thursday, April 5, 2018 7:25 AM | Last reply by Ameneh.Maleki - Sunday, April 15, 2018 5:31 AM -
0 Votes
Allow only connection from same computer
It can be configure after installation ...Answered | 5 Replies | 889 Views | Created by JakobJensen - Friday, July 17, 2015 5:49 AM | Last reply by Olaf Helper - Friday, July 17, 2015 11:09 AM -
0 Votes
create database users from logins
You can drive this from a cursor which loops over sys.server_principals, and generate the CREATE USER command in a string which you use dynamic SQL to execute.Answered | 5 Replies | 5287 Views | Created by Pskubal - Thursday, August 12, 2010 4:41 PM | Last reply by TiborK - Thursday, August 12, 2010 5:26 PM -
0 Votes
Delegated remote administration of only one database on a server with multiple databases
He would see all databases unless revoke view any database is issued against his login name - If you are reovking the permission now this will infact remove view permissions for all ...Answered | 1 Replies | 6100 Views | Created by NLBret - Thursday, April 8, 2010 10:06 PM | Last reply by Lekss - Thursday, April 8, 2010 10:20 PM -
2 Votes
Copy database from SQL server 2008 on one computer to SQL server 2008 R2 on another computer
Manish, The restore worked with the user accounts on the source and destination computers being different.Answered | 13 Replies | 6375 Views | Created by robertrackl - Wednesday, October 26, 2011 5:30 PM | Last reply by Tom Moreau - Friday, October 28, 2011 2:02 AM -
0 Votes
Remote desktop login
or what is the exact error message you are getting incase if you are unable to login to the SQL server.Answered | 3 Replies | 6241 Views | Created by sk12346 - Thursday, May 31, 2012 6:28 PM | Last reply by Rama Udaya - Friday, June 1, 2012 7:03 AM -
0 Votes
Trying to set up a New Login from Workgroup User
You can resolve this issue by creating the same user account with the same password under the Users group on both of the two computers.Answered | 6 Replies | 4922 Views | Created by AlanCam - Thursday, December 3, 2009 3:35 PM | Last reply by Charles Wang - MSFT - Tuesday, December 8, 2009 3:28 AM -
0 Votes
Login Failure for user sp_testlinkedserver
Judging from the screenshot you posted earlier, there is a login-mapping set up for this account.Answered | 10 Replies | 1421 Views | Created by nickswoca - Monday, January 4, 2016 7:30 PM | Last reply by Erland Sommarskog - Tuesday, January 5, 2016 10:23 PM -
1 Votes
Login failed for user ''. getting from SSMS
I experienced this once and it was an actual computer AD account.Answered | 3 Replies | 7502 Views | Created by Satish Kumar Gajula - Saturday, October 22, 2011 1:19 AM | Last reply by Kreadus - Sunday, November 6, 2011 12:44 AM -
2 Votes
Issues with Remote Machine Login into HDInsight cluster
I can surely go ahead and delete the current cluster and create new one, no issues with that, because we din't had anything critical on that one.Answered | 6 Replies | 3844 Views | Created by vishal0soni - Friday, June 28, 2013 6:14 AM | Last reply by vishal0soni - Thursday, July 4, 2013 4:41 AM -
3 Votes
double DisplayName, doube Profiles, same WinLiveID, can login to only one
You can't merge 2 accounts but i think you can change your Windows Live ID Associated with your profile.Answered | 6 Replies | 24039 Views | Created by vbnetskywalker1 - Tuesday, November 30, 2010 4:04 AM | Last reply by vbnetskywalker - Sunday, January 1, 2012 7:16 PM -
0 Votes
How to Create users in sql server for accessing only one database ( withour db_owner permission )
When I have db reader access only to one db and apply following command : Deny view any database to ...Answered | 8 Replies | 6193 Views | Created by Ma4ek - Friday, April 3, 2015 1:22 PM | Last reply by Andreas.Wolter - Tuesday, April 7, 2015 8:55 PM -
0 Votes
Run a program on a remote computer
It should be possible without needing a bespoke service... but I'll need to investigate as you can run WMI queries on remote machines and MMC snap ins let you configure ...Answered | 11 Replies | 16288 Views | Created by derrickwhitt - Tuesday, November 10, 2009 3:55 PM | Last reply by DandandanMSDN - Thursday, July 21, 2011 5:33 AM -
0 Votes
One user cannot login via Forms Based Authentication
Have you tried with a different browser (say Firefox) from that computer?Answered | 2 Replies | 7080 Views | Created by Sephiroth0327 - Thursday, May 26, 2011 4:16 PM | Last reply by Rick A. - MSFT - Thursday, May 26, 2011 7:26 PM
No announcements