sql error 15138: program

Showing posts with label program. Show all posts

Thursday, March 29, 2012

Error 18456" error message when you specify configuration database

I appreciate if some one please help me to solve the following problem
SYMPTOMS
I am runnning the Setup program to install Microsoft Windows SharePoint
Services. After the Setup program is completed successfully, I configure
Windows SharePoint Services settings in SharePoint Central Administration. I
then specify configuration database settings on the Set Configuration
Database Server page of SharePoint Central Administration, and then I click
OK. Then, I receive one of the following error messages:
"Error 18456" error message when you specify configuration database settings
on the Set Configuration Database Server page of SharePoint Central
Administrator"
I have gone through the article on
http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
Please let me know if some one came across this problem & i could solve it
with your support
Thanks in advance
RegardsError 18456
Severity Level 14
Message Text
Login failed for user '%ls'.
Make sure that the user you specified is correct and has the correct password.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Yakoob" wrote:
> I appreciate if some one please help me to solve the following problem
>
> SYMPTOMS
> I am runnning the Setup program to install Microsoft Windows SharePoint
> Services. After the Setup program is completed successfully, I configure
> Windows SharePoint Services settings in SharePoint Central Administration. I
> then specify configuration database settings on the Set Configuration
> Database Server page of SharePoint Central Administration, and then I click
> OK. Then, I receive one of the following error messages:
> "Error 18456" error message when you specify configuration database settings
> on the Set Configuration Database Server page of SharePoint Central
> Administrator"
> I have gone through the article on
> http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> Please let me know if some one came across this problem & i could solve it
> with your support
> Thanks in advance
> Regards|||Here it is not asking for any user, In database connection type, i have using
the option "user windows authentication" so i dont know which account its
going to use here to create the database.
Please help me out
Thanks
"Mike Epprecht (SQL MVP)" wrote:
> Error 18456
> Severity Level 14
> Message Text
> Login failed for user '%ls'.
>
> Make sure that the user you specified is correct and has the correct password.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Yakoob" wrote:
> > I appreciate if some one please help me to solve the following problem
> >
> >
> > SYMPTOMS
> >
> > I am runnning the Setup program to install Microsoft Windows SharePoint
> > Services. After the Setup program is completed successfully, I configure
> > Windows SharePoint Services settings in SharePoint Central Administration. I
> > then specify configuration database settings on the Set Configuration
> > Database Server page of SharePoint Central Administration, and then I click
> > OK. Then, I receive one of the following error messages:
> > "Error 18456" error message when you specify configuration database settings
> > on the Set Configuration Database Server page of SharePoint Central
> > Administrator"
> >
> > I have gone through the article on
> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me out.
> > Please let me know if some one came across this problem & i could solve it
> > with your support
> > Thanks in advance
> > Regards|||It's probably [NT AUTHORITY\NETWORK SERVICE]. You should be able to see the
error in the SQL Error log (Open SQL Enterprise Manager and connect to the
SQL Server instance in question and navigate to Management>SQL Server Logs)
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yakoob" <Yakoob@.discussions.microsoft.com> wrote in message
news:D91EF3D6-7AE4-4707-9F60-FEEFB797B771@.microsoft.com...
> Here it is not asking for any user, In database connection type, i have
> using
> the option "user windows authentication" so i dont know which account its
> going to use here to create the database.
> Please help me out
> Thanks
> "Mike Epprecht (SQL MVP)" wrote:
>> Error 18456
>> Severity Level 14
>> Message Text
>> Login failed for user '%ls'.
>>
>> Make sure that the user you specified is correct and has the correct
>> password.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Yakoob" wrote:
>> > I appreciate if some one please help me to solve the following problem
>> >
>> >
>> > SYMPTOMS
>> >
>> > I am runnning the Setup program to install Microsoft Windows SharePoint
>> > Services. After the Setup program is completed successfully, I
>> > configure
>> > Windows SharePoint Services settings in SharePoint Central
>> > Administration. I
>> > then specify configuration database settings on the Set Configuration
>> > Database Server page of SharePoint Central Administration, and then I
>> > click
>> > OK. Then, I receive one of the following error messages:
>> > "Error 18456" error message when you specify configuration database
>> > settings
>> > on the Set Configuration Database Server page of SharePoint Central
>> > Administrator"
>> >
>> > I have gone through the article on
>> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me
>> > out.
>> > Please let me know if some one came across this problem & i could solve
>> > it
>> > with your support
>> > Thanks in advance
>> > Regards|||Thanks for your reply, yes i understand that it iw using NT AUTHORITY\NETWORK
SERVICE, but even this i didn't find in SQL server logs as you have
mentioned. If i have to check for correct password then where? because i am
not providing here any password during "set configuration database server". I
am selecting the following options which is mandatory as per installation
guide for MS project 2003 server.
1. Database server = "i give sql server name"
2. SQL server database name = "database name as sharepointdb"
3. selected the option "use windows authentication
4. then last option " users already have domain accounts. Do not creat
active directory accounts.
I dont see any NT AUTHORITY account in active directory to give permission
for database create or to see for its password, please let me know
Thanks & Regards
"Jasper Smith" wrote:
> It's probably [NT AUTHORITY\NETWORK SERVICE]. You should be able to see the
> error in the SQL Error log (Open SQL Enterprise Manager and connect to the
> SQL Server instance in question and navigate to Management>SQL Server Logs)
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Yakoob" <Yakoob@.discussions.microsoft.com> wrote in message
> news:D91EF3D6-7AE4-4707-9F60-FEEFB797B771@.microsoft.com...
> > Here it is not asking for any user, In database connection type, i have
> > using
> > the option "user windows authentication" so i dont know which account its
> > going to use here to create the database.
> > Please help me out
> >
> > Thanks
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Error 18456
> >> Severity Level 14
> >> Message Text
> >> Login failed for user '%ls'.
> >>
> >>
> >> Make sure that the user you specified is correct and has the correct
> >> password.
> >>
> >> Regards
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >>
> >>
> >> "Yakoob" wrote:
> >>
> >> > I appreciate if some one please help me to solve the following problem
> >> >
> >> >
> >> > SYMPTOMS
> >> >
> >> > I am runnning the Setup program to install Microsoft Windows SharePoint
> >> > Services. After the Setup program is completed successfully, I
> >> > configure
> >> > Windows SharePoint Services settings in SharePoint Central
> >> > Administration. I
> >> > then specify configuration database settings on the Set Configuration
> >> > Database Server page of SharePoint Central Administration, and then I
> >> > click
> >> > OK. Then, I receive one of the following error messages:
> >> > "Error 18456" error message when you specify configuration database
> >> > settings
> >> > on the Set Configuration Database Server page of SharePoint Central
> >> > Administrator"
> >> >
> >> > I have gone through the article on
> >> > http://support.microsoft.com/?kbid=889646&FR=1 but it does not help me
> >> > out.
> >> > Please let me know if some one came across this problem & i could solve
> >> > it
> >> > with your support
> >> > Thanks in advance
> >> > Regards
>
>

