Failed to set proper user name ('domain\username') for the connection

Im runnning a Trace from Production against a Development box and getting
this error message:
Failed to set proper user name ('domain\username') for the connection
. I have removed the db_id from the Trace table. Also, all the Logins/ Users
are set to the proper default DB. So Im really confused as to why I would be
getting this? Any ideas?
TIA, ChrisRHi
Have you got the same db_id for the database(s) on the production and
development servers? You may want to restore master! Alternatively try to
save the trace as a SQL File and then run that, you should not get this
problem and it will be easier to debug any problems that you do get.
John
"ChrisR" <ChrisR@.noEmail.com> wrote in message
news:%23qqMGq7CFHA.4052@.TK2MSFTNGP15.phx.gbl...
> Im runnning a Trace from Production against a Development box and getting
> this error message:
> Failed to set proper user name ('domain\username') for the connection
> . I have removed the db_id from the Trace table. Also, all the Logins/
> Users
> are set to the proper default DB. So Im really confused as to why I would
> be
> getting this? Any ideas?
>
> TIA, ChrisR
>|||John if Im not mistaken, the problem should have been fixed by simply
removing the db_id... therefore not requiring the restore of Master.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:e6jSfhHDFHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hi
> Have you got the same db_id for the database(s) on the production and
> development servers? You may want to restore master! Alternatively try to
> save the trace as a SQL File and then run that, you should not get this
> problem and it will be easier to debug any problems that you do get.
> John
> "ChrisR" <ChrisR@.noEmail.com> wrote in message
> news:%23qqMGq7CFHA.4052@.TK2MSFTNGP15.phx.gbl...
> > Im runnning a Trace from Production against a Development box and
getting
> > this error message:
> >
> > Failed to set proper user name ('domain\username') for the connection
> >
> > . I have removed the db_id from the Trace table. Also, all the Logins/
> > Users
> > are set to the proper default DB. So Im really confused as to why I
would
> > be
> > getting this? Any ideas?
> >
> >
> >
> > TIA, ChrisR
> >
> >
>|||Hi
That is not what I understand! Profiling it may help.
John
ChrisR wrote:
> John if Im not mistaken, the problem should have been fixed by simply
> removing the db_id... therefore not requiring the restore of Master.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:e6jSfhHDFHA.2180@.TK2MSFTNGP10.phx.gbl...
> > Hi
> >
> > Have you got the same db_id for the database(s) on the production
and
> > development servers? You may want to restore master! Alternatively
try to
> > save the trace as a SQL File and then run that, you should not get
this
> > problem and it will be easier to debug any problems that you do
get.
> >
> > John
> >
> > "ChrisR" <ChrisR@.noEmail.com> wrote in message
> > news:%23qqMGq7CFHA.4052@.TK2MSFTNGP15.phx.gbl...
> > > Im runnning a Trace from Production against a Development box and
> getting
> > > this error message:
> > >
> > > Failed to set proper user name ('domain\username') for the
connection
> > >
> > > . I have removed the db_id from the Trace table. Also, all the
Logins/
> > > Users
> > > are set to the proper default DB. So Im really confused as to why
I
> would
> > > be
> > > getting this? Any ideas?
> > >
> > >
> > >
> > > TIA, ChrisR
> > >
> > >
> >
> >|||It generally does work if you remove database ids from the
trace. Double check to make sure all the users captured in
the trace have a default database of the target database.
The commands should then be executed in the default database
so the database id isn't an issue.
-Sue
On 8 Feb 2005 00:01:01 -0800, "John Bell"
<jbellnewsposts@.hotmail.com> wrote:
>Hi
>That is not what I understand! Profiling it may help.
>John
>ChrisR wrote:
>> John if Im not mistaken, the problem should have been fixed by simply
>> removing the db_id... therefore not requiring the restore of Master.
>>
>> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
>> news:e6jSfhHDFHA.2180@.TK2MSFTNGP10.phx.gbl...
>> > Hi
>> >
>> > Have you got the same db_id for the database(s) on the production
>and
>> > development servers? You may want to restore master! Alternatively
>try to
>> > save the trace as a SQL File and then run that, you should not get
>this
>> > problem and it will be easier to debug any problems that you do
>get.
>> >
>> > John
>> >
>> > "ChrisR" <ChrisR@.noEmail.com> wrote in message
>> > news:%23qqMGq7CFHA.4052@.TK2MSFTNGP15.phx.gbl...
>> > > Im runnning a Trace from Production against a Development box and
>> getting
>> > > this error message:
>> > >
>> > > Failed to set proper user name ('domain\username') for the
>connection
>> > >
>> > > . I have removed the db_id from the Trace table. Also, all the
>Logins/
>> > > Users
>> > > are set to the proper default DB. So Im really confused as to why
>I
>> would
>> > > be
>> > > getting this? Any ideas?
>> > >
>> > >
>> > >
>> > > TIA, ChrisR
>> > >
>> > >
>> >
>> >|||Hi
Another through, although you say there default databases are set for
all users, check that there are no orphaned users.
John
John Bell wrote:
> Hi
> That is not what I understand! Profiling it may help.
> John
> ChrisR wrote:
> > John if Im not mistaken, the problem should have been fixed by
simply
> > removing the db_id... therefore not requiring the restore of
Master.
> >
> >
> > "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> > news:e6jSfhHDFHA.2180@.TK2MSFTNGP10.phx.gbl...
> > > Hi
> > >
> > > Have you got the same db_id for the database(s) on the production
> and
> > > development servers? You may want to restore master!
Alternatively
> try to
> > > save the trace as a SQL File and then run that, you should not
get
> this
> > > problem and it will be easier to debug any problems that you do
> get.
> > >
> > > John
> > >
> > > "ChrisR" <ChrisR@.noEmail.com> wrote in message
> > > news:%23qqMGq7CFHA.4052@.TK2MSFTNGP15.phx.gbl...
> > > > Im runnning a Trace from Production against a Development box
and
> > getting
> > > > this error message:
> > > >
> > > > Failed to set proper user name ('domain\username') for the
> connection
> > > >
> > > > . I have removed the db_id from the Trace table. Also, all the
> Logins/
> > > > Users
> > > > are set to the proper default DB. So Im really confused as to
why
> I
> > would
> > > > be
> > > > getting this? Any ideas?
> > > >
> > > >
> > > >
> > > > TIA, ChrisR
> > > >
> > > >
> > >
> > >

