(JOB?)SA:MP Game-Mode Development

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 ...

Install Director 5.1: Login failed for user 'sa'

===========================================================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 attem ...

can SA,ILS and TS combined together?

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 urge ...

Problem with IBM Director after changing the sa password on sql server

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 th ...

Cannot run SQLServerAgent jobs after changing SA password

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 see ...

SQLConfigDataSource(....) with "UID=sa" & "PWD=" dont work. Why

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. ...

sa user

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. ...

sa can not start SQL Server Agent!

HiNeed help. I cant start SQL Server Agent by using sa. It will run if I use windows autho!Any ideas? ...

Controlling Sa

is it possible to control the sa login , so that he cannot view a specific table. is it possibleregdsram ...

Logging on with SA account!!

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? ...

LOST SA USER on MSDE

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 ...

Login failed for user 'sa'.

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/te ...

DTS Package Error: Login failed for user 'sa'

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 us ...

how about the performance about "sa" a/c?

any consideration of performance issue when i use "sa" a/c to connect SQL SERVER in java program? will be faster or slower? ...

Deny access to sa account

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 ...

i cant log in whit sa profile

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. ...

Replication - How to create objects as dbo.object when not SA

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 cau ...

change sa password

How do you change the sa password in SQL 7.0sp_password but what is teh syntax to change it from blank ...

Changed sa password, db maint plan not working

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 ...

need to locate sa password

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. ...

SQL Login SA - time out issue

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. ...

prevent table data acces from sa

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; ...

DTS cube processing from a non sa account

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 fi ...

Remote Laptop SA Password

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 the ...

A Different Login failed for user 'sa' problem

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 ...

Retrieving SA password

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 re ...

Login failed for user sa, error 18456

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 a ...

Login failed for user 'sa'.

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┬ ...

Replication using SA acocunt only

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 error ...

Unable to login SQLSrvr 7.0 with 'sa' user

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 ...

SA rights

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 sto ...

execute xp_cmdshell and other SA storedproc

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. ...

Can SA be dropped

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 ...

sa and sso role separation

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 ...

Replication and a changed sa password

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 tellin ...

sa password keep changing automatically

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 ...

Default password for sa account

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 i ...

Alert for 'sa' account

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 ...

Alert for 'sa' account

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 whi ...

6.5 Question - Unable to revoke SA permission from local admin group

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 m ...

sa privileges.

in mixed mode,is there a way to prevent access from user SA to a specific database? ...

sa password

AllI can not change the 'sa' password, it's give me the error attached.What can I do?Thks ...

sa password

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 ...

Can't connect via EM after changing sa password?

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 ...

change SA's password

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. ...

Running trigger t-sql as the sa

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 = 'hi@hotmail.ca', @subject = 'Script fired!', @message = 'Hi' ...

SA user logging off and on again w/ same spid

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 ex ...

Login failed for user 'sa'

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 ? ...

User 'sa' is locked out

I just brought SQL Server 2005 up on Windows Server 2003 a few days ago. Everything was going great up until a few minutes ago. I tried to connect using the Management Console and get the messageLogin failed for user 'sa' because the account is currently locked out. Your administrator can unlock it. ...

Login failed for user 'sa' . The user is not associated with a trusted connection.

Visual Studio and SQL SERVER 2005 Express. I tried @ home pc. XP environment.when I use SQL Server authentication in database explorer I get :Login failed for user 'sa' . The user is not associated with a trusted connection .The windows authentication is successful ONLY in database explorer when I t ...