Error 18456" error message when you specify configuration database

Monday, March 19, 2012

Error 1389 (aka 0x80070576 or STATUS_TIME_DIFFERENCE_AT_DC or ERROR_TIME_SKEW)?

Hello
When executing a BULK INSERT sql statement from within a program one of our
clients gets:
SQL Server Error: SQL State: 42000, SQL Error Code: 4861
Could not bulk insert because file
'\\W2K3SRV2\DTASQL$\Xtb860_dv_salspec.TXT' could not be opened. Operating
system error code 1398(There is a time and/or date difference between the
client and server.).
I have looked around the MS Knowledgebase, Google groups, and the internet
in general and have come up with two articles
http://support.microsoft.com/?id=830619
http://www.myitforum.com/articles/8/view.asp?id=6853
but they do not seem to apply to SQL Server. Our app *is* running on a
W2003Server machine named W2K3SRV2 with SQL Server 2000 on another
W2003Server machine named W2K3SRV4, so SQL server is fetching the text file
from W2K3SRV2.
BITS (as mentioned in the first link) is running on W2K3SRV2 but has no
connection with our app.
What could be going on here?
TIA
JanHave you tried syncing the times on the client and server with the domain
controller? Although the article doesn't mention SQL Server specifically,
any application using the underlying Win32 API could get error code 1398 due
to the time difference.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Jan Doggen" <j.doggen@.BLOCKqsa.nl> wrote in message
news:%23nErEnaeGHA.3792@.TK2MSFTNGP03.phx.gbl...
> Hello
> When executing a BULK INSERT sql statement from within a program one of
> our
> clients gets:
> SQL Server Error: SQL State: 42000, SQL Error Code: 4861
> Could not bulk insert because file
> '\\W2K3SRV2\DTASQL$\Xtb860_dv_salspec.TXT' could not be opened. Operating
> system error code 1398(There is a time and/or date difference between the
> client and server.).
> I have looked around the MS Knowledgebase, Google groups, and the internet
> in general and have come up with two articles
> http://support.microsoft.com/?id=830619
> http://www.myitforum.com/articles/8/view.asp?id=6853
> but they do not seem to apply to SQL Server. Our app *is* running on a
> W2003Server machine named W2K3SRV2 with SQL Server 2000 on another
> W2003Server machine named W2K3SRV4, so SQL server is fetching the text
> file
> from W2K3SRV2.
> BITS (as mentioned in the first link) is running on W2K3SRV2 but has no
> connection with our app.
> What could be going on here?
> TIA
> Jan
>

