Answer Questions

• Roachy Avoid windows login prompt while accessing report server.

  Hi, We are using Microsoft Reporting Service 2005 to develop reports and we are accessing these reports through a J2EE application. The front end is implemented using Tapestry and we using JBoss as our applicaiton server. We are using Shared Data Sources for the reports and we set its data source type to SQL Server Analysis Services. In the credential tab, by default "Use Windows authentication" is selected. All other options are disabled. When I access my reportserver through my web application, I am always prompted for a windows login and password. How can I avoid being shown the windows login prompt, since our web application will be used by several users and we do not want the users to type in a username/password everyt ...Show All

• madaboutnoggins Database restore speed

  This problem isn't specific to SQL Server, but because of the size of the files I deal with with SQL Server, it is the place I notice it more often, and hopefully one of you has, too. If I am restoring a database (or simply copying a huge file) that takes more than a couple of minutes, I find, by watching the network bandwidth, that after a couple of minutes, the data rate cuts on half and stays that way for the rest of the restore (or copy). If I have a Gb/s connection, maybe I start at 240Mb/s and then drop off to 120MB/s. If I have a 100Mb/s connection, maybe I start at 70Mb/s and drop to 30-40MB/s. It is fairly consistant in how long before the drop and in the magnatude of the drop (approximately 50%). The network staff have no c ...Show All

