Hi All,
I encountered a bizzard situation. The guest id in tempdb disappeared after I rebooted (shutdown and startup) my server. That caused errors in application whenever a stored proc needs to create a temporary table.
Has anyone seen this happened before? Any idea on why or how it happened?
Thanks in advance.
When i restart my database server, guest login is getting deleted automatically from tempdb. it shudn't happen. please can anyone suggest me solution for my problem.
thanx and regards
kiran
Everytime I reboot my sql server 2000 the guest account on tempdb is gone, but the guest account on master remains.
Can anyone offer my any ideas how I can stop that from happening?
thanks
View 7 Replies View RelatedToday when I tried to troubleshoot a failed job, I found out that the job history is disappreared. Some jobs' history still exist. Does anybody have idea what happened? How can I fix it?
Thanks a lot.
When I removed/re-installed SQLServer 2005 (Express) all of my dll's related to SQL Server disappeared from C:ProgramFilesMicrosoft SQLServer90SDKAssemblies: .ConnectionInfo, .Smo,.SMOEnum,.SQLEnum,.WmiEnum that I know of - maybe more.
How can I re-install these? Are they in the SQL kit, VB, SDK ???
Any help would be appreciated.
Hi,
We had 5 instances of SQL Server running on one of our machines and everything looked to be working fine. Today I installed another instance for a new application and once done and rebooted the new instance didn't show in the SQL Server Enterprise Manager. At this point we decided to uninstall it. After that 4 of the existing instances have diapered as well even though they are running and responding requests from their respective applications.
I did some googling and all I could see is something related to a command called nscontrol but I couldn’t find any nscontrol executable on that machine.
Does anyone have any idea what this problem could be?
Thanks
On Tuesday the SQL Server Counters showed up in Performance Monitor. Yesterday they were gone. Is there any way they could have disappeared other than someone explicitly deleted them? How would I go about restoring them? Obviously, I'm concerned.
Thanks for the help.
I have a stored procedure that for some reason disappeared on me. When I do “select * from the sysobjects”, it’s there. When I look at it from the EM, it’s not there. I refreshed everything a lot of times. Here is the data I get from the sysobjects:
myproc90587511U 141610615041224002002-01-26 15:41:13.44702240U 18302002-01-26 15:41:13.447000005200
Any help would be greatly appreciated.
We setup a number of roles with access rights to tables in the DB. This week for some unknown reason, rights on these roles disappeared.
We had to run a restore to reset the roles in the database. After the restore, we could not reproduce the problem.
Are there scenarios to avoid that would cause rights to drop from roles and users? (These rights were gone not just hidden)
Tim.
Hello,
I was modifying some standard reports of one planning program, by downloading .rdl file from report server and creating a new report project. I have done so many times.
Last weak in one of those new reports only header of the report was seen in the report server as I thought I had made some kind of mistake tried to look for it, and after some time the problem fixed itself and I blamed everything on one mixed up connection between the tables in the report, because after removing it the problem fixed itself, but now I think that was just a coincidence.
This weak after working fine for about a weak, 6 reports appeared as only headers and footers, they worked fine yesterday and no changes were made to the reports, but in the morning only the header is seen.
The reports that are affected are the 4 new ones, and 2 original ones, they are all dealing with the same date just different grouping and sorting.
Does anyone know how to fix this problem?
Darius
hi,
i have starange problem here.
i have total 10 nt groups mapped to security manager.
today when i opened security manager it is saying no groups
in the security manager,security manager is blank.
i am using mixed security mode.
pls give me any ideas..
it is very ugent pls..
Thank u very much
--Kavira
hello,
am not sure if this is the right forum to post this.
We have a couple of sites running MS SQL, however we have never had issues with data corruption.
I was working with a certain site and then noticed that all users in the users table were missing except one.
Secondly, the users table had all permissions revoked.
how did this happen and whats the best way to go about restoring it.
Ehi
Suddently System Databases Folder is not showing on Studio 9.0 for all the SQL servers instance. Do you know why ? Is there any option other than De-attach them?
If our SQL Server is not part of a domain, can "Guest" users still connect to the SQL server?
What we are experiencing is -- when a drive is mapped to the server connectivity is fine.
But, without the drive mapping, the SQL connections cannot be made.
Thoughts, Ideas,
(hopefully without adding unique logins for each user at the server)
I want to know what is the guest account and what its use for ?
View 1 Replies View RelatedHello world
View 1 Replies View RelatedIn SQL2K5 guest user can not be dropped from ANY databases. How ever we can use the following command to disable it.
USE <Database Name>
GO
REVOKE CONNECT FROM GUEST
GO
How to find in a DB, whether guest user is disable or not, using TSQL?
------------------------
I think, therefore I am - Rene Descartes
Nel database "master" ho mappato, per errore, l'utente "guest" su unutente sql "XXX" creato in SQLServer.Questo tipo di impostazione non permette più di aver accesso conl'utente anonimo "guest" (mappato su null) al db (con autorizzazionilimitate al ruolo public).Ho provato sia da EM che con le varie SP a rimuovere l'utente, amapparlo su un'altro utente, ... ma non sono riuscito a ripristinarela situazione di partenza.Mi servirebbe una idea per non dover effettuare il backup di tutti idb, disinstallare SQLServer, reinstallare SQLServer e fare il restoredi tutti i db (soluzione possibile ma che tengo come ultimaspiaggia!!).Grazie
View 1 Replies View RelatedHas anyone seen the SQL Server error:
"tempdb is skipped. You cannot run a query that requires tempdb"?
We're running a .Net web application with a SQL Server 2000 backend, and we get the error intermittently. Restarting the SQL Server service seems to fix it, as it causes tempdb to be rebuilt, but this isn't a long term solution. Any direction or hints would be greatly appreciated. Thanks!
- Mike
I would like a guest to view some items on the application.
And I recently intalled SQL Server 2000 on my machine. Will integrate Access when ready.
I can access or simply read data from a db if I specify User ID and Password.
Such as....
Dim nwindConn As SqlConnection = New SqlConnection("Data Source=localhost;User Id=sa;Password=xxxxx;Initial Catalog=Northwind;")
Yes, testing first, then adjusting all my code for the SQL instead of Access.
If I leave the id and pw out, it won't read - login failure.
I have read so much on authentication and some posts here, even the one on login failure, but that didn't help.
Keep in mind, just installed, only users are the default ones by the installation.
What setting in the SQL Server is there, and I have looked, that if it's a guest, no id or pw, allow read only to items such as datagrids which only read from tables?
Thanks all,
Zath
How do you disable Guest account in SQL Server.
can you do this thru registry?
Tahnk You,
Piyush Patel
Hi,
I know this seems odd but is there any way to change the guest's password?
I know this is paradoxical regarding the nature of guest user but if there is any way please clarify me!
-Thanks
Hi,
I have some questions regarding guest acct. I am using some database security scanning software (again) and it says that guest acct should be dropped from these databases, msdb, pubs, Northwind.
Can i safely say that i can drop the guest acct in pubs and Northwind without any issue?
For msdb, will there be any concerns? How can i verify?
If i just revoke the public permission on guest, is it the same as dropping the user?
Lastly, I see that in all databases, the guest acct exists, but some are of permit and some are of via group membership for the database access column. What is the difference?
Thanks guys. appreciate your help. Audit deadline coming up.. i still have about 20 more audit pts to go... :)
Just wondering what is the use of the build in guest account in SQL2000?
Should you remove it? Or just leave it there?
I quess a user can make an odbc connection to the database with that account, but can cause no harm.
What to do?
Greetz,
The nerd.
I've used the following:
EXEC sp_MSforeachdb 'USE [?];
REVOKE CONNECT FROM GUEST;'
GO
And this is what I get:
Msg 15182, Level 16, State 1, Line 2
Cannot disable access to the guest user in master or tempdb.
Msg 15182, Level 16, State 1, Line 2
Cannot disable access to the guest user in master or tempdb.
Msg 15151, Level 16, State 1, Line 2
Cannot find the user 'GUEST', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 2
Cannot find the user 'GUEST', because it does not exist or you do not have permission.
Msg 15151, Level 16, State 1, Line 2
Cannot find the user 'GUEST', because it does not exist or you do not have permission.
When I do this:
EXEC sp_MSforeachdb 'USE [?];
SELECT ''[?]'' AS DBName,* FROM sysusers;'
GO
The guest sid for all tables shows 0x00, is this the reason I get above errors?
I try to attach a database mdf file to Microsoft SQL server 2014 on Amazon Elastic Computing Cloud, EC2, but fail with the following message, "User 'guest' does not have permission to run DBCC checkprimaryfile. (Microsoft SQL Server, Error: 2571)" The ID I use to REMOTE login has administrator rights and I have chosen to "run as administrator"
View 1 Replies View Related
Hi All:
I hope I'm in the correct forum for this question. If I'm not, forgive me and point me in the proper direction.
I have SQL Server 2000 databases that I am trying to secure. To that end I've deleted the guest account from all but the master and tempdb databases.
Within the master db I've denied access of any "flavor" to all objects but spt_values, syscharsets, sp_MSSQLDMO80_version, and sp_MSdbuserpriv (only because I've discovered they are necessary).
Can anyone tell me where I might find the absolute minimum permissions configuration for the guest account in master?
I have no third party vendor software accessing my SQL Server 2000 databases. The thought of
Demographics:
SQL Server 2000 sp4 running on Windows 2003 Server with the current service packs.
Any help is greatly appreciated.
caeriel
I've read a bunch of articles saying you should always remove the guest user from the user databases and model. It seems to me that if a user only has public access then the user can't do anything on the database. If the guest user only has public access to a user database how is it a security threat? I must be missing something.
View 0 Replies View RelatedCan I use osql to known the database install on a server via 'guest'account ?I had over 300 servers with sql server all around France (differentversion : 6.5, 7 and 8)I need to check all database on each servers from my place.Of course, also it would have been to easy, I don't have all 'sa'password...Is that possible to use the 'guest' account to execute a query likethis via osql :Extract.sqlexec sp_helpdbExtract.cmdfor /f "usebackq tokens=1 delims=" %%i IN (ListServer.txt) DOosql-S%%i -Uguest -P -dmaster -i"C:ExtractionExtract.sql"-o"C:Extraction\%%i.rpt"Could I query 'master' with the 'guest' account ?Or any other ideas how to do this by an other way ?Thanks
View 1 Replies View RelatedHi Guys,
We are using MS SQL 2005. I am ask to remove the PUBLIC rights to the objects listed in the following query in the master DB:
SELECT sysusers.name, sysobjects.name,sysprotects.action FROM sysobjects, sysusers, sysprotects WHERE sysobjects.id = sysprotects.id AND sysprotects.uid = sysusers.uid AND sysprotects.protecttype = 205
I keep having the "Cannot find the object [Objectname], because it does not exists or you do not have permission."
How do I create a query to remove the PUBLIC rights at a single run. (There are total of 1660 items, please dun ask me to write the DENY or REVOKE statement 1660 time )
How do I DENY the rights for objects starting with the prefix "dm_" or items like "TABLE PRIVILEGES"
Thanks guys Any help on this is greatly appreciated.
Hi
I have a situation (on SQL Server 2000 SP3a) where the guest account appears in the list of database users despite the account being removed via sp_dropuser.
The guest account appears in the list of users with Database Access set as 'Via Group Membership'
Once in this state it cannot be removed as sp_drop user will now report:
Server: Msg 15008, Level 16, State 1, Procedure sp_revokedbaccess, Line 36
User 'guest' does not exist in the current database.
My conerns are:
(a) Does this imply any security risks ?
(b) How can I remove all reference to the guest account?
Any ideas or suggestions would be appreciated
Regards
Nadreck
Hi all,
I have setup a new SQL 2000 SP4 and internal auditor query about revoke permission from Public role and remove guest from all databases.
1. Can I revoke all default permissions (select on system tables in all DBs) from "Public" role? I am concern any error after such action.
2. I found that guest account in DB -- master, tempdb and msdb. According to Microsoft documents. The account should not remove and can't from master and tempdb. How about msdb?
Thanks,
Regards,
Edwin