Answer Questions

• Amit Glazer Domain group logins failing on SQL 2k5 workgroup

  This question is regarding a brand new out-of-the-box SQL Server 2005 Workgroup Edition install. The old SQL Server 2000 server is working properly with regard to the issue we're having: We are using Windows Authentication, and have created SQL logins for about 40 different groups on our domain. We've given those logins the appropriate permissions on the databases they're supposed to be able to access. The SQL Server is not a domain controller, but is a member of the domain, and domain logins do work for Windows-login purposes on this box. The problem is that when users try to connect to the SQL server, they are denied access. An error 18456 is thrown, and logged in the Application event log stating "L ...Show All

• Mohsen Kokabi STRAGG for MSSQL?

  We utilize a function on Oracle named STRAGG that aggregates and comma separates results.  Does something like this exist for MSSQL 2000   We won't be able to upgrade to 2005 for a while. Example table: name         amount Joe            15 Mary          20 Joe            45 Mary          55 Example query: select name, stragg(amount) from table group by name Example results: Joe        15, 45 Mary       20,5 ...Show All

• Kunamaneni EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters

  I had enabled SQL Trace and if i understand correctly SQL Trace will help us in finding slow stored procedures how ever when i click tables and traces i getthis "EXECUTE msdb.dbo.sp_sqlagent_get_perf_counters" link.What am i suppose to do with this how do i analyze the sql trace data where is it. I did open the load database there are lot of tables what all tables are of our concern..how do you analyze that kindly help. I believe you can get a better response in the SQL Server Tools General forum. I moved your post. ...Show All

