How on EARTH do you connect to sql server using asp.net

im using the free asp.net web matrix.. and i have sql server installed on my local machine

i have looked all over the web to find how.. and cant find any.. does anyone actually have code to show how to do this?

please help someone> i have looked all over the web to find how..

really? I don't think you have, you know. for a start have you looked at the tutorials section of this site? or www.411asp.net? or www.4guysfromrolla.com? or my site? or in the .NET documentation?|||You may wish to look up System.Data.SqlClient

How long does it take to startup SQL Service with AWE enabled

Hi,
We have a fail-over cluster with a SQL Server 2000 instance installed on it.
There are 6GB memory available on the cluster, and we have the /PAE switch
turned on. I want to enable AWE in SQL Server and allocate 3-4GB to SQL
server. but from what I read about turn on AWE, some paper warned that the
startup process of SQL service will take a lot longer. Does anybody have
experience about how long it takes to startup SQL in a cluster with AWE
enabled with 3GB memory allocated? And if we experience a timeout error
before SQL Service started, what can we do?
Thanks
Hong Wang
Yes, the failover process will take longer with AWE enabled. The reason is
that the AWE memory must be "zeroed out." This takes extra time. However,
we have found that the Recovery Interval controls most of the failover
timing and that managing the Shared Volumes consumes more time than the AWE
clearing.
With 8 GB RAM, Windows 2000, SQL Server max server memory set to 6.5 GB, a
typical failover for a busy system could take 3 to 5 minutes. The recovery
process could take up to 15 minutes or so on a busy system once services
were restored on the new node.
There is also a KB article that discusses application processes "awareness"
of clustered instances. Basically, the application must use retry logic for
detected database connectivity errors, which can be trapped. However, this
would be good practice even if the database was hosted on a stand-alone
system.
Sincerely,
Anthony Thomas

"Hong Wang" <HongWang@.discussions.microsoft.com> wrote in message
news:4CBDA708-88EF-49F6-A55C-70C3F90F5F1A@.microsoft.com...
> Hi,
> We have a fail-over cluster with a SQL Server 2000 instance installed on
it.
> There are 6GB memory available on the cluster, and we have the /PAE switch
> turned on. I want to enable AWE in SQL Server and allocate 3-4GB to SQL
> server. but from what I read about turn on AWE, some paper warned that the
> startup process of SQL service will take a lot longer. Does anybody have
> experience about how long it takes to startup SQL in a cluster with AWE
> enabled with 3GB memory allocated? And if we experience a timeout error
> before SQL Service started, what can we do?
> Thanks
> Hong Wang

how is report designer installed in vs2005

Hi All,
I want to install the report designer in my visual studio 2005 so that i can
create reports for deployment to the 2005 sql server report server but I
seem to not find any instructions on how to do this. Can someone steer me
in the right direction. Thanks.install the client tools of SQL Server 2005 on your desktop.
"MarkR" <mrussell@.dasny.org.dontspamme> wrote in message
news:uMafw0f8FHA.3200@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I want to install the report designer in my visual studio 2005 so that i
> can create reports for deployment to the 2005 sql server report server but
> I seem to not find any instructions on how to do this. Can someone steer
> me in the right direction. Thanks.
>

How I can register MSSQL Server 2000 by IP Address

How I can register MSSQL Server 2000 by IP Address-

I installed MSSQL Server 2000 sp3a, Enterprise edition on windows 2000 advanced server box with sp4. Its primarily give instance with name like servername/sqlindia, Where sqlindia is instance and servername is physical machine name.

I would like to registration of sqlserver instance by IP Address. How I can do it.

Thanking You

R.MallEnsure the client network utility is mentioned with ALIAS using IP Address.