Showing posts with label page. Show all posts
Showing posts with label page. Show all posts

Friday, March 30, 2012

Microsoft SQL Server 2005 Integration Services book by Kirk Haselden

Hello, I would love to know where people are discussing the book Microsoft SQL Server 2005 Integration Services book by Kirk Hasleden.

I'm on page 41 and I'm getting an error with the example in the "SELECT "2004" FROM Sales.vSalesPersonSalesByFiscalYears"
part because there is not a table called Sales.vSalesPersonSalesByFiscalYears in the AdventureWorks database.

Thank youoThat view exists in mine.|||Ok thanks - I didn't realize it was a view. Got it working...

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Windows Update Web Page indicates I have BOTH a
SUCCESS and FAILURE for
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
?Is it possible for my machine to have TWO DIFFERENT MS SQL Server Express installations? Is the problem real or some small ghost issue?
I do have a trial CD from Microsoft .. Visual Studio 2005 Team Suite.

Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.

SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update


LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources

I include the logfile since it seems to convey useful informations to SQL Express experienced.

summary.txt logfile
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Time: 03/13/2007 12:28:02.906
KB Number: KB921896
Machine: somejunk
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU SP2 2005.090.3042.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 0
Error Description :
-
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
Success
Exit Code Returned: 0

did you get the resolved? I'm haveing the same issue.

Sean

|||Me too. It continually tries to install although AFAIK it IS installed.
|||

No I did not get this resolved.

I suppose this creates uncertainty for me and perhaps others.

Please excuse my late reply.

|||

This has failed to install twice already this morning, and I've got a third Automatic Update message, which will probably be the same MS SQL Server trying and failing to install. This has been going on for at least a month--though not with multiple attempts in a day.

I wish I knew whether this was simply noise or whether it's something I should focus on, but characteristically, it's hidden behind opaque names and failure messages. I often feel like I don't own the computer I paid for; I'm simply maintaining it for MS.

|||I am having this same issue also - continuously tries to update but says it can't - any help out there?

jn|||

I'm having the same problem,

Has anybody been able to resolve this, its anoying the heck out of me?

Abe

|||Are you running ACT! on your computer? I am and it took an ACT! technician to get it resolved. It only took a full week of effort. LOL Yes I am serious a full week! One of the things you might try is uninstalling the SQL Server 2005 and then letting automatic update reinstall it. jn|||I uninstalled SQL Server 2005, reinstalled it and I am still having this problem. This is bad.|||

I got the same problem but got it resolved.
Apparently some of the ms sql server services (NOT any Express service) like SQL server active directory helper, and the sql server browser were disabled on my machine. I put them on an "Automatic" startup type and the update worked fine.

I hope it will help any of you.

Pieter

|||My automatic update of Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) keeps failing and I do not even use SQL Server. How do I get rid of this nuisance?|||Following the advice of the previous posts I simply set the sql server express and sql browser services to manual start up and started the services (previously there were disabled and not running). Then I installed the service pack and it worked. Thankx for the advice.
|||

What version of ACT! are you running. I just installed ACT! 2007 and now have this issue. During the install, it corrupted .Net Framework 2.0 and SQL Server. Now all the other apps like QuickBooks, and OneCare Live don't operate the same.


Thanks,

JN2

|||

I am also running Act!2007(9) - I started having problems when auotmatic update tried to install the upgrade to version 9.0.1.162. The best thing for you to do is call Act and tell them you are having an installation problem. They'll give you free support for installation issues. That's what I did and they finally corrected the issue by having a technician take over my computer remotely. They had to make a lot of changes to the system files and then manually unistall ACT to get it worked out. Then I had to download the trial version of Act from their website - which is always the most current version - and re register it. It was VERY time consuming. Act techies worked on it for over 4 hours on 3 different occasions! Hopefully for you they have this figured out. Good luck.

jn

|||