• Seif Ibrahim SQL server does not exist or Access denied after input of critical updates

  Hello guys och dolls. I have a DTS program in sql-server 2000 which worked to week 27 but not from week 28. During that time I was on vacation och no one else was working with the server. The part which is the problem looks like this. if exists (select * from dbo.sysobjects where id = object_id(N'[lenko7].[aviskydd]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [lenko7].[aviskydd] GO CREATE TABLE [lenko7].[aviskydd] ( [Col002] [varchar] (255) NOT NULL, [linecount] [int] NOT NULL ) ON [PRIMARY] GO I have not changed owner. I don't understand why this DTS package suddenly cant work because it has been working for a several years with no problems. The only thing a know is that we have updated windows 2000 cause of ...Show All

• Tom Rixom ODBC Link from Access to SQL Server 2005 Stored Function

  If I define a table-valued function in a SQL Server 2005 database, can I link to it from Access 2003 using ODBC I've defined the function successfully, and I can link from Access to tables in the database (so my ODBC link is basically functioning), but I can't see the table-valued function in the Linked Table Manager in Access. I can define a pass-through query to grab the table, but with a pass-through query I have to provide the ODBC password every time. What am I missing Suggestions Try creating a view around your table valued function, and then linking to the view. It worked for the sample I just tried. Thanks ...Show All

• Anand Raman - MSFT Error while building ASSP_Beta_1_Source_Code project

  Hi, I am getting following errors while trying to build this Stored Procedure project: ..\StringFilters.cs(24): The type or namespace name 'AnalysisServices' does not exist in the class or namespace 'Microsoft' (are you missing an assembly reference ) Why is compiler not able to find this namespace Do i need to include any assembly reference for this I need to include msmgdsrv.dll for being able to use the interface Microsoft.AnalysisServices.AdomdServer. But i am unable to add this reference from ..\Program Files\Common Files\System\Ole DB\msmgdsrv.dll Any pointers on this would be welcome... Try adding this reference from Analysis Server's installation folder. By default it is installed into C:\Program File ...Show All

• Speedbird186 Remotely Register SQL Server 2005 Express in Enterprise Manager

  I have SQL Server 2005 Express installed on a windows server 2003 standard edition. I have configured the windows firewall to allow exceptions for sqlservr.exe and sqlbrowser.exe. I have enabled remote and local connections using tcp/ip & Named Pipes through the Sql Server Surface Area Connection utility. I am able to telnet into the server with: telnet <server ip> <1433>. Here is the strange part: I am able to connect to the Sql Server remotely from a development machine via Sql Server Management Studio Express, but I am unable to connect to the Sql Server from the same development machine by registering it in Sql Server Enterprise Manager...Is it possible to register SQL Express through Enterprise Manager ...Show All

• Leo Liu SQL Analysis Services Service does not start

  I have installed SQL Server 2005 Standard Edition for use with Team Foundation Server. I have verified the installation according to the documentation, and all is well except that the Analysis Services Service is not started. When I click Start, I see the progress bar as if it is starting, but it stops shortly after, saying that "Some services stop if there is nothing to do". Team Foundation Server requires that this service be started for the installation to succeed. How do I get the service to stay started Thanks in advance. I just did a fresh install and SQL Server is OK, Now I can't get reporting services to work with Team Foundation Server! What lo ...Show All

• Hosam Kamel merge two results into one

  Hi, I want to run a query which will return two results as one row. I am building a system which returns all the projects for a user that start between two dates, usually the beginning and end of the week. If two projects start during that week I get two rows of results, but I want to actually merge these two results into one row. So that I can display the project names as project 1, project 2 Instead of project 1 project 2 I did try using GROUP BY to merge the results but this didn't work, what other ways can I do this Thanks Stephen DECLARE @project nvarchar ( 2000 ) SET @project = '' SELECT @project = @project + [projectname] + ',' FROM ( SELEC ...Show All

• adorer 2005 Remote Connection Error

  Hi, Hope someone can help with this, having a huge problem connecting to SQL 2005 from a client machine. I get the following error: "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) (Microsoft SQL Server, Error: -1)" I have SQL 2005 installed on a server containing SQL 2000 (default instance) and then SQL 2005 as the instance SERVER\SQL2005. 2005 is running SP1. I'm connecting via windows authentication, using just using Management Studio. I've also configured the ...Show All

• Dan_Brownlow User initiated backups

  During the month end close the accontants want to have their SQL2000 databases backed up before they run certain processes. We (IT) run the backups using the SQL management console when they call. Is there a way we can allow the users to start a backup without giving them access to the SQL management console It depends on how much effort you want to put into this. You could buld a little application that uses SMO to do a backup, or invoke a backup via a script (see below re: rights). You could add one (or more) of the Accountant Users the db_backupoperator role, and show them how to use the UI to do the backup, or give them a script to run. We already have end of ...Show All

• soconne Short Circuit Evaluation in Conditional Split Expression

  I think I know the answer to this but thought I'd ask anyway.  I have a conditional split to check a column for null values or empty string values.  It looks like this: (!ISNULL(Ballot)) || (LEN(TRIM(Ballot)) > 0) My question is:  Are both sides of the expression evaluated   My testing says yes, because a Null value causes an error.  Is there a way to short circuit the evaluation like the || operator in C# or the (less than elegant, and seemingly threatening) OrElse operator in VB   Whats the best alternative: A slightly more complex expression that turns a null value into an empty string A script component Two conditional splits Two paths out of one condtional s ...Show All

• Closer Access database synchroniser fails with 'incorrect format or content'

  I've installed ADS on a windows mobile 5.0 device and am trying to run the sample Wizard application. It connects to the test database on the device OK, but fails to connect to the database on the desktop with the error: "The HTTP request failed due to incorrect format or content. Try restarting the IIS server" I've tried changing the port from 1024 in case it was already in use, but this doesn't change the error. Nor does restarting IIS (v5.1). IIS appears to be running correctly on the desktop. Any ideas what to try next thanks irs hi got corrected this problum.the cause is that the http url specified in sqlceremoteaccess is incorrect.but actualy the joke is that the same url ...Show All

• kwards3 Set Background color using RGB value

  Hi All, i have a field which stores the related RGB values for each record I need to set programatically the background color for some objects in the report using the RGB value stored for the record. how can i convert the rgb value to color and then set the background color for the report object. Please Help Thanks In Advance sud <BackgroundColor>#6e9eca</BackgroundColor> 1. Report parameters >> Add Name : "bgcolor" Data type: string check Internal Available values: From query (You have to define dataset and return the bgcolor value) Default values: Non-queried:  #FFFFFF 2. Edit Expression in BackgroundColor (Object Propertie ...Show All

• Tigers21 For new in SSIS. To send data from operational d/base to data warehouse

  Hi Dear All! I am Crystal Reports Developer and I am new in SSIS environment. I have started to read Professional SQL Server 2005 IS book. I am really confused by many tasks to choose. I need to develop reports from data warehouse. But before I have to send the data from operational database (SQL Server 2000) to warehouse (SQL Server 2005) monthly - I have a script for retrieving the data. For my package, I chose Data Flow Task, Execute SQL Task, and OLE DB Destination, and it does not work. Please help me if I can look similar packages performing Thank you!! When I started, I watched that webcast several times in order to pick up on several topics... Just give it time and ...Show All

• venkee ODBC Excel Driver

  dear all: I used ADO to connection excel file(excel2003); below is the source code: Dim Conn,Driver,DBPath,Rs, defaultPath defaultPath=Replace(xlsFile, "\VQAUser.xls", "") Set Conn = Server.CreateObject("ADODB.Connection") Driver="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & xlsFile & ";Extended Properties=""Excel 8.0; HDR=yes;"";" Driver="DBQ="&xlsFile&";DRIVER=Microsoft Excel Driver (*.xls);UID=admin;UserCommitSync=Yes;Threads=3;SafeTransactions=0;ReadOnly=0;PageTimeout=5;MaxScanRows=8;MaxBufferSize=2048;FIL=excel 8.0;DriverId=790" Driver="DRIVER=Microsoft Excel Driver (*.xls);DriverId=790;DefaultDir="&de ...Show All