Answer Questions

• Kanika Failed Install of SQL Server 2005 SP1 CTP

  Hello, We are attempting to install the CTP for SQL Server 2005 SP1 and receive the following error message in the log: The following exception occurred: Unable to install Windows Installer MSP file  Date: 03/24/2006 14:19:40.562  File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp  Line: 856 This is then followed by this failure with the Database Services: Product: Database S ...Show All

• Kyra Database Engine Connection Error.

  I got the sql2005 std edition at the msdn rollout, and the vs2005 studio. I uninstalled sql2000 and now, cannot connect to the database engine. I get the following error message with a link to an page that offers no info. What's up and how can I get it to work Please, help. 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 ...Show All

• Bhaskara.NET MDB to SDF

  My company has purchased the SQL 2005 Server Enterprise and I have imported the Access database to the SQL Server.   I have built a SQL 2005 mobile database (a sdf file) within VS.net 2005. Can any one tell me how to load it to the SQL server management studio and transfer tables from SQL Server Enterprise database to the SQL 2005 Server Mobile database   By the way, I could not fine the “SQLMobile.sql” file mentioned in ...Show All

• Byron118766 Cannot uninstall SQL Server Express

  Hi! I uninstalled Visual Studio 2005, but then I get this error when trying to uninstall SQL Express: "The SQL Server System Configuration check cannot be executed due to WMI configuration on the machine XXX: Error: 2147746132 (0x80040154)" I don't even know what WMI is! I have these installed (none of which can I uninstall): Microsoft SQl Server 2005 Microsoft SQl Server Mobile [ENU] Developer Tools Microsoft SQl ...Show All

• paulballard MSDAORA error on one machine

  Hi, On one machine, I get an error when I test a newly created MSDAORA connection. TITLE: Connection Manager ------------------------------ Test connection failed because of an error in initializing provider. Oracle error occurred, but error message could not be retrieved from Oracle. ------------------------------ How could I do a clean uninstall of the Microsoft OLEDB provider for Oracle and re-install it. Where could I find an installer for t ...Show All

• c_jensen Problem using SQL Server Mobile 2005 with Windows Mobile 5 application

  Hello, I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database. The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration. The "ssceoledb.h" which I include incluses the "transact.h" file. But my proble ...Show All

• udotan Subscriptions

  We are running Reporting Services on an Application server, side by side with a web application. The server exists outside our corporate domain due to the fact that our external vendors need access to the application (not the reports). Our web app uses a third party mail system to funnel the application email thru our corporate exchange server. Since Reporting Services is not connected to our domain, it can not authenticate to send reports via e ...Show All

• Bharat Gadhia error of Initializing SQL Server Reconciler has failed using SQL Server CE 2.0

  hi, i'm using SQL Server CE 2.0 in my application. When i try to synchronize my database by calling replicator.Synchronize(); errors :   Initializing SQL Server Reconciler has failed. process could not connect to Distributor SQL Server does not exists and access denied. what i did right now is i try to register regsvr32 "C:\Program Files\Microsoft SQL Server CE 2.0\Server\sscerp20.dll" regsvr32 "C:\Labs\NorthwindTempFiles\sscesa20 ...Show All

• ecdown DDL triggers on create Logins

  Hi all, I have setup a DDL trigger for server logins.  If I drop a user my trigger fires off an email with the EVENTDATA (). value.  If I create a new user the Eventdata is null.  I am using the code below: TIA, Joe DROP TRIGGER ddl_trig_login ON ALL SERVER GO CREATE TRIGGER ddl_trig_login ON ALL SERVER FOR DDL_LOGIN_EVENTS AS declare @user varchar ( 100 ), @event varchar ( 1000 ), @subj varchar ( ...Show All

• Yoni Gibbs DataBase Connection

  hi everybody; my questions about when database connection : i am when connecting database latter receiveing exception error.Error is : An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll codes : SqlCeConnection cnn=new SqlCeConnection("Datasource=\\My Documents\\Business\\LOREAL.sdf"); cnn.Open(); // Exception is here help me.. ca ...Show All

• Michael.Weinhardt - MSFT populating a calendar table Newbie question

  Hello evryone first post of many ........probably.  Happy new year to you all! Ok down to business........... i am in the process of creating a calendar table for a DW and need to create somthing called a scheme quarter. Basically what i want is for Q1 to start at july 2001 and increment from there.  it will also not reset the number after Q4 ie April 2005 would be Q18.   I am looking for a way to do this w ...Show All

• Rahul_It Fuzzy Lookup componant eating all available virtual memory

  Hey, I have a large set of data that I need to match against another large set of data.  The reference table has 9.8mill rows and my input has 14.6mill rows.  I started with a new project.  I added my connection, then a task to clear the result table, then my data flow, then my OLE source, then my Fuzzy Lookup task, then my SQL Server Destination.  I set the connection of my OLE source and set the query to pull the dat ...Show All

• AMaher Detaching a Database using SQL-SMO

  Hi, Please let me know how I go about detaching a database in SQL 2005 usng SQL-DMO. I think even before detaching a database we have to clear the connections. If the solution is provided it will be of great help as it is very critical. Regards Kris Once inititated you can use the: SomeServer = new Server(); --Has to be modified here SomeServer.DetachDatabase( "MyDatabaseName" , false ...Show All

• isha_2 ~* Total Pages mismatch *~

  Hi, The number of pages in the report viewer and the number of pages in print preview are different. how could the prob. be resolved... Thanks in advance. Cheers Chakri. The Report-Viewer doesn't follow the page-properties (height/width/borders) and so it doesn't make page-breaks if your page is "full". Why is this bothering you Page count for the viewer controls is cal ...Show All

• DavidMBaker ProcessAdd processing hangs

  I'm trying to do an incremental process of a cube that has 3 measure groups. The first measure group is fairly straightforward, run-of-the-mill measures. The other 2 are distinct counts of an ID. When running the incremental process (ProcessAdd), the status seems to complete, and then everything just hangs. I can't find anything that the server is doing, but it won't return. This happens in BIDS using debug, management studio wizard, and manage ...Show All