Failed to schedule DTS in SQL 2005

Hello,

I am trying to to schedule DTS Package but this message appear .

Message
The job failed. The Job was invoked by User sa. The last step to run was step 1 (1). and this

Message
Executed as user: Computer name\SYSTEM. The package execution failed. The step failed

so how I can schedule DTS Package in sql 2005 .

Do you have logging enabled for this package? if enabled check the log file it should have more detailed information on the error.

The error you have posted is a very generic error from the job agent, and it does not give any information.

Thanks

|||

Sounds like you might have some issues with the account settings. See the following thread for tips on setting up proxies / credentials / jobs etc.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1955723&SiteID=1

|||

Thanks, all

But still the same problem even I did all thing to solve but still can't schedule DTS, but when I see th proparites of the

SQL Server Agent-->Connection and found the sql server connection grayed out and can't select or change it . so may be this is the problem but how to run the agent under sa account .

|||

Assuming you are talking about the connection infromation on the left hand side of the job properties screen, that connection information is how you are currently connected to the sql server. You would need to look at the steps tab and click edit on the step associated with the package you are trying to run. At the top of this screen there will be a place for the step name (i.e. run package x), the type (sql server integration services package) and the run as. You would select the correct proxy name from the run as drop down that ties to your sa account...

|||

Thanks very much for you reply but I still can't schedule the DTS even though when I execute the dts it's work fine and I did all thing what said here http://www.codeproject.com/useritems/Schedule__Run__SSIS__DTS.asp

|||

I am trying to schedule working DTS in sql server 2005 sp 2 . but I it failed and got this message . I searched at Internet and found this

http://support.microsoft.com/kb/904796

but I can’t understand how to solve it, any one can help please .

Message

Executed as user: ComputrName\Administrator. ...00.3042.00 for 32-bitCopyright (C) Microsoft Corp 1984-2005. All rights reserved.Started:10:16:11 ?Error: 2007-08-17 22:16:12.95Code: 0x00000000Source: Copy Data from ROOM toDBNamedboER_ROOMTaskDescription: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.at DTS.PackageClass.Execute()at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()End ErrorError: 2007-08-17 22:16:14.75Code: 0x00000000Description: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user.at DTS.PackageClass.Execute()at Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()End ErrorError: 2007-08-17 22:16:15.14Code: 0x00000000The package execution fa...The step failed.

