Answer Questions

• kinpin9 Help - How do I create a new instance

  Hi Guys Im new to SQL and I need to create a new instance Help hi, you need to install (and not create) a new instance if no other instance has been already installed.. If you install a SQLExpress instance, by default a named instance named SQLExpress will be installed... it's actual full name will be <ComputerName>\SQLExpress to do that, just run the SQLExpress installer.. if you like to "play" with the advanced options, you can modify the instance name (or install a default instance as well, if not already installed), if remote connections will be enabled (network protocols are disabled by default), modify (if required) the collation settings for sort order and comparations, allow standard ...Show All

• kawano1h Urgent help please!!!!! Error trying to uninstall RS sql 2k5

  Hello, One of our lovely NA's decided to remove IIS and the reinstall it while RS was installed before trying to uninstall RS. So RS broke. We then tried to uninstall RS to start over and get this error: The setup failed to read IIsMimeMap table. The error code is -2147024893 Anyone have a work around to get us to uninstall RS This way we can install IIS 6.0 from scratch and try to install RS afterwards. Thanks. I'm sorry but I am not an admin. Can you please simplify this answer Thanks! ivolved, Ok I copied over the msicuu.exe to the win2k3 box now I see a bunch of 2005 items. Should I just remove the Microsoft 2005 (All users) only or all What is your su ...Show All

• tmigliorino Change Email Task Properties

  HI, How can I programmatically change the properties of Send Mail task using Script Task. I want to change the From, To and Attachment parameters of the Send Mail task. If the Script Task can't do it, Is there any alternative to do Thanks All those questions are answered here: http://blogs.conchango.com/jamiethomson/archive/2006/06/28/4156.aspx -Jamie ...Show All

• prasannakumar63529 Database start trigger 2005

  Hi, I have searched high and low, and can not find any mention of SQL2005 and mount/start database DDL triggers. I need a trigger/job/event to update a column in a table to indicate that the database has been restarted. I can not have an application connect to the database and set this value as I am afraid one of my other computers may connect first and get the wrong state from the database. Is there any way to have SQL2005 update a table on MOUNT/Service Start/DB start Regards, Derek I solved it on my own. I use a StoredProcedure in the MASTER database and set it to start automatically. ~Derek ...Show All

• Dario Galvani Invalid Descriptor Index error

  I'm testing db to db transactional replication on a box ( all on the same box ) and the distribution agent fails with the above error. I know it's something to do with the physical server as this test works on other servers fine. SQL2k Ent sp4 on w2k3 ent sp1. ( clustered ) Server and Agent accounts are in local admins, tried push and pull, named and anonymous. Replication also fails if I use the default snapshot location. I suspect policy restrictions ( maybe on the sql service accounts ) Any pointers would be helpful - there are no errors other than above, sadly. Here is the results I am getting. I am sorry to say this didn't help me much. I also have someone checking a possible issue with the x ...Show All

• Sergey Sotnikov blank passwords

  Is there a way to test for blank passwords on logins using SMO There are no methods or properties in the Login object which will return any password data.  Due to the hashed nature of the passwords you've got some challenges to determining whether or not the password is blank just by reading the password hash as well. Your best bet would probably be to iterate through the Logins collection and for each Login object attempt to establish an ADO.Net connection to the database, supplying a blank password for the connection.  (I used to have a T-SQL script that searched my network for SQL Servers with a blank 'sa' password, until I eliminated that problem here.) Thanks! I also have a Tsql ...Show All

• NeTBaPb How to Synchronize SQL Server Login SIDs

  Hi everyone... On two instances of SQL Server 2005 I am using the same SQL login names, but the SID is different for each one. I would like to synchronize these IDs so that when I restore the production database to the developement database I don't have to remove and re-add the logins. Is there a quick and easy way to do this Thanks, Forch You can create a login with the same SID on the second server using the SDI = sid option on CREATE LOGIN DDL ( http://msdn2.microsoft.com/en-us/library/ms189751.aspx ). -Raul Garcia SDE/T SQL Server Engine While it will take a lot of manual effort, it will do the trick. Thanks! ...Show All

