No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Unanswered0VotesAdding Windows groups
I'm having an issue adding a windows group in SQL server 2008R2. The instance is running on Windows 2008 and as mentioned is a SQL 2008R2 instance. If I add a windows user they are able to ... -
Answered1VotesCan not remote-connect to SQL with public IP after changing the port number
Hi Well, 2 hours I searched the internet to look for an answer but failed. I have SQL 2008 R2 developer installed on the windows 2008 standard server and is ... -
Unanswered0Votesallow sysadmin role temporarily, is it possible to do in a secure way.
Hi everyone I'm in a environment where a number of systems do not hava a test/acceptance environment. For example telephony, or systems thats integrated with *IX systems, or squid ... -
Unanswered0VotesSp_xp_cmdshell_proxy_account not changing xp_cmdshell context?
Hi, I've reset the proxy account using: EXEC sp_xp_cmdshell_proxy_account NULL; Then I created a new proxy account: EXEC ... -
Answered5VotesGranting Permissions to AD Group on SQL Server 2008 Instance
Tech Folks, Good Morning!!!! Here is my question ....I am using "Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 ... -
Proposed1VotesHow to set check password policy false for all future new users
Hi, We are receving an exception when we are creating a user from our application "SQL SERVER 2008 password validation failed the password does not meet ... -
Unanswered0VotesUpdate user
Hi, I have the below user for my database: GO CREATE USER [sun] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[sun] How do I edit the user so that the LOGIN ... -
Unanswered0Votesexecute permission on a procedure allows selects without specific read permission
Does this behavior seem correct or am I not seeing some hidden security setting? I have a brand new login that I just mapped to a database. All that this user has is an execute ... -
Answered21VotesWindows Authentication - Different Domain
Hi: I am trying to figure out if there is a way to connect via SQL Server Management Studio to a server sitting on a separate domain. So here is the situation. there is Server B ... -
Proposed1VotesConfiguring Sql Server 2008R2 for encrypted connections
I have followed the recommended steps at http://technet.microsoft.com/en-us/library/ms191192.aspx in order to configure my certificate and for Sql Server to accept encrypted ... -
Unanswered0VotesHow to give a instaled sql server 2000 windows authentication
Dear guys I installed a software. That software installed a sql server 2000 instance. But don't have access that sql server. So I install Sql server client tools to get access that sql server. ... -
Unanswered0VotesIdentify Windows database user created without login
Hi guys, I'm running into an issue when try to sweep out orphaned database users. Basically, it's about the way how to identify orphaned Windows database users from Windows database ... -
Discussion0VotesTEMPDB doesn't show it's encrypted when other databases are encrypted for sql 2008 R2.
when I encrypt a database in sql server 2008 R2 the documentation states then once a database is encrypted tempdb becomes encrypted. but when I look up properties in SSMS for tempdb it doesn't show ... -
Proposed0VotesMinimum permissions
SQL2000 What are the minimum privileges / permissions / database roles needed to grant a user (besides granting sysadmin) to: 1) Create and ... -
Unanswered0VotesThe server principal 'username' already exists (Microsoft SQL Server, error: 15025)
SQL Management Studio SQL 2008 R2 Create database Restor from backup Now I am trying to ... -
Unanswered0VotesDatabse shrink status
Hi All, I have started the databse shrink using GUI, It's keep on running since 1 hour. The DB size is 53GB. ANy idea how much time it will going to take to ... -
Unanswered0Votesproblem Encrypting Database from master key
Hello All, I need a help.. I use tempdb for createing master key, becuase masterkey was already created by someone in the master database of system ... -
Answered10VotesMicrosoft SQL Server Error 18456 Severity 14 State 1
I can't seem to connect to our local instance of Microsoft SQL Server. I obtained the followinf infrotmation from the error log and I can't find anything in regards to Severity 14 and state 1. If ... -
Proposed0VotesAlter index or table
I have SQL2008 and I'm sys.admin on that server. But I can't create alter table or alter index script, it is disabled(grey). If I click on some index, I can't add columns or change ... -
Answered0VotesSQL 2012 - Backup to remote device
Hi I need tips in resolving "access denied" errors on a network share. Using the agent account i can manually copy the local BAK to the remote ... - Items 1 to 20 of 6236 Next ›