|||

how to Reinstall the SQL Server 2000 tools? where to find it .

Still no solution can solve this issue .

sql

Failed to reserve contiguous memory

Guys,
does anyone know what to do when you get this kind of
error message: My server is windows 2000 sp4, sql2000
sp3a, Here is the min and max memory configuration in
sp_config
min memory per query (KB) 512 2147483647
min server memory (MB) 0 2147483647
WARNING: Failed to reserve contiguous memory of Size= 65536.
Buffer Distribution: Stolen=4294948690 Free=412
Procedures=142775
Inram=0 Dirty=1232 Kept=0
I/O=0, Latched=41, Other=105186
Does anyone know what needs to be done. It happened
yester at 4pm and hasn't happened again. Let me know
please. Thanks.
Mary LouChances are it is related to one of these:
http://support.microsoft.com/default.aspx?scid=kb;en-us;832674&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;818095&Product=sql2k
http://support.microsoft.com/default.aspx?scid=kb;en-us;316749&Product=sql2k
Andrew J. Kelly SQL MVP
"Mary Lou" <anonymous@.discussions.microsoft.com> wrote in message
news:197a01c4a25a$62bf7f50$a301280a@.phx.gbl...
> Guys,
> does anyone know what to do when you get this kind of
> error message: My server is windows 2000 sp4, sql2000
> sp3a, Here is the min and max memory configuration in
> sp_config
> min memory per query (KB) 512 2147483647
> min server memory (MB) 0 2147483647
>
> WARNING: Failed to reserve contiguous memory of Size=> 65536.
> Buffer Distribution: Stolen=4294948690 Free=412
> Procedures=142775
> Inram=0 Dirty=1232 Kept=0
> I/O=0, Latched=41, Other=105186
>
> Does anyone know what needs to be done. It happened
> yester at 4pm and hasn't happened again. Let me know
> please. Thanks.
> Mary Lou

Failed to reserve contiguous memory

Guys,
does anyone know what to do when you get this kind of
error message: My server is windows 2000 sp4, sql2000
sp3a, Here is the min and max memory configuration in
sp_config
min memory per query (KB)5122147483647
min server memory (MB)02147483647
WARNING: Failed to reserve contiguous memory of Size=
65536.
Buffer Distribution: Stolen=4294948690 Free=412
Procedures=142775
Inram=0 Dirty=1232 Kept=0
I/O=0, Latched=41, Other=105186
Does anyone know what needs to be done. It happened
yester at 4pm and hasn't happened again. Let me know
please. Thanks.
Mary Lou
Chances are it is related to one of these:
http://support.microsoft.com/default...&Product=sql2k
http://support.microsoft.com/default...&Product=sql2k
http://support.microsoft.com/default...&Product=sql2k
Andrew J. Kelly SQL MVP
"Mary Lou" <anonymous@.discussions.microsoft.com> wrote in message
news:197a01c4a25a$62bf7f50$a301280a@.phx.gbl...
> Guys,
> does anyone know what to do when you get this kind of
> error message: My server is windows 2000 sp4, sql2000
> sp3a, Here is the min and max memory configuration in
> sp_config
> min memory per query (KB) 512 2147483647
> min server memory (MB) 0 2147483647
>
> WARNING: Failed to reserve contiguous memory of Size=
> 65536.
> Buffer Distribution: Stolen=4294948690 Free=412
> Procedures=142775
> Inram=0 Dirty=1232 Kept=0
> I/O=0, Latched=41, Other=105186
>
> Does anyone know what needs to be done. It happened
> yester at 4pm and hasn't happened again. Let me know
> please. Thanks.
> Mary Lou

Failed to open connection dialog

when i want to open sql it show me error message and when i try again with ctrl+n it works but not complite! i have both .NET2003 and 2005 in my computer under mssql2005 windows2003EP

Failed to open connection dialog.

ADDITIONAL INFORMATION:

Could not load file or assembly 'SqlMgmt, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A) (mscorlib)

Strong name validation failed. (Exception from HRESULT: 0x8013141A)

BUTTONS:

OK

It seems like one of the assemblies is either missing or corrupted. I am moving this thread to the setup and upgrade forum, hopefully there somebody will be able to guide in how to reinstall the proper components.

Thanks,

