I had a similar problem when I was messing about with maintenance plans (in a test environment fortunately). I can't quite remember what I did to rectify it. ...

I've installed SQL Server 2005 on clusters & standalone servers with domain user accounts for the services with no issues. Create the accounts first, run SQL Server setup &...

No problem. That query could be trimmed a bit. I just pulled it out of a documentation script I have that outputs the results wrapped in HTML, so...

The last 4 digits are the system time at time of backup commencement. In this case, 0000 represents midnight.

This is set when the backup file is created, when the...

A) Depends what you mean by heavily used. Are you talking size or reads/writes? Size is easy - use sp_spaceused. You could always run SQL Profiler...

Is the Backup Exec agent installed on the server already?

In order for the agent to be able to backup all (specified) files on a given machine, it needs...

Or run sp_helpdb 'dbname'.

Or in the context of the database you want the info on, sp_helpfile.

Or for all of them sp_msforeachdb 'exec sp_helpdb [?]' or sp_msforeachdb 'use [?] exec sp_helpfile'

Lots...

Try this:

To get a list of SQL Server logins:

[font="Courier New"]EXEC master..sp_helplogins[/font]

A list of Server role memberships:

[font="Courier New"]EXEC master..sp_helpsrvrolemember[/font]

To get a list of database users, role memberships for all databases:

[font="Courier New"]DECLARE...

Start by running SQL Profiler & doing it through the GUI. That will show you what is happening behind the scenes.

Then start hacking away. 🙂

You can use sp_helptext...

As has been said, it doesn't matter who YOU log in as, it matters who the SQL Server SERVICE starts up with.

Since it is starting up with the LocalSystem account,...

The above script needs a slight revision.

If you are running the backups at the same time every night/morning, then all that will change is the date. So running the...

Try experimenting with reg.exe. It should be installed with Windows by default. It is a command-line registry editing tool. Just run reg /? from a command prompt...

@hydralisk: Can you ping the server? By name or IP? Can your colleagues (the ones who can successfully connect at least)? What port is SQL Server...

I already assumed you had rights within SQL Server to do the restore.

No, I mean open Computer Management on the SQL server you are trying to restore to, navigate to...

So what port are you connecting on? And what port is SQL Server listening on?

From memory, if SQL Server is configured to listen on a different port (i.e. not...