error -132

hello
I try to install the anallysis Server but when I start the program shows
me the next message
"moving data error -132"
I've got a windows 2k server sp4 and sql server 2k
thanks.Any workaround for this? I am getting the same error when trying to apply
--> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
"Alberto GonzÃ¡lez" wrote:
> hello
>
> I try to install the anallysis Server but when I start the program shows
> me the next message
> "moving data error -132"
> I've got a windows 2k server sp4 and sql server 2k
> thanks.
>
>|||Getting the same thing - any ideas?
"Paul J" wrote:
> Any workaround for this? I am getting the same error when trying to apply
> --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> "Alberto GonzÃ¡lez" wrote:
> > hello
> >
> >
> > I try to install the anallysis Server but when I start the program shows
> > me the next message
> >
> > "moving data error -132"
> >
> > I've got a windows 2k server sp4 and sql server 2k
> >
> > thanks.
> >
> >
> >
> >|||The following worked for me. Make sure the following services are stopped
when applying SP4.
a. MSDTC - Microsoft Distributed Transaction Coordinator
b. MSSEARCH - Microsoft Search
c. ReportServer - SQL Reporting Services
d. SQL Server Databases. Example, MOM or BizTalk
I hope this helps.
Paul J.
"Todd Bell" wrote:
> Getting the same thing - any ideas?
>
> "Paul J" wrote:
> > Any workaround for this? I am getting the same error when trying to apply
> > --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> >
> > "Alberto GonzÃ¡lez" wrote:
> >
> > > hello
> > >
> > >
> > > I try to install the anallysis Server but when I start the program shows
> > > me the next message
> > >
> > > "moving data error -132"
> > >
> > > I've got a windows 2k server sp4 and sql server 2k
> > >
> > > thanks.
> > >
> > >
> > >
> > >|||Nope - tried stopping all the below but 132 still appears
"Paul J" wrote:
> The following worked for me. Make sure the following services are stopped
> when applying SP4.
> a. MSDTC - Microsoft Distributed Transaction Coordinator
> b. MSSEARCH - Microsoft Search
> c. ReportServer - SQL Reporting Services
> d. SQL Server Databases. Example, MOM or BizTalk
> I hope this helps.
> Paul J.
> "Todd Bell" wrote:
> > Getting the same thing - any ideas?
> >
> >
> > "Paul J" wrote:
> >
> > > Any workaround for this? I am getting the same error when trying to apply
> > > --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> > >
> > > "Alberto GonzÃ¡lez" wrote:
> > >
> > > > hello
> > > >
> > > >
> > > > I try to install the anallysis Server but when I start the program shows
> > > > me the next message
> > > >
> > > > "moving data error -132"
> > > >
> > > > I've got a windows 2k server sp4 and sql server 2k
> > > >
> > > > thanks.
> > > >
> > > >
> > > >
> > > >|||I am pretty sure this error occurs because a handle is open to a file(s) that
the service pack needs access to and its probably a service. Try shutting
down antivirus software and other programs. You may also want to try
start>run>MSCONFIG "enter" and hide all Microsoft Services and shutdown
everything else, reboot then try to install the service pack. Good luck.
"Todd Bell" wrote:
> Nope - tried stopping all the below but 132 still appears
> "Paul J" wrote:
> > The following worked for me. Make sure the following services are stopped
> > when applying SP4.
> >
> > a. MSDTC - Microsoft Distributed Transaction Coordinator
> > b. MSSEARCH - Microsoft Search
> > c. ReportServer - SQL Reporting Services
> > d. SQL Server Databases. Example, MOM or BizTalk
> >
> > I hope this helps.
> > Paul J.
> > "Todd Bell" wrote:
> >
> > > Getting the same thing - any ideas?
> > >
> > >
> > > "Paul J" wrote:
> > >
> > > > Any workaround for this? I am getting the same error when trying to apply
> > > > --> Service Pack 4 for Microsoft SQL Server 2000 "Analysis Services"
> > > >
> > > > "Alberto GonzÃ¡lez" wrote:
> > > >
> > > > > hello
> > > > >
> > > > >
> > > > > I try to install the anallysis Server but when I start the program shows
> > > > > me the next message
> > > > >
> > > > > "moving data error -132"
> > > > >
> > > > > I've got a windows 2k server sp4 and sql server 2k
> > > > >
> > > > > thanks.
> > > > >
> > > > >
> > > > >
> > > > >

error -132

Friday, March 9, 2012

Error 0x800c0005 when calling Microsoft.XMLHTTP from inside SQLSer

0x800c0005 = Error 5 = Access Denied.
What has changed on the server?
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SammyBar" wrote:

