Answer Questions

• alka_mehta Remove SP1 or install SP2 Dec. CTP

  This sounds trivial but it has become an issue here. We had the original RTM of SQL2005 with Reporting Services installed and running fine. We were explicity NOT installing SP1 because of a feature that was removed from reporting services (the select-all checkbox in the multi-value parameter). This feature is supposed to be back in SP2. So wouldn't you know it, somehow someone inadvertently installed SP1 in the course of doing windows updates and now users are complaining about the missing select-all checkbox. I figure my options are to either install the SP2 Dec CTP or try uninstalling SP1 (if that's even possible). Any recommendations Ah! there is a hotfix addressing this very issue. I will try it. ...Show All

• roadresident Not associated with trusted sql server connection

  Hi All... I'm using asp.net 2.0 against a SQL Server 2005 database and am getting an error, Login failed for user 'MyUser'. The user is not associated with a trusted SQL Server connection. I've done searches for this error and most say to switch from windows-only authentication to mixed mode. That seems more like a workaround rather than a solution. I mean we should be able to use windows-only right So how does one set up that user to be associated with a trusted connection The odd thing in my setup is that I'm using the exact same username and password as I'm using to connect to the database with Visual Studio 2005 and that works fine. But when I try the same acct/pwd from asp.net, I get that error. FWIW, here's my connection ...Show All

• winstonSmith Excel extraction issue

  I have a spreadsheet that's designed to look like a form. Does anyone know how I would create a SSIS package to extract specific cell values TIA Have you tried using the Excel Source Adapter ( http://msdn2.microsoft.com/en-us/library/ms181175.aspx ) Thanks Anjan. ...Show All

• Gliksman Advanced SQL Generation Options in VS2005

  Hi There im not sure if im in the right place but i was wondering why the above option is greyed out when creating a new sql datasource. This occurs even when i select all fields within the table (including primary key fields) Thanks Todd I have the same problem. I set the primary key in the table I'm trying to access to ArticlesID with the value of int, I select all the proper settings, but the Advanced SQL Options is still greyed out. I cannot seem to get this to work. This also happened to me and it did not work even though I followed all of your suggestions. So, I closed the project and re-opened it again WITHOUT connecting to the database. I started the Configure D ...Show All

• jamesIEDOTNET configure web synchronization pb

  hi, First, sorry for my english, I'm french When i try to configure web synchronization, I get the following err " success Hresult 0x8007000"(!!!) for the step : setting the snapshot share permission I really don't understand : my folder have all the rights for the user agent... I don't know what to do. Config . SQL Server SP4,Microsoft SQL Server 2005 Mobile Edition It had worked but I had to reinstall the system and now, it does not work anymore Thans for your help, Eric Are you using a domain user If you could post your steps in detail, I can try to help. Are you using the "configure web synchronization wizard" have you follow the instruction in SQL server 2005 mobile edt ...Show All

• pdianne Question about by Import oracle data and field is null

  Hi, I've a question about importing Oracle data and some fields are null. I get an error 'Conversion failed because the data value overflowed the specified type'. When i look in preview query result, via OLE db Source editor > Preview, this field contains '<value too big to display>'. What do i do wrong Can somebody help me Thanks in advance Olaf Hi Buck, What is the problem. I have a made a SSIS, in VS2005, with an ole db source, settings to the oracle db, and an ole db destination, settings to sql 2005 db. When i look in preview query result, via OLE db Source editor > Preview, afield contains '<value too big to display>'. This field is a datetime oracle field and it's emp ...Show All

