Are you a local admin?

Try putting the service account in the local admin group to allow it to change permissions on directories.

Revisit this later to ensure security policies are adhered...

excellent reminder

select db_name(database_id),physical_name from sys.master_files

All the information you need is in that table. [name] is the logical file name. If you're looking for a specific filename, look in [physical_name].

And you're not able to see the report site at all?

You've checked your UAC settings?

start IE as admin like you've done. Add the report server url to your trusted sites tools -> options -> content -> trusted sites -> sites. Add http://localhost*...

A few questions about your setup first.

Is the reporting server on a seperate machine?

Is the reporting server in a different domain?

Are you a local administrator on the reporting server?

you must declare the variable before using it

and the parameter is @passwd for that procedure, so...

declare @pwd varbinary(256)

SET @pwd = CONVERT (varbinary(256), 0x01000ABGFDSECDS)

EXEC master..sp_addlogin 'sahit',@passwd = @pwd, @sid...

abdul.irfan2 (5/24/2011)

---

could you explain what you mean when you said ---

they have some sort of network scanning/inventory application on their machine that tries to connect with no login name.

...also we...

The sp_change_users_login procedure still works in 2008. the 'update_one' parameter maps a database user to a server login. The discrepency is when you move a database to a new instance...

No. You can only send emails from Workgroup, Web, Standard, Enterprise, and Datacenter.

seed is the starting number.

increment is the amount you want to increment for each record insert.

ALTER TABLE [tableName]

ADD [columnName] int identity(1,1)

will yield

1,2,3,4,5...

create table test(col1 int identity primary key not null, col2 int)

--check table design. identity specification = yes

insert into test (col2)

values (2),(5),(23)

alter table dbo.test

drop constraint [constraintName]

--check table design. identity specification =...

It's a form of join.

select a.col1,b.col1

FROM A,B

WHERE a.col1 = b.col1

same as

select a.col1,b.col1

from a

inner join b

on a.col1 = b.col1

pretty sure I have that correct

And make sure you do adequate testing prior to releasing to production.

ALTER TABLE [tableName]

ADD [columnName] int identity(seed,increment)

This will populate the new field with an auto-incrementing number

Then you can add the primary key constraint on the new field