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.
Thanks, Bruce
Hi,
while going through the service I noticed that the MSSQLServerADHelper Service is set to run manually.
I wanted to know what this service does and should it set it to run automatically?
Thanks.
I am running a procedure and get
Arithmetic overflow occurred.
(20637 row(s) affected)
does it mean that the procedure failed, but I am still getting # of rows affected, which I think it did do some process, but why the error message
Arithmetic overflow occurred. and what does it mean?
thanks
Ali
Hi,
while going through the service I noticed that the MSSQLServerADHelper Service is set to run manually.
I wanted to know what this service does and should it set it to run automatically?
Thanks.
the service cannot start without two startup parameters
can anyone tell me what these should be?
Hi All,
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
private String number;
private String letter;
private bool m_Null;
public HouseNo()
{
Number = "0";
Letter = "0";
}
public HouseNo(String number, String letter)
{
Number = number;
Letter = letter;
}
public string Number
{
get { return number; }
set { number = value; }
}
public string Letter
{
get { return letter; }
set { letter = value; }
}
public int CompareTo(Object obj)
{
if (obj is HouseNo)
{
HouseNo hno = (HouseNo) obj;
int numCompare = Number.CompareTo(hno.Number);
return (numCompare == 0 ? Letter.CompareTo(hno.Letter) : numCompare);
}
else throw new Exception("Obj is not a HouseNo");
}
public override string ToString()
{
// Replace the following code with your code
return Number+Letter;
}
public bool IsNull
{
get
{
// Put your code here
return m_Null;
}
}
public static HouseNo Null
{
get
{
HouseNo h = new HouseNo();
h.m_Null = true;
return h;
}
}
public static HouseNo Parse(SqlString s)
{
if (s.IsNull)
return Null;
HouseNo u = new HouseNo();
// Put your code here
return u;
}
#region IBinarySerialize Members
public void Read(System.IO.BinaryReader r)
{
Number = r.ReadString();
Letter = r.ReadString();
}
public void Write(System.IO.BinaryWriter w)
{
w.Write(Number);
w.Write(Letter);
}
#endregion
}
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.
Thanks for any help
I'm trying to enable the Service Broker for Sql Server 2005 because I want to be able to use a SqlDependency object.
I ran the following query to see if my local sql server service broker was enabled:
SELECT is_broker_enabled FROM sys.databases WHERE name = 'dbname';
It came back with a value of 0 (which means it is not enabled).
I tried executing the following sql command to enable it:
ALTER DATABASE dbname SET ENABLE_BROKER;
The query has been running for over 5 mins and just keeps spinning (should it take this long to enable the Service brfoker), so I cancel it.
I even try to issue the command to see if the service broker is enabled after I cancel the query and it is not enabled.
How can I properly enable the Service Broker?
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.
Please help
Thanks
Smitha
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.
thanks
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:
CREATE TABLE [dbo].[TestTable](
[id] [int] IDENTITY(1,1) NOT NULL,
[text] [ntext] COLLATE Latin1_General_CI_AS NULL,
CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
Then I executed these commands:
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'.
Can somebody give me a hint?
Greetings,
Phillip
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()
Hello:
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 ?
Many thanks.
Hello.
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.
Thanks.
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
Thanks
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?
thanks in advance
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.
View 2 Replies View Related
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.
Thanks!
I am trying to go through the MS tutorials on creating Data-Driven Subscriptions.
http://technet.microsoft.com/en-us/library/ms169673.aspx
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?
helloi use Visual Web Developer and SQL server 2005 express , how can i enable service borker of my sql server ?thaks for any helpderin
View 1 Replies View RelatedIm 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'.
Source Error:
Line 13: protected void Page_Load(object sender, EventArgs e)Line 14: {Line 15: Membership.CreateUser("jeff", [password], [email]);Line 16: }Line 17: }
Source File: c:InetpubKineticDefault.aspx.cs Line: 15
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.
View 3 Replies View RelatedI 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?
View 8 Replies View RelatedI was wondering if it was possible to incorporate sql views or functions that filter data on the top bar for users when they run a report.
a response is greatly appreciated! If so, how?
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?
Hello,
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.
Thank you
Jatin Shah
Hi ,
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 :-)
Best Regards,
Sudhansu Tiwari
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.
SSISDB 2014 - Enabling CLR - Is there are kind of security risks for enabling CLR when creating SSISDB?
View 0 Replies View RelatedI 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.
Thanks
Subhash Subramanyam