SQL Express 2005

[rf222]

Can I access SQL Express 2005 database from another machine or is it only local? What is the connection string?

My infrastructure:

Server 1
IIS with NET pages

Server 2
SQl Express 2005 with database files

My hosting does not have SQL Express 2005. Why they do not have it, not sure. Do you think it is a business decission, so they can sell SQL Server 2005 instead?

 

[mrdenny]

Yes you can access SQL Express 2005 from another machine. You just need to enable it. Use the SAC to configure it.

SQL Express 2005 doesn't have the same features as Standard edition such as the SQL Agent. Express also has a database size limit which Standard Edition doesn't have.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[rf222]

What is SAC? How do i run it?

 

[mrdenny]

Surface Area Scan. Start > Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com