Hello, i'am trying to connect to a sql server from php and the server returned to me the fallowing error: the session is not associated whit any trusted conection ("conección de confianza" in spanish). Can any body help me?
thanks
menrique.
Hi
I have to
implement table level loggin on a bunch of tables. The problem is that
I also have to log the user that made the changes
Obviously the
right way would be to run everything tru stored procs - but that is not
possible for me because there is a lot of existing functionality built
already - some direct sql and a super large number of sprocs.
So I wanted to go with a trigger based approach .However since the
changes are being made by a web app SQL has no idea who the actual web
application based user is.
I originally tried to solve the
problem by adding a LastUpdatedBy column to some of the tables and
forcing the functions to update that too - so that the trigger can read
that column but that has turned out to be very tedius and buggy.
So I want to try something else - so far it seems to be working but I
just want to make sure I am not messing up anything along the way.
There is a function is TSQL called APP_NAME() , this return the name of
the application that started the connection that the TSQL is running
in. This made scense during the desktop days when it would return the
actual .EXE name of the file that executed the changes.
Nowadys it's not so usefull any more becuase in a web based app all
changes are being done by aspnet_wp.exe so i don't know if that info is
usefull - as a matter of fact all access thru ado.net default to ".Net SqlClient Data Provider" .
So my thinking is like this - if I add 'Application Name= userid" to
the connection string before I open it - then I will have access to
that userid thruout any changes that usermakes via APP_NAME()
I realize that I may be messing up the connection pool a bit - but I
have relativley few (60) users who are on the system for long spans -
so each one will be able to reuse their own connectiions.
I just want to make sure before I go off on this that i am not messing things up badly
Thanks for reading this whole thing
Hi,
I execute my ssis from BI without problem (debug mode), but when I import into SQL server and try to run with logging on sqlserver provider always my package failure.
If option of logging is empty all works fine (No one logging method is active).
There is some permission to set for this option?
I use into SiSS ole db native client connection.
Hope some one can help me.
Alen Italy
This belove is the error...
---------
An OLE DB error has occurred. Error code: 0x80040E37.
An OLE DB record is available. Source: "Microsoft SQL Native Client"
Hresult: 0x80040E37 Description: "La transazione distribuita è stata
completata. Integrare questa sessione in una nuova transazione o nella
transazione Null.".
Hi all,
I am using ODBC to connect SQL Server 2000 + SP4 server runnig on Windows 2003 standard edition Server +SP1. But, sporadically my application server connectivity to DB fails and i receive the following error messages
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (WrapperWrite()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.) In D:de.cpp 702 Apr 12 2006 20:34:47
[Microsoft][ODBC SQL Server Driver]Communication link failure) In D:de.cpp 702 Apr 12 2006 20:34:47
20071017 08:23:10 TID (00000ff0) Sev (3) Err (0) Msg (Read failure.
General SQL error.
Strange thing is that i receive this error only sporadically, Please Please advice !
Thanks ,
Jitender
Hi,
I have copied my first web site to our web server, the web site is secured using AspNetSqlProvider. I have attempted to browse the site from IIS tree and I am redirected to the logon page as expected. The autentitcation is attempted and fails with:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
The database is in the app_data file, why is it not found?
Regards,
JoeBo
Whats happens when moving a sql server database to another sql server database and the DTS fails. Does it copy half the data or it doesn't copy any data????
View 2 Replies View RelatedHello Everybody
We created DTS package and scheduled it as a job.
When we run the DTS package, it works, but job doesn't.
We don't get any meaningful errors. We know that DTS runs on workstation where you sit, and job always runs on the server.
The main question is what we might be missing, and the second question is which server does the job run on - destination or source?
We use SQL Server 7 / Win 2000 Server on both servers.
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSTransferObjectsTask_1 DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147220413 (80040443) Error string: Error source: Help file: Help context: 0 Error Detail Records: DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1 DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Thanks for your help
Does anyone have some suggestions as to why my scheduled recurring DTS packages keep failing to run?
I can manually execute the package and it works just fine but I don't know why the schedule job fails and there is not enough information in the error log to help me figure out what I have missed.
The DTS is copies a CSV file from a different server into an existing table in my Database. The DTS has the following steps
Truncate the table,
Copy and import the text file into the table and
Finally send me an email if it completes the task.
I have the package and the SQL Agent Service accounts set to my NT Account, which has admin rights
Hi,
An RPC to another server is failing with error 18484.
Any suggestions will be welcome.
Regards
Vedanth
SQL 2005 SP1.
declare @exec varchar(128)
set @exec = 'bcp [boxNamemysql2k5].adventureWorks.sales.customer format nul -T -n -f c:customer.fmt'
--print @exec
exec master..xp_cmdshell @exec
gives me:
SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 2
Warning = [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
NULL
(5 row(s) affected)
It's my local PC, that I am local admin on. I did the same thing (different DB of course) on a local 2000 instance and got the same result. It's been a few years since I used BCP, and this isn't ringing a bell. Can someone please assist?
TIA, cfr
Dear AllA quick question:I run a set of scheduled jobs. The jobs run Stored Procedures.However, if the sproc fails, the job quits and moves on to the nextone. However, the sproc should carry on. E.g, IF find bad records,EXPORT to file, GO TO NEXT RECORD (BUT DON'T QUIT THE SPROC). The jobscheduler does not allow this, therefore, the sproc does not get achance to finish.Is there a way to ensure a sproc can finish before moving on to thenext step?ThanksSimon
View 1 Replies View RelatedHi All,We have SQL Server 2000 (sp3), running on Win2k Server. Yesterday, midmorning, during normal processing (selecting data .. loading data ..etc) the sql server service suddenly shut down and would not startagain. We received several messages but the 2 most consistent messageswere that 1) the ums.dll could not be loaded and 2) the services failedto start in a timely fashion.IN the event log, the only thing of interest was this:Application popup: sqlservr.exe - Entry Point Not Found : The procedureentry point?FindNextAvailable@UmsSchedulerQueue@@QAEPAVUmsSch eduler@@W4UmsSchedulerAlgorithms@@@Z could not be located in the dynamic link library UMS.DLL.I am at a complete loss. I did create a new instance of sql Server andreattached all of my databases to the new instance - but, of course, nowthe question being posed to me is "what happened?" I have no idea andam wondering if anyone has experienced this before or has any insightthey might be able to share.Any information would be greatly appreciated! Thanks!Bethany HollidayIU, KSOBIndiana Business Research Center*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
View 1 Replies View RelatedThis error continues to occur even after a couple of uninstalls and re-installs, only to result in the same error. I can send the logs if you like, but they are large, so this is the short popup I am getting: ( I can't paste the message, but here is the text:
The installer has encountered an unexpected error: The error code is 2331. Error loading library Cprogram filesmicrosoft SQL Server ... sqlca.dll or finding entry point. The specified module could not be found.
Here is a better message out of the event log:
Product: Microsoft SQL Server 2005 Notification Services -- Error 2331. The installer has encountered an unexpected error. The error code is 2331. Error loading library C:Program FilesMicrosoft SQL Server90Setup BootstrapBin{37E9AD9F-3217-4229-B5A5-7A0C82364C6C}sqlca.dll or finding entry point The specified module could not be found.
Any help would be appreciated. Also, XP Pro SP2. Fresh install, no betas, clean box, not upgrade. Thanks in advance for ANY help! Rick
Does anyone hany any experience of using SSIS with MS DTC?
View 9 Replies View Relatedi am using the ftp task to ftp files from remote location to my local system but the task failed giving error "password was not allowed" (i am trying to retrieve the information for the task from configuration table).pls suggest
View 9 Replies View RelatedI have designed an SSIS that needs to download a set of files via ftp. The ftp is working fine under Business Studio. When I move it to The server and try runing the package I'm getting the following errors:
Error: Unable to connect to FTP server using "FTP Server"
Error: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed.
This is not my first FTP in SSIS, so I also have the following item set:
Protectionlevel = EncryptProtectedWithPassword
I have several other FTP packages that go to the exact same server, with the exact same user ID and password that are working.
What am I missing?
I am new to asp.net 2.0, although I have some experience with asp.net 1.1. In my new machine I have VS 2005, SQL Server 2000 and Sql Server 2005 installed. I wanted to connect to a database in SqlServer 2000 from a simple asp.net 2.0 project. I used the following connection string:
string strConn = "Data Source=xyz/abc;Initial Catalog=dbname;UID=abc;PWD=efg;";
xyz/abc is the name displyed in the enterprise manager, under SQLServer Group. When I run the app, I am getting the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
The error indicates that it is trying to connect to SQL Server 2005, although my xyz/abc is a SqlServer 2000 instance. Not sure how to force the connection to the SqlServer 2000 database.
Thanks
Hello Everyone and thanks for your help in advance. I have set up a new installation of SQL Server 2005 and VS 2005. I am trying to get some web applications up and working, but am experiencing problems with the database connection. I am tring to use the the sa account to connect, but am receiving the error "Login for user 'sa' failed. Not associated with at trusted account...". I am familiar with this error and have made sure that the SQL Server is using SQL Server and Windows Authentication Mode. The connection string I am passing to it is:
server=(local);uid=sa;pwd=password;database=Northwind
which I believe is correct. So I'm confused as to what the problem is. Any help on this topic would be greatly appreciated. Thanks.
why I am getting (Instance failure.) when trying to connect to sql server from the web.config connectionstring..
the web.config entry is :
<connectionStrings><add name="website_connectionstring" connectionString="Data Source=.\SQLEXPRESS;initial catalog=zatoor;integrated security=true" providerName="System.Data.SqlClient" />
<!--
<remove name="website_connectionstring"/>
<add name="website_connectionstring" connectionString="Server=whsql-v21.prod.mesa1.secureserver.net;Database=DB_143379;User ID=zatoor;Password=Mujtaba2007;Trusted_Connection=False" providerName="System.Data.SqlClient" />-->
</connectionStrings>
the code is :sql_connection = new SqlConnection(ConfigurationManager.ConnectionStrings["website_connectionstring"].ToString());
sql_connection.Open();
I have designed a DTS Package and it can be run successfully from Enterprise Manager. However, when I schedule the DTS package to run as a job then it fails with an error message of "Error string: The system cannot find the file specified.".
Anyone any idea as to why the job cannot find the DTS package?
Can it be something to do with SQL Server 7 and 2000 tools as 2000 Client tools have recently been installed onto my PC and the package and job ran fine when I had designed everything in SQL Server 7.
Thanks in advance
Vince.
Hi
I am running sql server 7, since friday my users are not unable to access their database on the server. NT group authentication is the mode of accessing the data on the server, the temporary soluton I have found so far is to create individual login. Which means creating login for every user on the network. NT4 Group membership that has always worked no longer functions.
Please help.
When I try to run any dts package that tries to copy stored procedures from one db to another, it fails and i get this message:
Need to run the object to perform this operation
[SQL-DMO]Code execution exception: EXCEPTION_ACCESS_VIOLATION
The problem appeared a couple of weeks ago, the same package that now fails ran with no problems for some 6 months or so.
When i searched the Microsoft site i found a bugfix that fit the problem exactly but the workaround and SP3 installation (which supposedly fixes the problem) didn't work.
Please help!!
I backed up my database on the live server copied it to the backup server and restored it successfully. I then set up a DTS export on the live server to copy objects and data to the backup db. The job keeps failing. Each time it fails it reports an "ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint ...... However, there is nothing wrong with any foreign key, I have checked and the data in the tables are definitely fine and key is definitely fine (I removed it and added it again checking the data). I am able to DTS these tables which are supposed to have problems as a separte DTS job. I believe the job is inserting data in the table which has the foreign key before it inserts data in the table with the primary key and this is causing the problem. As an aside this job used to work perfectly well.
Can someone offer a suggestion on what I should do.
Thanks.
I am getting periodic failures of my Transaction log. SQL
Server 7.0 Service Pack 3 on NT 4.0. IT is not occurring
in a set pattern. I have attached the error. I am unable
to find anything on the Internet or n TechNet can someone
help me out.
Thanks;
Message is as follows:
Microsoft (R) SQLMaint Utility (Unicode),
Version [Microsoft SQL-DMO (ODBC SQLState: HYT00)]
Error 0: [Microsoft][ODBC SQL Server Driver]Timeout expired
Hi experts,
my server was having windows as well as sql login authentication. Once i checked the deny access for BUILTAdministrators . . I'am unable to login as
SA and also I'am also unable to change that check as well. . .any solutions
in this regard will be appreciated
Hi
My flatform is NT4 with Sql 7 server. At least one a week user loose connection to the database on the Sql server. I can ping the server ok but an error message pops up each time they try to access the database that the server is not known to be running. What performance monitor counter can I monitor to determine if there is a problem accessing the database.
I have a DTS pkg containing VBScript scheduled as a job. The script creates an ADODB connection and opens it passing the servername, username, and password as parameters. We are using NT Authentication, and SQLAgent is using a domain account (SQLService acct).
The job runs fine if I specify a SQL username with SA authority in the ADO connection string. But if I try to use an NT acct it gets a login failure for the i.d. I also noticed that none of the NT login/users show up in the Job Owner drop down list of the job properties window.
My question is should I be able to run the job using just an NT account with SA authority or do I need both NT and SQL i.d.s to run jobs? What am I doing wrong?
Hi,
I want to know if it's possible to retrieve what kind of error have occurred when the on Failure workflow is execute in a DTS package.
Martin
Recently I witnessed a failed SQL 7 Enterprise installation due to an access error on an ado file. Apparently SQL Server was trying to copy an active x component that was already in use when the error occured. Anyone have experience with this?
Server: Intel DK440LX Dual PII Dual SCSI UW
Server OS NT 4 SP4
Has anyone come across this.
Replication-Distribution: Task 'xxxxxx' failed. 21S01[Microsoft][ODBC SQL Server Driver][SQL Server]Insert error: column name or number of supplied values does not match table definition.
But the tables are exactly the same and a partial batch did replicate
Running SQL Server 7:
Looking at the jobs under SQL Server Agent in Enterprise Manager, I notice that several of my backup jobs failed last night, is there anywhere I can look that will give me a more descriptive error message? I looked at the SQL Server Logs and didn't find anything that gives me any clue.
Thanks.
joe
I am using the command
"dbcc shrinkdatabase (ESP_REPORTING, 10)"
This has worked for the past year but Recently it fails with the following error:
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
In the log it contains:
Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.
Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.
Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'xp_instance_regread'.
12/23/02 09:48:33 Stack Overflow Dump not possible - Exception c00000fd E at 0x00401EE1
Address=401ee1 Exception Code = c00000fd
eax=03fbcd1c ebx=0000129a ecx=03fb2ef0 edx=00000000
esi=30784000 edi=00000cf8 eip=00401ee1 esp=03fbcd1c
ebp=03fbcd24 efl=00010206
cs=1b ss=23 ds=23 es=23 fs=38 gs=0
1: Return Address 00401EE1
2: Return Address 004135ED
3: Return Address 00417FCF
4: Return Address 00418388
5: Return Address 004348E2
6: Return Address 00418543
7: Return Address 00914329
8: Return Address 00913D00
9: Return Address 00916747
10: Return Address 009190B8
11: Return Address 009189A2
12: Return Address 0091829D
13: Return Address 0091769B
14: Return Address 0062B855
15: Return Address 0062AD91
16: Return Address 004160DB
17: Return Address 00415765
18: Return Address 00415410
19: Return Address 00459A54
20: Return Address 004175D8
dbcc shrinkdatabase (ESP_REPORTING, 10)
TotalPhysicalMemory = 2147000320, AvailablePhysicalMemory = 265838592
AvailableVirtualMemory = 353890304, AvailablePagingFile = 2312122368
Any ideas? The db is 1.7gig.
Thanks,
Ken Nicholson
Hi Guys,
I am doing a fullbackup once a day and transaction log backup every 15 mins.
The jobs are running fine on both primary server and secondary server (restores always with norecovery).
But unexpectedly I am receiving the below error on the secondary server from yesterday.
Eg:
The transaction log backup taken at xyz_13_00.trn fails and I cannot go further.
Msg 4330, Sev 16: The log in this backup set cannot be applied because it is on a recovery path inconsistent with the database. [SQLSTATE 42000]
Msg 3013, Sev 16: RESTORE LOG is terminating abnormally. [SQLSTATE 42000]
If I try restoring from the transaction log backup taken at xyz_12_45.trn, it restores fine.
The statement that I use,
restore log xyz from disk='E:MSSQLsqlbackupTranlogBackupxyzxyz_13_ 00.trn'
with replace,norecovery,
move 'xyz_log' to 'f:mssqldataxyz_Log.LDF'
Please help.
Thanks,
Anu