Answer Questions

• Sergio G SQLConnect to SQL Server fails when connection intialized from a service

  I have an issue where SQL Server is refusing a connection that is initiated from within a Windows service. The connection is attempted using the SQLConnect ODBC function (yes I know there are newer and better things out there but I'm stuck with ODBC for now ). SQLConnect returns SQL_ERROR and the error code that is returned is: 28000 Invalid authorization specification The value specified for the argument UserName or the value specified ...Show All

• dutchtrader14 MSSQL 2005: MSSQL service automatically 'stop' after launch Management studio

  After installing the MSSQL 2005 Eval edition, 2 DBs were restored and trying to attach a DB, it failed.  When retry, it shows an error 'An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be cvause by the fact that under the default setting SQL server does not allow remotion connection. (Provider: Named Pipes Provider, error: 40 - conould not open a connection ...Show All

• Marlon Configuration for SQL 2000

  Hi, What configuration steps should I do to enable my .NET web application to access my SQL 2000 database I have SQL Server 2000 SP3, SQL 2005 Express, SQL 2005 and VS 2005 installed on the same machine. Is it anything to do with the NT Authority\Network Service or ASPNET account that I need to allow access to or what Kinda lost here... been banging my server for the past week. Cheers! That is also my ne ...Show All

• lnessling Export database from SQL server 2005 to 2000

  Hi I need to transfer schema and data from SQL server 2005 to SQL server 2000. Backup had been perfect, but a backupfile made by SQL server 2005 can't be read in SQL server 2000. I seach for a solution but I did not found any. Is there someone that have a solution Hi, either make an import from the 2k server or an export from the 2k5 server via DTS Assistent. Another but more complicated way would be to create scripts of your da ...Show All

• Kiran Babu Create New SQL Server Mobile Edition Database

  Hi, I follow the instruction to install SQL Server 2005 Mobile Edition, but when I try to change the Data Source to add a new connection, I don't find "Create New SQL Server Mobile Edition Database". Does anyone know how to fix this Thanks Paolo Giorgio Thank you, but it still not working. We follow your instruction, reboot the PC, but the Dataprovider still not in the list of the Data Sources. Any ...Show All

• pedron Reading compressed files - problem with x00

  I am trying to read a 36 byte files that contains compressed data. I create my Flat File data source and SSIS reads it fine UNTIL it hits a x00 in the file. Then it stops reading and I can't get any data after it. There is data after the x00. Here the entire hex string: C7 C7 CF 6A 00 00 05 02 3D 03 21 01 E0 02 00 00 00 00 00 00 00 00 3D 3C 1E FD 02 C8 00 00 00 AE 41 E3 28 7C To test, I changed the two x00 in bytes 5 and 6 to x01 and SSIS rea ...Show All

• vladMD configuring a database in sqlserver?

  I am learning dotnet thru Microsoft Official Curriculum and I got stuck up at one point. That is I couldn't configure the required databases according to the sql server I have installed and configured. I created a doctors database and while configuring using the below code I couldn't know what is '\ASPNET' in "SELECT @s = @@servername + '\ASPNET'" Also what is 'webuser' ---Configure Doctors USE doctors GO DECLARE @s varch ...Show All

• Karthik - MSFT SQL Server Express EULA

  Hello, I want to use SQL Server Express 2005 as the database server for a commercial web site. Web site users will have both anonymous and non-anonymous access to web pages on the site (generated from data in the SQL Server Express database). Is this kind of use within the EULA of SQL Server Express 2005 That clause is being removed from the SP1 license so you can safely ignore it. SQL Server Express can ...Show All

• JTDSpoons RMO On Sql Server 2000

  Hi. I'm using RMO to connect to a MSSQL 2000 Server to manage replication. I've successfully connected to the server, created the distributor, publication, articles and subscriber. However, when i try to manage the agents (ie. TransPublication. StartSnapshotGenerationAgentJob ) it says the method is only supported on MSSQL 2005. Is there any way I can control the agents from RMO on sqlserver 2000 Tore Birkeland ...Show All

• orac123456789 Making outbound HTTP requests from SQLCLR

  Hi, I have written a C# console application that adds a message to a SB queue and a C# stored procedure that reads the message from the queue. I have had so many problems that I'm beginning to doubt the usefulness of this, but that is probably just my frustration speaking. I am stuck on putting an XML message into the queue and reading the XML in the stored procedure. The console app has a simple object called Message. This class has ...Show All

• Jonas Folleso Communicating between 3 Service Broker instances

  I have a problem. I am trying to set up Service Broker communication between 3 machines, all running the September CTP release. I have included the scrip (edited) that I used to setup the 3 machines. This scrip refers mainly to what was done to server1, with comments to indicate which parts were done on the other servers (commented out the connectionstring property to indicate a change of server) I also added comments to indicate the copying/del ...Show All

• Terry Denham Process Question

  When a report is requested from SSRS 2k5, what steps are taken between the machines to generate and draw the report Here's what we are seeing: When we request a report using the web ( http://<report server>/Reports), a few of our reports are taking 15+ minutes to render. During those 15+ minutes we have looked at CPU utilization on the client machine, the SSRS server and the database server (3 different machines) and the CPU is running ...Show All

• Ravenet Generating packages using C#

  Hi, we would like to generate SSIS packages(connections, data flow tasks, etc..) programatically using C#. Is it possible to do so At present we are creating packages by dragging and dropping required componets from toolbox and configuring them manually. We have a requirement of creating around 300 packages every week. Manual creation of packages is really a nightmare. I heard from one of friends that using c# we can create packages. ...Show All

• Wolfgang K. multiple instances

  Does SQL Server express support running multiple instances of database http://msdn2.microsoft.com/en-US/library/ms165614(SQL.90).aspx Yes. ...Show All

• rrmadhav SQL Server 2005 CLR integration problems with unmanaged code

  Hi, With SQL Server 2005 I'm trying to define a CLR integration UDF that calls unmanaged C++ code contained in a .dll. I have the following two signed assemblies: 1) 'wrapper' - this assembly is basically a wrapper class writen in C++ managed extensions code that calls a legacy library written in unmanaged C++ 2) 'provider'- this assembly offers services some of which are contained in the 'wrapper' assembly. This class is written in C# and i ...Show All