I feel your pain. I was on the phone with them (ACT Support) yesterday for 3hours 50minutes for the install. They crashed and deleted my .NET Framework, killed my security damaged QuickBooks (somehow) and then told me to call the other vendors to restore my data. I don't know why I put myself through so much pain with Sage.

Thanks for the reply on SQL Exp SP2. Today I have not received the update error warnings. But the day is young. Once I get a solution, I'll post it.

JN2

sql

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Windows Update Web Page indicates I have BOTH a
SUCCESS and FAILURE for
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
?Is it possible for my machine to have TWO DIFFERENT MS SQL Server Express installations? Is the problem real or some small ghost issue?
I do have a trial CD from Microsoft .. Visual Studio 2005 Team Suite.

Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.

SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update


LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources

I include the logfile since it seems to convey useful informations to SQL Express experienced.

summary.txt logfile
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Time: 03/13/2007 12:28:02.906
KB Number: KB921896
Machine: somejunk
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU SP2 2005.090.3042.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 0
Error Description :
-
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
Success
Exit Code Returned: 0

did you get the resolved? I'm haveing the same issue.

Sean

|||Me too. It continually tries to install although AFAIK it IS installed.
|||

No I did not get this resolved.

I suppose this creates uncertainty for me and perhaps others.

Please excuse my late reply.

|||

This has failed to install twice already this morning, and I've got a third Automatic Update message, which will probably be the same MS SQL Server trying and failing to install. This has been going on for at least a month--though not with multiple attempts in a day.

I wish I knew whether this was simply noise or whether it's something I should focus on, but characteristically, it's hidden behind opaque names and failure messages. I often feel like I don't own the computer I paid for; I'm simply maintaining it for MS.

|||I am having this same issue also - continuously tries to update but says it can't - any help out there?

jn|||

I'm having the same problem,

Has anybody been able to resolve this, its anoying the heck out of me?

Abe

|||Are you running ACT! on your computer? I am and it took an ACT! technician to get it resolved. It only took a full week of effort. LOL Yes I am serious a full week! One of the things you might try is uninstalling the SQL Server 2005 and then letting automatic update reinstall it. jn|||I uninstalled SQL Server 2005, reinstalled it and I am still having this problem. This is bad.|||

I got the same problem but got it resolved.
Apparently some of the ms sql server services (NOT any Express service) like SQL server active directory helper, and the sql server browser were disabled on my machine. I put them on an "Automatic" startup type and the update worked fine.

I hope it will help any of you.

Pieter

|||My automatic update of Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) keeps failing and I do not even use SQL Server. How do I get rid of this nuisance?|||Following the advice of the previous posts I simply set the sql server express and sql browser services to manual start up and started the services (previously there were disabled and not running). Then I installed the service pack and it worked. Thankx for the advice.
|||

What version of ACT! are you running. I just installed ACT! 2007 and now have this issue. During the install, it corrupted .Net Framework 2.0 and SQL Server. Now all the other apps like QuickBooks, and OneCare Live don't operate the same.


Thanks,

JN2

|||

I am also running Act!2007(9) - I started having problems when auotmatic update tried to install the upgrade to version 9.0.1.162. The best thing for you to do is call Act and tell them you are having an installation problem. They'll give you free support for installation issues. That's what I did and they finally corrected the issue by having a technician take over my computer remotely. They had to make a lot of changes to the system files and then manually unistall ACT to get it worked out. Then I had to download the trial version of Act from their website - which is always the most current version - and re register it. It was VERY time consuming. Act techies worked on it for over 4 hours on 3 different occasions! Hopefully for you they have this figured out. Good luck.

jn

|||

I feel your pain. I was on the phone with them (ACT Support) yesterday for 3hours 50minutes for the install. They crashed and deleted my .NET Framework, killed my security damaged QuickBooks (somehow) and then told me to call the other vendors to restore my data. I don't know why I put myself through so much pain with Sage.

Thanks for the reply on SQL Exp SP2. Today I have not received the update error warnings. But the day is young. Once I get a solution, I'll post it.