> Hi all,
> We have a sp that sends http requests. It uses Microsoft XMLHTTP component
> that is part of XML pack that is standard with SQL Server 2000 SP3. For an
> unknown reason the XMLHTTP component started to fail raising the error:
> OLE Automation Error Information
> HRESULT: 0x800c0005
> I've seen this error in Visual Basic 6 when trying to create a component
> that is not well installed. But here this error is raised when creating th
e
> object but when sending the request:
> Exec @.nError = sp_OACreate 'Microsoft.XMLHTTP', @.iReq OUT
> If @.nError != 0
> Begin
> Select @.nError = Null
> Raiserror('sp_OACreate Microsoft.XMLHTTP FAILED! [sp_send_http]', 16, -1)
> Goto Fin
> End
> Exec @.nError = sp_OAMethod @.iReq, 'Open', NULL, 'POST', @.sUrl, false,
> @.sUser, @.sPassword
> If @.nError != 0
> Begin
> Raiserror('sp_OAMethod Open FAILED! [sp_send_http]', 16, -1)
> Goto Fin
> End
> Exec @.nError = sp_OAMethod @.iReq, 'send'
> If @.nError != 0
> Begin
> Raiserror('sp_OAMethod Send FAILED! [sp_send_http]', 16, -1)
> Goto Fin
> End
> then it goes well through sp_OACreate and sp_OAMethod "Open" calls.
> I reregister msxml.dll, msxml2.dll, msxml2.dll, and restarted the server b
ut
> it was useless.
> Looking around on the server logs the only suspected entry I've found was:
> SqlDumpExceptionHandler: Process 397 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
> * ---
--
> * Short Stack Dump
> * 09C73F85 Module(UNKNOWN+00000000)
> * 0066A220 Module(sqlservr+0026A220) (MSXMLThreadDetach+0000003D)
> * 00505DF1 Module(sqlservr+00105DF1) (clean_process+000000C6)
> * 0050611D Module(sqlservr+0010611D) (kill_proc+000000EE)
> * 00506513 Module(sqlservr+00106513) (logout+000001AC)
> * 005063D8 Module(sqlservr+001063D8) (release_srvproc+00000045)
> * 004270F9 Module(sqlservr+000270F9) (process_commands+000002A2)
> * 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
> * 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
> * 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)
> * 77E8B2D8 Module(KERNEL32+0000B2D8) (lstrcmpiW+000000B7)
> * ---
--
> It looks like after that the XMLHTTP doesn't works.
> Then my problem is to restore the XMLHTTP component to normal state. It ru
ns
> on a production server so the rules here are very strict. We cannot instal
l
> any new package there. So just reinstalling the xml package is the least
> desirable solution. I'd prefer just reregister the proper dlls but it look
s
> like reregistering msxml?.dll is not enought.
> What should I do?
> Should I register any other dll associated to msxml?.dll
> Any idea is welcomed
> Thanks in advance
> Sammy
>
>> 0x800c0005 = Error 5 = Access Denied.
!!!
Where did you find error codes?

> What has changed on the server?
Nothing. It is in the production server and it is forbidden to change
anything..., even security patches...|||> Where did you find error codes?
From an OS command prompt:
NET HELPMSG 5
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"SammyBar" <sammybar@.gmail.com> wrote in message news:%23ZP6ykskFHA.3144@.TK2MSFTNGP12.phx.g
bl...
> !!!
> Where did you find error codes?
>
> Nothing. It is in the production server and it is forbidden to change
> anything..., even security patches...
>|||Hi
It is the standard COM error. After seeing the same ones for 10 years, you
generally get to know them.
You can strip the last 4 characters, and use them as Tibor Karaszi noted in
his post.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"SammyBar" <sammybar@.gmail.com> wrote in message
news:%23ZP6ykskFHA.3144@.TK2MSFTNGP12.phx.gbl...
> !!!
> Where did you find error codes?
>
> Nothing. It is in the production server and it is forbidden to change
> anything..., even security patches...
>|||> What has changed on the server?
Ok, I found the error. Somebody activated a second NIC on the server and
that mangled the network routes. The server that was being requested was not
available by pinging. That is way the error was raising on the "send"
method.
Thanks you all for the hints
Best regards
Sammy

Wednesday, March 7, 2012

error [could not find st.proc. "user _get total users"]

