DTS from 2000 to 2005

I migrated a DTS package from my 2000 test server to my 2005 test server and
I seem to be lost... The log file shows that everything converted fine,
where will I find that package? PLEASE HELP ME!!!1 THANK YOU>I migrated a DTS package from my 2000 test server to my 2005 test server
>and I seem to be lost... The log file shows that everything converted
>fine, where will I find that package? PLEASE HELP ME!!!1 THANK YOU
In SQL Server Management Studio, in Object Explorer, connect to the
Integration Services. Then chack whether the paclage is registered in the
local msdb database. If it is somewhere on the file system, search for the
*.dtsx files with Windows Explorer.
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message|||Im SSMS click on connect and choose Server Type-- Integration Services
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:ujXNdIX8GHA.1188@.TK2MSFTNGP05.phx.gbl...
>I migrated a DTS package from my 2000 test server to my 2005 test server
>and I seem to be lost... The log file shows that everything converted
>fine, where will I find that package? PLEASE HELP ME!!!1 THANK YOU
>|||something just doesn't seem right here >> I have SQL2000 installed as the
default instance, and 2005 as a named instance, when I register integration
services I only see the server name (which is by default the default
instance) I do not see, and can not find the 2005 named instance. So I
tried to work with that and I registered it and drilled down to the MSDB
container, when I open that container I get this error >>
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
--
ADDITIONAL INFORMATION:
The SQL server specified in SSIS service configuration is not present or is
not available. This might occur when there is no default instance of SQL
Server on the computer. For more information, see the topic "Configuring the
Integration Services Service" in Server 2005 Books Online.
Client unable to establish connection
Encryption not supported on SQL Server. (MsDtsSrvr)
--
BUTTONS:
OK
--
<< I am just guessing here but is this because I have the wrong SQL server
registered in integration services '
ANYbody have any ideas, pleases... Thank you!!
========================================================"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eJGXbXb8GHA.2128@.TK2MSFTNGP05.phx.gbl...
> >I migrated a DTS package from my 2000 test server to my 2005 test server
> >and I seem to be lost... The log file shows that everything converted
> >fine, where will I find that package? PLEASE HELP ME!!!1 THANK YOU
> In SQL Server Management Studio, in Object Explorer, connect to the
> Integration Services. Then chack whether the paclage is registered in the
> local msdb database. If it is somewhere on the file system, search for the
> *.dtsx files with Windows Explorer.
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>|||I'm a bit confused but I think your issue is that you are
using a named instances for 2005 and possibly didn't modify
the configuration file as indicated in the Books Online
topic so that SSIS would work with the named instance.
Locate the file MsDtsSrvr.ini.xml in your 2005 installation
path Program Files\Microsoft
SQL Server\90\DTS\Binn
The server name entry for a named instance should be
something along the lines of:
<ServerName>YourServer\YourInstanceName</ServerName>
-Sue
On Tue, 17 Oct 2006 09:39:53 -0500, "WANNABE" <breichenbach
AT istate DOT com> wrote:
>something just doesn't seem right here >> I have SQL2000 installed as the
>default instance, and 2005 as a named instance, when I register integration
>services I only see the server name (which is by default the default
>instance) I do not see, and can not find the 2005 named instance. So I
>tried to work with that and I registered it and drilled down to the MSDB
>container, when I open that container I get this error >>
>TITLE: Microsoft SQL Server Management Studio
>--
>Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
>For help, click:
>http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
>--
>ADDITIONAL INFORMATION:
>The SQL server specified in SSIS service configuration is not present or is
>not available. This might occur when there is no default instance of SQL
>Server on the computer. For more information, see the topic "Configuring the
>Integration Services Service" in Server 2005 Books Online.
>Client unable to establish connection
>Encryption not supported on SQL Server. (MsDtsSrvr)
>--
>BUTTONS:
>OK
>--
><< I am just guessing here but is this because I have the wrong SQL server
>registered in integration services '
>ANYbody have any ideas, pleases... Thank you!!
>========================================================>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
>message news:eJGXbXb8GHA.2128@.TK2MSFTNGP05.phx.gbl...
>> >I migrated a DTS package from my 2000 test server to my 2005 test server
>> >and I seem to be lost... The log file shows that everything converted
>> >fine, where will I find that package? PLEASE HELP ME!!!1 THANK YOU
>> In SQL Server Management Studio, in Object Explorer, connect to the
>> Integration Services. Then chack whether the paclage is registered in the
>> local msdb database. If it is somewhere on the file system, search for the
>> *.dtsx files with Windows Explorer.
>> --
>> Dejan Sarka, SQL Server MVP
>> Mentor, www.SolidQualityLearning.com
>> Anything written in this message represents solely the point of view of
>> the sender.
>> This message does not imply endorsement from Solid Quality Learning, and
>> it does not represent the point of view of Solid Quality Learning or any
>> other person, company or institution mentioned in this message
>>
>