JN2

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Windows Update Web Page indicates I have BOTH a
SUCCESS and FAILURE for
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
?Is it possible for my machine to have TWO DIFFERENT MS SQL Server Express installations? Is the problem real or some small ghost issue?
I do have a trial CD from Microsoft .. Visual Studio 2005 Team Suite.

Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.

SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update


LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources

I include the logfile since it seems to convey useful informations to SQL Express experienced.

summary.txt logfile
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Time: 03/13/2007 12:28:02.906
KB Number: KB921896
Machine: somejunk
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU SP2 2005.090.3042.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 0
Error Description :
-
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
Success
Exit Code Returned: 0

did you get the resolved? I'm haveing the same issue.

Sean

|||Me too. It continually tries to install although AFAIK it IS installed.|||

No I did not get this resolved.

I suppose this creates uncertainty for me and perhaps others.

Please excuse my late reply.

|||

This has failed to install twice already this morning, and I've got a third Automatic Update message, which will probably be the same MS SQL Server trying and failing to install. This has been going on for at least a month--though not with multiple attempts in a day.

I wish I knew whether this was simply noise or whether it's something I should focus on, but characteristically, it's hidden behind opaque names and failure messages. I often feel like I don't own the computer I paid for; I'm simply maintaining it for MS.

|||I am having this same issue also - continuously tries to update but says it can't - any help out there?

jn|||

I'm having the same problem,

Has anybody been able to resolve this, its anoying the heck out of me?

Abe

|||Are you running ACT! on your computer? I am and it took an ACT! technician to get it resolved. It only took a full week of effort. LOL Yes I am serious a full week! One of the things you might try is uninstalling the SQL Server 2005 and then letting automatic update reinstall it. jn|||I uninstalled SQL Server 2005, reinstalled it and I am still having this problem. This is bad.|||

I got the same problem but got it resolved.
Apparently some of the ms sql server services (NOT any Express service) like SQL server active directory helper, and the sql server browser were disabled on my machine. I put them on an "Automatic" startup type and the update worked fine.

I hope it will help any of you.

Pieter

|||My automatic update of Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) keeps failing and I do not even use SQL Server. How do I get rid of this nuisance?|||Following the advice of the previous posts I simply set the sql server express and sql browser services to manual start up and started the services (previously there were disabled and not running). Then I installed the service pack and it worked. Thankx for the advice.|||

What version of ACT! are you running. I just installed ACT! 2007 and now have this issue. During the install, it corrupted .Net Framework 2.0 and SQL Server. Now all the other apps like QuickBooks, and OneCare Live don't operate the same.


Thanks,

JN2

|||

I am also running Act!2007(9) - I started having problems when auotmatic update tried to install the upgrade to version 9.0.1.162. The best thing for you to do is call Act and tell them you are having an installation problem. They'll give you free support for installation issues. That's what I did and they finally corrected the issue by having a technician take over my computer remotely. They had to make a lot of changes to the system files and then manually unistall ACT to get it worked out. Then I had to download the trial version of Act from their website - which is always the most current version - and re register it. It was VERY time consuming. Act techies worked on it for over 4 hours on 3 different occasions! Hopefully for you they have this figured out. Good luck.

jn

|||

I feel your pain. I was on the phone with them (ACT Support) yesterday for 3hours 50minutes for the install. They crashed and deleted my .NET Framework, killed my security damaged QuickBooks (somehow) and then told me to call the other vendors to restore my data. I don't know why I put myself through so much pain with Sage.

Thanks for the reply on SQL Exp SP2. Today I have not received the update error warnings. But the day is young. Once I get a solution, I'll post it.

JN2

Microsoft SQL Server 2005 Express Edition Service Pack 2 ..Failure

Windows Update Web Page indicates I have BOTH a
SUCCESS and FAILURE for
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)
?Is it possible for my machine to have TWO DIFFERENT MS SQL Server Express installations? Is the problem real or some small ghost issue?
I do have a trial CD from Microsoft .. Visual Studio 2005 Team Suite.

