Removing Server Groups
Sep 29, 1999In SQL 6.5 enterprise mgr I Could easily delete by right clicking on a server or group. In 7
this functionality is gone. Anybody done this.
Thanks
ADVERTISEMENT
Problem With Matrix (in Subreport, Multiple Groups), Groups Repeating First Row Data
Jan 25, 2008I have a new SQL 2005 (SP2) Reporting Services server to which I've just upgraded and deployed some SSRS 2000 reports.
I have a subreport that contains a matrix with two groups. The report data seems to be inexplicably repeating the data for the first row in the group for all rows in the group. Example:
ID1
ID2
DisplayData
1
1
A
1
2
B
1
3
C
2
1
A
2
2
B
2
3
C
Parent group is on ID1, child group is on ID2, report would show:
1
1
A
2
A
3
A
2
1
A
2
A
3
A
Is this a matrix bug in 2005 SP2, or do I need to do something differently? I can no longer pull a comparison version from an SSRS 2000 server to verify, but I believe it was working as expected before...
SQL Server Groups
Feb 7, 2007Is it possible that i can create a SQL Server Group in sql 2005. Eg. in 2K when u right click (in Enterprise manager) on Microsoft Sql servers you can see "New Sql server Group". I am talking about this group. I have many servers in NYC and Dallas and in VA. I want to group them in the group names NYC DAL VA. is it possible.
View 12 Replies View RelatedSQL Server Admin 2014 :: Determine Which Server Is Currently Active For Availability Groups
Nov 25, 2014I want two write a small script to determine which is the currently active (primary) server in the AG.
Right now, I see that using SELECT * FROM SYS.dm_hadr_availability_replica_states I can determine the role. However, when the server goes down and switches to the secondary node, I don't believe that the role changes (or does it?). How do I determine which is the active node?
Cannot Connect To SQL Server With NT Groups
Oct 8, 2004Hi.
Have problems connecting to SQL server with NT group authentication.
Get error 4064: Error connecting to user default database.
There's no problems connecting with NT users og SQL users.
SQL2000 + Windows2000 both running latest service packs. All SP have been reinstalled.
The server suddenly stopped accepting NT group logins. It have been running for 1 year with no problems - 4 days ago it started generating this error.
Any ideas anyone?
SQL Server 2005 AD Groups
Sep 1, 2006Please excuse me if this is basic SQL, however I'm new to SQL and how
it works.
I'm running SQL Server 2005 and have a number of databases. What I want
to do is control access to each database via an Active Directory group.
The group has been setup in AD and users added. I've then gone into SQL
Management Studio and gone to the Security folder under the server and
then Logins and added the group. Within that I've then added
permissions to a specific database. All good so far, however when you
try to login to the database I get a Login failed error message. In
contrast if I add individual users to the security, Logins on SQL
Manager I can get the DB to open with a username and password box for
the specific user.
What I would like to know is:
How can I control access to SQL Databases using Active Directory
Security Groups?
What setup is required on the SQL side to allow access to the databases
from users in the security groups, but still require them to login with
their windows authentication?
Removing A Server Name
Mar 31, 2007SQL
Upgrading to VS05 Pro SP1/SqlExpress (from VS03 Pro/SQL MSDE)
Question 1) €“ is there a way to tell which version of the SQL Express was installed? I think it is €œSQL Server 2005 Express Edition With Advance Services€?, but don€™t know how to confirm that.
Question 2) - SQL Server Management Studio Express, Registered Servers, it shows :
Database Engine
sqlexpress (note the lower case)
If I right click and choose €œPreviously Registered Servers€?, it shows a message that I will be displaying SQL Server 2000 (i.e. MSDE) server names, and it shows
SQL Server Group
SQLEXPRESS (note the upper case)
CSOLUTION
I wish to completely remove CSOLUTION (in MSDE you would uninstall it from the Control Panel), but right clicking and choosing the delete option does nothing (it does not delete it). Deleting SQL Server Group also has no affect either. How do I remove CSOLUTION ?
Question 3) - In the VS05 program, the SQL connection string includes €œData Source=.SQLEXPRESS€¦.€? (NOTE UPPER CASE) Why do I have a lower case and an upper case listed above? Starting/stopping one sqlexpress/ SQLEXPRESS does the same to the other. Don€™t I wan€™t to complete delete anything under SQL Server Group since it represents SQL Server 2000 (i.e. MSDE) server names? SQL Server 2000 and CSOLUTION have been uninstalled from this machine.
Thanks!
bob
Off Thread: SQL Server Users Groups
Feb 12, 2004Hope I'm not going to annoy anyone here too much but I'm looking for a place to post a job opening and was hoping that someone out there might know of a good site or two.
The job will be in the north Denver area.
Thanks! (And apologies if this is completely inappropriate behavior.)
Windows Groups For SQL Server - What Am I Doing Wrong?
Jul 23, 2005Hi there,I have an Access front end application that uses a SQL Server 2000Desktop Edition backend. I have created a package with the Access2003 runtime that I'd now like to deploy. I have created a globalgroup in the domain and placed the users that I'd like to give accessto the database (via my application front end) in that group. I'vethen created a local group on the SQL Server machine and added myglobal SQL Server group to it. I've also added that local group asdatabase user from SQL Server. From my reading of the variousmaterial on the Internet this should work but it doesn't. I can'taccess the database via the application from any machine other than mydevelopment machine. My VBA code specifies integrated security forthe connection string.Help please! I'm so close to deploying this and now I'm bogged downin security. Any ideas anyone has would be appreciated. Accountadministration and Windows security is not my strong suit.Barb
View 2 Replies View RelatedImportance Of The New SQL Server Windows Groups
Oct 19, 2005Those of you who have installed SQL Server 2005 may have noticed that the installation creates several new Windows groups on the server. Do not underestimate the importance of these groups.
View 3 Replies View RelatedWill Removing A Registered Server Running SQL Server Remove The Database Too ?
Feb 17, 2006Hi all, i encountered this problem.. whenever i tried to create publications it always prompt me this error msg "sql server replications does not support nicknames,such "." or "(local)". i know i need to delete the registration and register a new server with a different name.. i just want to double confirm whether deleting the registration will affect the databases or not ? :
View 1 Replies View RelatedRemoving IIS From A SQL7 Server?
Feb 26, 2001An unknown person at a client's site installed IIS on a production SQL Server. I would like to remove it (it's not being used and the service is shut down). Does anyone know of any troubles with uninstalling IIS? Will the removal also hose SQL?
Thanks in advance?
Steve
Removing SQL Utilities Off Server
Aug 27, 1998Does anyone know how to remove SQL utilities off the server manually.
When I run the setup.exe from the SQL CD to remove SQL from server that option button is
shaded, I try reinstalling SQL utilities and then I try removing and still it won`t let me?
Help!!!
Removing The Echoing Of Sql Server
Sep 20, 2006Hi All,
Hope all is going well ...... I have a question for you ...
Whenever we execute any command in sql query analyzer ... suppose to retrieve a table ... the sql server echoes a line .... 'X rows selected ' or like that ....
Is there any command by which I can supress the echoing of SQL Server in the GRID box ....
Like that @echo off in DOS
Removing A SQL Server Instance
Jan 30, 2008I have to install SQL 2000 and SQL 2005 on a server to do a Share Point upgrade. After the upgrade I want to remove the SQL 2000 instance.
My question is, has anyone done this and what, if any, issues did you have. Does it matter what order they are installed in? Will I break my 2005 instance when I remove the 2000 instance?
Any information would be greatly appreciated! Thanks in advance!!
Jim Youmans
St Louis, MO USA
SQL Server 2012 :: MIN And MAX Dates For Groups Of Rows?
Jan 21, 2014I have a dataset that contains an EmployeeID, StartDate, EndDate, and Location. Each record tells me at which location and employee was during a payroll period (fortnightly). So the data looks like:
EMP_KEYSTART_DTEND_DTLOCATION
120130117201301318103
120130117201301318103
120130131201302143354
120130131201302148103
220130117201301311234
220130131201302144567
120130214201302283354
220130214201302281234
Employees can be at multiple locations during the two weeks. They can work at one location, stop working there, start working somewhere else, and then maybe go back to their old location. There are duplicate records here as each employee can be at the same location multiple times during the two week period. What I need to capture is the actual start and end date of an employee at each location for each 'assignment'. An assignment is defined as a continual period of employment at a location with gaps of no less than 4 days - if there is a gap of more than four days then that is classed as a new assignment.
SQL Server 2008 :: Using Groups To Manage Privileges
Mar 7, 2015I am still fairly new to Sql Server 2008 R2 (express) , but am enjoying exploring it.
I have several databases up and running and now a large number of users in each.
But I notice whenever I write a stored procedure I have to go in and add each user to give them permission to exec it. When the user numbers are low its not a problem but I now have over 20 users on 1 database and its becoming tiresome.
I have heard of Active Directory on Windows Server but my database is installed on windows xp professional PC. Its running well and we don't have a budget to change it.
I've been searching the internet to see if there is some way I can create a group within sql server give the group all the necessary permissions/ privileges and then add the users to that group thereafter...
SQL Server 2000 And Active Directory Groups
Mar 19, 2008Hi all,
just want to confirm this:
We have a department and want to grant them access to various databases on a sql server 2000 instance. Can we create an AD group for these users and just add the group as a login to SQL Server? Or do we have to create a db user for each member of the group and map the logins one by one?
Thanks
Removing Certain Records Of A SQL Server Table
May 10, 2004Hello all,
A little question regarding SQL Server DB's.
I have a two tables containing customers invoices, one for the invoices header (ie: customer #, invoice date,... KEY: invoice # + invoice date) and another for the details of the invoices (ie: each invoice line details KEY: invoice # + line #). I need to periodically remove invoices older than a certain timeframe (ex: all invoices older than 48 months).
How can I proceed?
I am fairly new with SQL server.... Please help!
Thanks,
Eric
:(
SQL Server 2014 :: Getting Unique Number For Groups Of Records?
Aug 6, 2014I'm trying to do the following and haven't been able to figure it out.
Say there's a table with these records:
Col1 Col2 Col3
a b c
a b c
a b d
e f g
e f g
I want to generate a number that represents the groups of columns like this:
Col1 Col2 Col3 MyNumber
a b c 1
a b c 1
a b d 2
e f g 3
e f g 3
So that each grouping gets its own identifier. I've tried this:
SELECT Col1, Col2, Col3
row_number() OVER (PARTITION BY Col1, Col2, Col3
ORDER BY Col1, Col2, Col3) AS MyNumber
FROM MyTable
But I get this:
Col1 Col2 Col3 MyNumber
a b c 1
a b c 2
a b d 1
e f g 1
e f g 2
SQL Server 2012 :: Rank On Repeating Groups Of Bit Field?
Jan 16, 2015I have some data where a bit value changes over time and I want to rank it by the repeating groups, how do I write the SQL so that I get the result below?
I want to sort by create date, and every time the bit changes value we start the rank over.
If I partition by the bit field, it will just group the entire data set by the bit field.
Bit CreateDate Rank
1 3/15/2014 1
1 3/14/2014 2
0 3/9/2014 1
0 3/8/2014 2
0 3/6/2014 3
1 3/4/2014 1
0 2/28/2014 1
0 2/20/2014 2
0 2/15/2014 3
0 2/10/2014 4
SQL Server Admin 2014 :: CDC And AlwaysOn Availability Groups
Apr 2, 2015The MSDN doc makes it sound like after a failover of the primary, the CDC data won't "keep working" on the secondary unless you "To allow the logreader to proceed further and still have disaster recovery capacity, remove the original primary replica from the availability group using ALTER AVAILABITY GROUP <group_name> REMOVE REPLICA. Then add a new secondary replica to the availability group."
We have a few CDC tracked tables that we use and the general idea of AlwaysOn I thought was to minimize all the overhead and let things "just work" so your apps just connect and the listener re-routes everything where it needs to go.
It looks like to get this working properly an automated job /trigger would have to wait for a failover event and then kick off tasks to remove and re-add the replica and perhaps start up the CDC job on the secondary?
SQL Server 2012 :: How To Choose Max Of Each Groups Formed By Row Number
Sep 15, 2015I have a below table as:
IF OBJECT_ID('tempdb..#Test') IS NOt NULL
DROP TABLe #Test
--===== Create the test table with
create table #Test([Year] float,
Age Int,
)
INSERT INTO #Test
([Year], Age)
[Code]...
I queried below to get additional column
Select *,row_number() over(partition by [Year] order by Age) as RN from #Test as
YearAgeRN
2014301
2014312
2014323
2015251
2015262
2015273
2015284
2015295
i want one more addtional column (Desired Output) with max of RN in each group as below"
YearAgeRNDesired output
20152515
20152625
20152735
20152845
20152955
20143013
20143123
20143233
SQL Server Admin 2014 :: Way To Restore All File Groups Except One?
Oct 19, 2015is there a way to restore all file groups except one? example: Database A has 10 filegroups, but 1 of them is defunct, so i cant delete it and there's no backup for restore it.Can I create a new DB restoring the 9 good FGs from a database A's backup?
View 9 Replies View RelatedActive Directory Groups Don't Work With Linked Server?
May 24, 2006I mapped a login created with an Active Directory Group on server A to a login on server B through a linked server on server A and received a null login error when attempting to connect.
I changed the Active Directory Group login to an individual active directory login and the connection worked fine.
I saw someone post online somewhere that Active Directory Groups don't work with linked server by design--but I wanted to get confirmation on this. Can anyone confirm this, particularly someone from Microsoft?
How To Create Missing SQL Server Local Groups After Installation
Dec 17, 2007
I have a clustered server environment where three of the SQL Server local groups were not created during installation. One of these missing groups is SQLServer2005SQLAgentUser$ComputerName$InstanceName, and this is causing problems with trying to automate replication.
How do I create this group after I have installed SQL Server?
Thanks,
Neal
Can't Add Any Groups To A SQL 2005 Login On Windows 2008 Server
May 16, 2008 Hi,
We have just created a new Windows 2008 server running SQL 2005 64 bit. I am in the process of migrating old SQL 2000 databases onto this new server. One of the databases required a SQL login for some Windows groups that get created from the SMS software. I'm having a problem when I go into create a new login, select object type Groups, from this location , I enter the object name and click Check Names and it finds it. I select okay and everything looks good. But when I click ok on the New Login screen, I get the 15401 error saying that Windows NT user or group not found. I have gone into the Server Manager - Groups and verified that the group exists, and it does. The only thing I see when I click properties is on the bottom right had side of the screen it says "Changes to a user's group membership are not effective until the next time the user logs on." It says this for all the groups on this server and I get the same error message when I try to add any group. I have had the user that is a memeber of this group log off and back on a few times, but it still says the same thing and I still get the same error.
Anyone have any ideas on what the problem might be? Is there something on the Windows 2008 server setup that we missed?
Thanks,
Isabelle
SQLServer2005MSSQLUser$ And The Other SQL Server 2005 Security Groups Deleted
Sep 19, 2007It appears that I have a machine where the SQL Server 2005 Security groups were deleted, now I am unable to change account settings in configuration manager ( I get a WMI provider error ). Is there any way to recreate these security groups without uninstalling and reinstalling SQL Server?
View 3 Replies View RelatedSQL Server 2008 :: Removing Null From Result Set
Aug 25, 2015I want to remove the nulls from the result set so the result is 1 line. Code and results are below:
SELECT
CustomerNumber,
(case when yearseq = 2012 then isnull(sum(mainPower),0)+isnull(sum(sidePower),0)+isnull(Sum(leftPower),0)
+isnull(Sum(netappPower),0)+isnull(Sum(rightPower),0)+isnull(Sum(lowerPower),0) end) as '2012',
(case when yearseq = 2013 then
[Code] ....
What can I do to my code to remove the Nulls to the entire result is just 1 line?
Removing Installed Instances From SQL Server Express
May 16, 2007I installed SQL Server Express trail for 3 times each with new instance. Now I came to know that I need to have a default instance. I un-installed the SQL Server Express and tried to install it again. It still says I have installed instances and if I select default instance the option buttons are un-checked and disabled. I tried to delete all the folders related to the SQL Server installationa dn tried but still I see the same thing. Please help me in istalling the default instance.
Thank you.
SQL XML :: Server Is Removing First Character Of Values If It Is A Space
Jun 3, 2015I'm creating a table using a XML string and a stored procedure to the SQL Server. I'm having problems in just one field, it is a nvarchar(10) type. This field's string XML Schema is also nvharchar(10) type. It is called CodCanalPrice.
Today, the only values this field can assume are AA or BB or CC, (...), ZZ or (space)A, (space)B, (...), (space)C. Note that (space) is actually a space character. They all have 2 characters.
The XML data string of one data row is showed below:
<row id="1" (...many fields...) CodCanalPrice=" A" />
When the statement is executed, SQL server removes the first space (so in this case it is updated to A without space in the table). The others values that don't have an space before like AA or BB are updated fine. All others fields are also updated correctly.
So far I tried to replace the first space for  but SQL Server doesn't accept this tag.
SQL Server Admin 2014 :: How Does Security Works Between Availability Groups
May 21, 2014how does security works between availability groups.
ex if i create an object and grant permissions to a user will that be replicated to secondary replica .
SQL Server Admin 2014 :: Load Balancing With Availability Groups
Aug 28, 2014We are having a conversation at work and the subject of load balancing with SQL came up. Right now we are running SQL Server 2014 on four (4) machines. I am using a AlwaysOn with Availability Groups (AG). Now I know that we can scale out the reading in AG by allowing the secondary serves to receive reads.
Is there a way to be able to do this with writes? Can I have in essences 2 masters that some how reconcile with each other? We are expecting a huge amount of writes in the near future and we need a way for SQL to handle the amount of traffic we are expecting with out any issues.
I explored the possibility of Peer - to - Peer replication; however, it seems that it would be more work if we are constantly making updates to the database scheme.