Hi all,
We have a remote server which runs SQL server 2000 DEV edition. We have 4 databases running in it. Our application needs the feature of Full Text Search in all the four databases. We have installed the necessary services. The problem is that we are able to create FTS on one database but when we try to run FTS on other databases the MSSearch service stops. on restarting it mssql stops. we are not able to do FTS on more than one database.
We had tried the same in our local server but it is working fine. The only difference between the two is that the local machine are member server. Has this to do anything with the FTS? Meanwhile the eventviewer doent help much, it just tells that the mssearch engine has stopped unexpectedly and it has done this 'n' time.
I was installing application software that was trying to install SQL Server 2005 and received the following error message.
"Setup failed because Service MSSQLServerADHelper is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property profile enabled."
Simple fix for most but I do not know how to do what it asks.
I'm new to SQL Server Express. But I need to find out how easy it is to create custom types with SQL Server Express because we have to represent house numbers as a custom type in the database. After enabling the CLR integration with the SQL Server Surface Area Configuration tool, I created an SQL Server Project with VS 2005 Pro., created a custom type called HouseNo, deployed it to a database and finally created a table with a column of that custom type. But when I tried to use the option 'Show Table Data' for that table, the following errors always appeared
SQL Execution Error
Executed SQL statement SELECT NP.ToString() AS NP From Table1 Error Source : .NET SqlClient Data Provider Error Message : Execution of user code in the .NET Framework is disabled. Enable "CLR Enabled" configuration Option. -- I think I've already enabled it.
Does anyone know how to solve the problem? Just one more question, for a custom type implementing the IComparable interface, would SQL Server Express uses the CompareTo method to perform sorting?
Thanks!
Regards, Nathan ---------------------------------------------------------------------------------------------- The SQL Server Epxress is newest and the following is code for the custom type.
--------------------------------------------------------------------------------------------- using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server;
[Serializable] [Microsoft.SqlServer.Server.SqlUserDefinedType(Format.UserDefined, IsByteOrdered = true, MaxByteSize = 8000)] public class HouseNo : INullable, IComparable, IBinarySerialize { // Private member
I'm trying to create a database that takes specific information from a number of databases on different servers to make some reporting that we have much easier.
I'm pretty new to SQL so I'm not sure of the best way to proceed. I read an article that suggested I use the OPENROWSET command. The problem is, the version of SQL that came with one of the programmes we use is limited and will not allow you to turn on the allow "Ad Hoc distributed Queries" so the SLQ statement will not execute.
I'm confused why it won't let me to connect through ODBC as I've created a web page that selects data from this database with no problems!
Here is the SQL statement that I've written to make sure it is the correct one (on the msdn library page it said that this was the ODBC connection):
SELECT a.* FROM OPENROWSET('MSDASQL','DRIVER=(SQL Server);SERVER=APPOLOACT7;UID=sa;PWD=***************', 'SELECT * FROM MDCTestAndDev.dbo.TBL_CONTACT') AS a
I've also created the ODBC connection using the tool on Administration Tools>Data Sources ODBC
Any help would be greatly appreciated (also any ways of selecting from one database and inserting it into another will be helpfull)
I am using SQL Server 6.5. By default TCP/IP protocol is not enabled (1433 port is not opened by the server). How can I enable this so that I can use a JDBC driver to connect to it.
In SQL Server 2000, the "SQL Server Network Utility" helps us to enable the TCP/IP protocol. But not able to figure our how/where this can be done in 6.5.
I have SQL 2005 (v9.0.3042) on Windows Server 2003. The sql server is running under LocalSystem account.
I am trying to enable SSL encryption as described in the article http://support.microsoft.com/kb/316898. I have logged onto the machine as an administrator when creating a new certificate request in MMC. I have set "Force Encryption" to true on server and restarted the server.
However all my clients (.net code, SQL Server Management Studio) successfully connect to the server without "Encrypt=Yes". I expected to see a ssl error or some kind of error denying connection because the cliend did not request ssl ecnryption.
what am I missing? any help would be greatly appreciated.
I have log shipping enabled on databases(primary and secondary) and works fine. I need to implement TDE on the database. I have experience on implementing TDE on databases which are not used for log-shipping.
What are the steps needed to setup TDE which are involved with log-shipping.
Hello, I try to get the full-text search on SQL Server Express with advanced Services SP2 running, but I got some problems. First I tell you what I did. I created a new database called TestDB.
Then I created a TestTable inside the db with a Primary Key:
sp_fulltext_database enable create fulltext catalog testcatalog as default create fulltext index on TestTable(text) key index PK_TestTable
Now the problem: When I insert some rows in the Table the catalog get not populated. (change Tracking Setting is set to auto) Instead these error messages are written into the crawl log:
Error '0x80004005' occurred during full-text index population for table or indexed view '[TestDB].[dbo].[TestTable]' (table or indexed view ID '2073058421', database ID '5'), full-text key value 0x00000002. Attempt will be made to reindex it.
The component 'sqlfth90.dll' reported error while indexing. Component path 'c:ProgrammeMicrosoft SQL Server90COMsqlfth90.dll'.
I'm connected to my instance locally using Enterprise Management Studio. I click the node 'Management', right-click "Full-Text Search", and click Start. I get this error message. Any ideas?
===================================
Unable to start service MSFTESQL on server PAUL-PC.
===================================
Access Denied (ObjectExplorer)
------------------------------ Program Location:
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32 returnValue) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
Is it possible to standardize sql views or functions to filter data for the user, before they view the report? For example if I have a SQL view that filters for "green, cotton-made socks", can this somehow be an option among others before a user presses "view report?"
A response is greatly appreciated. If this is possible, how ?
Our software applications require the sa login to be enabled. We have a .NET (C#) installation application that installs our software applications.
So, is there any way that we can programmatically enable the sa login for SQL Server 2005? Ideally, we'd like to code this into our installation application.
I have a report that can accept two parameters name or address. So if the user selects the name the dropdown for address should be disabled. if the user select an address the name dropdown should be disables?
is it possible to do something like this in SQL Report
I have an application that will deployed on LANS running 1- 10 systems on average.
The front end is C#.net 2.0 and the backend will be sql express.
I need to enable remote connections by default because 99.5% of our customers have 2 or more computers.
I have two questions:
1) How do I enabled remote access during installation? Can I run the sqlExpress install silently and turn this on so that my users (who are very non-technical) do not have to go into surface configuration and turn on network access?
2) If I already have sql express installed (like on my development machine now) how do I enable remote access via a command line utility without having to run the surface configuration tool? I want to be able to execute a command to turn on network access so my users don't have to go to a GUI tool(Surface area configuration) and turn it on themselves. Can I use sqlcmd to turn on network access or some other command line utility that I can execute easily. Perhaps there is some type of .NET assembly that I can reference from within my C#.net application that will allow me to enable remote access? Basically How do i take care of this without making my users have to do it?
I have log shipping enabled on databases(primary and secondary) and works fine. I need to implement TDE on the database. I have experience on implementing TDE on databases which are not used for log-shipping.steps needed to setup TDE which are involved with log-shipping.
I have a report where a particular row may or may not need to drill down, depending on whether or not there is more than one row grouped within it. I was wondering if there is some sort of property I can access that will enable or disable a drill down. I know where to go to do it in the IDE, but this is something that needs to happen at runtime.
I have followed the steps multiple times but when I go to add the Data-Driven Subscription, the option is disabled. The report's datasource is setup to use stored credentials and the server Mail is setup. Is there another prerequisite that I'm missing?
Im getting ASP.Net 2.0 Beta 2 setup on my home machine to kick around with. Im assuming this error means i have SqlServer Express mis-configured for integrated security. if so, how do i go about making sure that the ASPNET user has at least read access to the Database? Error Message wrote: Server Error in '/Kinetic' Application.
Cannot open database "aspnetdb" requested by the login. The login failed.Login failed for user 'GAMESASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "aspnetdb" requested by the login. The login failed.Login failed for user 'GAMESASPNET'.
I am trying to enable the FileStream in SQL Server 2012 Enterprise Edition. I can successfully enable "Enable Filestream for Transact-SQL Access" but I am unable to enable "Enable Filestream for the file I/O access". Due to this I am unable to open the folder location of the filetable.
I have log shipping enabled on databases(primary and secondary) and works fine. I need to implement TDE on the database. I have experience on implementing TDE on databases which are not used for log-shipping.
What are the steps needed to setup TDE which are involved with log-shipping.
we wonder about the tradeoffs of t-sql vs clr in sql server 2005 especially from a memory perspective. Is there documentation available on this subject?
We are developing an application that requires change tracking.We tested it in development and test environments and we are preparing our production deployment.The very first thing that needs to be done is an
ALTER DATABASE [db_name] SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)
We are holding on this first step because this statement alone executed for a good 4min on the development server. The production environment is many times larger and busier, and we can’t afford service disruption, so we are at the point where we need to understand what’s involved in running this ALTER DATABASE statement.Is there any documentation on what is happening behind the scene when this statement executes such that we can assess the risks of running it in production?
I have created around 10 seperate packages for our application data load. Now I am planning to create a master package (or a wrapper package) which will execute all the 10 packages (thru execute package task). Then I have a job which executes the master package at a given date and time.
Question : How can I enable / disable execution of each package within the master package depending upon a flag variable. The reason why I need this mechanism is if the flag = 0 then I don't want all 10 packages within master package to execute and if flag = 1 then master package execution should begin and subsequently execute all packages within that master package.
How do we install a certificate for enabling security on MS -SQL Server 2005? I tried to install through MMC but it says no " certificate authority found " . Any help will be highly appreciated , Thanks to you all in advance :-)
I am trying to enable CDC feature in SQL Server 2012 Enterprise Edition ( 11.0.2424.0).The command to enable CDC for Database worked fine, but the command for enabling CDC on Table failed.Command used for enabling CDC on table is as follows.
USE DatabaseName GO EXEC sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'TableName', @role_name = NULL, @supports_net_changes = 1
Following is the error message got
Msg 22832, Level 16, State 1, Procedure sp_cdc_enable_table_internal, Line 623...Could not update the metadata that indicates table [dbo].[TableName] is enabled for Change Data Capture. The failure occurred when executing the command '[sys].[sp_cdc_add_job] @job_type = N'capture''. The error returned was 22836: 'Could not update the metadata for database DatabaseName to indicate that a Change Data Capture job has been added. The failure occurred when executing the command 'sp_add_ jobstep_ internal'. The error returned was 14234: 'The specified '@server' is invalid (valid values are returned by sp_helpserver).'. Use the action and error to determine the cause of the failure and resubmit the request.'. Use the action and error to determine the cause of the failure and resubmit the request.
I have a customer who is looking to encrypt their applications connection to the back-end SQL server. I've gotten a valid certificate for the server from a trusted CA, and it's installed on the server (shows up in Personal certificates in the Certificate MMC when selecting the computer) and I can choose it in the drop down on the certificates tab of the SQL Network protocols properties in Configuration Manager.
Now, my question: If I select the certificate but do NOT enable the "Force Encryption" option, the client will be able to request encryption on their end, and the connection will then be encrypted. If the client (other applications) do NOT request encryption, they will still be able to connect, but their connection will be un-encrypted. URL....
Lastly, I could've swore I had found some information indicating that some methods of establishing a connection to SQL can fail when Force Encryption is enabled, as the method doesn't support SSL encryption.
Hi Friends "I wonder why the boolean values Set to "Disable Property" using expressions does not work as expected (though Precedence constraints work fine). I find no way to disable individual task. "
I have a boolen variable V, (False) enabled by default at design time for a task T, I disable T based on a condition (if A ! = 'a') during runtime.
Now first time when I run the Package, Task gets disabled (works fine on the condition given). However T gets permanently disabled even after we stop debug mode, which is not the expected behavior. Further on when you run, it wont work at all.
Is it true that a task disabled at design time cannot be enabled during runtime via expressions ?
If things are working fine in your case, pls let me know what settings are required.
I have an existing instance of sql express 2005 w/advanced services installed. When I installed I did not install full text search. Is there a way I can enable full text search on this existing instance?
I am trying to create an un-attended SQL 2005 Express install. I have successfully made my own template.ini file to install SQL the way I like but I cannot find a way to make it install with the "Ad hox remote queries" option enabled.
Is there anyway to do this? I can't seem to find any switches in the INI file to allow this.