Hi folks!
I want to add another sql instance where the sql2\sql named instance is placed. This instance should have a different default collation.
Is it possible to have 2 sql servers running in the same service/app pool and share the same disks?
If so, do anyone know how to this should be installed?
The server setup is:
Operating system: windows server 2008
SQL Server 2008 Standard edition
2 nodes
Server02 and Server03
2 Service/app pools
sql1 (default instance) with 3 disks
sql2 (second instance) (sql2\sql) with 3 disks
I really hope someone knows how to work this 🙂
Regards!