Answer Questions

• vc1234 HELP --- I can't access cubes from excel

  I try to register the dll in a remote machine but I couldn't. Do I need to install something else in the remote machine Does anyone has connected with Excel from other computer than the server From the server I can connect. What whould I install in the computer to connect to the server with Excel Thanks in advance. whats the message / error  u r gett5ing. what exact ...Show All

• EricN Information for Column-Level Merge Replication

  Please provide me a column-level merge replication in SQL Server 2005. In the SQL Sever books online, I could able to get very few informaiton about this topic. Please provide me a best practices for using this kind of conflict resolution in Merge-replication. Provide me a best solution for this problem Following are my tables structure Organization (top-level)    AddressID -> ID         & ...Show All

• Jmill07 SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• amit lohia Cannot install June CTP on Windows 2003 DC !!!

  I am trying to install Sql Server 2005 June CTP on a Windows Server 2003 SP1 primary domain controller with IIS/ASP installed. I get this error (when Sql Server Database Services is being installed:  "SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLServer2005MSSQLServerADHelp­erUser". And I am not alone! See http://forums.microsoft.com/msdn/ShowPost.aspx PostID=18788 Any workaround or update to ...Show All

• Masterbrain Proxies in NT4 domain

  I am unfortunately in an NT4 domain. I am trying to use proxies for jobs but its failing with the following errors SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 10.55.250.67] followed by Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 10.55.250.67] I assume this is a Kerberos iss ...Show All

• scottm87 SQL 2000 - Replication Error 2812

  Windows Server 2003 SQL Server 2000 on both servers Attempting to configure replication from server A to Server B using publishing configuration wizard. Using Enterprise Manager and we received error 2812: Could not find stored Procedure 'msdb.dbo.sp_add_jobstep_internal'. Following the analysis of general Microsoft help which pointed to a user/rights problem I used the Query Analyser, login with 'sa' and executed sp_adddistribut ...Show All

• rgoodyear Print Button

  Print button is disabled for some users. Don't know why it is doing so Works fine for most of the users in the same group. Any help is much appreciated. SQL SERVER Reporting Services 2000 Win XP check whether any printer drivers are installed in the machine. if no printers are installed, then print button gets disabled suresh babu k Is there anyway of removing the Print functionality of Report Manager i. ...Show All

• BAB Pkg Execution Works in VS but not in SQL

  I'm able to execute a package in VS Pro on my machine. However when I upload it to the sql server and try to execute the package directly it fails with: Error: The product level is insuficient for component "...." (3129) Error: The product level is insuficient for component "...." (5411) The first component is a DataReader Source which is consuming an ODBC (Noble Systems ATOMIX Driver) connection and the second componen ...Show All

• Roman Yakovenko Why can I not read VARCHAR(MAX)?

  Hi there. Can Anyone help We have recently started to use SQL Server 2005 Express for a client. We have to accommodate some fields which exceed the 8000 character size for a VARCHAR, and all the advice says to use VARCHAR(MAX). If we do, we can place data there, but seem unable to read it back. We are interrogating via ODBC (SQL Native Client) using ASP (not .NET) on a windows 2003 server via IIS. We can find nothing at all on the web to h ...Show All

• ReverieTech LIMIT Clause

  It seems current version of SQL Server doesn't support LIMIT clause in SELECT statement. Will future version of SQL Server support it Thx. The sample: WITH OrderedOrders AS ( SELECT SalesOrderID , OrderDate , ROW_NUMBER () OVER ( order by OrderDate ) as RowNumber FROM Sales . SalesOrderHeader ) SELECT * FROM OrderedOrders WHERE RowNumber between 50 and 60 ; --woul ...Show All

• Kaloyan Service Broker not working for Restored databases (SQL 2000 databases restored on 2005)

  I just restored my SQL server 2000 database on the SQL server 2005. after this i ran the Service broker sample ("Hello World") on this database by changing the AdventureWorks name to the new database name. The "setup.sql" runs fine. When i run the "SendMessage.sql" i was not getting any rows in the output (The message was not getting inserted into the queue). I checked the Service broker is enabled on this databased ...Show All

• JEEA Serious limitation in SQL server installation

  I am trying to install the server in a non-system drive.  I have to install the server in a diffferent folder like (E:) instead of the default C: due to existing partition that I have to continue to have (due to reasons that include security). Even though I selected this drive and every thing else (Program Files etc) the same, the install program still asks for over 2 GB on C drive. I checked each of the install options and ...Show All

• MalcolmB XML Bulk Load

  Hi, I have a simple console app the load xml to SQl 2005 using SQLXMLBulkLoad4Class and I getting execption "Error connecting to the data source." below is my code. you can find the execption below my code. please advice! [ STAThread ] static void Main( string [] args) { SQLXMLBULKLOADLib. SQLXMLBulkLoad4Class objBL = new SQLXMLBULKLOADLib. SQLXMLBulkLoad4Class (); objBL.ConnectionString = "My Connect ...Show All

• mjr85 Failure sending mail: The transport lost its connection to the server

  More and more often, I am seeing this error message in RS subscriptions. I would assume it means the IIS server can't connect to the corporate exchange server. However I was wondering if there is some timeout setting/configuration in RS or the IIS server (or any other kind of setting) I can change to help alleviate this problem. Has anyone else experienced this Or know how to fix it Thanks, Jeff   UPDATE: After looking closer ...Show All

• Paolo Greppi How to secure the web pages of Report Server and Report Manager in MSSQL 2005

  After I setup the MSSQL 2005 Reporting Services, I found everybody can access the web pages of Report Server and Report Manager. How to ensure that only authorized users can access them This link may help http://msdn2.microsoft.com/en-us/library/ms157198(SQL.90).aspx ...Show All