I installed a cd program and the sql database 2000 included in the cd.
However, when launching the program I get a message "could not find stored
procedure user-get total users'. If I continue I get a second later on "coul
d
not find stored procedure 'user -name in use '. The provider has no idea .
System is a P4 XP home sp2
I am not a specialist so before going to deep dive in the systems, is there
any thing "simple" than can be done ?From what CD do you install, is it a vendor specific Database (MSDE). What
"Program" are you starting when you get that error. Seems to me that this
might be a vendor specific problem, if you got an individual coded app.
More Information would be great.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>I installed a cd program and the sql database 2000 included in the cd.
> However, when launching the program I get a message "could not find
> stored
> procedure user-get total users'. If I continue I get a second later on
> "could
> not find stored procedure 'user -name in use '. The provider has no idea .
> System is a P4 XP home sp2
> I am not a specialist so before going to deep dive in the systems, is
> there
> any thing "simple" than can be done ?|||Thanks Jens, It is a multimedia software , when installing it also proposes
to install SQL.The error starts after launching the program ( ican see part
of it) , it seems that it sends a login not registered in SQL, there must be
somewhere a table to update .
I have reintsalled everything including the sql, but the problem is still
there.
the strange thing is that in the very first install worked fine. I had to
reinstall x p and to reinstall all the programs, all went fine except for
this one.
"Jens Sü?meyer" wrote:

> From what CD do you install, is it a vendor specific Database (MSDE). What
> "Program" are you starting when you get that error. Seems to me that this
> might be a vendor specific problem, if you got an individual coded app.
> More Information would be great.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
> news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>
>

error [could not find st.proc. "user _get total users"]

I installed a cd program and the sql database 2000 included in the cd.
However, when launching the program I get a message "could not find stored
procedure user-get total users'. If I continue I get a second later on "could
not find stored procedure 'user -name in use '. The provider has no idea .
System is a P4 XP home sp2
I am not a specialist so before going to deep dive in the systems, is there
any thing "simple" than can be done ?From what CD do you install, is it a vendor specific Database (MSDE). What
"Program" are you starting when you get that error. Seems to me that this
might be a vendor specific problem, if you got an individual coded app.
More Information would be great.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>I installed a cd program and the sql database 2000 included in the cd.
> However, when launching the program I get a message "could not find
> stored
> procedure user-get total users'. If I continue I get a second later on
> "could
> not find stored procedure 'user -name in use '. The provider has no idea .
> System is a P4 XP home sp2
> I am not a specialist so before going to deep dive in the systems, is
> there
> any thing "simple" than can be done ?|||Thanks Jens, It is a multimedia software , when installing it also proposes
to install SQL.The error starts after launching the program ( ican see part
of it) , it seems that it sends a login not registered in SQL, there must be
somewhere a table to update .
I have reintsalled everything including the sql, but the problem is still
there.
the strange thing is that in the very first install worked fine. I had to
reinstall x p and to reinstall all the programs, all went fine except for
this one.
"Jens SÃ¼Ã?meyer" wrote:
> From what CD do you install, is it a vendor specific Database (MSDE). What
> "Program" are you starting when you get that error. Seems to me that this
> might be a vendor specific problem, if you got an individual coded app.
> More Information would be great.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
> news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
> >I installed a cd program and the sql database 2000 included in the cd.
> > However, when launching the program I get a message "could not find
> > stored
> > procedure user-get total users'. If I continue I get a second later on
> > "could
> > not find stored procedure 'user -name in use '. The provider has no idea .
> > System is a P4 XP home sp2
> > I am not a specialist so before going to deep dive in the systems, is
> > there
> > any thing "simple" than can be done ?
>
>

error [could not find st.proc. "user _get total users"]

I installed a cd program and the sql database 2000 included in the cd.
However, when launching the program I get a message "could not find stored
procedure user-get total users'. If I continue I get a second later on "could
not find stored procedure 'user -name in use '. The provider has no idea .
System is a P4 XP home sp2
I am not a specialist so before going to deep dive in the systems, is there
any thing "simple" than can be done ?
From what CD do you install, is it a vendor specific Database (MSDE). What
"Program" are you starting when you get that error. Seems to me that this
might be a vendor specific problem, if you got an individual coded app.
More Information would be great.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>I installed a cd program and the sql database 2000 included in the cd.
> However, when launching the program I get a message "could not find
> stored
> procedure user-get total users'. If I continue I get a second later on
> "could
> not find stored procedure 'user -name in use '. The provider has no idea .
> System is a P4 XP home sp2
> I am not a specialist so before going to deep dive in the systems, is
> there
> any thing "simple" than can be done ?
|||Thanks Jens, It is a multimedia software , when installing it also proposes
to install SQL.The error starts after launching the program ( ican see part
of it) , it seems that it sends a login not registered in SQL, there must be
somewhere a table to update .
I have reintsalled everything including the sql, but the problem is still
there.
the strange thing is that in the very first install worked fine. I had to
reinstall x p and to reinstall all the programs, all went fine except for
this one.
"Jens Sü?meyer" wrote:

> From what CD do you install, is it a vendor specific Database (MSDE). What
> "Program" are you starting when you get that error. Seems to me that this
> might be a vendor specific problem, if you got an individual coded app.
> More Information would be great.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "pink bear" <pink bear @.discussions.microsoft.com> schrieb im Newsbeitrag
> news:FC323DB9-58A0-4BCF-BA75-8A6792D79CE3@.microsoft.com...
>
>

