Answer Questions

• gilabite SQL Server 2005 Express remote access?

  I am currently using a Microsoft Access (MDB) for my application. But I am looking at allowing other users on the network access the same database -- I know a Microsoft Access database is not the best solutuon for this enviroment. I'd like to use SQL Server 2005 Express in this case. I am very fimilular with SQL Server 2000 Std/Ent editions. My question is, can I use the free SQL Server 2005 Express edition and allow remote users to ...Show All

• Deki PA Clusters and Log Shipping

  Does anyone know of any issues with using Active/Passive or Active/Active clusters and log shipping. Will log shipping still work if a failover occurs Thanks Setting up log-shipping between two clusters gets a little more intricate because you have to establish the file shares log-shipping needs and although the shared disk fails over, the shares have to be setup in advance, and the node has to be the activ ...Show All

• Johnny Co Merge replication with anonymous subscribers and identity columns

  Hi, I read the BOL on how the publisher will had out identity ranges to subscribers, but it was not clear if this was also the case for anonymous subscribers. Will merge replication with identity columns work with anonymous subscribers that sync via HTTPS Thanks, Darrell Young Yes, it should work. Please try and let us know if you encounter any issues. ...Show All

• DennisLonndon RTM Integration Services Job

  When I try to create a job step of type SQL Server Integration Services Package I get an error: =================================== The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI) ------------------------------ Program Location:    at Microsoft.SqlServer.Management.SqlManagerUI.DTSJobSubSystemDefinition.Microsoft.SqlServer.Management.SqlManagerUI.IJobStepPropertiesControl.Load(JobStepData ...Show All

• TaylorClark SQL Server Management Studio Express: Missing DataBases from VWD Project

  LOST DATA BASES I appear to be doing something stupid! I created a VWD express project that contains a database. In VWD the DB application works fine. I can see all my tables. VWD stores the DB in the applications area of MY DOCUMENTS in a project folder under “SQL SERVER Management Studio Express”. However, when I run the SQL Server Management Studio Express, I get a instance of the “(computer_name)SQL\express” that contains the Syste ...Show All

• Thomas Greenleaf Re-Execution of For each Loop Container

  I have a For each loop container and inside the same a group of text files are loading to a table using bulk insert task.If there are duplicate files i dont wish to load it into the table. Duplicate check can be done by script task but how do i skip the files and repeat the for loop for the next files. That means i want to skip some files and load the other files in a for loop. How do i do that. Can anybody please help me. ...Show All

• Mauro Mazzieri SQL Server 2005 Management Studio Error

  Hi guys,    I just installed SQL Server 05 Dev. Edition on my test server but after trying to open the management studio/SQL profiler I am getting the following error (Please assist): ************** Exception Text ************** System.InvalidCastException: Unable to cast object of type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization' to type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization'.   ...Show All

• BillR2 Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path

  Hi, I spend two days looking for an anwser to this problem but no luck. I have a simple ASP.NET 2.0 application which run correctly on my local machine. But After uploading all files including web.config file on a Windows 2003 Server with SQLEXPRESS installed. I have this error. Please Help!!!!!! Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a ...Show All

• Miles Miller SA password

  Hi expert, I just install SQL server express. Very smooth installation and allow me login into the server by using window authentication. How i want to login as sa. if I using sa as login and SQL Server authentication. I cannot login to ther server. Thanks. Yep. Jens, the website refers to SQL Server Desktop Engine (SQL Server 2000) it is still valid for SQL Server Express ...Show All

• ST2B Datetime parameters

  Hello, I have a date time parameters, Users can pickup a date using the calendar control but he can also change the date and also add time. When a user type wrong date or time we got error message only when he try to run the report, can I change this behavior ...Show All

• SQLAdmin2005 problem with dtexec

  Hi I have a SSIS package which pulls files from a network share and loads data into SQLServer Database. When I execute the application using DTExecUI , It runs fine without any issues , but where as when I run it using the command line arguments, It seems to go in sleep mode and nothing happens. I need to kill the package from Task manager. Following is the command I use to run my application Dtexec /FILE "N:\Temp\Load ...Show All

• John Chorlton Regarding the System Tables

  Hi all, I would like to get the Database diagram for the System Tables and views. Where can I find it Thanks! Raju Check out this HTH ...Show All

• steelers0118 Verifying authentication

  Hi guys, I am getting the following errors: 1. Error Code: 80045901 Message: Initializing SQL Server Reconciler has failed. [,,,,,] Minor Err.: 29045 Source: Microsoft SQL Server 2000 Windows CE Edition 2. Error Code: 4E74 Message: The process could not connect to Distributor 'XBOX\MOBILETEST'. Minor Err.: 0 Source: Merge Process 3. Error Code: 11 Message: SQL Server does not exist or access denied. Minor Err.: 0 Source: XBOX\MOBILETEST Is the ...Show All

• vitalcc The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid

  Hello, I am getting the following warning in the Application Event Log: The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid. The warning is logged by the SQLBrowser service. This is happening on Windows 2003 server with SQL Server Express 2005. On the same machine SQL Server 2000 is installed. I am currently unable to connect from remote clients to the instance of SQL Express and I bel ...Show All

• Penny Reed New to MDX. Help Needed with a Calculation Definition in my SSAS 2005 Cube

  I'm new to MDX and I don't quite get the hang of it yet, so I'll try to provide all of the relevant information that I can so that you guys can help me. My company has a lot of "Rolling 12 Month" metrics and I've been able to incorporate all but a few in my SSAS 2005 cube.   By "Rolling 12", we refer to the 12-month period that ends with the previous month.  So all "Rolling 12" metrics reviewed in December 2005 refer to the period ...Show All