DTS from 2000 to 2005

I migrated a DTS package from my 2000 test server to my 2005 test server and
I seem to be lost... The log file shows that everything converted fine,
where will I find that package? PLEASE HELP ME!!!1 THANK YOU
>I migrated a DTS package from my 2000 test server to my 2005 test server
>and I seem to be lost... The log file shows that everything converted
>fine, where will I find that package? PLEASE HELP ME!!!1 THANK YOU
In SQL Server Management Studio, in Object Explorer, connect to the
Integration Services. Then chack whether the paclage is registered in the
local msdb database. If it is somewhere on the file system, search for the
*.dtsx files with Windows Explorer.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
|||Im SSMS click on connect and choose Server Type-- Integration Services
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:ujXNdIX8GHA.1188@.TK2MSFTNGP05.phx.gbl...
>I migrated a DTS package from my 2000 test server to my 2005 test server
>and I seem to be lost... The log file shows that everything converted
>fine, where will I find that package? PLEASE HELP ME!!!1 THANK YOU
>
|||something just doesn't seem right here >> I have SQL2000 installed as the
default instance, and 2005 as a named instance, when I register integration
services I only see the server name (which is by default the default
instance) I do not see, and can not find the 2005 named instance. So I
tried to work with that and I registered it and drilled down to the MSDB
container, when I open that container I get this error >>
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476
ADDITIONAL INFORMATION:
The SQL server specified in SSIS service configuration is not present or is
not available. This might occur when there is no default instance of SQL
Server on the computer. For more information, see the topic "Configuring the
Integration Services Service" in Server 2005 Books Online.
Client unable to establish connection
Encryption not supported on SQL Server. (MsDtsSrvr)
BUTTONS:
OK
<< I am just guessing here but is this because I have the wrong SQL server
registered in integration services ?
ANYbody have any ideas, pleases... Thank you!!
================================================== ======
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:eJGXbXb8GHA.2128@.TK2MSFTNGP05.phx.gbl...
> In SQL Server Management Studio, in Object Explorer, connect to the
> Integration Services. Then chack whether the paclage is registered in the
> local msdb database. If it is somewhere on the file system, search for the
> *.dtsx files with Windows Explorer.
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>
|||I'm a bit confused but I think your issue is that you are
using a named instances for 2005 and possibly didn't modify
the configuration file as indicated in the Books Online
topic so that SSIS would work with the named instance.
Locate the file MsDtsSrvr.ini.xml in your 2005 installation
path Program Files\Microsoft
SQL Server\90\DTS\Binn
The server name entry for a named instance should be
something along the lines of:
<ServerName>YourServer\YourInstanceName</ServerName>
-Sue
On Tue, 17 Oct 2006 09:39:53 -0500, "WANNABE" <breichenbach
AT istate DOT com> wrote:

>something just doesn't seem right here >> I have SQL2000 installed as the
>default instance, and 2005 as a named instance, when I register integration
>services I only see the server name (which is by default the default
>instance) I do not see, and can not find the 2005 named instance. So I
>tried to work with that and I registered it and drilled down to the MSDB
>container, when I open that container I get this error >>
>TITLE: Microsoft SQL Server Management Studio
>--
>Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
>For help, click:
>http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476
>--
>ADDITIONAL INFORMATION:
>The SQL server specified in SSIS service configuration is not present or is
>not available. This might occur when there is no default instance of SQL
>Server on the computer. For more information, see the topic "Configuring the
>Integration Services Service" in Server 2005 Books Online.
>Client unable to establish connection
>Encryption not supported on SQL Server. (MsDtsSrvr)
>--
>BUTTONS:
>OK
>--
><< I am just guessing here but is this because I have the wrong SQL server
>registered in integration services ?
>ANYbody have any ideas, pleases... Thank you!!
>================================================= =======
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
>message news:eJGXbXb8GHA.2128@.TK2MSFTNGP05.phx.gbl...
>

DTS from 2000 to 2005

I migrated a DTS package from my 2000 test server to my 2005 test server and
I seem to be lost... The log file shows that everything converted fine,
where will I find that package? PLEASE HELP ME!!!1 THANK YOU>I migrated a DTS package from my 2000 test server to my 2005 test server
>and I seem to be lost... The log file shows that everything converted
>fine, where will I find that package? PLEASE HELP ME!!!1 THANK YOU
In SQL Server Management Studio, in Object Explorer, connect to the
Integration Services. Then chack whether the paclage is registered in the
local msdb database. If it is somewhere on the file system, search for the
*.dtsx files with Windows Explorer.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message|||Im SSMS click on connect and choose Server Type-- Integration Services
"WANNABE" <breichenbach AT istate DOT com> wrote in message
news:ujXNdIX8GHA.1188@.TK2MSFTNGP05.phx.gbl...
>I migrated a DTS package from my 2000 test server to my 2005 test server
>and I seem to be lost... The log file shows that everything converted
>fine, where will I find that package? PLEASE HELP ME!!!1 THANK YOU
>|||something just doesn't seem right here >> I have SQL2000 installed as the
default instance, and 2005 as a named instance, when I register integration
services I only see the server name (which is by default the default
instance) I do not see, and can not find the 2005 named instance. So I
tried to work with that and I registered it and drilled down to the MSDB
container, when I open that container I get this error >>
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
--
ADDITIONAL INFORMATION:
The SQL server specified in SSIS service configuration is not present or is
not available. This might occur when there is no default instance of SQL
Server on the computer. For more information, see the topic "Configuring the
Integration Services Service" in Server 2005 Books Online.
Client unable to establish connection
Encryption not supported on SQL Server. (MsDtsSrvr)
--
BUTTONS:
OK
--
<< I am just guessing here but is this because I have the wrong SQL server
registered in integration services '
ANYbody have any ideas, pleases... Thank you!!
========================================
================
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eJGXbXb8GHA.2128@.TK2MSFTNGP05.phx.gbl...
> In SQL Server Management Studio, in Object Explorer, connect to the
> Integration Services. Then chack whether the paclage is registered in the
> local msdb database. If it is somewhere on the file system, search for the
> *.dtsx files with Windows Explorer.
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www.SolidQualityLearning.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>|||I'm a bit confused but I think your issue is that you are
using a named instances for 2005 and possibly didn't modify
the configuration file as indicated in the Books Online
topic so that SSIS would work with the named instance.
Locate the file MsDtsSrvr.ini.xml in your 2005 installation
path Program Files\Microsoft
SQL Server\90\DTS\Binn
The server name entry for a named instance should be
something along the lines of:
<ServerName>YourServer\YourInstanceName</ServerName>
-Sue
On Tue, 17 Oct 2006 09:39:53 -0500, "WANNABE" <breichenbach
AT istate DOT com> wrote:

>something just doesn't seem right here >> I have SQL2000 installed as the
>default instance, and 2005 as a named instance, when I register integration
>services I only see the server name (which is by default the default
>instance) I do not see, and can not find the 2005 named instance. So I
>tried to work with that and I registered it and drilled down to the MSDB
>container, when I open that container I get this error >>
>TITLE: Microsoft SQL Server Management Studio
>--
>Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
>For help, click:
>http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
>--
>ADDITIONAL INFORMATION:
>The SQL server specified in SSIS service configuration is not present or is
>not available. This might occur when there is no default instance of SQL
>Server on the computer. For more information, see the topic "Configuring th
e
>Integration Services Service" in Server 2005 Books Online.
>Client unable to establish connection
>Encryption not supported on SQL Server. (MsDtsSrvr)
>--
>BUTTONS:
>OK
>--
><< I am just guessing here but is this because I have the wrong SQL server
>registered in integration services '
>ANYbody have any ideas, pleases... Thank you!!
> ========================================
================
>"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
>message news:eJGXbXb8GHA.2128@.TK2MSFTNGP05.phx.gbl...
>

DTS and Log File

Ok, I have a problem that maybe easy to solve because of my inexperience but it sure is baffling. I am trying to load a text file into a table on SQL server. This file is around 635 meg. When I try to load it through a DTS it will run through all the rows (1228000). Then it will hang for a while then I will get a execution failure saying that the log file is full. Then it will tell you to backup the log file and blah blah blah. Problem is I do this and then try again and get the same problem. As a matter of fact the second time I tried it told me the tempdb log file was full. Any ideas? I have the log file for the database set to expand as needed.

Thanks
TomI'm thinking it is the DTS log file rather than the Database

http://vyaskn.tripod.com/sql_server_dts_error_file.htm

DTL job error log details -- sql server 2000

Hi
In job history for a DTS job I get percent complete and not futher details
when the job fails. There is no log written anywhere.
How to debug such issues?
Tks
MangeshYou can try by clicking 'Show Step details' in top right corner of the job
history section. That will show you step wise details of the result
execution. As far as logging is concerned, you can log each step's details in
a directory of your choice. This can be done while you are creating the job
steps.
ReportFAQGuy
"Mangesh Deshpande" wrote:
> Hi
> In job history for a DTS job I get percent complete and not futher details
> when the job fails. There is no log written anywhere.
> How to debug such issues?
> Tks
> Mangesh

dtexec hangs unexpectedly

I have noticed a strange behaviour when running some of my packages with dtexec. The packages use EventHandlers to log information to a database using the Execute SQL Task with the query stored in a variable. This variable is further part of the package configuration, so that I can change the query without changing the package itself. Now, this all works fine, until I made a typo in the query causing the syntax to be invalid, ie changing SELECT to SELCET. Now, one would expect the package to fail, and it does, if I run it through the debugger in Visual Studio, but when I run it using dtexec it just hangs and I have to kill the process using the Task Manager.

Peculiarly, I tried doing the same thing with a task that was not contained in an EventHandler, and then the package fails as expected, both when running it in the debugger and using dtexec. This is not a major problem, but what I am afraid of is that one day the database server will be down and cause an error in the Execute SQL Task in the EventHandler, causing dtexec to hang indefinitely. Has anyone else had problems like these?

Regards,
Lars

That's a really interesting observation Lars. I'd certainly be very worried about this happening as well. It might be worth logging as a bug.

I've certainly noticed dtexec appearing to hang but have never managed to track down why. Perhaps this was the reason.

-Jamie

|||

I finally managed to track down the problem. It is described here: http://msdn2.microsoft.com/en-us/library/system.diagnostics.process.standardoutput.aspx and it is the deadlock that arises when reading both standard input and standard error after eachoter. In other words, this was related to my poor .NET skills and not a problem within SSIS.

Regards,
Lars

DTC question