Sunday, February 26, 2012

Error (1552) ODBC, Insert Execute Error

Hi, I have a program called dbms/copy that I use to conver clarion database tables. The program first creates the table, if already exists I delete and recreate. This part works fine. When it tries to insert the records I get the following error message:

Error (1552)

ODBC, Insert Execute Error -> Buffer Contained 100 Records but only 0 Records were written

I created a System DSN ODBC link to the SQL Server. I tried using the "sa" user, as well as creating a user and checking off all available permissions. It seems to be a permissions problem to me, although it appears I have permission to do everything. It is definately able to connect since it has no problem creating/deleting/recreating the table in the SQL Server database.

I tried doing the same import with an ODBC connection to a Microsoft Access database and it works without any problems.

Any idea what's giving me this error?I turned on ODBC tracing and the following errors showed up in the SQL.log file:

dbmswin7 f58-b90 ENTER SQLSetStmtAttr
SQLHSTMT 00E51F98
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x00000001
SQLINTEGER 0

dbmswin7 f58-b90 EXIT SQLSetStmtAttr with return code -1 (SQL_ERROR)
SQLHSTMT 00E51F98
SQLINTEGER 6 <SQL_ATTR_CURSOR_TYPE>
SQLPOINTER 0x00000001
SQLINTEGER 0

DIAG [24000] [Microsoft][ODBC Driver Manager] Invalid cursor state (0)

dbmswin7 f58-b90 ENTER SQLSetStmtAttr
SQLHSTMT 00E51F98
SQLINTEGER 7 <SQL_ATTR_CONCURRENCY>
SQLPOINTER 0x00000003
SQLINTEGER 0

dbmswin7 f58-b90 EXIT SQLSetStmtAttr with return code -1 (SQL_ERROR)
SQLHSTMT 00E51F98
SQLINTEGER 7 <SQL_ATTR_CONCURRENCY>
SQLPOINTER 0x00000003
SQLINTEGER 0

DIAG [24000] [Microsoft][ODBC Driver Manager] Invalid cursor state (0)

dbmswin7 f58-b90 ENTER SQLSetStmtAttr
SQLHSTMT 00E51F98
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 0x00000000
SQLINTEGER 0

dbmswin7 f58-b90 EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 00E51F98
SQLINTEGER 5 <SQL_ATTR_ROW_BIND_TYPE>
SQLPOINTER 0x00000000
SQLINTEGER 0

dbmswin7 f58-b90 ENTER SQLSetStmtAttr
SQLHSTMT 00E51F98
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 0x00000064
SQLINTEGER 0

dbmswin7 f58-b90 EXIT SQLSetStmtAttr with return code 0 (SQL_SUCCESS)
SQLHSTMT 00E51F98
SQLINTEGER 27 <SQL_ATTR_ROW_ARRAY_SIZE>
SQLPOINTER 0x00000064 (BADMEM)
SQLINTEGER 0

dbmswin7 f58-b90 ENTER SQLBulkOperations
SQLHSTMT 00E51F98
SQLSMALLINT 4

dbmswin7 f58-b90 EXIT SQLBulkOperations with return code -1 (SQL_ERROR)
SQLHSTMT 00E51F98
SQLSMALLINT 4

DIAG [S1092] [Microsoft][ODBC SQL Server Driver]Invalid attribute/option identifier (0)

dbmswin7 f58-b90 ENTER SQLRowCount
HSTMT 00E51F98
SQLLEN * 0x0012F7F4

dbmswin7 f58-b90 EXIT SQLRowCount with return code 0 (SQL_SUCCESS)
HSTMT 00E51F98
SQLLEN * 0x0012F7F4 (0)

dbmswin7 f58-b90 ENTER SQLDisconnect
HDBC 00E515E8

dbmswin7 f58-b90 EXIT SQLDisconnect with return code 0 (SQL_SUCCESS)
HDBC 00E515E8

Originally posted by UltraSmooth
Hi, I have a program called dbms/copy that I use to conver clarion database tables. The program first creates the table, if already exists I delete and recreate. This part works fine. When it tries to insert the records I get the following error message:

Error (1552)

ODBC, Insert Execute Error -> Buffer Contained 100 Records but only 0 Records were written

I created a System DSN ODBC link to the SQL Server. I tried using the "sa" user, as well as creating a user and checking off all available permissions. It seems to be a permissions problem to me, although it appears I have permission to do everything. It is definately able to connect since it has no problem creating/deleting/recreating the table in the SQL Server database.

I tried doing the same import with an ODBC connection to a Microsoft Access database and it works without any problems.

Any idea what's giving me this error?

Sunday, February 19, 2012

Error - Cannot open the datafile

Hi there,