Please note that this is what windows update indicates on the web page
duplicate lines are on the web page .. not a copy and paste mistake.

SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update


LINK FOLLOWED
Installation Failure
Error Code: 0x652
Try to install the update again, or request help from one of the following resources

I include the logfile since it seems to convey useful informations to SQL Express experienced.

summary.txt logfile
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Time: 03/13/2007 12:28:02.906
KB Number: KB921896
Machine: somejunk
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU SP2 2005.090.3042.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 3042
Product Version (Final) :
Status : Not Selected
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 0
Error Description :
-
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
Success
Exit Code Returned: 0

did you get the resolved? I'm haveing the same issue.

Sean

|||Me too. It continually tries to install although AFAIK it IS installed.
|||

No I did not get this resolved.

I suppose this creates uncertainty for me and perhaps others.

Please excuse my late reply.

|||

This has failed to install twice already this morning, and I've got a third Automatic Update message, which will probably be the same MS SQL Server trying and failing to install. This has been going on for at least a month--though not with multiple attempts in a day.

I wish I knew whether this was simply noise or whether it's something I should focus on, but characteristically, it's hidden behind opaque names and failure messages. I often feel like I don't own the computer I paid for; I'm simply maintaining it for MS.

|||I am having this same issue also - continuously tries to update but says it can't - any help out there?

jn|||

I'm having the same problem,

Has anybody been able to resolve this, its anoying the heck out of me?

Abe

|||Are you running ACT! on your computer? I am and it took an ACT! technician to get it resolved. It only took a full week of effort. LOL Yes I am serious a full week! One of the things you might try is uninstalling the SQL Server 2005 and then letting automatic update reinstall it. jn|||I uninstalled SQL Server 2005, reinstalled it and I am still having this problem. This is bad.|||

I got the same problem but got it resolved.
Apparently some of the ms sql server services (NOT any Express service) like SQL server active directory helper, and the sql server browser were disabled on my machine. I put them on an "Automatic" startup type and the update worked fine.

I hope it will help any of you.

Pieter

|||My automatic update of Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) keeps failing and I do not even use SQL Server. How do I get rid of this nuisance?|||Following the advice of the previous posts I simply set the sql server express and sql browser services to manual start up and started the services (previously there were disabled and not running). Then I installed the service pack and it worked. Thankx for the advice.
|||

What version of ACT! are you running. I just installed ACT! 2007 and now have this issue. During the install, it corrupted .Net Framework 2.0 and SQL Server. Now all the other apps like QuickBooks, and OneCare Live don't operate the same.


Thanks,

JN2

|||

I am also running Act!2007(9) - I started having problems when auotmatic update tried to install the upgrade to version 9.0.1.162. The best thing for you to do is call Act and tell them you are having an installation problem. They'll give you free support for installation issues. That's what I did and they finally corrected the issue by having a technician take over my computer remotely. They had to make a lot of changes to the system files and then manually unistall ACT to get it worked out. Then I had to download the trial version of Act from their website - which is always the most current version - and re register it. It was VERY time consuming. Act techies worked on it for over 4 hours on 3 different occasions! Hopefully for you they have this figured out. Good luck.

jn

|||

I feel your pain. I was on the phone with them (ACT Support) yesterday for 3hours 50minutes for the install. They crashed and deleted my .NET Framework, killed my security damaged QuickBooks (somehow) and then told me to call the other vendors to restore my data. I don't know why I put myself through so much pain with Sage.

Thanks for the reply on SQL Exp SP2. Today I have not received the update error warnings. But the day is young. Once I get a solution, I'll post it.

JN2

Wednesday, March 28, 2012

microsoft sql database (*.mdf) using help ?

Hi

