SQL databases and SBS 2003

SQL Server Express

Index ‹ SQL Server

- Previous
  - 1
    - SSIS Connection Manager passwords I downloaded Service Pack 1 for Visual Studio 2005, Version 8.0.50727.762 (SP.050727-7600), but I still get this error message. I tried the SA username and password for the connections in connection manager, but even after I checked the save password box and close the connection and reopen, it gives me the following error message: "Test connection failed because of an error in intializing provider. Login failed for user 'sa'." Tag: SQL databases and SBS 2003
  - 2
    - How to drill down on fields Hi Jens , Thanks for did that and am able to see the data .. Tag: SQL databases and SBS 2003
  - 3
    - System.Data.SqlServerCE.dll reference causes error ... What happens if you remove this reference again - does it go back to working properly Have you added a reference to the correct version of system.data.sqlserverce.dll (see this post across at www.sqlserverce.org ) as this might be a cause - although it normally manifests itself as a build error rather than a runtime issue. Tag: SQL databases and SBS 2003
  - 4
    - Deploying reports to MOSS 2007 The TargetDataSource Folder is http://vpc001/ReportingServices/DataSources, the TargetReportFolder is http://vpc001/ReportingServices/Reports and the TargetServerURL is http://vpc001/ReportingServices. I can see all of these locations. When I try to deploy I get the Reporting Services Login window with the Server set to http://vpc001/ReportingServices . Thanks for your interest in helping me understand what is going on here. Regards, Michael Tag: SQL databases and SBS 2003
  - 5
    - How To Set Multiple ReadOnlyVariables in Script Component in Integration Services 2005 Triple-check your spelling and the scope your variables are defined in. I got the error just this morning and it was a spelling problem. Tag: SQL databases and SBS 2003
  - 6
    - Help with expression to display a per-week daterange value! Thanks for the help, it worked well. I had to add SUM(Fields!Rejections.Value) and SUM(Fields!Amount) to add the rejections and amounts up for each line per week, but in all, it did work! I bet you assumed I knew that, but I didn't, but I did figure it out. Now my issue is how do I make it so it shows all the weeks Refer to my goal example above. I was able to replicate Jarret's results, but I'd like it to show the missing weeks of 2,3,5,6 with 0 values. Keep in mind there are no data that falls into these weeks, I just want to display the weeks and show 0 as values for both rejections and amounts. What do i need to put into the expression to place so-called "dummy" weeks on the report Tag: SQL databases and SBS 2003
  - 7
    - Trigger programming SQL 2005 vs SQL 2000 First, I would carefully examine and ask WHY a CURSOR is being used in a TRIGGER. In almost all situations, the use of a CURSOR in a TRIGGER is a very bad idea. It increases the lenght of the TRANSACTION, holding locks longer than necessary, increasing the chance of blocking behavior. Almost always, a CURSOR in a TRIGGER is the result of not understanding how to process SET based data. My recommendation: Post the entire TRIGGER code and the TABLE DDL. Folks here will help you determine if there is a more efficient method to accomplish the task. You will get excellent assistance to make your database operate more efficiently. Tag: SQL databases and SBS 2003
  - 8
    - Problems with Roles and sp_helpRoleMember This is a windows authenticated user. Based on previous posts in this forum, I've already looked at those 2 tables (principals and rolemembers). Indeed, the guy's principal ID never is added to the rolemembers table when I check off the role for that guy's login or use sp_addrole. Either I don't have permissions (which I do - Admin) or something is overriding this guy's role configuration. And why would he only see 1 from sp_helprolemembers and I see 20 Please help me make some sense on what's happening... (thanks for your reply Buck) Tag: SQL databases and SBS 2003
  - 9
    - Join Using a substring function I already have a SQL script (SP) that works fine, however what I am trying to achieve is get rid of this SP/view concept and replace with SSIS packages/tasks/transformations. Thanks for helping. Tag: SQL databases and SBS 2003
  - 10
    - What's wrong? Whats the statement just before the IF statement Remember, @@ROWCOUNT gives you the number of rows affected by the last processed statement within the batch. Its good practice to always set the value of @@ROWCOUNT to a variable if you're going to use the value later on in a stored procedure. Tag: SQL databases and SBS 2003
  - 11
    - error 1155 message Can anyone help please, I'm trying to install post smile. www postsmile.com. I keep getting the error setup message. Unable to execute file code 1155 Shellexecute Ex failed. I haven't a clue what this means except it won't connect me to the site and I have paid for this and entered the code. I've altered my firewall to accept it in case it was this but still no luck.Is it a fault with the company or my computer Many thanks in advance. Tag: SQL databases and SBS 2003
  - 12
    - Running job error in schedule Dear rottengeek, I have found that there is no that check box saying show step details. Please advise if you have any further instructions. Regards, LG Tag: SQL databases and SBS 2003
  - 13
    - Image insertion to ss2005 from Windows Mobile Hi , I am trynig to insert an image from the Windows mobile to the SQL database. Is it possible to perform this using RDA After some search in this forum , I got an impression that the only way to do this by storing the image in a local database and then do a merge replication. I do not want to do the merge replcation just fo rthis reason. Is it possible in RDA Debugging shows only some part of the data is getting updated. While trying to retrieve the image in a webpage error is poping up. My code is : string strbytes = ( Convert .ToBase64String(bytes)).ToString(); DbObj.GetSubmitSql( "Update Odrs set SignedBy ='" + txtSign.Text + "', Signature = Convert(Image,'" + bytes + "') where OrderId=" + orderNo + "" ); Please help.... Tag: SQL databases and SBS 2003
  - 14
    - error hi thanx for reply now i m getting this error Server: Msg 241, Level 16, State 1, Line 1 Syntax error converting datetime from character string. Tag: SQL databases and SBS 2003
  - 15
    - Second opinion on how to build this cube Thank you for your reply. Please can you guide me on how to "get AS to perform the same functionality as the lookup" mentioned in your reply. Or do I need to perform this "lookup" functionality if I attached the "population" measure to the main "production" table cube and shared the dimensions in the "dimension usage" tab. I would think once I share the dimensions between the two measures, AS will automatically know where the "population" measure is associated with the dimensions. Thanks. Tag: SQL databases and SBS 2003
  - 16
    - Named Pipes Provider, error: 40 - Could not open a connection to SQL Server Nan, Before I get on with this post - thank you for your reply. The XPSP2 machine actually had the firewall disabled, and I verified that it could accept connections on the the associated ports with the Shields Up utility. I tested this on both machines. I can connect to the server from the XPSP2 machine, Import / Export, manage, view logs, and do everything EXCEPT get the Copy Database package to run. SQL Server Agent always fails on the last step with the following error: Event Type: Error Event Source: SQLISPackage Event Category: None Event ID: 12550 Date: 1/10/2006 Time: 1:34:15 PM User: NT AUTHORITY\SYSTEM Computer: 401SERVER Description: Event Name: OnError Message: Failed to connect to server BETHESDA. StackTrace: at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() at Microsoft.SqlServer.Dts.Tasks.TransferObjectsTask.TransferObjectsTask.OpenConnection(Server& server, ServerProperty serverProp) InnerException-->An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) StackTrace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.Common.ConnectionManager.InternalConnect(WindowsIdentity impersonatedIdentity) at Microsoft.SqlServer.Management.Common.ConnectionManager.Connect() Operator: NT AUTHORITY\SYSTEM Source Name: BETHESDA_401SERVER_Transfer Objects Task Source ID: {86F355AD-3B74-4D7B-8D2D-C743C790A269} Execution ID: {91B7C32C-C439-4EDB-8A0F-9F8BF207BC06} Start Time: 1/10/2006 1:34:15 PM End Time: 1/10/2006 1:34:15 PM Data Code: 0 For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp . Have you (or anyone else) successfully executed a Copy Databse task Steve Tag: SQL databases and SBS 2003
