Is it possible to install SQL Express with SQL standard Edition

Hi,

I have installed SQL standard Edition in my computer for one project. We want to kick off a new project, and intend to use SQL Express, Will anybody advise me whether I can install SQL express when SQL Standard Edition is there? or I need to remove SQL standard Edition first and install SQL express?

Thanks a lot

Haihong

Yes absolutely you can install them side-by-side. You are limited in the number and flavors of SQL Server installs really only by your hardware capabilities. The one caveat is that each beyond the first will have to be named uniquely as you can only have one default instance running. I have SQL Server 2000, SQL Server 2005 Express, and SQL Server 2005 Developer on the same machine and haven't had any problems.|||

Hi,

yes you sure can do this. The new SQL Express instance will have a different port number′, so if you want to connect to this instance you either have to name the port number after the instance name by using the syntax Machinename\InstanceName,Portnumber or start the SQL Browser service which wil redirect the client automatically to the appropiate port number during connection time.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Is it possible to import users logins when u restore a DB?

Im abit puzzled here and im looking to see if there is any easy solution

Case:

Have Backed up an DP, then Restored it on another computer.

Then all users will be in the system (Not visible to users, but in sys info)

OK!

Then I set up all LOGINS...

After all this procedure is completed I use the sp_change_users_login Update_One function...

Question:

Cant I just import or other way use old logins/users

(I know this msg might sound weird, but hehe I hope someone knows what I mean..)

Thx!As far as I know there isn't since the logins are stored in the master database. Unless in your scenario you can backup the master database and restore it on the other computer after doing the same for your database.

This worked for me when upgrading from SQL 7 to SQL 2K.|||oh! :eek:

Many thanks, I will try that one :p|||You can use command line utility bcp to copy the master..syslogins table
out of server1 and then bcp it back in to server2. Make sure you use
-c option as this will allow you to edit the output since you will need to
remove any entries which already exist in server2 (eg. "sa") in order
to prevent it falling over with duplicate key errors.

Type bcp on command line to get full list of options.|||2Scre@.m
Sorry, but I think that guys were wrong.
Read this
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q298897
and other links from it.