-Raul Garcia

SDE/T

SQL Server Engine

Failed to load msxmlsql.dll

Hi All,
I get the following error message when trying to run the following SQL
script in SQL Server 2000 SP 4.
SQL Script:
--
DECLARE @.hdoc int
DECLARE @.doc varchar(1000)
SET @.doc ='
<ROOT>
<Customer CustomerID="VINET" ContactName="Paul Henriot">
<Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
<OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
<OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
</Order>
</Customer>
<Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
<Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00">
<OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
</Order>
</Customer>
</ROOT>'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
-- Remove the internal representation.
exec sp_xml_removedocument @.hdoc
Error Message:
--
Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line
18
Failed to load msxmlsql.dll.
Does anybody know this error message?
Thanks,
RonenRonen,
I have a couple of questions.
1) When you performed the upgrade from SP3, did you get any errors?
2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
Server\80\Shared directory (replace X with whatever drive you installed Sql
Server on)?
Regards,
Galex
"Ronen" wrote:

> Hi All,
> I get the following error message when trying to run the following SQL
> script in SQL Server 2000 SP 4.
> SQL Script:
> --
> DECLARE @.hdoc int
> DECLARE @.doc varchar(1000)
> SET @.doc ='
> <ROOT>
> <Customer CustomerID="VINET" ContactName="Paul Henriot">
> <Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00
">
> <OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
> <OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
> </Order>
> </Customer>
> <Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
> <Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00
">
> <OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
> </Order>
> </Customer>
> </ROOT>'
> --Create an internal representation of the XML document.
> EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
> -- Remove the internal representation.
> exec sp_xml_removedocument @.hdoc
> Error Message:
> --
> Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Lin
e
> 18
> Failed to load msxmlsql.dll.
> Does anybody know this error message?
> Thanks,
> Ronen
>
>|||Hi Ronen, is this still a problem?
Thanks
Michael
"Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
> Ronen,
> I have a couple of questions.
> 1) When you performed the upgrade from SP3, did you get any errors?
> 2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
> Server\80\Shared directory (replace X with whatever drive you installed
> Sql
> Server on)?
> Regards,
> Galex
> "Ronen" wrote:
>|||I run the SQL script on a Virtual PC that's already installed with Microsoft
CRM 3.0 and SQL Server 2000 SP 4. I got the VPC image from Microsoft.
I find the file msxmlsql.dll exists in C:\Program Files\Microsoft SQL
Server\80\Shared directory with file version 1.0.1045.0.
Thanks.
Best regards,
Ronen
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uYhiD3QAGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi Ronen, is this still a problem?
> Thanks
> Michael
> "Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
> news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
>sql

Failed to load msxmlsql.dll

Hi All,
I get the following error message when trying to run the following SQL
script in SQL Server 2000 SP 4.
SQL Script:
DECLARE @.hdoc int
DECLARE @.doc varchar(1000)
SET @.doc ='
<ROOT>
<Customer CustomerID="VINET" ContactName="Paul Henriot">
<Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
<OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
<OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
</Order>
</Customer>
<Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
<Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00">
<OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
</Order>
</Customer>
</ROOT>'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
-- Remove the internal representation.
exec sp_xml_removedocument @.hdoc
Error Message:
Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line
18
Failed to load msxmlsql.dll.
Does anybody know this error message?
Thanks,
Ronen
Ronen,
I have a couple of questions.
1) When you performed the upgrade from SP3, did you get any errors?
2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
Server\80\Shared directory (replace X with whatever drive you installed Sql
Server on)?
Regards,
Galex
"Ronen" wrote:

> Hi All,
> I get the following error message when trying to run the following SQL
> script in SQL Server 2000 SP 4.
> SQL Script:
> --
> DECLARE @.hdoc int
> DECLARE @.doc varchar(1000)
> SET @.doc ='
> <ROOT>
> <Customer CustomerID="VINET" ContactName="Paul Henriot">
> <Order CustomerID="VINET" EmployeeID="5" OrderDate="1996-07-04T00:00:00">
> <OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
> <OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
> </Order>
> </Customer>
> <Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
> <Order CustomerID="LILAS" EmployeeID="3" OrderDate="1996-08-16T00:00:00">
> <OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
> </Order>
> </Customer>
> </ROOT>'
> --Create an internal representation of the XML document.
> EXEC sp_xml_preparedocument @.hdoc OUTPUT, @.doc
> -- Remove the internal representation.
> exec sp_xml_removedocument @.hdoc
> Error Message:
> --
> Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line
> 18
> Failed to load msxmlsql.dll.
> Does anybody know this error message?
> Thanks,
> Ronen
>
>
|||Hi Ronen, is this still a problem?
Thanks
Michael
"Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...[vbcol=seagreen]
> Ronen,
> I have a couple of questions.
> 1) When you performed the upgrade from SP3, did you get any errors?
> 2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
> Server\80\Shared directory (replace X with whatever drive you installed
> Sql
> Server on)?
> Regards,
> Galex
> "Ronen" wrote:
|||I run the SQL script on a Virtual PC that's already installed with Microsoft
CRM 3.0 and SQL Server 2000 SP 4. I got the VPC image from Microsoft.
I find the file msxmlsql.dll exists in C:\Program Files\Microsoft SQL
Server\80\Shared directory with file version 1.0.1045.0.
Thanks.
Best regards,
Ronen
"Michael Rys [MSFT]" <mrys@.online.microsoft.com> wrote in message
news:uYhiD3QAGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi Ronen, is this still a problem?
> Thanks
> Michael
> "Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
> news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
>

Failed to generate SQL script

Hi, there,
I received the following message while trying to generate a sql script on
a table:
[SQL-DMO] CreateFile error on ServerName.DbName.DP1
How to fix this problem? Thanks.
Hi
Searching Google for this gives quite a few hits
http://tinyurl.com/a8xsx
And this one looks promissing:
http://tinyurl.com/d5mcq
John
"Kathy" wrote:

> Hi, there,
> I received the following message while trying to generate a sql script on
> a table:
> [SQL-DMO] CreateFile error on ServerName.DbName.DP1
> How to fix this problem? Thanks.
|||John, thank you very much for providing the information. It's very helpful
for me to further diagose the issue.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Searching Google for this gives quite a few hits
> http://tinyurl.com/a8xsx
> And this one looks promissing:
> http://tinyurl.com/d5mcq
> John
> "Kathy" wrote:
sql

Failed to generate SQL script

Hi, there,
I received the following message while trying to generate a sql script on
a table:
[SQL-DMO] CreateFile error on ServerName.DbName.DP1
How to fix this problem? Thanks.Hi
Searching Google for this gives quite a few hits
http://tinyurl.com/a8xsx
And this one looks promissing:
http://tinyurl.com/d5mcq
John
"Kathy" wrote:
> Hi, there,
> I received the following message while trying to generate a sql script on
> a table:
> [SQL-DMO] CreateFile error on ServerName.DbName.DP1
> How to fix this problem? Thanks.|||John, thank you very much for providing the information. It's very helpful
for me to further diagose the issue.
"John Bell" wrote:
> Hi
> Searching Google for this gives quite a few hits
> http://tinyurl.com/a8xsx
> And this one looks promissing:
> http://tinyurl.com/d5mcq
> John
> "Kathy" wrote:
> > Hi, there,
> > I received the following message while trying to generate a sql script on
> > a table:
> > [SQL-DMO] CreateFile error on ServerName.DbName.DP1
> >
> > How to fix this problem? Thanks.

Failed to generate SQL script

Hi, there,
I received the following message while trying to generate a sql script on
a table:
[SQL-DMO] CreateFile error on ServerName.DbName.DP1
How to fix this problem? Thanks.Hi
Searching Google for this gives quite a few hits
http://tinyurl.com/a8xsx
And this one looks promissing:
http://tinyurl.com/d5mcq
John
"Kathy" wrote:

> Hi, there,
> I received the following message while trying to generate a sql script o
n
> a table:
> [SQL-DMO] CreateFile error on ServerName.DbName.DP1
> How to fix this problem? Thanks.|||John, thank you very much for providing the information. It's very helpful
for me to further diagose the issue.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Searching Google for this gives quite a few hits
> http://tinyurl.com/a8xsx
> And this one looks promissing:
> http://tinyurl.com/d5mcq
> John
> "Kathy" wrote:
>

Failed to generate a user instance SQL Server Express 2005

Hello,

I get the following message after updating to sql server express 2005 advanced.

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

I noticed that in my C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Template Data I have not databases? How do I get them back?

I also had to add back the aspnet to the permissions and the network and network service to the app_data folder.

Can any one help?

Thanks

