I am experiencing problems with the lockf function on AIX 5.3.The man page for sigaction states that if SA_RESTART is setthen the lockf function will restart if the process receives a signal,but the lockf function in my program returns -1 with errno set to a value of 4.I have included my test program (tlck.cpp) which shows the problem,together with a "tk" script for sending SIGUSR1 signals to the process.The tlck program is compiled using the "xlC xlC tlck.cpp -o tlck" command.If the tlck program is run on two terminals and the tk script run on a third,then the process being signalled by the t
Hello, I am trying to track down a good program that is good with Python and C++ combined thats what I believe is in the SA:MP coding process. I already have a gamemode I had downloaded I'm just trying to have someone alter it I want alot of changes done to the script. 'The gamemode is based as Role Play and I want it to be combined with deathmatch areanas, racing, hitman they kill people for money which people place hits on each other then again enforcing them not place random hits on each other. I want to be strictly everything to be followed by rules like excessive team killing, excessive i
===========================================================MicrosoftSQLServer 2000 Driver for JDBCSQL ServerLogin failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.SQL state: HY000SQL error code: 18452MicrosoftSQLServer 2000 Driver for JDBCAn error occured while attempting to log onto the database.SQL state: 08001SQL error code: 0===========================================================Windows Server 2003 SE R2 x64 + fixes, MS SQL 2000 EE SP4 mixed mode with the JDBC connector, Port=1433CLASSPATH=.;C:\Program Files (x86)\Microsoft SQL Server 2000 Driver for JD
plez help me... can SA(simulated anealing), ILS (Interated Local Search) and TS (Tabu Search) combined together since i'm going to use the same program to get the solution for every method?can these 3 methods combined in 1 big program to make a better solutions? if can..how?plez..this is really urgent...
I am using IBM Director 4.20 and until today i was working fine with no problems at all. Today thoughI decided to change the password of the sa user on the sql server 2000 in which i have stored the database for director and since then the ibm director server service cannot start. I dont remember the previous sa password that's why i changed it and the error i receive after attempting to start the service is the following:Event Type: ErrorEvent Source: TWGServerEvent Category: Application Error Event ID: 101Date: 1/9/2009Time: 3:07:01 PMUser: N/AComputer: DIRECTOR01Description:Application Erro
I am new to SQL Server 2000. When I set a password for SA all the SQLServerAgent jobs fail with a login error and will not start. I have tried to change the SQLAgent service login via the Control Panel/Services, but it will not accept SA as a valid login, when I browse logins, only the NT logins seem to appear. The jobs are owned by my normal login and not by SA.This is probably a simple change, but I am going round in circles trying to locate the 'how to' documentation.
SQLConfigDataSource(....) with "UID=sa" & "PWD=" dont work.When I do not send in a user id and password, I can create a DSN and open a database (remote database on a remote server) and everything is fine.(This works on all Windows 2000 nmachines that I know and some WIN NT 4.0 machines).For those where the "SQLConnect(....)" ( in the 2nd function) fails, I checked the ODBC connection and and found that a the Server was the correct one but the "Login ID" was "administrator". Trying to proceed in the ODBC panel fails. ApparentlTo try to solve
What's the current standard for treatment of the sa user account? I've got a pretty tight password on it, but is it the standard to do something more? Removing the user from sysadmins, removing the user all together?It's generally better to know than not to know, so I thought I'd ask.
HiNeed help. I cant start SQL Server Agent by using sa. It will run if I use windows autho!Any ideas?
is it possible to control the sa login , so that he cannot view a specific table. is it possibleregdsram
I am attempting to connect to SQL7.0 via the SA account via an ASP page and having the message:Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'WRIGHT\IUSR_WRIGHT'.Any ideas?
I have a problem: i locked me out of our MSDE I wanted to change the SA password like this:PHP Code: osql -U sa -Q "sp_password NULL, 'secretPW'" then later i had to open it again (for a stupid application):PHP Code: osql -U sa -Q "sp_password 'secretPW', ''" it's an empty password.But now i can't connect anymore. Even with old passwords...Do you have any ideas?thx a lotlacroix
For better or worse my knowledge of SQL Server 7 has large holes. I believe that I have been hacked.when I try to log on via the internet I get:+++++++++Microsoft OLE DB Provider for ODBC Drivers error '80040e4d' [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. /national/teasers/teaserFunction.asp, line 17 ++++++++++Is it possible that my sa password got changed?In my ASP code I have the following:DSN_Name = "DRIVER=SQL Server;dsn=database;UID=sa;PWD=;"DOes this mean that my password for user sa should be ;?Help -- I'm ignorant and down
I am trying to edit a DTS package which is a transfer of data between two tables (connections)i can view the properties of either connection but i get this error when i try to edit the transformation section of a pakcage that is supposed to transfer data from one table to another.Login failed for user 'sa' i am running enterprise manager on the server itself so i shouldn't have any connection issues.if i try to change the authentication on either connection from "use SQL authentication" to "use windows NT authentication" i get this error:' Cannot generate SSPI context '
any consideration of performance issue when i use "sa" a/c to connect SQL SERVER in java program? will be faster or slower?
hi.. i have one datbase my name dbMyEmp and one login emp .. only emp login should access the the database and even 'sa' account should not be able to manupulate the dbMyemp object..how to go about it..thnaks in adv..Venu
HiI tryed to login to my database whit profile sa but the SQL Server 6.5 tellme that it can't log in because the user is not found.How i can solve this problem, someone know???plis helpme.
I just completed creating a replication job between a server at my location, where I have SA privileges, to a subscription server at a location where I have db_owner rights (no SA). When replication runs, the objects get created on the subscriber as userid.object rather then dbo.object. How do I cause replication to create the objects as dbo.object?Dave
How do you change the sa password in SQL 7.0sp_password but what is teh syntax to change it from blank
Our in-house developer changed the "sa" password on the Sql 2000 server and now the database maintenance plan that I created for backups to disk isn't working. The day it stopped I received the following errors in the log:"2003-02-13 09:20:41.37 spid58 Error: 15457, Severity: 0, State: 12003-02-13 09:20:41.37 spid58 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..2003-02-13 09:20:41.48 spid58 Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.2003-02-13 15:54:25.59 spid53 Error: 15
I have recently switched from MySQL 3.x to 5.0.21 and since the website I'm managing has a problem on a query: Here is the error I get: Unknown column 'a.SA_ID' in 'on clause' When I request the following: "SELECT a.A_ID as ID, A_REFERENCE as REF, AT_LIBELLE AS TITRE, s.SA_IMAGE, a.A_ANNEE AS ANNEE, IF(CURDATE() BETWEEN a.A_DATE_DEB_PROMO AND a.A_DATE_FIN_PROMO AND pd.PD_PRIX_PROMO > 0, pd.PD_PRIX_PROMO, NULL) AS PRIXPROMO, pd.PD_PRIX AS PRIX FROM ARTICLES a, ARTICLES_TRANSLATION at, PRIXDEVISES pd , SAISON s LEFT JOIN SAISON_TRADUCTION AS st ON a.SA_ID = st.SA_ID WHERE a.CAT_ID IN ($l
Just inherited a 6.5 dataserver, DBA left w/o giving sa password, (I can connect as dbo of one of the databases though. Any suggestions as tohow I might be able to obtain this information? Any help would be appreciated.
We have an issue on our network which drops the connection to SQL2000 and we have to login again using SQL login sa - most of the time it will reconnect immediately or we will get the error msg below.This is very annoying as some of our software needs to run 24hrs uninterrupted for testing purposes. I've tried named pipes and that doesn't stop the problem, and I'm using Server Login (SA) authentication model. I've also noticed that some of the Internet access is problematic (i.e. "can't find DSN for Google" type errors, "connection timed out" type errors.Does anybody know w
I have an simple question: Is it possibileto make an data from a table unaccesibilefor sa ? I'm not interested if sa can modify back the rights in orer to see it;
We are running a DTS package from a non-sa owned job and I am getting the following message:A problem occurred while attempting to logon as the Windows user 'SQLAgentCmdExec': The parameter is incorrect. When I set the Sql Agent proxy account to an windows administrator on the sql server it works fine. However when the Sql Agent proxy account is not administrator I get the above error.Please note that the Analysis Services is located on a different machine.
We have remote users using sql server 7 on laptops. They use a vb app and replicate with the main server.I have just discovered they have weak passwords on their sa account.Others are suggesting that the laptops do not need strong passwords for their sa account as they are only subscribers . Are they talking rubbish?
I know there are already topics on the "Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection" problem but I think this one might be different.I am working with 2 servers, both running Windows Server 2003 with 1 running SQL Server 2000 and the other acting as a Web Server, and a PC running Windows XP Pro as a development machine - all of which are on the same domain.I am developing a couple of ASP.NET web applications, and this is where the problem occurs. If I try to connect to the SQL database with the web application running on the development PC
The people who originally setup the databases on our server have left and didn't pass on the password for the SA username. Is there anyway of extracting the SA password if I have access to SQL Server Enterprise Manager? I want to avoid resetting the password otherwise I the existing programs that rely upon that login name may not function problem. If anyone has any ideas I'm willing to give it a go.
We have an application which uses SQL Server 2K through MDAC 2.5 on Windows 2K Pro.After an year of no any problems we started to get 18456 error periodically. What we are doing to fix it is seting "sa" password to let's say "password" one.It works for some days, but then error appears again, and recovery way is all the same - to set "sa" password to "password".Any suggeston what can corrupt "sa"'s password?How to be protected from it? (any patches?)
HelloI´m trying to find who are trying to connect to my SQL server using sa user/password.I already enable failure audit on security tab on EM but 'SQL Server Logs' and 'Event Viewer" only shows: - Login failed for user 'sa'. Please anybody knows how can i get ip address from intruder. (I don´t want install any sniffer tool to do this).tksRobinson
I am trying to create a replication between servers and I deleted all the access acounts from my server leaving just the SA account (no more trusted connections).I created an account with administrator privileges for running SQL Server and Agent and configured my server for replication with no errors, but when I create the snapshot agent it is trying to connect to the distributor using the Builtin\Administrator account.I did all the replication configuration using the Enterprise Manager and changing all the setting to use the SA account and I don'w know how to make the agent to connect to the
I am running into a problem loggin into SQLsrver 7.0 using 'sa' account but works fine admin account(NT acct)I have installed sqlsrvr 7.0 on win2k - server standard edition. Installed SQLserver using NT domain account. I have created a username 'sa' with admin previleges. When I try to login with sa, login fails in the enterprise manager. ? I tried to re-install the server7.0 using local account, again unable to login with 'sa' account in the enterprise manager Appreciate if you could shed some lights on this issue
Is there a way in SQL server to grant "SA" rights to non-SA users for certain commands.I know there's a way to do this in Sybase by creating a password protected role and then activating it within a stored procedure. Thus, the specific right is only active for the brief duration of the stored procedure - which runs the particular command to be granted. The role is de-activated at the end of the stored procedure.Any suggestions are greatly appreciated.
I have to execute stored procedures containingxp_cmdshell and certain system storedprocedures in msdb and masterwith a user who is not SA.(i.e iam able to execute stored procedures when i log as sa,but any other user cannot run them)Pls tell how to do this, it is quite urgent.
Is it possible at all to remove the SA login or deny "System Administrator" from it by loggin as another user who has sa previledges
Do we have provision of separating sa and sso role in SQL server as we have in sybase? ( In such a case, sa shouldn't have any control on creating/modifying users/logins)ThxWilson
HiThe password for 'sa' was change on the subscriber and now, following a restart of the distributor, the following error message comes up:The process could not connect to Subscriber 'servername'. Login failed for user 'sa'.Short of removing the subscriber and recreating it, is there a way of telling replication that there is a new sa password?TIA
I am working with MSDE, but some how the password for sa keep changing by itself. I can reset it by logging in windows authentication mode using osql, but the next day the password does not work again.Please give me some suggestionsMik
Hai,While installing SQL Server 2000 on my Windows 2000 Advanced Server, i choose Windows Authentication mode, so i was not able to enter a password for sa account. And after installation, in Enterprise Manager i could still see sa account under logins but the account has a password.So my question is what is the default password for sa account when we choose Windows Authentication mode and is it possible to change the mode from windows Authentication to Mixed Authentication mode after installation, with out re-installaing SQL Server 2000.Thank you in advanceWith
I'd like to create an Alert that sends me an email whenever a login attempt fails (ok, flooding is possible) or when the 'sa' account is used. I switched the Audit Level to 'All' (properties tab of the database) and created an alert which sends me an email whenever a login fails. However, I find the email itself rather limited; I can't tell from which ctr the attempt was made. Also, I see no way of creating an alert specific for the account 'sa'. How would I go about that?
EDIT: sorry for the double posting... please ignore this thread.I'd like to create an Alert that sends me an email whenever a login attempt fails (ok, flooding is possible) or when the 'sa' account is used. I switched the Audit Level to 'All' (properties tab of the database) and created an alert which sends me an email whenever a login fails. However, I find the email itself rather limited; I can't tell from which ctr the attempt was made. Also, I see no way of creating an alert specific for the account 'sa'. How would I go about that?
We have a SQL Server 6.5 instance that has yet to be upgraded to SQL 2000. (Long story). Anyhow, I'm trying to revoke SA permission from the local administrators group, which SQL Server grants by default during setup. I followed the instructions on BOL, but no luck. Here is what I've tried.Changed my desktop client from named pipes to TCP/IPVerified the server client allows TCP/IP and named pipes (needed for old applications)Changed security mode to MixedCreated a local group called DBA_AdminGranted DBA_Admin SA permission through SQL Security ManagerRevoked SA permission from Administrators g
in mixed mode,is there a way to prevent access from user SA to a specific database?
AllI can not change the 'sa' password, it's give me the error attached.What can I do?Thks
I can not change the 'sa' password. It's showing the error below:<<Error 21776: [SQL-DMO The name 'dbo' was not found in the Users collection. If the name is a qualified name, use [] to separate various parts of the name, and try again.>>What can i do?Thks
A client of mine changed his SA password "because it hadn't been changed in a while". Now nobody can get into Enterprise Manager - opening EM or trying to right-click > Connect on the server yields an error:A connection could not be established to SERVER1. Reason: login failed for user 'sa'. Please verify SQL Server is running and check your SQL Server Registration properties (by right-clicking on the SERVER1 node) and try again. Of course, if I right-click on the SERVER1 node, I get the same message. My client remembers the password he set; I managed to use it to get into Query A
I've searched this forum and was surprised to not find this asked before - Is there any way to change SA's password (we have managed to lose it somehow)? And we do have physical access to our SQL Server of course...if that helps.
How does one run the following command in the context of the sa account while logged in as themselves (not sa). The "SQL Authentication" user does not have access to master.EXECUTE master.dbo.xp_sendmail @recipients = '[email protected]', @subject = 'Script fired!', @message = 'Hi'
I've got a third party app running atop my sql server instance. When auditing logons in profiler, I see that the user (sa) logs off, and then immediately logs back on. Interestingly, the app logs back on with this user again, and the instance gives it the same spid as it previously had.Can anyone explain this behaviour, or point me to a place where I can investigate ?
I have replication between central server and 15 servers in different sites, all of them are configure in the same way, I can not replicte one server I received the message : The process could not connect to Subscriber 'ServerName' and the full message is:Login failed for user 'sa'.Any help ?