Answer Questions

• Marc Selman Does SSEUtil.exe have a "errorlevel"?

  I am going to write a DOS batch file to execute a bunch of SSEUTIL command, such as sseutil -run aaa.sql -m sseutil -run bbb.sql -m .... My question is, can I use the following skills to show error message if the aaa.sql failed to be executed SSEUTIL-run aaa.sql -m if errorlevel 1 goto ERROR1 ... Thanks. Thanks Antoine. Very helpful. Hello Tony, ve ...Show All

• Eric Livergood Unable to connect to Analysis Services as a client

  Hi, I got SQL SERVER 2005 SP1 installed on a server and is running fine. I've installed BI studio on a client computer and I can access the database engine. On the client computer, while deloying my cube I get the following error : the project could not be deployed on the server "server_name\instance_name" due to connectivity problems. Verify that the server is running I've checked the project properties and in the deployment section ...Show All

• oivindroed "Failed to load expression host assembly. Details: StrongName cannot have an empty string for the assembly name. "

  I previously had an ASP.NET 1.1 site running on my IIS 6.0 server ( not the default website) with Reporting Services running in a subdirectory of that website.  I recently upgraded to ASP.NET 2.0 for my website and was greeted with an error when trying to view a report.  The error was very non-descript, but when I checked the server logs, it recorded the details as "It is not possible to run two different versions of ASP.NET in the sam ...Show All

• Sakellariou Dimitris Can't connect to SQL Express 2005

  I have a web app running on a laptop (for demo purposes) with the following connect string: "datasource=<machine name>\SQLExpress;initial catalog=BlueTarp;User ID=sa;Password=xxx" I can connect to this instance using both oSQL or sqlcmd and can select from the tables within BlueTarp, but my web app won't connect, and I can't figure out why!! When I installed SQL Express, I used a named instance, called "SQLExpress&q ...Show All

• Anand Raman - MSFT Script Task debug error

  Good afternoon - Info: Microsoft SQL Server Management Studio 9.00.1399.00 Microsoft Analysis Services Client Tools 2005.090.1399.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600 I am trying to debug a script task within a SSIS package by setting ...Show All

• Emma321 SQL Server 2000 & Reporting Services (Report Manager)

  Hi there! My company is thinking about making the switch over from Crystal reports to RS and it's my job to install and test it over the next month.  Unfortunately I seem to be stumbling at the first hurdle!  The installation process went well together with the setup of the sample reports.  At the moment I'm running this on my local development machine: Windows XP SQL Server 2000 SP4 Visual Studio.net 2003 IIS 5.1 RS 2000 SP2 Due ...Show All

• DiegoV Help setting up replication on remote IIS

  Hello, I am trying to setup merge replication for a sqlmobile database. I was able to set it up on a test environment which the sql instance and the iis were on the same box. I am trying now to go live. Our sql instance is on another box than the iis. I am now getting a 404 error when trying to test in the url https://www.domain.com/sqlmobile/sqlcesa30.dll diag Is there a walk through for iis running on a different box, or does someone know ...Show All

• chaminda perera error: 17194

  I cannot use sql connection. This is my connection string 'Conn.Open "Provider=SQLNCLI;Database=dbname;Server=.\\MSSQLSERVER;UID=username;PWD=test123;" The error message appears on browser is Microsoft SQL Native Client error '80004005' Client unable to establish connection due to prelogin failure /Connect.asp, line 8 in SQL server ERRORLOG, it shows Error: 17194, Severity: 16, State: 1. The server was unable to load the SSL provider library n ...Show All

• Andy Thevelein TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host

  We are getting a problem when the below error Log Server: SQL Server 2005 and SP1. Then, All the Web Servers will drop all connections and stop the network service. Later, the network service will start up automatically but all the before service is dropped. We would like to know the error coming from Error Log ================ TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host ...Show All

• Protean Cannot get Stored Procedure parameters in SMO

  Hi , I have tried it all and I cannot seem to get the stored Procedure parameters StoredProcedure sp= new StoredProcedure (mActiveDatabase,spName); foreach ( StoredProcedureParameter spParam in sp.Parameters) { string fldName = spParam.Name; } Now I can see in the Debug Visualizer the spName and other properties however the parameter.count is 0 even though I know for a fact i have 3 p ...Show All

• Rick Wong SQL Server Management Studio Express CTP won't open - why?

  I can't seem to open my SQL Server Management Studio Express CTP anymore.  I need help figuring this out.  I was able to open it before.   I went to the Control Panel>Add/Remove Programs and tried to "repair" the program but nothing changes.  Anytime I double-click on ssmsee.exe, the hour-glass flashes, but the program never starts.  Any ideas why The last thing I loaded was the AdventureWorksBI.msi.  ...Show All

• abruton Task Upgrades, Update and CanUpdate methods.. Why?

  I am writing a new version of a task with and additional property, and wish to support upgrades between the versions. I have implemented the CanUpdate and Update methods, and update the Xml for the new property. The problem I then have it LoadFromXml gets called which promptly fails since it is still using the old version of the Xml. Have I misunderstood the point of the Update mechanism It would seem to me that I’d better off ignoring Update a ...Show All

• KPLNG beginner question - instances VS. separate databases?

  Hi, I hope this is the right place to ask this question. I'm trying to get started programming databases against SQL Server Express. I'm pretty confident in understanding the techniques of how to access a database, a specific table, retrieve rows, etc. However, I’m having endless frustration in understanding the very rudimentary basics of how the SQL system even works. I know I don’t need this information to program against it on a sim ...Show All

• Vijay Patil How to convert DTS with ActiveX scripts?

  I have a SQL 2000 server with several DTS packages with ActiveX scripting. I have tried to migrate these over to the new server but I get an error saying it can't find the data source. It uses ODBC to Oracle and all are defined. So my next task is to rewrite these simple packages in the new SSBI. Is there a sample or tutorial for doing this that would cover converting the scripting Thanks. Sounds like a simila ...Show All

• Bruno Silva INNER JOIN Question

  How do I deny a Innet join(make the inverse) I tried to use <> at the condition but it keeps bringing the equal results... Thanks From what I understand you want to do something like SELECT id, t1.stuff, t2.stuff FROM table1 t1 INNER JOIN table2 t2 on t1.id <> t2.somerelationalid This may help http://msdn2.microsoft.com/en-us/library/ms190014(SQL.90).aspx Using an OUTER JOIN will b ...Show All