- Next
  - 1
    - MDX calculated measure Thanks Bryan, I will try something like you described above. Do you know if there is a way to get a value from a specific level in the hierarchy I can get the values I need but I have a problem to write the mdx question that will give me the percent value as answer. With one of these code samples I get the values that I want to divide in the calculated measure (They give the same result) 1. Code Snippet distinctcount ([Customer].[Customer]. members ) 2. Code Snippet COUNT ( CROSSJOIN ({[Measures].[Sales]}, {[Customer].[Customer]. members }), EXCLUDEEMPTY ) For example: Vendor1 10 Article1 8 Article2 5 Article3 10 Vendor2 26 vendor3 54 Vendor1 have a total of 10 customers and Article1 are sold to 8 of those customers, Article2 to 5 and Article3 are sold to all 10 of the customers. What I want to do is to have a calculated measure that divides Article1 value with Vendor1 value(8/10), Article2 value with Vendor1 value (5/10) and so on. The values are from the same code sample so Vendor1s value of 10 uses the same code as the Article1s value (distinctcount([Kund].[Kund]. members )) And Code Snippet distinctcount([Customer].[Customer]. members ) / distinctcount([Customer].[Customer]. members ) wont work of course I want to have a calculated measure that dont change when I drill down Vendor. Like: A B Vendor1 10 10 Article1 8 10 Article2 5 10 Article3 10 10 Vendor2 26 26 Vendor3 54 54 Then I just need to divide A / B*100 and I have the value that I need. If someone knows how to do this I would be very happy Tag: SQL databases and SBS 2003
  - 2
    - SQL 2005 Pull Subscriber stuck "Uploading data changes to publisher" I haven't run the profiler yet, but all dependet objects are included in the publication. While doing some more testing, I realized that the two suspect subscribers have another symptom in common. A simple update query on a simple table with 10 rows took over a minute on both databases. I looked in the activity monitor and couldn't find any locks on the object. As soon as I stopped the merge agent at the subscriber, the query ran instantly! I started the agent back up, and again, the query took over a minute. Is my best option to just drop and recreate the subscriptions This is possible now, since we aren't in production yet and the amount of data being reintialized is small enough to replicate within a few hours. Should I drop and recreate the publisher and all subscribers I feel like it is best to start on a clean slate while I still can. Drew Tag: SQL databases and SBS 2003
  - 3
    - How to export to a fixed width flat text file with row delimiters? To make this work so that each row is exactly the same length, you may need to add a zero length column as the last one in the connection manager, and set the row delimiter on that one. Tag: SQL databases and SBS 2003
  - 4
    - Management Studio - Script Date Comments These auto generated by SMO Scripter Options. By default it only have the following options, IncludeHeaders IncludeIfNotExists DdlBodyOnly DdlHeaderOnly ExtendedProperties ScriptDrops I am not sure whether we can change these settings on Management Studio or not. But on SMO we can control all these. Tag: SQL databases and SBS 2003
  - 5
    - Grouping records IF I understand you correctly, you may want something more like this: Code Snippet SELECT DISTINCT w.SummitId, r.ReqDtLs, a.AreaName, l.LocNo, t.TownName FROM TownList t JOIN Area a ON t.TownCode = a.TownCode JOIN Locality l ON a.AreaNo = l.AreaNo JOIN WebRequest w ON w.AreaNo = a.AreaNo JOIN RequestType ar ON r.ReqID = w.ReqID WHERE ( w.DateOfRequest >= dateadd( month, datediff( month , 0, getdate() ) -1 , 0 ) AND w.DateOfRequest < dateadd( month, datediff( month, 0, getdate() ), 0 ) Without sample data, we can't test our suggestions. Tag: SQL databases and SBS 2003
  - 6
    - rank Ordering Hey Darren, Here is the MDX i use to create the Rank. CREATE MEMBER CURRENTCUBE .[Customer Rank] AS IIF ([Measures].[Sales Amount] = 0, NULL , Rank ([Customer].[Customer Group Name]. CurrentMember ,[Customer].[Customer Group Name]. CurrentMember . Level . Members ,[Measures].[Sales Amount])), VISIBLE = 1; Any advice Thanks again Scotty Tag: SQL databases and SBS 2003
  - 7
    - Special charecters in SQL server See if this helps. Identifiers http://msdn2.microsoft.com/en-us/library/ms175874.aspx AMB Tag: SQL databases and SBS 2003
  - 8
    - Retrieve name of running stored procedure Hm, I was trying to find a way to accomplish that WITHOUT having to write the name of the stored procedure in it. But thanks anyway. :-) Tag: SQL databases and SBS 2003
  - 9
    - How do I do "If statement" in SSIS? To add to Wenyang's answer...you will need to use the Conditonal Operator within the Derived Column transform. : (Conditional) (SSIS) ( http://msdn2.microsoft.com/en-us/library/ms141680.aspx ) Wenyang, I don't thinkyour answer is complete. Do you really think it warrants being marked as an answer Hope you don't mind me asking. Regards Jamie Tag: SQL databases and SBS 2003
  - 10
    - Cannot Reference Database.Tables Collection By TableName --? Yes indeed, the schema was the issue. I could not access the item in the collection using schema.tablename, but rather using this syntax: Code Snippet db.Tables["EmployeePayHistory","HumanResources"] Thank you for your help! Tag: SQL databases and SBS 2003
  - 11
    - Importing data into SSE General E Pist wrote: 1 - Is there some way to connect a machine DSN to a database in SSE that is other than 'Master' 2 - Are there better ways to import data into SSE 3 - Is there some way to move or copy a table from one SSE database to another Yes, if you go through the configuration step when you create your DSN, or just click configure when selecting an existing DSN, you have the option to set the database context for the DSN. The option is disabled by default, you need to check the box that says 'Change the default database to' at which point you will get a dropdown listing all the database on the server. Obviously you need to have access to the database in order to export into it. Better is a relative term, alternate ways would be a more appropriate description. In addition to simple Export from Access, you can also use: Access Upsizing wizard, SQL Migration Assistant for Access, BCP utility and Linked Servers. (The inverse of Linked Server is a Linked Table in Access and then run Append queries to move the data.) DTS will work against Express if you have it installed with another edition of SQL. As folks have found, there is no way to get the DTS wizard to showup in Management Studio Express. For structure only you can use the scripting option within Managment Studio Express. If you want to move the data as well, you could acctually just write a normal INSERT query and use three or four part naming to handle the Database and Server barrier, for example: INSERT INTO servername.databasename.schema.table ... You could also use the Database Publishing Wizard which scripts out your database (scheam and data) and then run the scripts for the new database. There are undoubtable a number of ways to do this using SMO if you want to code it yourself, but I figured I'd stick with the more straight forward methods. Mike Tag: SQL databases and SBS 2003
  - 12
    - JDBC Driver for SQL Server 2005 Can any version of the SQL Server 2000 JDBC driver connect to SQL Server 2005 or do I have to install the new JDBC version 1.1 to connect to my 2005 instance Tag: SQL databases and SBS 2003
  - 13
    - Strange Exceptions with views usings casts on 2005 (worked fine on sql2k) I'm not actually trying to cast 'AA' as in int. The sql for the view should only return the values in the 'Type 2' items which are numeric. The error is the fact that it is trying to convert something that i have not requested i.e. 'Type 1' items Tag: SQL databases and SBS 2003
  - 14
    - Operating system error 38(Reached the end of the file.) on file "C:\Data\myfile_log.LDF" Hi, The issue is that the client did not backup since 3 weeks (his mistake) and the only solution is to restore from the corrupted files that they have. I tried your solution but it did not work. This is the error that i got when i ran (CREATE DATABASE FOR ATTACH_REBUILD_LOG ): The log cannot be rebuilt because the database was not cleanly shut down. Thanks for your reply, Tarek Ghazali SQL Server MVP Tag: SQL databases and SBS 2003
  - 15
    - what permission do I need to grant ? I have created this linked server object already and I can read it now as a sysadmin. another user called eis that is not a sysadmin. EIS user want to access tables in the linked server e.g as400link which created by me as a dba. DO I need to grant any permission to access those tables to EIS or I must create a new user EIS in AS400 database and grant select permission to EIS in as400 there but EIS user in sql server 2005 is not a sysadmin so EIS user can't create a linked object. That is the problem. or I must grant sysadmin permission to EIS user so that he can create a linked server in sql server 2005 and I need to create a user EIS in AS400 and grant select permission there Thanks Tag: SQL databases and SBS 2003
  - 16
    - Mining structure Processing Event Notification Raymond This helped fix the issue thanks for your response -anil Tag: SQL databases and SBS 2003

Just Guessing

I have run into this issue repeatedly when installing applications on SBS 2003. The application needs a database and looks for one when installing. It sees the SQL 2000 databases pre-installed on SBS 2003 for monitoring and reporting and assumes it can use them. Ultimately the program grinds to a halt because these instances cannot be used for the application (I'm assuming). The program should install it's own instance of SQL . I end up spending quite a bit of time mending the installation by manually installing some "lite" version of SQL and piecing it to the application.

Is there anyway to use the existing SBS 2003 SQL databases for a new app, like a backup program There is no SQL management software on SBS 2003, so how is that done Should I always install a new instance of SQL server for a new application

I would love to see some official documentation on how to do this.

Thanks!

Top

Re: SQL databases and SBS 2003

Mike Wachal - MSFT

Hi Just Guessing,

You need to discuss these types of questions with the person or company that you got the application from. If these are packages software applications, it is unlikely that you are licensed to modify the applicaiton in the way you are suggesting. As such, if the applications is failing because it detects an existing SQL install, but can't use it, you need to contact the vendor for that application and get their help in installing it.

Mike

Top