Monday, February 27, 2012

Help - How do I create a new instance

Hi Guys

Im new to SQL and I need to create a new instance ?

Help

Do you already have a instance ? Which SQL Server version are you using `SQL Server Express or any Full featured version ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

hi,

you need to install (and not create) a new instance if no other instance has been already installed..

If you install a SQLExpress instance, by default a named instance named SQLExpress will be installed... it's actual full name will be <ComputerName>\SQLExpress

to do that, just run the SQLExpress installer.. if you like to "play" with the advanced options, you can modify the instance name (or install a default instance as well, if not already installed), if remote connections will be enabled (network protocols are disabled by default), modify (if required) the collation settings for sort order and comparations, allow standard SQL Server logins instead of Windows authenticated connection only and the like...

regards

No comments:

Post a Comment