Hi friends,
If I have a ms dtc log file on my hands, and it is, I believe, in some
binary format, is there any way to view it?
Thanks a lot in advanceHi,
> If I have a ms dtc log file on my hands, and it is, I believe, in some
> binary format, is there any way to view it?
I'm afraid there is no way to do it. The file is encrypted as an
internal part of DTC service.
Best regards,
Marcin Guzowski
http://guzowski.info|||It is sad.
It's actually dtc trace file.
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:esu87d$p2a$1@.news.onet.pl...
> Hi,
>> If I have a ms dtc log file on my hands, and it is, I believe, in some
>> binary format, is there any way to view it?
> I'm afraid there is no way to do it. The file is encrypted as an internal
> part of DTC service.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

DTC question

Hi friends,
If I have a ms dtc log file on my hands, and it is, I believe, in some
binary format, is there any way to view it?
Thanks a lot in advance
It is sad.
It's actually dtc trace file.
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:esu87d$p2a$1@.news.onet.pl...
> Hi,
>
> I'm afraid there is no way to do it. The file is encrypted as an internal
> part of DTC service.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

DTC question

Hi friends,
If I have a ms dtc log file on my hands, and it is, I believe, in some
binary format, is there any way to view it?
Thanks a lot in advanceHi,

> If I have a ms dtc log file on my hands, and it is, I believe, in some
> binary format, is there any way to view it?
I'm afraid there is no way to do it. The file is encrypted as an
internal part of DTC service.
Best regards,
Marcin Guzowski
http://guzowski.info|||It is sad.
It's actually dtc trace file.
"Marcin A. Guzowski" <tu_wstaw_moje_imie@.guzowski.info> wrote in message
news:esu87d$p2a$1@.news.onet.pl...
> Hi,
>
> I'm afraid there is no way to do it. The file is encrypted as an internal
> part of DTC service.
>
> --
> Best regards,
> Marcin Guzowski
> http://guzowski.info

dt_verstamp006

Hi, I was looking on SQLServer log files in EM, I found the following
message :
"EXECUTE permission denied on object 'dt_verstamp006', database 'mydaabase',
owner 'dbo'.."
just before this message there is :
"Error: 229, Severity: 14, State: 5"
So, what is "dt_verstamp006" object ? the user executing the sql is dbo user
Thanks in advance
Hello,
dt_verstamp006 was created when when you created and saved a database
diagram in Enterprise
Manager. Please refer to the following article for details:
327145 FIX: You cannot create diagrams in SQL Enterprise Manager if you are
not
http://support.microsoft.com/?id=327145
You may want to run following command to grant exec permssion to the SP
Grant exec on dt_verstamp006 to [user].
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: dt_verstamp006
| thread-index: AcVA048EkrLc/oC0RQKNwLeu08tSyQ==
| X-WBNR-Posting-Host: 194.51.27.4
| From: "=?Utf-8?B?U2FsYW1FbGlhcw==?=" <eliassal@.online.nospam>
| Subject: dt_verstamp006
| Date: Thu, 14 Apr 2005 02:23:03 -0700
| Lines: 8
| Message-ID: <EA9A9625-C77F-4B49-91B0-B1686B590F45@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| Path: TK2MSFTNGXA01.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:52446
| NNTP-Posting-Host: tk2msftngxa03.phx.gbl 10.40.2.157
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi, I was looking on SQLServer log files in EM, I found the following
| message :
| "EXECUTE permission denied on object 'dt_verstamp006', database
'mydaabase',
| owner 'dbo'.."
| just before this message there is :
| "Error: 229, Severity: 14, State: 5"
| So, what is "dt_verstamp006" object ? the user executing the sql is dbo
user
| Thanks in advance
|

dt_verstamp006

