Re: SQL Server 2000 vs SQL Server Express

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Grey Alien wrote:
I have an ASP.Net website that was developed using SQL Server 2000. I
want to 'port' it to use SQL Server Express, since I don't have SQL
Server 2000 (besides my db is less than 1GB).

Questions:

1). What is the difference between SQL Server 2000 and SQL Server
Express?

See the other responses. If you don't use replication or backup, you won't
have many problems, I guess.

2). What changes (if any) do I have to make to make the website work
with SQL Server express ?

Just change the connection string.

--

Riki


.

Relevant Pages

  • Re: Connecting to Sql Server using an IP address
    ... using IP address without port number (default port number ... of SQL Server is 1433) cannot connect to the SQL Server on a remote ... name in the connection string can connect the remote machine successfully. ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connecting to DB with Static IP over the internet
    ... port and dmz was forward to the incorect internal ip address:) ... and any other ms sql server related ports on the server. ... item on the connection string. ... is listening, I do netstat -a and it does list that it is being listened ...
    (microsoft.public.sqlserver.setup)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
    (microsoft.public.sqlserver.setup)
  • Re: connect to named instance w/ non-default port
    ... it sounds like there is no need to specify the port number in the connection string. ... It listens on port 1434 for SQL Server requests by name/instance and resolves them to the particular port. ... this is well and good because I am troubleshooting a network where the Sql Server instance is reassigned a new listening port on machine restart. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADP problems after SQL 2005 Upgrade
    ... Use the SQL Server Configuration Manager to create aliases; ... each port can be associated only with a single instance. ... Sylvain Lafontaine, ing. ...
    (microsoft.public.access.adp.sqlserver)