Enable sa login on existing sql 2005 database installation.

http://msdn.microsoft.com/en-us/library/ms188670.aspx

Management studio is not available.

To enable the sa login by using Transact-SQL

I see the code snippet but do not understand how to implement the code. Is it run from a command prompt? Sorry I do not know much about how to function with SQL. I am working with my server and I am nervious about running commands I do not understand.

yes from command prompt

I will try it today. Thanks.

basically, what the command is doing is enabling mixed mode authentication..by default, SQL Server only allows windows authentication.  

Why is management studio not available? You can go and download management studio express for free.  Once you've done that, open up a new query window and run the command

SQL will not allow me to update without the SA password with the SQL installation in ACT!. ACT! is really the problem. I am just trying to find a way to get around the crippled version they have installed with the program. With the SA password enabled I should be able to upgrade SQL and/or us a third party tool to generate reports from the SQL database.

Can I run this code from a command prompt or do I have to have management studio installed to be able to run the code? Management studio will not install without the sa password. Access is denied if I try to upgrade and and the sa password is requested. Since the sa password is not enabled I cannot enter it.

That is what I have been up against. Am I missing something or am I on the right track?

You're on the right track..go download management studio express.  

Try the ACTReader utility from http://www.act.com/products/large/cl/services/index.cfm/

Code does not run from a command prompt. Must need to do something else to get the code to run.

SQL server Management Studio will not authenticate to the SQL database. Uses windows authentication mode and will not give me access.

ACT corporate services has not called me back yet. Doenen' seem like I should have to pay for a utility to give me access to my data I have entered in their program I have allready paid for.

Any other suggestions?

The only way is to use the ACTReader utility... ACT! will randomise the SA pass otherwise

Another option is to just use the SDK or something like - http://www.crystalclearreports.com/

Act reader utility allows access to "most" data. Any idea what data it does not allow access to?

Crystalclearreports does not contain the reports we need. Neither does anything else I have looked into. We will have to build our own reports.

Where do you get the word "most" from? It should allow all. The OLEDB interface does have some limitations for memory.

Crystal Clear Reports contains a bunch of standard reports which can make life easier when creating you're own

if I install Crystal Clear Reports I can edit the reports? I was under the impression they could not be edited.

I have finally received work from ACT corporate sales and what "most" data means. According to them ALL data is accessable, only the SA password is not accessable with the Act Reader Utility. It is supposed to give you only read access to the database.