View Complete Post
[UserID] = @UserID
I am unable to install SQL Server 2008 R2 Developer Edition (x86) on my Windows 2008 (32 bit) virtual machine. It fails everytime with "Could not find the Database Engine startup handle." error.
I am facing a problem with restoressp STSADM command. We are using a separate SQL server 2005 instance for our SharePoint PORTAL. For e.g. the instance name is MOSSSQL. I have restored the SSP database from production environment to development environment.
But facing the problem when I associate the restored SSP database with new SSP using restoressp STSADM command.
As per Microsoft guideline I have used the restorespp command to attach the database with my new SSP. If I pass the sspdatabaseserver input parameter as “servername\SQL instance name” then its giving me the error message that “required argument
are mission – sspdatabase”.
Below is the command
stsadm -o restoressp
-sspdatabaseserver "MYMOSS\MOSSSQL "
Note: I have system admin rights and I am the DB owner
Hey, i have a WebSite project which i published, in the machine where i published the WebSite everything works smooth.
when i moving it to the server, i got the Error:
Value cannot be null.<br>Parameter name: type
Value cannot be null.Parameter name: type
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.ArgumentNullException: Value cannot be null.Parameter name: type
and the details of it:
Value cannot be null.
Parameter name: type] System.Activator.CreateInstance(Type type,
Boolean nonPublic) +2843963
Boolean isAuthenticated) +76
System.Web.Profile.ProfileBase.Create(String username, Boolean
isAuthenticated) +312 System.Web.HttpContext.get_Profile() +108
PasswordRecovery.get_Profile() +39 PasswordRecovery.Page_PreInit(O
hi, I am working in asp.net MVC....
Not sure if this is a bug, or a misconfiguration on my part, but the &output= doesn't work on the IIS7 server but it works fine on local VS Web server(2008) i.e.
but http://www.example.com///&format=xml doesn't.
please let me know what can be the problem & how can i resolve that
thanks in advance
when i set the SQL Server database engine to NT AUTHORITY\NETWORK SERVICE the install works correctly but when i set it to NT AUTHORITY\SYSTEM i get a "Could not find the Database Engine startup handle." error , The Database engine services is
The Summary Log File
Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then
rerun SQL Server Setup.
Exit code (Decimal): -2061893609
Exit facility code: 1306
Exit error code: 23
Exit message: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then
rerun SQL Server Setup.
I created a function that has some queries inside which must combine data from the local server with data from an external server. I defined a linked server and everything works fine. However, the names of the external server and database are now hardcoded
in my TSQL, as the necessary syntax here is the fully qualified tablename:
SELECT col1, col2 FROM [extServer].[extDatabase].[dbo].[myTable]
The problem is that each customer where we install our function can have a different server name. So I thought to create a function parameter so the caller can specify the server name. But I'm quite sure this cannot be the standard way of doing such
a thing. I thought, names of servers and databases are normally in connectionstrings and should not get via parameter into the function. But I don't see a way to do it an other way. The whole thing needs to work within reporting services, and there you can't
deliver parameters for server name. Any suggestions?
I am getting the following error message when I try to run a script that writes to an excel file calling my Package with a SQL 2008 JOB.
Executed as user: xxxx\xxxxxxx. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Option "12.0;HDR=YES;" is not valid. The command
line parameters are invalid. The step failed.
This same package runs correctly if I execute it in dev mode in BIDS. I had to set 64bitmode to false in Dev mode to get it to work. I set executable options in the job step to 'run in 32 bit mode' The error message indicates to me
it is trying to run in 32 bit mode which should be correct but it doesn't like the extended parameters. .
Here is my connection string from the data sources tab on the job
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\xxxx.xlsx;Extended Properties="EXCEL 12.0;HDR=YES";
This was filled in ny the connection object for me. I have read the article closely at
http://toddmcdermid.blogspot.com/2009/10/quick-reference-ssis-in-32-and-64-bits.html and still can't figure out what I need to change.