Tom

Moving this thread over to the SQL Express forum.

-- Robert

|||

With User Instances the database files are not created in the old data directories, they are normally installed in the main project output directories for the project. In ASP.Net this is normally the ASP_Data directory. When the application starts it will automaticle attach the database to the database engine and set the permissions.

With your problem have you tried a complete rebuild of the application, Did it work befor you upgraded to Express Advanced. Also you might want to try opening up the file and attaching it to the database engine using the management studio just to make sure it is working fine, you can then detach it and try the application again.

|||

Hi Tom,

Did you ever resolve this issue?

You definitely need the databases located in Template Data in order for User Instances to work. If you didn't get this resolved, I would suggest trying to re-run the install. Usually the only reason an installation results in those files going missing is that some SQL process was running at the time of the installation.

If you haven't tried it yet. I'd also recomend moving to SQL SP1 which you can download from http://msdn.microsoft.com/vstudio/express/sql/download/.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B

When and why does this error message appear..

Error 1 Error loading MasterPackage.dtsx: Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

are you using package configurations? if so , how are they being stored (db, XML file ect.)

what is your ProtectionLevel set to on your package properties?

how is the package being run? (debug, SqlAgent, execcute w/o debug , command line ect.)

|||

I have a master package which is calling other packages...I just opened to set some package configuration but did not set and then it's coming out with this message when i try to open my master package but is running fine even if comes out with this message...

|||

what is the ProtectionLevel property set to on the children and parent? Right click properties -> ProtectionLevel)

it appears that when you are opening the package it cannot decrypt the sensitive information.

This often occurs when developing on one box and promoting to another.

|||

my protection leve is set to EncryptSensitiveWithUserKey on both parent and child.

|||As Ryan wrote, this error may occur when moving from one box to another - this protection level uses Windows Data Protection API (DPAPI), which automatically encrypts secrets with user key, but is limited in that it obviously allows only original user to decrypt secrets, and (less known) it only works on original computer only, unless you are using Roadmin Profile.

If you need to move packages to other computers, or execute them under different user account - use other protection levels. See Books Online for details.

Failed to create user login

This is the error message i keep getting when following the SQL Server tutorial on how to make a new user;

TITLE: Microsoft SQL Server Management Studio Express

Create failed for Login 'employee'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

The MUST_CHANGE option is not supported by this version of Microsoft Windows. (Microsoft SQL Server, Error: 15195)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=15195&LinkId=20476

BUTTONS:

OK

Why is that? Im running XP, do i need to be on 2000 Server or something?

This enhanced option is only available when SQL Server is installed on a Windows 2003 Server system.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||i dont understand|||

OK, let me explain it to you. Prior SQL Server 2005, there have been no ways to control the password complexity or behaviour in SQL Server, which means that you could use a password like "aaa" or 123" or just a blank one. The options that are known from the Windows Domain like "Enforce password complexity" which only lets you create a password which is complex enough (containing enough characters / numbers / special characters) didn′t exists. Also the option "User must change password upon first connection" didn′t exists. With SQL Server 2005 these options have become available also for SQL Server passwords / users, but... you need to have Windows 2003 to enforce those rules as they are controlled by a group policy of Windows 2003. Any machine prior to WIndows 2003 won′t know the rules, therefore SQL Server thros an error, stating that these options are not available on the current platform SQL Server is installed on.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||

If you really need to create this user of just a matter of study, what you could do is to select the SQL Server authentication and uncheck the "Enforce password policy". This way you will not get the error message, but remember that this is not a correct way to go.

Igor Pacheco

Failed to create user login

This is the error message i keep getting when following the SQL Server tutorial on how to make a new user;

TITLE: Microsoft SQL Server Management Studio Express

Create failed for Login 'employee'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

The MUST_CHANGE option is not supported by this version of Microsoft Windows. (Microsoft SQL Server, Error: 15195)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=15195&LinkId=20476

BUTTONS:

OK

Why is that? Im running XP, do i need to be on 2000 Server or something?

This enhanced option is only available when SQL Server is installed on a Windows 2003 Server system.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||i dont understand|||