I use visual std. 2005 and I create a asp.net web page after >add item> sql database > I added my project *.mdf file when I make project my project is runnig with visual studio 2005 but I sent my hostting (internet server )I cant use this mdf file . Are we register this mdf file sqlserver ? can we use this mdf file like access file (mdb ) . What kind of thing I do to use this mdf file .

Thanks

I know some hosts don't support SQL 2005, FastHosts in the UK for exampe have no plans to allow the user of the SQL Express MDF files so it cannot work like an Access MDB file. They say that this is down to performance and security implications.|||

prokurs:

Are we register this mdf file sqlserver ? can we use this mdf file like access file (mdb ) . What kind of thing I do to use this mdf file .

No, you must have a SQL instance on the host to use mdf files. Although in VS2005 you can create mdf files and use them by attaching them to a SQL Express Instance (specified in the Data Source property in your connection string), you still need a SQL Instance to which you have access. So you must have a SQL2005/Express instance on the hosting machine, and then add proper permissions to your account.

|||

hi can you look my mistake this mistake's source ishttp://www.prokurs.com/e/loginana.aspx you can enter this page after write random user name and passwors after then I have got a this mistake please help ?

Server Error in '/' Application.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735091 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102



Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

|||

It is a connection failure, if you're using SQL2000 you need to make sure TCP/IP and Named Pipes network libraries are enabled on the SQL2000 instance via Server Network Utility; in case of SQL2005/Express you can enable the remote connecitons using SQL Server Surface Area. Then rewrite your connection string to point to the correct SQL instance.

If you're using built-in Login Controls (membership provider) in .NET 2.0, you can customize the database connections as mentioned in this article:

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

sql

Monday, March 12, 2012

MHTML Streaming

I am streaming an MHTML file to an aspx page:
Response.Clear()
Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht")
Response.AddHeader("Content-Length", MyByteArray.Length.ToString)
Response.ContentType = "multipart/related"
Response.BinaryWrite(MyByteArray)
Response.Flush()
When I load the aspx page on my computer with IE... I get "Invalid syntax
error"... when I load the same page... thru HTTP access from a co-worker's
computer... it loads fine... what am I doing wrong?
Not sure if it makes a difference... I had the address bar hidden so I didn't
notice at first... when my co-worker renders the stream the url stays the
same... for me I get mhtml: in front of the url... in addition to the
"invalid syntax" error.I figured I should post this in case other ppl were looking for some
answers... apparently my MHTML issue has something to do with a security
patch for IE... there is however a way to get around it...
You can attach a dummy query string to your aspx page that ends with a .mht.
For example, if the page that streams down mht content is MyPage.aspx, then
you want to use this URL:
http://Path-To-File/MyPage.aspx?ignored=whatever.mht
"MER78" wrote:
> I am streaming an MHTML file to an aspx page:
> Response.Clear()
> Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht")
> Response.AddHeader("Content-Length", MyByteArray.Length.ToString)
> Response.ContentType = "multipart/related"
> Response.BinaryWrite(MyByteArray)
> Response.Flush()
> When I load the aspx page on my computer with IE... I get "Invalid syntax
> error"... when I load the same page... thru HTTP access from a co-worker's
> computer... it loads fine... what am I doing wrong?
> Not sure if it makes a difference... I had the address bar hidden so I didn't
> notice at first... when my co-worker renders the stream the url stays the
> same... for me I get mhtml: in front of the url... in addition to the
> "invalid syntax" error.

Friday, March 9, 2012

Method not found: Void Microsoft.Reporting.WebForms.ReportViewer.Reset().

After using this Reset method on my asp RV control, now the page issues this error:

Exception Details:System.MissingMethodException: Method not found: 'Void Microsoft.Reporting.WebForms.ReportViewer.Reset()'.

I tried downloading ReportViewer.exe 2005 Redistr. from the MS site and installed at the server but still get same error.

Is there a newer redist somewhere that I haven't found? Or do I need to regasm some files?

Fixed it. Even after running the ReportViewer.exe 2005 Redistr. on the server machine, nothing changed. Looks like that Redist from MS is not up to date.