• McGatz AVG Measure

  In AS2005 how i make a measure with tha aggregate function avg Thanks i have tried the AverageOfChildre but i get an error because i'm using the standar edition... I can't believe there is an easy way to get an avg measure :( Thanks!!! now.. i can have a calculated member in a column of the drilldown Javier, To create a new calculated member, go to the calculations tab in your cube in BI Studio and then do one of two things, click on the "New Calculated Member" button on the tool bar. It looks like a calculator - or you can go to the menu and select "Cube", "New Calculated Member". Once you have done that, you should put the name at the top in the box labeled "Nam ...Show All

• WebService4Ever How to Add Reporting Services in Microsoft Dynamics CRM 3.0

  How to Add Reporting Services in Microsoft Dynamics CRM 3.0 What do you mean by "add reporting services in [...] CRM" SRS is a prerequisite for CRM (if you want reports to work) so you ususally install it on the SQL Server before installing CRM. During CRM setup you get to specify the URL to your reporting server. In the CRM, You are able to import your RDL file in your settings area, you can then select which entities you want to have access to that report. Note, you will have to update your config file if you want to report to run from a menu should as "Orders", "Accounts", and "Contacts" Ham Hi Download SQLReportPackCRM.msi and ...Show All

• pkr2000 SS 2005 64 bit ?

  Hi There I realise this is a pretty broad question, but are there any special considerations for 64 bit SS2005. I have never installed 64 bit before, is there any major difference to 32 bit or any special configurations or setting that must be checked, i could not find anything in BOL specific to SS2005 64 bit installation. For example, enabling AWE memory, Windows 3Gb switch etc, i know that on 64bit windows over 3 Gigs Ram is automatically addressable as it is 64bit, but is there still a configuration setting in 64 bit SS2005 that must be changed after installation. I have also discovered from BOL that there is no Sql or Database mail on 64 bit, only with SP1. That kind of stuff, i dont expect an essay for an answer, but i ...Show All

• phoenix11 DMO and Windows Authentication

  I'd like to use DMO to browse for databases on our SQL Servers using Windows Authneitication, rather than the SQL Server Authentication with login and password. Is this possible. This is the chuck of code that I've borrowed to do it so far. Can you make the Connection without the user and password Thanks, Howie Set SQLInstance = New SQLDMO.SQLServer 'Connect to the server by name (from global variable) SQLInstance.Connect t_Server, t_User, t_Password 'Set the instance to that server ID SQLSrvrID = SQLInstance.ConnectionID Set SQLInstance = SQL2000.SQLServers.ItemById(SQLSrvrID) 'Display the available databases in a list box ListDatabases.Clear x = 1 For Each DB In SQLInstance.Databases 'Do not add system ...Show All

• ELDHOSE_BABY_a06ce9 some problem of Querie for "Select" & "Insert"

  I would like to run a query for get contious data ( like data_no=1 and data_no=2 ..... and data_no=2) I only know to run a query for get single data for example: select data_no from tableA where data_no=1 if I want to select mutiple and continue data what can I do after get data how can I insert mutiple data to DB for 1 query many thanks u can use 'order by no'.. various commbinations from there on.. select top 10 * from student order by no or do this.. select * from student where no <11 order by no etc.ctc... for inserting into other table.. insert into 'tablename' select * from student where no <11 order by no thanks you all ...Show All

• MuscleHead changing merge agent profile for HTTPS - mergeSubscriberType = anonymous

  Hi We are using HTTPS merge replication Our setup is as follows: subscription.CreateSyncAgentByDefault = False -- I wrote a windows service to synchronise subscription. UseWebSynchronization = True subscription.InternetSecurityMode = AuthenticationMethod.BasicAuthentication subscription.SubscriberType = MergeSubscriberType.Anonymous Some of our subscribers have low-quality internet connections - how do I get the agent at the publisher/distributer use a slower profile - I've read How to: Work with Replication Agent Profiles ( Replication Transact-SQL Programming) but can't see where you specifiy an alternate agent profile On the distributer / publisher (same machine) I go to replication monitor -> Warnings and ...Show All

• Yannis Angelis Download for redistributable SQL Server Express Edition?

  Where do I find the setup files needed to redistribute sql server express installation files I downloaded the SQLEXPR_ADV.EXE but the files disappear as soon as you cancel the installation. I need the sql server setup files to package with my program fr distribution. THANKS SO MUCH Yes. You cannot copy the temporary folder with drag/drop. But you can open a console window with xcopy to copy the temporary to a new folder. I do not know whether you can redistribute the content. You need to contact your attonary before you do that. the problem is I need to customize the upgrade by providing the template.ini with it. template.ini is onl ...Show All

• RobertMC Trouble with establishing server connection in SQL Server 2005

  I have been developing a web application using Visual Web Developer with SQL Server Express. The application includes databases (I’m having users create accounts to become members, and I use their profile information to customize some of the web pages to the particular member). I have purchased Visual Studio 2005 Pro, which comes with SQL Server 2005 Developer Edition. I installed both of these without uninstalling Visual Web Developer (I wanted to have my work transfer from VWD to VS Pro). When I open Visual Studio Pro, my web application is there, with the pages I have coded. But when I try to connect to the data base (e.g., by logging in as a member), I get this error message: An error has occurred while e ...Show All

• ROBIverson How to use the Microsoft OLE DB Provider for DB2.

  I follow the steps: 1.In configure OLE DB Connection Manager dialog, I click New. 2.In Connection Manager dialog ,I choose Native OLE DB\Microsoft OLE DB Provider for DB2. 3.In Connection Manager dialog I click the "Data Links" button. Now I am on "Data link property" dialog.  4.On connection tab, I enter fmdb for data source, which is my remote database name. On Network section I choose TCP/IP Connection and set the right IP/Port. Uncheck Single sign-on and enter the user and password. Then comes the Database section. Database name fmdb for Initial catalog,"fmdbrun" for Default Schema,  then what is Package Collection (My db2 database is in a AIX/RS 6000 box). 5.On advanced tab, I choose DB2/6000 fo ...Show All