I have written a program that loads a package (SomePackage.dtsx) from the physical drive and executes that. The package does nothing but imports data from a csv file to the Sql server 2005. But I can see that the package is failing continuously. I meant the package.Execute() method is returning a DTSExecResult.Failure. I investigated the Package.Errors property that contains the error collection and found that there are two DTSError objects into the collection.

The first one’s description says that

Cannot open the datafile "D:\SOME.csv".

And the later one’s is

component "SOURCE FLAT FILE COMPONENT" (1) failed the pre-execute phase and returned error code 0xC020200E.

But the most interesting thing is if I execute the package through the Execute package Utility (double clicking onto the SomePackage.dtsx file) ships with Sql server 2005 then it executes fine and works as expected. I have checked the permission of the csv file and it has everyone’s full access.

Can anyone help me on this?

I will appreciate all kind of suggestions.

Thanks

Moim

Hi,

"right click" the "flatfile connection manager"
click on "Edit". there are several properties here that needs to be configured
one of which is the "format".. make sure its "delimited" or something that suits your need.
if it didn't solve your problem try other properties
in this area.

regards,

joey

|||

What is different about when you use your tool vs dtexecui?

Is this the same machine?

Is this the same user running both tools?

|||

Darren,

Basically I can see the only difference is when I am running through the code it is failing and when I am running from the windows explorer it is working.

Nothing more. It is same machine, same user.

Any Idea?

Thanks

Moim

|||

joeydj,

Im afraid, I have created that package programmatically so I dont have a scope to edit that inside the Sql Server BI editor. anyway, I checked out and these properties are set.

Any Idea?

Thanks

Moim

|||Is your file on a mapped drive, by chance?|||

Brammer,

No its on a local drive (drive D: ).

Any other idea?

THanks

Moim

|||

Ok, so same package, same machine, same user, same execution parameters, just a different execution host... does not make much sense.

Try adding logging to the package, something simple like log all warnings and errors to a text file. Any other errors? There must be some difference but that error is not very clear as to what.

Wednesday, February 15, 2012

Erratic connections to SQL database

We are running SBS 2003 Premium with SP1.
Each PC runs a small VB .exe, a booking program, which we use as a front end
to SQL database.
Since installing ISA Server 2004 and SQL2K SP4 several machines now have
trouble running the booking program. It hangs for up to 30 seconds at a time
in different parts of the process but always, apparently, when it is trying
to access the SQL data. A booking that should take no more than half a minute
is now taking 5 minutes or more.
All other machines running the same program do not have a problem. I have
slowly eliminated user issues, log in issues and possible physical (network)
problems.
Now I am baffled!
Any suggestions please!
"mh1959" <mh1959@.discussions.microsoft.com> wrote in message
news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> We are running SBS 2003 Premium with SP1.
> Each PC runs a small VB .exe, a booking program, which we use as a front
> end
> to SQL database.
> Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> trouble running the booking program. It hangs for up to 30 seconds at a
> time
> in different parts of the process but always, apparently, when it is
> trying
> to access the SQL data. A booking that should take no more than half a
> minute
> is now taking 5 minutes or more.
> All other machines running the same program do not have a problem. I have
> slowly eliminated user issues, log in issues and possible physical
> (network)
> problems.
> Now I am baffled!
> Any suggestions please!
Is your ISA server throttling bandwidth for some reason?
What type of connection are you using? Named Pipes? TCP/IP?
What is the speed of the network? What are your NIC cards set to if they
can do both 10/100/1000 for example.
Rick Sawtell
|||Rick,
Thanks for your response, as soon as I saw your question about "named pipes"
I realised where the problem was.
Thanks for your help.
"Rick Sawtell" wrote:

> "mh1959" <mh1959@.discussions.microsoft.com> wrote in message
> news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> Is your ISA server throttling bandwidth for some reason?
> What type of connection are you using? Named Pipes? TCP/IP?
> What is the speed of the network? What are your NIC cards set to if they
> can do both 10/100/1000 for example.
> Rick Sawtell
>
>

Erratic connections to SQL database

