<add the Power Users group to SQL Logins and assign the server role of "Database Creators">

is the most interesting part of your message.

How do I do that?

What does it mean,...

SQLBill,

In IE 6 the size of the box is aproximately 550 X 450 px.

Im Mozilla 1.6 it is about 400 X 200 px.

So I guess I just need to use...

But what exactly this thing does?

Details please.

I have never heard

that somebody modified IUSR_ account.

It's a built-in IIS account.

If you touch it it might affect

other things on your system.

But still.

Even if I have full control over IUSR...

Integrated Security. OK.

I'm using SQL Server

for web application running at WebHosting company.

Internet users are being authenticated as IUSR_MachineName users at the Web Server. Web server communicates with

SQL Server through that...

This is the connection string from my ASP code:

PROVIDER=SQLOLEDB.1;DATA SOURCE=MachineName;INITIAL CATALOG=DatabaseName;USER ID=userid;PASSWORD=password;

In case I want to swicth to Windows Authentication Mode

how would it change?

If I change to Windows Authentication mode

I...

WebHosting company started to block

traffic on port 1433 except two IP's

that I gave them. This stopped the attack.

But WebHosting company

says it's a temporary solution.

They would like to discuss with us

a...

I forgot what it's called - DSN or DSNless.

This is what I use:

PROVIDER=SQLOLEDB.1;DATA SOURCE=MachineName;INITIAL CATALOG=DatabaseName;USER ID=iserid;PASSWORD=password;

Where would I need to insert port?

I need to read some ASP or VB documentation.

OK.

If we change SQL port 1433

to something else(how to choose what the new port should be?)

then I suspect we need to change all our database connection strings in all our...

Thanks Chris,

Reading time...

NAS.

Never heard of it.

Where I can read more about it?

No.

Our SQL Servers are not clustered.

And 2 or 3 SQL Servers are production.

Correction.

We have:

2 PDC servers

2 Citrix Servers

1 Exchange 5.5

4 SQL Server 2000

1 data server

1 print server

1 development Windows 2000 server (for testing web applications)

All are Windows 2000 servers,except one - Windows...

Thank you all guys for

your response.

Just to be completely clear about

the command...

So if I 'm connected in Query Analyzer

as "user51" and turn IDENTITY INSERT

ON and then I open another

QA...

Of course, xp_fixeddrives!

If you don't use it you loose it.

Thanks guys!