Have no access and unable to administer

Question

Have no access and unable to administer

john-1055503

Valued Member

Points: 63
More actions
March 29, 2009 at 10:06 am

#130232

Pretty much a complete newbie so bear with me. I am dealing with Fortis, a document imaging and management program. It's config file states it is using SQL Server 2005. No SQL 2005 service packs are evident. No evidence it is SQL Express. I did not install SQL 2005. I want to use the SQL Management Studio to schedule automatic backups of the database but receive "Login failed for user DOMAIN\administrator" "error 18456" with Server Type = Database Engine, Server Name = DOC-SERVER, & Windows Authentication. I have no idea what the SA password is so SQL Authentication is out. The database is two files with extensions of MDF and LDF. I hope this is enough info to start with.
Thanks,
JohnC

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply

maechismo_8514 SSCoach Points: 17510 More actions · Answer 1

john (3/29/2009)
I want to use the SQL Management Studio to schedule automatic backups of the database

You should have permissions to run a job. You should be either sysadmin or have an account that is the member of SQLAgentrole.

john-1055503 Valued Member Points: 63 More actions · Answer 2

I do not know what sysadmin is. Is SQLAgentrole an AD group name?

JohnC

Lowell SSC Guru Points: 323546 More actions · Answer 3

Krishna was alluding to the "sa" username and password on the SQL server for sysadmin rights. since it looks like someone removed access for BUILTIN\Administrators, where all the local and domain administrators inherit their rights from, you'll need to get the sa or some other SQL server administrator login in order to get started. do a backup of all your databases, including master as soon as you get access...it's a disaster waiting to happen.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

john-1055503 Valued Member Points: 63 More actions · Answer 4

1. Is there a way to reinstate the local Administrator's rights without the SA login?

2. Is there a way I can get the SA or some other SQL server administrator login?

JohnC

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 5

john (3/29/2009)
1. Is there a way to reinstate the local Administrator's rights without the SA login?

Yes, but it requires that you are local administrator on the server that's running SQL. It also requires that the SQL service be stopped, so it can't be done if SQL's in use.

2. Is there a way I can get the SA or some other SQL server administrator login?

No.

Are there any people there with any SQL experience?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

john-1055503 Valued Member Points: 63 More actions · Answer 6

1. I have local administrator access and I can stop the SQL service off hours. How do I proceed?

2. No SQL experience in house.

JohnC

PS when I reply the previous post is not visable. Is this configurable?

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 7

john (3/29/2009)
1. I have local administrator access and I can stop the SQL service off hours. How do I proceed?

First you need to identify whether SQL is installed as a default instance or a named instance. Check the services on that machine for any related to SQL server.

List them.

2. No SQL experience in house.

Is there anyone you know that you can ask? Any chance of getting someone in for a couple days?

Trying to learn admin work from a forum is nt the easiest of things.

PS when I reply the previous post is not visable. Is this configurable?

Below the post window there's a box titled 'Last 10 Posts In Descending Order' with a + next to it. Click the + and you'll see the last 10 posts.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

RBarryYoung SSC Guru Points: 143329 More actions · Answer 8

john (3/29/2009)
PS when I reply the previous post is not visable. Is this configurable?

Also, if you want to quote the post you are replying to, then just click the "Quote" button instead of the "Reply" button.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

john-1055503 Valued Member Points: 63 More actions · Answer 9

john-1055503

Valued Member

Points: 63

March 29, 2009 at 5:47 pm

#968115

sqlbrowser

sqlmangr x2

sqlservr x2

sqlwriter

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 10

john (3/29/2009)
sqlservr x2

Specifics please. That's not enough information to help you. To give you an idea what I need, here's the output of SQL Server services running on my machine.

MSSQLSERVER

MSSQL$SQL2008

Also, you have two listed, which one is the database in question running in?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

john-1055503 Valued Member Points: 63 More actions · Answer 11

These two are it.

I do not know which one the DB in question is running in. One is it and the other must be Backup Exec.

JohnC

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 12

I need the actual names of the services in order to help you. One of those is going to be the default instance, one is going to be a named instance. To work with the named instance we need the name of it, which will be given in the service name.

Go to Administrative tools (on the server that's running SQL), open the Services window. Navigate to the two SQL Services.

Right click on them and select properties. At the top of the dialog that opens there be the service name and the display name. Note both of them down for both SQL services and post them here please.

Can you connect at all (not necessarily administrative permissions) to the SQL server that you want to schedule backups of? If so, open a query window, type the following and run it.

SELECT @@ServerName

Post the results here

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

steve block SSCertifiable Points: 7698 More actions · Answer 13

Who installed Fortis for you? If it was a vendor or consultant, you should be asking them some of these questions.

Clearly identify to them that you need to be able to perform backups to the Fortis database. We had a Fortis DB on my Server for a while but IT moved it back to their server but I could do some more checking if you like.

Steve

john-1055503 Valued Member Points: 63 More actions · Answer 14

Oddly though there are two instances of sqlserver running in the task manager there is only one in services and it is Backup Exec.

Have no idea how or where or with what to run query.

JohnC