• Adrian Foot Parameter visability dependant on a parameter?

  Is it possible to change the visibility of a parameter based on a boolean parameter that a user can view in the report So you have one parameter that is a boolean value defaulted to false, when the user changes the parameter from false to true another parameter, previously hidden, is then displayed. Thanks you can use the boolean value to make the text box which displays parameter hidden propety true or false Dynamically hiding certain parameters in the report viewer UI is not supported directly through RDL. You would need to implement your own custom frontend for handling this parameter logic and then send the selected parameter values to Reporting Services (e.g. via URL access, or by usin ...Show All

• Rabtok Excel as Frontend to SSAS 2005 Cube

  Hi, there, I am working on Excel as a front-end to a SSAS2005 cube. I intended to create a simple add-in that allows users to write back to the cube. Users will first retrieve data from the cube to pivot table and write back to the cube from the pivot table. I can find some sample source based on adodb and AS2000 but not adomd .net and SSAS2005. For the time being, information on SSAS2005 write-back from Excel seems very little. Not much references that I can refer to. Anyone can shed some light on this I would appreciate it if you can provide me some sample source in VBA using adomd .net or others that can demonstrate the write-back to a SSAS2005 cube. It would be great if the sample will be based on the AdventureWorksDW cube. Th ...Show All

• Utkarsh Shigihalli After an insert, how do I get the primary key of the new row?

  I am using C# and ADO.NET After executing an INSERT, I would like to retrieve the primary key of the last row inserted. I've tried running SELECT @@IDENTITY in a query, but I get an OleDbException with the message: {"Syntax error. in query expression 'SELECT @@IDENTITY'."}. does anyone know what to do The aggregate MAX is a function that was used in the old days to get the highest / recent value. Its not practical / preferable / suggested / recommended / whatever in days of writing with multiple users to a database. Like Joyei said, I would rather use the SCOPE_IDENTITY() approach. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Someone asked me ...Show All

• Bas de Zwart Calling SqlDependency.Stop() in class destructor

  Hey guys, Have you ever tried to call the SqlDependency.Stop() method in a class destructor (C#) It seems like the finalization process hangs after the call to the SqlDependency.Stop() method (for example the assignment after the SqlDependency.Stop() method call is never executed). ~Program() { if (!_finalized) { SqlDependency .Stop(NocConnectionString); _finalized = false ; } } I tried to use the ADO.NET 2.0 tracing, and it shows that the SqlCommand.Cancel() method call throws an exception during finalization, but it’s not possible to intercept it. Do you have any clue about it or have you ever experinced the same problem Regards, ...Show All

• Mark Flamer Daily use of encryption

  In practice, I find encryption kind of messy to use -- opening, closing keys, use of certificates, all the while trying not to give away the password in cleartext. If our .NET programmers are to use it efficently in high-level code we need a function call, say "EncryptValue(<input value>)", that simply returns the encrypted value. Is it possible to write such a function (And of course, we need the mate "DecryptValue(<encrypted value>)". TIA, Barkingdog That's what I just recently figured out - I will talk to my IT department to determine how the web application creates its database session - I also know that we have a webfarm - so each webserver that makes a ...Show All

• WinFormsUser13232 Analysis Services not Started!

  Good Day! I have installed SQL Server 2005 In services.msc SQL Server Analysis Services (MSSQLSERVER) can't be started. Message: Service Started and then Stopped and The service cannot be started: The following system error occurred: Only one usage of each socket address (protocol/network address/port) is normally permitted. What is this Thanks... Wow. It seems like SQL Analysis Services can't live with started SAP on the Machine. What ports use Analysis Services Ok Where can I change instance port for Analysis Mosha Pasumansky wrote: Server -> Properties -> Show All (advanced) properties -> ...Show All

• COBOLBeginner Error: 18456, Severity: 14, State: 16.

  I am getting the error Error: 18456, Severity: 14, State: 16. Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2] in the log repeated every 15 seconds or so. I am logged into the server as pri\sqlservice, I have started the sql server and sql server agent with pri\sqlservice and I can access databases and tables inside the Server Management studio. I have set up the login pri\sqlservice and given it dbo owner access to all databases. I am in the process of upgrading from 2000 to 2005. I have installed a new sql server 2005, restored backups of databases from 2000. I have also converted all packages and uploaded those to the new server (although they all point to the 2000 server). I have imported the jobs, but all but one ...Show All

• CharlieRussell No ADO type command for Data Flow?

  I'm probably not looking in the right place, but all I could find when creating a data flow task was OLE DB Commands.  I was trying to utilize a dataaccesslayer piece of code that we use every where in our projects, but because it uses ADO and not OLE DB, it caused an issue between the column data types. Is there an ADO command object available   Or are we forced to use the OLE DB command object   All I was looking to do was to Execute a SQL command.  There's an object on the Control Flow level to do that, but not on the Data Flow level---not sure why that is. Thanks, Jeff Tolman E&M Electric I have a set of records coming in to a Script Component and based on the data an ...Show All

• Njofra Grouping in Cube's dataset, Please Help

  have a measure called [Person COUNT] and an Attribute called [Injury Class] Injury Class has four members [Injury A] [Injury B] [Injury c] [Injury d] I want to get the Person count for each one individually, in seperate columns. So it would look like this [ Person Count A] [Person Count b] [Person Count C] [Person Count d] 125 254 4 1245 441 11 21 24 454 57 12 42 I want this all in One single Dataset. So that when i put it into a table, i dont get errors about being outside the scope, also everything will be lined up correctly. Please keep in mind, im new to mdx, i tried some code, but the stuff i tried didnt work. Is there a way to do this as a cal ...Show All

• LiamD Loop Through Flat Files Based On A Date Range

  Hello, I currently have a For Each File container that loops through all files from a specific directory. The files have a naming convention that looks like this; CDNSC.CDNSC.SC00015.01012007 The last segment of the file name is the date of the data in the file (mmddyyyy). The create date for these files is always a day later than indicated in the file name. What I would like to do is to have more control over the 'range' of files that are looped through by using the date portion of the file name to define what group of files should be looped through. Ideally, I would like to have a 'StartDate' variable and an 'EndDate' variable that I could define at run time for the package, and the package would loop through all of the files ...Show All

• Fippy Security Issues with Reports

  I am having a problem with getting my reports to work after deploying them to a report server.  Viewing them in the preview pane in Visual Studio 2005 works fine with the data being returned. But when trying to navigate to the report from my desktop machine using the report server url I get the following error An error has occurred during report processing. Cannot create a connection to data source 'datasource'. For more information about this error navigate to the report server on the local server machine, or enable remote errors So I remote into the report server and browse to the report from there and it works fine and the data is returned.  Is there something I am overlooking here I am using "Window ...Show All

• HSBF Lewe ODBC Connect Failed in SQL Job

  I am running SQL Server 2000 sp4 in Win Server 2003. I have a DTS packages which connects to FileMaker 6 files via the ODBC driver installed with FielMaker. The DTS packages work correctly when executed directly. However, when executed from a SQL Server Agent job, the same DTS packages fail. Always with the same message: Error: -2147467259 (80004005); Provider Error: 16394 (400A) Error string: [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed Error source: Microsoft OLE DB Provider for ODBC Drivers Searching for info on the above message seems to indicate a permissions problem. However, I am running the jobs with an full administrator account. All connections and the FielMaker files reside on the one ...Show All