OK, let me explain it to you. Prior SQL Server 2005, there have been no ways to control the password complexity or behaviour in SQL Server, which means that you could use a password like "aaa" or 123" or just a blank one. The options that are known from the Windows Domain like "Enforce password complexity" which only lets you create a password which is complex enough (containing enough characters / numbers / special characters) didn′t exists. Also the option "User must change password upon first connection" didn′t exists. With SQL Server 2005 these options have become available also for SQL Server passwords / users, but... you need to have Windows 2003 to enforce those rules as they are controlled by a group policy of Windows 2003. Any machine prior to WIndows 2003 won′t know the rules, therefore SQL Server thros an error, stating that these options are not available on the current platform SQL Server is installed on.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||

If you really need to create this user of just a matter of study, what you could do is to select the SQL Server authentication and uncheck the "Enforce password policy". This way you will not get the error message, but remember that this is not a correct way to go.

Igor Pacheco

sql

Failed to create Database

I am trying to create a blank/sample database on Dynamics POS with SQl Server Express. And a error message is read:

Error to create blank/sample database

Error details: failed to create windows users/groups or add the sql loggins

Do you have any idea why is this error message happening, or what can I do to fix it?

What OS did you use to install the point of sale system? And did your Express comes with Management Studio?|||

The operating system I use is Windows XP sp2

No , the Express came only with the server configuration Manager, the server error and usage reporting and the server surface area configuration.

|||OS(operating system), Tell the person Suface area configuration and configuration Manager without Management Studio is too limiting because I have talked to another Dynamics user with Express with everything. The reason is in Management Studio you can right click and create a database, if you make a mistake delete it and start new one. Hope this helps.|||

Thanks, but it didn′t work.

I installed it, and you′re right is easir to manage, even though the database I created appears at the Management studio, the POS keeps on telling failed to create XXX Database, ande Error details described before.

|||if there is no other error description in the installed of the POS application you will either have to use a SQL profiler (If you have another version of SQL Server that comes with SQL Profiler) or contact the vendor of the POS installation to investigate the problem or tell you where to find more detailed information about the error message (They may trace some error information to a trace source like a file)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

There are steps you are missing in Dynamics, I have found a thread you can post on at the Dynamics forums. It is not a SQL Server issue but Dynamics configuration issue because POS needs to be added to the new database you have created.

http://www.microsoftdynamicsforums.com/forums/forum_posts.asp?TID=1245

sql

Failed to connect to sql server problem - a strange one!

Full Error message is:

Failed to connect to server DDI-DP9IM5A5F5W. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

When I consult the error log I see:

Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
2007-01-30 04:53:14.93 Logon Error: 17809, Severity: 20, State: 3.

_

The log error message doesn't make any sense because there aren't 4 user connections.

After I received the error message, mgmt studio still lets me access the database make changes, but I cannot connect via my application. Any ideas? Thanks!

Hi,

are you using connection pooling ? Seems that your application does not release the connection after using them. You should consider your code regarding this. If you are not sure who is connected to your computer you should consider querying the procedure sp_who.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||It's a windows application that is connecting to this database and I'm not using connection pooling. Although I can get into the database and look around, I cannot query it. So, I can't run sp_who. Any other suggestions? Thanks for the reponse|||Lots similar issues are posted on the blog (http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx). Can you take a look at sql trace files and monitor SQL Server error logs? They might also help you to find the clues.|||

SSMS usually open two connection to the db. You can query your db using SSMS to see the connection state, by "select * from sys.dm_exec_connections".

|||I'll give her a try....|||When I searched with Google, I found the blog to which you refer. I wasn't able to figure anything out, but I may give it another shot. Thanks for the info.|||

i had same trouble, in my case this link gave solution. it is about certificates.

http://support.microsoft.com/default.aspx/kb/309398/

i hope this answer for you.

Failed to connect to sql server problem - a strange one!

Full Error message is:

Failed to connect to server DDI-DP9IM5A5F5W. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

When I consult the error log I see:

Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
2007-01-30 04:53:14.93 Logon Error: 17809, Severity: 20, State: 3.

_

The log error message doesn't make any sense because there aren't 4 user connections.

After I received the error message, mgmt studio still lets me access the database make changes, but I cannot connect via my application. Any ideas? Thanks!

Hi,

are you using connection pooling ? Seems that your application does not release the connection after using them. You should consider your code regarding this. If you are not sure who is connected to your computer you should consider querying the procedure sp_who.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||It's a windows application that is connecting to this database and I'm not using connection pooling. Although I can get into the database and look around, I cannot query it. So, I can't run sp_who. Any other suggestions? Thanks for the reponse
|||Lots similar issues are posted on the blog (http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx). Can you take a look at sql trace files and monitor SQL Server error logs? They might also help you to find the clues.|||

