Create Second sa Account (sa2) on SQL 6.5?

On the latest SQL 6.5 with the latest SQL 6.5 service pack, what's the
trick to creating an account besides sa that has the power to create
databases? I was thinking of calling this account 'sa2'. Why do this?
Well, my boss asked me to do it because of a SOX audit + SAS-70 audit
kind of thing.

I tried using the GUI to do it, but then when using the GUI as sa2, I
find the "Create Database" has been greyed out.

I have a funny feeling that the only way to get this is to hack the
sys* tables, which is a little risky.

Oh, and trust me, if I had the political weight in my company to get
off SQL 6.5, I would, but I don't. And mgmt already knows that SQL 6.5
is past support timeframe and is a ticking timebomb.Sounds like the SOX audit has given you another excellent reason to upgrade.
Tell the boss.

Sorry, I'm not familiar with 6.5. In 7.0 or 2000 you would create a login
and grant it the dbcreator or sysadmin role. I don't think this was the same
in 6.5 though.

--
David Portas
SQL Server MVP
--|||(googlemike@.hotpop.com) writes:
> On the latest SQL 6.5 with the latest SQL 6.5 service pack, what's the
> trick to creating an account besides sa that has the power to create
> databases? I was thinking of calling this account 'sa2'. Why do this?
> Well, my boss asked me to do it because of a SOX audit + SAS-70 audit
> kind of thing.
> I tried using the GUI to do it, but then when using the GUI as sa2, I
> find the "Create Database" has been greyed out.
> I have a funny feeling that the only way to get this is to hack the
> sys* tables, which is a little risky.

On SQL 6.5, there is one 'sa' and that's 'sa'. You can login with
Windows Authentication, and if you belong to BUILTIN/Administrators
you will be sa, not DOMAIN\User as on later versions.

As for the particular example of CREATE DATABASE, this is something you can
give to other users, by means of the GRANT statement. But you cannot
granr all rights that 'sa' to other people.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Create new database by the help of app_data folder without sql server express

I am using sql server 2005 developer edition with service pack 1
I have uninstalled sql express.
How Could I create new database by the help of app_data folder without sql server express.
That is when i right click on app_data folder and try to make a new database it give me the following error.

Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251

I don't want's to install sql server express and want's the functinality of creating a new database via App_Data folder.What Can do ?

You could do as the error message suggests, and install SQL Server Express 2005 or just not create a SQL Server Express database at all. Error messages don't lie (at least not most of the time).

Ryan

|||

In the interest of helping me through my learning curve, I think I understand the problem. Let me try to explain it, in the hope that if I'm wrong, someone can further enlighten me:

1. SQL Server is intended for 'Enterprise' use, complete with full security and all of the stuff that goes with Enterprise usage. All databases must be attached to an SQL Server instance and are subject to all of the controls that are imposed by that instance. You would use the Server Explorer or the management tools that come with SQL server to set up the database and make sure that it was attached to the server.

2. SQL Express is intended for small environments. Although it is similar to SQL Server, it is not subject to the same controls, nor can it support the same high volume usage. It is intended for use in a development environment, where an individual database can then be ported to SQL Server and for small applications that do not require an 'Enterprise' database solution. When you right click and create the database, you are actually creating a database that is not attached to an SQL Server instance. If you do this, then run SSME (the management tool for SQL Express), the database that you created is not displayed, unless you attach it.

They are different products for different purposes. It might be worth asking Microsoft to add functionality to create a database in SQL Server using the same type of process, but there are a lot of issues that go with that. Those issues do not exist in the typical SQL Express environment.

Hope this helps, and if I have made an error, hopefully someone will correct it, since I am still going through the learning curve - and it's a really steep one.

Regards,

Flavelle