Hi, I was looking on SQLServer log files in EM, I found the following
message :
"EXECUTE permission denied on object 'dt_verstamp006', database 'mydaabase',
owner 'dbo'.."
just before this message there is :
"Error: 229, Severity: 14, State: 5"
So, what is "dt_verstamp006" object ? the user executing the sql is dbo user
Thanks in advanceHello,
dt_verstamp006 was created when when you created and saved a database
diagram in Enterprise
Manager. Please refer to the following article for details:
327145 FIX: You cannot create diagrams in SQL Enterprise Manager if you are
not
http://support.microsoft.com/?id=327145
You may want to run following command to grant exec permssion to the SP
Grant exec on dt_verstamp006 to [user].
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: dt_verstamp006
| thread-index: AcVA048EkrLc/oC0RQKNwLeu08tSyQ==
| X-WBNR-Posting-Host: 194.51.27.4
| From: "examnotes" <eliassal@.online.nospam>
| Subject: dt_verstamp006
| Date: Thu, 14 Apr 2005 02:23:03 -0700
| Lines: 8
| Message-ID: <EA9A9625-C77F-4B49-91B0-B1686B590F45@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.server
| Path: TK2MSFTNGXA01.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:52446
| NNTP-Posting-Host: tk2msftngxa03.phx.gbl 10.40.2.157
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Hi, I was looking on SQLServer log files in EM, I found the following
| message :
| "EXECUTE permission denied on object 'dt_verstamp006', database
'mydaabase',
| owner 'dbo'.."
| just before this message there is :
| "Error: 229, Severity: 14, State: 5"
| So, what is "dt_verstamp006" object ? the user executing the sql is dbo
user
| Thanks in advance
|

DSN VS Logon

Our Database is ignores the authentication method that is chosen in the
database connection under ODBC. Everyone is getting a log on dialog.
Can any one help! ThanksYou didn't provide many details but is it safe to guess that
you are trying to use Windows Authentication in the DSN and
that all user who use this DSN are being prompted to enter a
user and password?
There was a similar issue with an old version of MDAC (2.5
maybe) if that's the case. You can check your MDAC
installation and version with component checker. Component
checker and MDAC versions are available for download from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Thu, 26 Oct 2006 12:49:02 -0700, Maida
<Maida@.discussions.microsoft.com> wrote:

>Our Database is ignores the authentication method that is chosen in the
>database connection under ODBC. Everyone is getting a log on dialog.
>Can any one help! Thanks|||Thanks Sue - Sorry I was short
We're moving on servers to a new Domain (btoins.com) then we will reimage
the workstation and move them. Before we moved it the DSN file worked fine w
e
didn't get any Windows Authentication box. We did a temp fix by putting the
domain users(genelco.com) in the local machine administrator group. Why
what's up with that - Thanks for your help!
"Sue Hoegemeier" wrote:

> You didn't provide many details but is it safe to guess that
> you are trying to use Windows Authentication in the DSN and
> that all user who use this DSN are being prompted to enter a
> user and password?
> There was a similar issue with an old version of MDAC (2.5
> maybe) if that's the case. You can check your MDAC
> installation and version with component checker. Component
> checker and MDAC versions are available for download from:
> http://msdn.microsoft.com/data/ref/mdac/downloads/
> -Sue
> On Thu, 26 Oct 2006 12:49:02 -0700, Maida
> <Maida@.discussions.microsoft.com> wrote:
>
>|||What protocol are you connecting with? Make sure it's TCP/IP
and not named pipes.
You can end up with some issues on logins, domain mappings
when moving domains but I can't tell from your post if this
is the issue or not. What domain are the users logging into
when they try to use the DSN? What domain are they listed
under in syslogins?
-Sue
On Fri, 27 Oct 2006 07:26:03 -0700, Maida
<Maida@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Thanks Sue - Sorry I was short
>We're moving on servers to a new Domain (btoins.com) then we will reimage
>the workstation and move them. Before we moved it the DSN file worked fine
we
>didn't get any Windows Authentication box. We did a temp fix by putting the
>domain users(genelco.com) in the local machine administrator group. Why
>what's up with that - Thanks for your help!
>"Sue Hoegemeier" wrote:
>