We are running SBS 2003 Premium with SP1.
Each PC runs a small VB .exe, a booking program, which we use as a front end
to SQL database.
Since installing ISA Server 2004 and SQL2K SP4 several machines now have
trouble running the booking program. It hangs for up to 30 seconds at a time
in different parts of the process but always, apparently, when it is trying
to access the SQL data. A booking that should take no more than half a minute
is now taking 5 minutes or more.
All other machines running the same program do not have a problem. I have
slowly eliminated user issues, log in issues and possible physical (network)
problems.
Now I am baffled!
Any suggestions please!"mh1959" <mh1959@.discussions.microsoft.com> wrote in message
news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> We are running SBS 2003 Premium with SP1.
> Each PC runs a small VB .exe, a booking program, which we use as a front
> end
> to SQL database.
> Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> trouble running the booking program. It hangs for up to 30 seconds at a
> time
> in different parts of the process but always, apparently, when it is
> trying
> to access the SQL data. A booking that should take no more than half a
> minute
> is now taking 5 minutes or more.
> All other machines running the same program do not have a problem. I have
> slowly eliminated user issues, log in issues and possible physical
> (network)
> problems.
> Now I am baffled!
> Any suggestions please!
Is your ISA server throttling bandwidth for some reason?
What type of connection are you using? Named Pipes? TCP/IP?
What is the speed of the network? What are your NIC cards set to if they
can do both 10/100/1000 for example.
Rick Sawtell|||Rick,
Thanks for your response, as soon as I saw your question about "named pipes"
I realised where the problem was.
Thanks for your help.
"Rick Sawtell" wrote:
> "mh1959" <mh1959@.discussions.microsoft.com> wrote in message
> news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> > We are running SBS 2003 Premium with SP1.
> > Each PC runs a small VB .exe, a booking program, which we use as a front
> > end
> > to SQL database.
> > Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> > trouble running the booking program. It hangs for up to 30 seconds at a
> > time
> > in different parts of the process but always, apparently, when it is
> > trying
> > to access the SQL data. A booking that should take no more than half a
> > minute
> > is now taking 5 minutes or more.
> > All other machines running the same program do not have a problem. I have
> > slowly eliminated user issues, log in issues and possible physical
> > (network)
> > problems.
> > Now I am baffled!
> > Any suggestions please!
> Is your ISA server throttling bandwidth for some reason?
> What type of connection are you using? Named Pipes? TCP/IP?
> What is the speed of the network? What are your NIC cards set to if they
> can do both 10/100/1000 for example.
> Rick Sawtell
>
>

Erratic connections to SQL database

We are running SBS 2003 Premium with SP1.
Each PC runs a small VB .exe, a booking program, which we use as a front end
to SQL database.
Since installing ISA Server 2004 and SQL2K SP4 several machines now have
trouble running the booking program. It hangs for up to 30 seconds at a time
in different parts of the process but always, apparently, when it is trying
to access the SQL data. A booking that should take no more than half a minut
e
is now taking 5 minutes or more.
All other machines running the same program do not have a problem. I have
slowly eliminated user issues, log in issues and possible physical (network)
problems.
Now I am baffled!
Any suggestions please!"mh1959" <mh1959@.discussions.microsoft.com> wrote in message
news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> We are running SBS 2003 Premium with SP1.
> Each PC runs a small VB .exe, a booking program, which we use as a front
> end
> to SQL database.
> Since installing ISA Server 2004 and SQL2K SP4 several machines now have
> trouble running the booking program. It hangs for up to 30 seconds at a
> time
> in different parts of the process but always, apparently, when it is
> trying
> to access the SQL data. A booking that should take no more than half a
> minute
> is now taking 5 minutes or more.
> All other machines running the same program do not have a problem. I have
> slowly eliminated user issues, log in issues and possible physical
> (network)
> problems.
> Now I am baffled!
> Any suggestions please!
Is your ISA server throttling bandwidth for some reason?
What type of connection are you using? Named Pipes? TCP/IP?
What is the speed of the network? What are your NIC cards set to if they
can do both 10/100/1000 for example.
Rick Sawtell|||Rick,
Thanks for your response, as soon as I saw your question about "named pipes"
I realised where the problem was.
Thanks for your help.
"Rick Sawtell" wrote:

> "mh1959" <mh1959@.discussions.microsoft.com> wrote in message
> news:685E71AD-84FC-4D5C-97EF-11CBC3954350@.microsoft.com...
> Is your ISA server throttling bandwidth for some reason?
> What type of connection are you using? Named Pipes? TCP/IP?
> What is the speed of the network? What are your NIC cards set to if they
> can do both 10/100/1000 for example.
> Rick Sawtell
>
>

Thursday, March 29, 2012

Error 18456" error message when you specify configuration database

Error 18456" error message when you specify configuration database

Error 18456" error message when you specify configuration database

Monday, March 19, 2012

Error 1389 (aka 0x80070576 or STATUS_TIME_DIFFERENCE_AT_DC or ERROR_TIME_SKEW)?

error -132

error -132

error -132

Friday, March 9, 2012

Error 0x800c0005 when calling Microsoft.XMLHTTP from inside SQLSer

Wednesday, March 7, 2012

error [could not find st.proc. "user _get total users"]

error [could not find st.proc. "user _get total users"]

error [could not find st.proc. "user _get total users"]

Sunday, February 26, 2012

Error (1552) ODBC, Insert Execute Error

Sunday, February 19, 2012

Error - Cannot open the datafile

Wednesday, February 15, 2012

Erratic connections to SQL database

Erratic connections to SQL database

Erratic connections to SQL database

sql error 15138

Blog Archive

About Me