Running SSMS for SQL Server 2012 with multiple instances with different collation
user5891664
I already have SQL Server 2012 (collation: Latin1_General_CI_AS) working happily on my machine. But I need to connect to an old database with different collation (SQL_Latin1_General_CP1_CI_AS).
So, I installed another instance of SQL Server 2012 with this collation. But I am not able to access this instance of SQL Server using SQL Server Management Studio(SSMS).
There is just one SSMS on my machine and whenever I try to connect to it, it connects to earlier instance of SQL Server 2012. How do I get SSMS connected to new instance of SQL Server?
Thanks.
TheGameiswar
If you are trying to connect from local and not sure of instance name..You can try selecting the browser for more option in servernames and click on local servers as shown below.This will enumerate all the instances present in machine..
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Python3; Speed when sending data : IRC protocol, DCC file transfer
- Next: (Explicit Binding) Customizing The Resolution Logic & Customizing The "Not Found" Behavior
Related
Related Related
- 1
Running SSMS for SQL Server 2012 with multiple instances with different collation
- 2
Changing the collation of a SQL Server 2012 database
- 3
OSX: Running multiple instances of an application with different arguments
- 4
How to change Instance Collation of sql server running on amazon rds?
- 5
meaning of multiple instances sql server
- 6
sql running in Access 2010 but not sql server 2012
- 7
SQL Server : same query running multiple times with different execution time
- 8
SQL Server 2012 - Break apart a running total
- 9
SQL Server 2012/2014 Calculate running count
- 10
Changing Collation did not effect on million rows of a table in SQL Server 2012 Database
- 11
SQL Server 2012: Multiple select count(column1) in a single query from different table causing errors
- 12
Using TFS 2010 Source Control with SQL Server 2012 SSMS to manage SQL Scripts
- 13
Multiple counts on the same SQL Server 2012 table
- 14
What are the advantages of running multiple instances of mysql on different ports?
- 15
Running multiple shell instances with different parameters at the same time
- 16
How do I setup multiple memcached instances running on different ports?
- 17
Running multiple shell instances with different parameters at the same time
- 18
Simulate running multiple server and client instances using Java concurrency
- 19
Running multiple instances of redis with [email protected]
- 20
Running multiple elasticsearch instances
- 21
Start SSMS for SQL 2012 using CMD
- 22
SSIS Package Not Running as 32bit in SQL Server 2012
- 23
add different texts for specific values SQL Server 2012
- 24
Running multiple stored procedures in SQL Server
- 25
Risk and effects of changing database collation in SQL Server
- 26
Collation conflict using 2 versions of SQL Server
- 27
How to fix a collation conflict in a SQL Server query?
- 28
SQL Server 2008 Collation conflict - how to resolve?
- 29
Query to change table collation in SQL Server 2008
Comments