Srvr Permissions: Public Gone, Need It Back!
Jun 3, 2008
Hi all,
Hope someone can help: by default, there's an entry for 'public' in server permissions (right-click server in Management Studio > Properties > Permissions), which has 1 selection: 'View All Databases' is set to 'grant'. I wanted to disable this permission, and so unfortunately unchecked the 'grant' tickbox but forgot to tick the 'deny' tickbox. What appears to have happened is the entire 'public' entry has been removed, meaning I can't go back and reselect 'grant' (or 'deny') for 'View All Databases'. I'd really like to get the 'public' role to reappear... Is that possible?
A very big thanks for any help!
View 1 Replies
ADVERTISEMENT
May 2, 2007
I have a db that I use as the backend to an Access application. The application looks at 2 databases that are on the clinet machine. A db from a vendor and my new database. I can read the vendor db (with the proper dns), but I can only read my db when the user has admin privileges. I have granted the public all permissions for the table on my db. What am I missing?
Also, this is a db on a Small business Server 2003 so all of the SQL tools do not appear to be there.
TIA
View 2 Replies
View Related
Mar 27, 2008
Can someone tell me what permissions has public role in sql server? can it read every table or it can just connect to a database and no more?
thanks
View 1 Replies
View Related
Sep 13, 2004
Every night, there are some stored procedures that run to recreate tables so that the information in the table is updated. After the tables are droped and recreated I have to go in and check the select box under the permissions for the public role. If i don't do this users will not be able to select from theres tables.
What can I do so that users are able to select from these tables after they are created?
Would you be able to specify the select permissions for the public role in the script that creates the table or run a script that gives all those tables select permissions for the public role?
All help is appreciated.
View 2 Replies
View Related
Sep 21, 2005
I am working with a SQLServer installation where all public permissionshave been revoked from the system.I currently hold the securityadmin and sysadmin roles to perform mylogicall access control work (creating logins and adding users todatabases and changing group memberships.)There has been a question as to whether or not I need the sysadmin roleto do my job, so we tried an experiment in dropping the sysadmin rolefrom my id.With no public permissions, I see no user information on the server,which really limits my ability to do the job.Has anyone ever worked with a super-locked-down server without thesysadmin role for doing security admin work?What I'm looking for is hopefully SQL to perform the access privilegesneeded for the security admin role by itself.Thanks in advance!
View 2 Replies
View Related
Oct 14, 2004
We have an audit issue that is requiring me to revoke the select permissions from the public role to the system tables. Has anyone had to do this?? What problems did you experience? Are their any tables that you were not able to change the permissions on? Any help is greatly appreciated.
View 5 Replies
View Related
Oct 17, 2007
Hello,
Does anybody have the transact SQL to find the permissions granted to the public role in a Database ?
Also looking for the SQL to find the permissions granted to the user Guest in a database ?
thanks
View 5 Replies
View Related
Dec 3, 2007
Hi
i am new to sql2008 and coming from vb6,sql2000 background. We tried Orcas. we dont want to move our project to dotnet for atleast one year. we want to makie it tune with windows vista also. so kindly tell us which version of adodb can be used with vb6 and sql2008. i am pasting our old code from vb6 here.
Code Block
dim cn as new adodb.connection
cn.open "Provider=SQLOLEDB.1;password=NETECH0507;Persist Security Info=False;User ID=sa;Initial Catalog=" & dbname & ";Data Source=" & gStrSQLServerName
Let me know what are the changes required while connecting with vb6 and sql 2008 express edition
Rgds
Pramod
View 6 Replies
View Related
Sep 24, 2001
Hi!
I have tried installing SQL Server 7.0 on my Win 98 machine. My machine has all the latest service packs and I think it is reasonably up to date. I've tried installing from the disc 3 times and it fails to install:
the Server Network Utility and Service Manager.
As a result, I am unable to register my local machine as a SQL server.
Any ways around this? Quick fixes?
Thanks!
--Michelle
View 4 Replies
View Related
Sep 19, 2000
Our network people changed our machine name one character without our permission, they say their naming standards can't handle an "underscore" we put in our name...now the SQL Server won't run because it doesn't recognize the name of the machine.
Is there a way of bypassing or telling SQL server that we changed the name without having to reload all of our information?
View 2 Replies
View Related
Oct 11, 1999
We have a development server that will only run SQL Server from a DOS command prompt. Each time I reboot the server the services don't autostart, and I am unable to start them manually using Service Manager. Does anyone know what I can do to fix this problem?
Thanks
View 1 Replies
View Related
Feb 12, 2004
Whenever I am trying to put my secondary server operational as my primary (primary is not available) by running
sp_change_secondary_role
@db_name = 'TX_ACCT',
@final_State = 1,
@access_level = 1,
@terminate = 1
I am repeatedly getting this message
Server: Msg 3021, Level 16, State 1, Procedure sp_change_secondary_role, Line 124
Cannot perform a backup or restore operation within a transaction.
Server: Msg 3013, Level 16, State 1, Procedure sp_change_secondary_role, Line 124
RESTORE DATABASE is terminating abnormally.
Server: Msg 226, Level 16, State 1, Line 1
ALTER DATABASE statement not allowed within multi-statement transaction.
Can you please help? This is urgent
View 6 Replies
View Related
Jan 15, 2008
Dear all,
We've a denormalised database (SQL Server 05) with around half a million rows, feeding a fairly simple Analysis Services cube. We were hoping to use the Excel 07 DM add-in as a user-friendly interface to lots of people, but as far as I can tell we need to first import the data into an Excel 07 worksheet. I realise 2007 has a 1mn limit, but the rows are wide, downloading GBs is not possible, and I have concerns about Excel performance and reliability at these volumes, especially on a desktop.
Is there any way to use the data mining functionality without having the data in Excel?
If not, what would be the simplest/quickest/cheapest way of providing this functionality (or subsets of it) to people who know Excel but not data mining?
Thanks for any guidance or corrections,
Chris
PS. Would downloading subsets of the data work, along the lines of the article entitled Sampling Nested Tables ( http://www.sqlserverdatamining.com/ssdm/Default.aspx?tabid=102&Id=14 )?
View 8 Replies
View Related
Dec 17, 2006
Posted - 12/17/2006 : 07:23:22
Hi,
I have just started to learn SQL Server 2005, and am currently using the MCTS SQL Server 2005 Self-Paced Training Kit. I am literally at the very start, and already seem to have hit a snag and can't figure it out. From browsing here in the past I recall people here seemed quite clued up, and I was hoping someone might be able to assist.
I am using SQL Server 2005 Ent. Edtn. (trial) on Win XP Pro (SP2). I am basically trying to run a sample script copied from book to create a database and primary, secondary and log files. Whilst I have the theory down, and thought I understood the SQL (have used other DBMSs in the past, MySQL/ACCESS etc.) I am getting an error when trying to run the following code when connected to the default instance on my PC. The code I am trying to run is:
create database Sales
ON
primary
(name = SalesPrimary,
filename = E:Sales_DataSalesPrimary.mdf,
size = 50mb,
MAXSIZE = 200,
filegrowth = 20),
Filegroup SalesFG
( name = SalesData1,
filename = F:Sales_DataSalesData1.ndf,
size = 200mb,
maxsize = 800,
filegrowth = 100),
( name = SalesData2,
Filename = F:Sales_DataSalesData2.ndf,
Size = 400mb,
Maxsize = 1200,
Filegrowth = 300),
Filegroup SalesHistoryFG
( name = SalesHistory1,
filename = F:Sales_DataSalesHistory1.ndf,
size = 100mb,
maxsize = 500,
filegrowth = 50)
LOG ON
(name = Archlog1,
Filename = G:Sales_DataSalesLog.ldf,
size = 300mb,
maxsize = 800,
filegrowth = 100)
I find I get the following error message:
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'E'.
Msg 132, Level 15, State 1, Line 16
The label 'F' has already been declared. Label names must be unique within a query batch or stored procedure.
Msg 132, Level 15, State 1, Line 22
The label 'F' has already been declared. Label names must be unique within a query batch or stored procedure.
Anyone have any ideas? Your help is greatly appreciated!
Thanks,
Will
View 8 Replies
View Related
Dec 30, 2005
The install went smoth with no error messages. But when I try to open report manager, I am getting the following message:
"The report server is not responding...."
When I try to access the report server, I get:
"The report server has encountered a configuration error. Access denied to the path c:program filesmicrosoft sql servermssql.3
eporting services
eportserver
sreportserver.config' is denied"
I have two partitions on win xp. These are C and D. C is a system drive and this is where sql server 2005 is installed as well.
Any ideas?
View 2 Replies
View Related
Apr 24, 2007
Hello,I'm trying to create a simple back up in the SQL Maintenance Plan that willmake a single back up copy of all database every night at 10 pm. I'd likethe previous nights file to be overwritten, so there will be only a singleback up file for each database (tape back up runs every night, so each daysback up will be saved on tape).Every night the maintenance plan makes a back up of all the databases to anew file with a datetime stamp, meaning the previous nights file stillexists. Even when I check "Remove files older than 22 hours" the previousnights file still exists. Is there any way to create a back up file withoutthe date time stamp so it overwrites the previous nights file?Thanks!Rick
View 5 Replies
View Related
May 14, 2015
New to Database Mirroring and I have a question about the Principal database server. I have a Database Mirroring setup configured for High-safety with automatic fail over mode using a witness.
When a fail over occurs because of a lost of communication between the principal and mirror, the mirror server takes on the roll of Principal. When communication is returned to the Principal server, at some point does the database that was the previous Principal database automatically go back to being the Principal server?
View 2 Replies
View Related
Jun 9, 2015
I need to run two reports each of A5 Size to run back to page and print on single A4 paper means in 1st half Sale bill will be printed and in second half Gate Pass Will Be Printed both report will be on same page and size and shape should be maintained. How to do it.
View 4 Replies
View Related
Jul 20, 2005
Hello,I am hoping you can help me with the following problem; I need to process the following steps every couple of hours in order to keep our Sql 2000 database a small as possible (the transaction log is 5x bigger than the db).1.back-up the entire database2.truncate the log3.shrink the log4.back-up once again.As you may have determined, I am relatively new to managing a sql server database and while I have found multiple articles online about the topics I need to accomplish, I cannot find any actual examples that explain where I input the coded used to accomplish the above-mentioned steps. I do understand the theory behind the steps I just do not know how to accomplish them!If you know of a well-documented tutorial, please point me in the right direction.Regards.
View 2 Replies
View Related
Sep 22, 2006
Does anybody know of a way to rollback SQL Server 2005
databases back to SQL Server 2000? Is there a way of doing it without
resorting to Copy Database Wizard? I love to find a way of attaching a SS 2005 database
to a SS 2000 instance without any issues.
I recently upgraded to SS 2005 and I am very unhappy with the SS 2005 and I
want to rollback to SS 2000, which was a lot more stable. I am having
several major issues that are affecting my whole company's day-to-day
operations and the managers are not happy. Some of the issues include
night time batch running very sluggish for no apparent reason. This is a
biggest problem because it only occurs once or so a week and causes a disturbance
with the daily activities when the night time processing isn€™t completed on
time. The rest of the time, the batch processing runs great, even a little better then on SS 2000. I
don't believe it is a matter of my application needing to be retuned because if
that was the case, then why isn't it running sluggish every night? Also,
it's never the same day that the sluggish behavior occurs. If it was occurring
on the same night, then I would have something to investigate within our
application, but it doesn't. Another issue that I am having involves a
night time job that restores a copy of the production database to the Data
Warehouse server to be used for updating the data warehouse. Again, most
of the time it runs great (~2 1/2 hours), but once or twice a week, it goes
stupid and takes 6 1/2 hours for no apparent reason. Again, it is not happening
the same day either, which could give me something to invesigate. On SS 2000, this same job ran flawlessly. Never I did I run into situation that the
database restoration took that long to run. Even another issue involves a SQL Server Agent Job that was put into suspended
state. What's a suspended state and how can I get it out of suspended
state? I can find no information about suspended state in BOL. I
did a Google and nothing came up. If this suspended state was put
in for security reasons, great, but then tell me how I can remove the suspended
state. I am also not happy with the
fact that I can't get accurate information about the queries that are actively
running at that particular moment. In SS 2000, when I noticed high CPU
usage on the server, I would run the sp_who2 active stored proc and it would
show me all the active thread and how much CPU it was consuming. I would
then find the running threads with the highest CPU numbers and investigate the
query and see if we could improve it. Now in SS 2005, I get in the same
situation and run the sp_who2 stored proc, and there is no smoking gun.
All of the active threads are showing very little CPU usage, which I am very
suspect of. What the heck happen to sp_who2? I looked at some of
the other ways of looking at running processes (i.e... sys.sysprocesses) and
they don't appear to be giving the information that I need.
I am very unhappy and I just want to roll back to SS 2000 and wait a couple of
years before I upgrade to SS 2005.
Dave Brown
View 1 Replies
View Related
Aug 2, 2006
Using SQL Server 2k5 sp1, Is there a way to deny users access to a specific column in a table and deny that same column to all stored procedures and views that use that column? I have a password field in a database in which I do not want anyone to have select permissions on (except one user). I denied access in the table itself, however the views still allow for the user to select that password. I know I can go through and set this on a view by view basis, but I am looking for something a little more global.
View 5 Replies
View Related
May 13, 2002
I am new at this and we encountered a problem. Can names in the public role be deleted? We have some names that need to go - however the delete option does not high light?
I would appreciate your help..
View 8 Replies
View Related
May 14, 2008
Hi Guys,
I am unable to deny DMV rights to public. I have already ran the SQL query successfully:
"DENY VIEW SERVER STATE TO public" and "DENY VIEW DATABASE STATE TO public"
However when I check my master DB, the public still have rights to all the dm_***** objects. Am I doing it wrong or is there any steps I missed out? Can anyone help please?
Thanks a million.
View 1 Replies
View Related
May 7, 2008
Is there a way to make a report public, to outside your domain users? We have a web application the users are authenticated in that is not in .NET and not using NT authentication and we want to have a report linked from inside the application that will pass the parameters in the URL. This is not very sensitive data and the report is using SQL authentication. We also don't want then to log in a second time for the report.
Can this be done easily?
Thanks
Linda
View 6 Replies
View Related
Feb 23, 2007
Hi,
I'm actually using global public variables in the custom code of my reports.
Is there a "chance" that , if the report is executed at the same time by two users, values calculated for an user will be crushed by other user's execution ?
Thanks in advance.
Grégory.
View 4 Replies
View Related
Mar 28, 2007
Are there any restrictions, limitations or anything to prevent the use of SQL Express database being used with my ASP.NET 2.0 application on a public web host?
If so, what are they?
Thanks.
View 10 Replies
View Related
Mar 16, 2004
While connecting to the DB through a public IP from my system i'm getting an SQL Server does not exist or access denied.But while using localhost its working fine.DB setting in the web.config file.The Code is
<!-- application specific settings -->
<appSettings>
<!-- <add key="connString" value="data source=10.1.1.228;initial catalog=ACE;password=XXXX;persist security info=True;user id=sa;packet size=4096" />-->
<add key="connString" value="packet size=4096;user id=sa;data source=EBIZ;persist security info=True;initial catalog=ACE;password=password" />
</appSettings>
What to do for this error.
View 1 Replies
View Related
Apr 26, 2001
Can I grant rights to "public" role ( customize it). Our app uses it.
thanks,
View 1 Replies
View Related
Apr 4, 2000
Is anyone using SQL server to navigate their public web site?
We are concerned about having a database hit every time the user chooses a different page from our navigation bar.
Any advice? Experience with this?
View 2 Replies
View Related
Jul 15, 2006
I get an error in query analyzer when running (parsing query):
CREATE PUBLIC SYNONYM LIB_GROUP_PERMITS FOR LIB_GROUP_PERMITS;
with an error of:
"Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'PUBLIC'."
Can anyone help me at all please!
Thanks!
View 3 Replies
View Related
Feb 14, 2008
set up windows 2003 server
sql server 2000
have public IP from netword soluctions
I can see website
what settings to i need to open up sql server to the public?
View 12 Replies
View Related
Mar 1, 2008
Hi,
I have installed a MS CRM 3.0 Server with SQL 2005 Reporting Server on the same server.
Whenever I access reports from MS CRM with internal IP i.e http://192.168.100.55:5555 within my network every default as well custom reports are working fine.
But the same when I access with Public IP i.e. http://209.199.X.X:5555 I am able to see the application in public i.p but the reports are not working.
Is there any way so that I can access my all reports from MS CRM in public IP.
Thanks
Kshitij
View 1 Replies
View Related
May 30, 2007
I am trying to use variables that are declared in a report that I am created in SSRS 2005.
For example:
Declare @Month as int
Set @Month = case when month(getdate()) = 1 then 9 else month(getdate()) - 3
When I do this, I get an error message, 'The declare cursor SQL construct or statement is not supported.'
So how do i properly declare a variable that can be used through all my dataset?
Thanks, Iris
View 10 Replies
View Related