I ended up copying my local files(Common, WebForms) to the server then running gacutil -i on them. All better.

|||

I'm glad you posted a solution to this error. I'm having the exact same problem when I transfer my application to our Windows Server 2003 box. What local files exactly did you transfer? I searched for both "Common" and "WebForms" on my workstation but was unable to find them. Thanks!

Regards,
David Gardner

|||

These are the files you need to use Reset():

Microsoft.ReportViewer.Common.dll 8.0.50727.762

Microsoft.ReportViewer.WebForms.dll 8.0.50727.762

|||

Alright. I'm having the same problems.

I installed the Visual Studio 2k5 SP1 as well as the ReportingViewer.exe redist. and nothing seems to work

Everytime I try to call reportviewer.reset() in code, it gets a blue squiggly underneath it and says "reset is not a member of Microsoft.Reporting.WebForms.ReportViewer"

I have tried to remove the references to the Microsoft.Reporting dlls and adding them back in but nothing has worked.

Anything else I can try?

|||

I'm having the same problem.

How do I use the gacutil? Can someone please send me the syntax for it?

Basically on my development machine I have VS2005 SP1 installed. When i'm deploying my application onto the staging server, I keep getting the following error message:

method does not exist: 'Void Microsoft.Reporting.WebForms.ReportViewer.Reset()'

Someone please help!!!

|||

Eric,

Can you send me the syntax for the gacutil please?

I'm having the same issues as the others are having, where it works on my development machine but not on the staging server.

I'll appreciate it.

|||

Eric,

I am also facing the same problem. After installating report viewer redistributable service pack it got solved in local machine. But after uplaoding to server, an empty alert with no message is showing.

I have tried to copy local files i.e common & webform from c:\winnt\assembly, MMS but its not allowing. From where should i copy these files.

Thanks In Advance.

Regards,

Vijay Kumar

|||

A better solution is to install the ReportViewer 2005 Redistributable SP1:
Microsoft Report Viewer Redistributable 2005 SP1 (Upgrade)

If you haven't installed the original redistributable, you can do the full SP1 install:
Microsoft Report Viewer Redistributable 2005 SP1 (Full Installation)

Note: you'll need to install Windows Installer 3.1 on your server if you want to use the Upgrade patch.

Saturday, February 25, 2012

message: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (severity 14)

Hi Im getting the following error when trying to connect to a php page...any ideas

message: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (severity 14)

Hi,

seems that you tried to impersonate the WebUser at the SQL Server database. The question would be what you want to use, wheter Windows Authentication or SQL Authentication ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Message: Cannot use Large Page Extensions

Hello!
I have noticed following messaeg in SQL Server 2005 error log:'Cannot
use Large Page Extensions: lock memory privilege was not granted.' Server
is Active/Passive 64-bit SQL Server cluster with 28GB or RAM.
Can anyone explaing what this messaeg means?
Thanks,
Igor
Did you give the service account for the SQL Server service "Lock Pages in memory" user rights.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Hello!
> I have noticed following messaeg in SQL Server 2005 error log:'Cannot use Large Page
> Extensions: lock memory privilege was not granted.' Server is Active/Passive 64-bit SQL Server
> cluster with 28GB or RAM.
> Can anyone explaing what this messaeg means?
> Thanks,
> Igor
>
|||Tibor,
Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL
says: 'Though not required, Microsoft recommends locking pages in memory
when using 64-bit operating systems'. Will my SQL Server benefit from having
this option configured?
Thanks,
Igor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
> Did you give the service account for the SQL Server service "Lock Pages in
> memory" user rights.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
>
|||Slava Oks has several articles on memory management on his blog. As I recall, he recommends locking
pages on 64 bit as well. Check it out at http://blogs.msdn.com/slavao/
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:O0LuocIRGHA.4452@.TK2MSFTNGP12.phx.gbl...
> Tibor,
> Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL says: 'Though not
> required, Microsoft recommends locking pages in memory when using 64-bit operating systems'. Will
> my SQL Server benefit from having this option configured?
>
> Thanks,
> Igor
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
>