• tala “The attempt to connect to the report server failed. Check your connection information and that the report server is a compati

  Hi, We are trying to implement two SQL server Reporting Services instances on the same machine, so we can have a test environment and a development environment. We already have one instance of Reporting Services which was installed at the same time than the SQL server 2005 database engine instance. Everything works fine. So we went ahead and installed a second instance of reporting services on the same machine. The following components/software are installed on the machine: - DATABASE ENGINE INSTANCE EDITION: SQL server 2005 developer edition - REPORTINS SERVICES INSTANCE: Developer edition - ASP.net 2.0 - IIS 6.0 The following steps were taken in order to add a second instance ...Show All

• Alastair Q loading mining model error

  Hello, I am using SQL Server 2005, and trying to load a mining model : microsoft association rules through a VB.net. When it is loading, this error msg displayed : "An error was encountered in the transport layer. The peer prematurely closed the connection." Any help is really appreciated. Thanks a lot, Mita Are you doing this in a VB.Net app where you've embedded the DM viewer controls The error you're seeing might be due to mismatched client components. Did you happen to have pre-release bits of the client components (the OLE DB provider, msolap90.dll, as well as ADOMD.NET) on the machine where you're running your app Re-installing RTM client components on the machine would fix the probl ...Show All

• tee_user5 performance and tunning

  hi. i have a new question.. how can i make my cube browsing faster since i processed like a million of records into my fact table.. browsing the cube has become really really slow... is there anything i can do to avoid this delay Hi, I have a similar issue with Sp1 + August 2006 hotfix. After a while when 30 to 40 users are issuing 400 to 800 queries against 16 cubes, in a matter of 4-6 hours, the 64 bits As server becomes very slow.It may even refuse any more connections. Users will start cancelling and re-issuing queries like crazy leading to even more performance degradation. I can see that it uses nearly 100% of all 8 CPU's and up to 40GB of page File (I have only 16GB of physical RAM). If I sto ...Show All

• Tadwick conditional display

  To simplify, I have a report with sections A,B, and C. Section A is always displayed. Section B is only displayed when the subject is Male. Section C is only displayed when the subject is Female. I want section B or C to directly follow section A. I have been using the hidden property to do this, but it is hard to maintain the report as I have placed these two sections on top of each other on the Layout tab. Is there a way to make either section B or C directly follow section A without having them overlap in the Layout tab I haven't tried this, but you might be able to put your rectangles/textboxes into a table (each as their own row), then set the visibility of the row to display which section (B or C) ...Show All

• magicalclick how to access named instance throug ip address

  I installed Named instance in SQL 2005 Server ( TESTAV\TESTNETAV ), now i am not able to acces this instance in SQL Query Ana.throug IP Address. i am able to access this instance through name How can i resolve this issue please help me out Thanks Allen for your reply. Now i am able to access Named Instances through IP Address in Query Analyzer, (<ip address>,<port>). Thanks Again for your help. Dear Hans1982, I dont understand what you want to ask, another instance (another PC). if you have 2 different instance in a same cluster then you have you specify different IP Address and different PORT to access this named instance. Default instance can be ...Show All

• Rahul Saxena OleDBException Overflow

  Im getting the following error : System.Data.OleDb.OleDbException was unhandled ErrorCode=-2147217833 Message="Overflow" Source="Microsoft JET Database Engine" StackTrace: at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQue ...Show All

• Behrooz PB Rolap Cubes - Cannot enable real time updates

  I am trying to create a ROLAP cube with 'Enable real-time updates' . When I go to process the cube it fails stating, Creating indexes for Aggregation XXXX CANNOT enable real time updates on this partition without indexed views: <date> Im running SQL Sever 2000 Developer Edition - SP4 on Windows Server 2003 My cube don't use DCount measures ,only simple calculation (sum, count) Can anyone help me debug this Is there any way to get a more descriptive error from Analysis Services Thank you ...Show All

• c_shah SQl Server CE database connection issue

  Hi, I have created my sql mobile database in c drive ( c:\SQlMobile\sqlmobile.sdf).now when i try to connect it with following code, it gives "The path is not valid. Check the directory for the database" error. i have tried all path options but no one is working.please help me. ( i am using visual studio 2005 and SQl server mobile) code: SqlCeConnection ssceconn = new SqlCeConnection ( "Data Source=c:\\SQlMobile\\sqlmobile.sdf;Password=XYZ11!@#" ); ssceconn.Open(); MessageBox .Show( "Ok" ); ssceconn.Close(); i am not running on device.I am using emulator (Pocket Pc 2003 se Emulator).so what should i do for it Ilya's ...Show All