Error when starting SQL SERVER service

Hello all,
When i am starting SQL Server, I am getting an error saying "Encryption Error When starting SQL Server service.. on connecttionbopen.... " What could be the problem ?
Please help me with the steps..
Saiwhat are the log on properties of the sql server services on your server?
have u recently changed the password for the server?
or else try using some other protocol from client/server utility.|||hello Harshal,
Actually when i am logging in to the database using my regular user details i am getting this error. Infact i am not able to see the Properties of the SQL server from the Enterprise manager. When i right Click and select properties of the Service in E.M i am getting the same error.

I tried re-installing the SQL server in the same Directory.. But Still the problem hooks..

What should i do now ?

Sai|||RE:
...I tried re-installing the SQL server in the same Directory.. But Still the problem hooks..
Q1 What should i do now ?
Sai

A1 Much depends on the specific situation.

Some things to consider / investigate:

a If the server was previously functional; what environment changes may have been made prior to the server having the issue, i.e.(where any patches, development environments, upgrades, etc. applied)?

b If the server was previously functional; what was the nature of any activity performed prior to the server having the issue, e.g.(were there any peak / near peak resource utilization conditions present, where load tests, intrusion tests, etc., performed)?

{Somewhat similar issues on development machines may sometimes be traced to such things as corrupted / damaged registry keys and / or dlls. On occasion, the fix is relatively simple, but this is not always necessarily so.}

If inital efforts are unsucessful, and the time / resources to investigate in detail are not available, you may wish to consider completely reinstalling OS, MS Sql Server (from "scratch"). However, if the issue ultimately is caused by a misbehaving custom application or perhaps even failing hardware, it may well re-occur (until any underlying issues have been resolved).

Error when I try to register a server in Analysis Services

Hi,
When I try to register a server in Analysis Services I get a error saying 'Automation error' and I also get a message saying Unable to open Registry Key 'SOFTWARE\MICROSOFT\OLAP Server\OLAP Manager'
Can someone please help.Install service pack 3 for SQL and Analysis Services.|||Thanks for the reply.

SP3 is already installed on the machine. I am not getting this message when I am logged on the machine as a user who belong to the Administrator group but if I log in the same machine as some other user (who is not a member of the Admin group), only then I get this message :confused:

Error when creating a table based function

I'm trying to create a table based function using SMO. The problem is that I get an error saying that I need to set the DataType property on the function before it can be created. However, the documentation clearly says that the DataType property is null for Table based functions. I can't even set this value to null either!

Here's a code snippet that shows what I'm trying to do.

if (returnType.ToLower() != "table")

{

Type clrDataType = Type.GetType(returnType);

returnSqlDataType = GetSqlDataType(clrDataType);

function.FunctionType = Smo.UserDefinedFunctionType.Scalar;

function.DataType = returnSqlDataType;

}

else

{

function.FunctionType = Smo.UserDefinedFunctionType.Table;

function.TableVariableName = xmlNode.Attributes["tableVariableName"].Value;

XmlNode returnTableDescription = GetChildOfParent(xmlNode, "ReturnTableDescription");

XmlNode columnsNode = GetChildOfParent(returnTableDescription, "Columns");

foreach (XmlNode columnNode in columnsNode.ChildNodes)

{

function.Columns.Add(CreateUdfColumn(function, columnNode));

}

}

The xmlNode that is being referenced is an XmlNode that is describing how to create the table. returnType is a variable that is set from one of the xmlNode's attributes.

When I call on function.Create() then I get the error that I posted above. Any help anyone can give is appreciated. One thing I also tried doing was to connect to an already existing Table based function and look at its SMO properties. Sure enough, its DataType property was null.

MSFT: Is this a bug?

Never mind on this post.....it was my mistake. The DataType property not being set wasn't on the function itself, but rather on the columns collection.

Problem solved.

Error when connecting to sql 2000

I am trying to connect to a sql 2k database using a Microsoft Application block. I get the following error. It is saying about 2005, I verified that SQL 2K is running on the server.

System.Data.SqlClient.SqlException: 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

Any help will be appreciated.

Hi,

1. Verify the firewall have open the port of SQL 2K,

2. the Service pack versión I have some problems with versions under sp4

greetings.

|||

Hi jijo_robert,

That's a common issue. If you perform a search through google for the error message you are getting, you will find many valuable solutions.

The first thing for you to do is to check your connection string, make sure you have used the correct server name, database name , authentication mode,,.etc

If you still cannot figure it out, open up your query analyzer and connect to your database manually, see if you can login this way(there is a possibility that there maybe some problem in the server side)

Hope my suggestion helps

|||I could connect using sql query analyzer. I can also connect during design time (Gridview --> SQLDatasource --> and see the records with a connection string) but when I run it it gives this error.|||Make sure that you don't have any other program using the database other than Visual Web Developer if that is what u're using, or having the connection open. What mostly cause this kind of problem is when you have your database open in the database explorer of your VWD or VS.Hope this works.Please give me the appropriate make if this works for this is my first post on the forums|||

No other program is using SQL server databsae