SSMS usually open two connection to the db. You can query your db using SSMS to see the connection state, by "select * from sys.dm_exec_connections".

|||I'll give her a try....
|||When I searched with Google, I found the blog to which you refer. I wasn't able to figure anything out, but I may give it another shot. Thanks for the info.
|||

i had same trouble, in my case this link gave solution. it is about certificates.

http://support.microsoft.com/default.aspx/kb/309398/

i hope this answer for you.

sql

Failed to call SSIS package from ASPX C# Web Page

Hi, Everyone:

I am getting the following error message when I try to execute a SSIS package from an asp.net page written in C# 2.0. What I am trying to do is basically just click on a button in the web page and it will execute the package. The code to execute the package is pretty simple. I pass the path of the DTS package stored in the local folder. This works fine in the machine where SQL2005 is installed locally. But it fail when I have a seperate Web Server and SQL Server. Any ideas? Do I have to install SSIS or SQL2005 on a web server as well?

Thanks

static public string Execute_SSIS_DTS(string DTS_Path)

{

Microsoft.SqlServer.Dts.Runtime.Application app;

app = new Microsoft.SqlServer.Dts.Runtime.Application();

Package package = app.LoadPackage(DTS_Path, null);

DTSExecResult result = package.Execute();

return result.ToString();

}

Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.

Line 226: static public string Execute_SSIS_DTS(string DTS_Path)

Line 227: {

Line 228: Application app = new Application();

Line 229: Package package = app.LoadPackage(DTS_Path, null);

Line 230: DTSExecResult result = package.Execute();

[COMException (0x80040154): Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.]
Microsoft.SqlServer.Dts.Runtime.Application..ctor() +43

[DtsPipelineException: Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154.]
Microsoft.SqlServer.Dts.Runtime.Application..ctor() +169
Utilities.Execute_SSIS_DTS(String DTS_Path) in c:\Inetpub\wwwroot\MasterTables\App_Code\Utilities.cs:228
MasterTables_Admin_MasterTables_LOINC_External.btn_SyncLISTest_Click(Object sender, EventArgs e) in c:\Inetpub\wwwroot\MasterTables\MasterTables_Custom\MasterTablesCustom_LOINC_External.aspx.cs:98
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +141
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +32
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3215

Yes, to use SSIS object model and to execute package you do need to install SSIS on this machine, of course.

See my blog entry for some more details
http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx

Failed to access IIS metabase?

Please help!

All of sudden, I cannot connect to the reporting services through MS SQL Server management studio. error message is "Failed to access IIS metabase".

As I checked the system:

1. reporting services is working properly (status is "started")

2. cannot access http://localhost/ReportServer$SQL2005 , the same error

3. Run:"C:\>cscript metaacl.vbs IIS://localhost/w3svc", it shows:
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

XP\ASPNET
Access: R E
BUILTIN\Administrators
Access: RWSUED
Everyone
Access: E
XP\VS Developers
Access: RWSUE
XP\ASPNET
Access: R
XP\ASPNET
Access: R

I reinstall IIS and it doesn't work. Please help, thank you so much!

Are you able to access http://localhost/reportserver from IE? Are you able to access any web pages from IE?|||

Thank you for your reply.

The first answer is no, I cannot access http://localhost/reportserver from IE(The instance of SQL server 2005 is "SQL2005".)

The second answer is yes, I can access IIS' default web page and the other web pages.

|||Anybody can help, please?|||

I think you need to figure out what are the required ACLs. Maybe you can start by giving everybody full access. If that works start reducing the permissions.

BTW, I thought the error message would give you more details about what ACLs are missing, but I could be wrong.

|||One more thing, if you uninstalled IIS, you may run into some problem when you try to uninstall RS later on: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=735b5260-f6bf-4ea5-94b2-6c41ae387a9a

Failed Login SQL Express

Everything works fine with the website I've created except i get a Login failed message every now and then

Failed Login is: NT AUTHORITY\NETWORK SERVICE

Is this to do with the maximum number of connections to the database?

how can i stop this from happening?

AusClans:

Is this to do with the maximum number of connections to the database?

Maybe, but probably not. That would be a different error message. What is the full exception message you get?

Don