Message: Cannot use Large Page Extensions

Hello!
I have noticed following messaeg in SQL Server 2005 error log:'Cannot
use Large Page Extensions: lock memory privilege was not granted.' Server
is Active/Passive 64-bit SQL Server cluster with 28GB or RAM.
Can anyone explaing what this messaeg means?
Thanks,
IgorDid you give the service account for the SQL Server service "Lock Pages in m
emory" user rights.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Hello!
> I have noticed following messaeg in SQL Server 2005 error log:'Cannot u
se Large Page
> Extensions: lock memory privilege was not granted.' Server is Active/Pass
ive 64-bit SQL Server
> cluster with 28GB or RAM.
> Can anyone explaing what this messaeg means?
> Thanks,
> Igor
>|||Tibor,
Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL
says: 'Though not required, Microsoft recommends locking pages in memory
when using 64-bit operating systems'. Will my SQL Server benefit from having
this option configured?
Thanks,
Igor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
> Did you give the service account for the SQL Server service "Lock Pages in
> memory" user rights.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
>|||Slava Oks has several articles on memory management on his blog. As I recall
, he recommends locking
pages on 64 bit as well. Check it out at http://blogs.msdn.com/slavao/
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:O0LuocIRGHA.4452@.TK2MSFTNGP12.phx.gbl...
> Tibor,
> Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL
says: 'Though not
> required, Microsoft recommends locking pages in memory when using 64-bit o
perating systems'. Will
> my SQL Server benefit from having this option configured?
>
> Thanks,
> Igor
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
>

Message: Cannot use Large Page Extensions

Hello!
I have noticed following messaeg in SQL Server 2005 error log:'Cannot
use Large Page Extensions: lock memory privilege was not granted.' Server
is Active/Passive 64-bit SQL Server cluster with 28GB or RAM.
Can anyone explaing what this messaeg means?
Thanks,
IgorDid you give the service account for the SQL Server service "Lock Pages in memory" user rights.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Hello!
> I have noticed following messaeg in SQL Server 2005 error log:'Cannot use Large Page
> Extensions: lock memory privilege was not granted.' Server is Active/Passive 64-bit SQL Server
> cluster with 28GB or RAM.
> Can anyone explaing what this messaeg means?
> Thanks,
> Igor
>|||Tibor,
Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL
says: 'Though not required, Microsoft recommends locking pages in memory
when using 64-bit operating systems'. Will my SQL Server benefit from having
this option configured?
Thanks,
Igor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
> Did you give the service account for the SQL Server service "Lock Pages in
> memory" user rights.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
>> Hello!
>> I have noticed following messaeg in SQL Server 2005 error log:'Cannot
>> use Large Page Extensions: lock memory privilege was not granted.'
>> Server is Active/Passive 64-bit SQL Server cluster with 28GB or RAM.
>> Can anyone explaing what this messaeg means?
>> Thanks,
>> Igor
>|||Slava Oks has several articles on memory management on his blog. As I recall, he recommends locking
pages on 64 bit as well. Check it out at http://blogs.msdn.com/slavao/
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:O0LuocIRGHA.4452@.TK2MSFTNGP12.phx.gbl...
> Tibor,
> Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL says: 'Though not
> required, Microsoft recommends locking pages in memory when using 64-bit operating systems'. Will
> my SQL Server benefit from having this option configured?
>
> Thanks,
> Igor
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
>> Did you give the service account for the SQL Server service "Lock Pages in memory" user rights.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
>> news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
>> Hello!
>> I have noticed following messaeg in SQL Server 2005 error log:'Cannot use Large Page
>> Extensions: lock memory privilege was not granted.' Server is Active/Passive 64-bit SQL Server
>> cluster with 28GB or RAM.
>> Can anyone explaing what this messaeg means?
>> Thanks,
>> Igor
>>
>